anchor command

Anchor selected rows to a blockchain

The anchor command performs a one-off anchoring of selected database rows to the blockchain specified in the configuration file.

Usage

% provendb-oracle anchor --help
Anchor one or more tables to the blockchain.

USAGE
  $ provendb-oracle anchor

OPTIONS
  -v, --verbose        increased logging verbosity
  --config=config      config file location
  --includeRowIds      Include proofs for every row in the proof file
  --includeScn         Include SCN into rowid signature (create historical proof)
  --tables=tables      (required) tables to anchor
  --validate=validate  Validate the proof and output to file
  --where=where        WHERE clause to filter rows

DESCRIPTION
  Anchor reads the current state of selected table, filtered by an options WHERE
  clause.  Rows are hashed and anchored to the blockchain.

Arguments

Argument

Descriptionthough

--config

Configuration file which contains Oracle and provend DB configuration see Configuration file Reference

--includeRowIds

If the validate option is specified, include a proof for each row in the output

--includeScn

Create signatures for the rows concerned at the current System Change Number. This option assumes that Flashback queries are enabled. See System Change Numbers and Flashback Query

--tables=tables

Table(s) that are to be anchored. This argument can be specified multiple times to anchor multiple tables.

--validate=validate

After creating the proof, immediately validate the proof and create a proof file.

--where=where

WHERE clause to be applied to each of the tables being anchored.

Example

% provendb-oracle anchor --tables=PROVENDBDEMO.CONTRACTSTABLE --where=CONTRACTID=1 --validate=contract1.proof --includeRowIds --includeScn
15:48:18.389 INFO  Anchoring Tables: PROVENDBDEMO.CONTRACTSTABLE
15:48:18.393 INFO  Connecting to Oracle...
15:48:18.656 INFO  Connected to Oracle
15:48:18.657 INFO  Connecting to Proofable
15:48:18.662 INFO  Checking PROVENDBDEMO.CONTRACTSTABLE
15:48:18.697 INFO  PROVENDBDEMO.CONTRACTSTABLE is not flashback managed
15:48:18.713 INFO  Processing  PROVENDBDEMO.CONTRACTSTABLE adhoc: adhocWhere: CONTRACTID=1
15:48:18.713 INFO  WHERE CONTRACTID=1
15:48:18.764 INFO  --> Anchoring data to HEDERA
15:48:18.764 INFO  1 keys
Anchoring proof: BATCHING
Anchoring proof: QUEUING
Anchoring proof: PROCESSING
Anchoring proof: PENDING
Anchoring proof: CONFIRMED
15:48:23.369 INFO  Saving trie tuoxGe1ErrsgpTwZ6wXvlT to db
15:48:23.460 INFO  Proof tuoxGe1ErrsgpTwZ6wXvlT created and stored to DB
15:48:23.460 INFO  Writing proof for tuoxGe1ErrsgpTwZ6wXvlT to contract1.proof
.
15:48:24.699 INFO  Wrote proof file to contract1.proof
15:48:24.699 INFO  Proof written to contract1.proof

What’s Next