history command

History provides details about the proofs that exist for specific tables and rows

The history command lists the proofs which exist for specific tables and rows.

Usage

~ % provendb-oracle history --help
List version history for a specific rows

USAGE
  $ provendb-oracle history

OPTIONS
  -v, --verbose    increased logging verbosity
  --config=config  config file location
  --rowId=rowId    row ID to fetch versions for
  --tables=tables  tablenames to search (username.tablename)
  --where=where    WHERE clause to filter rows

DESCRIPTION
  ...
  Show the rowids and optionally SCNs for which we have anchored proofs

Arguments

Argument

Description

--config

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

--rowId

Show history for a specific rowid. This will list all the keys for that rowid, including those that are qualified by SCN. See System Change Numbers and Flashback Query

--tables

Tables that will be processed. Can be specified more than once.

--where

Where clause to apply to the tables.

--proofOnly

List Proofs only, do not include Rowids

Example

~ % provendb-oracle history --tables=PROVENDBDEMO.CONTRACTSTABLE --where=CONTRACTID=1
15:50:52.856 INFO  Listing versions for: undefined
15:50:52.859 INFO  Connecting to Oracle...
15:50:53.439 INFO  Connected to Oracle
Table:  PROVENDBDEMO.CONTRACTSTABLE
-----------------------------------

   Rowid:  AAAR5UAAMAAAAVvAAA
-----------------------------
Proof                  key                        startDate                endDate
tvzW2DzD7JkSel5aviIaRJ AAAR5UAAMAAAAVvAAA.3048532 2020-11-18T15:46:29.000Z 2020-11-18T15:46:29.000Z
tmCv3-Hkgbskt5szLUP-Nm AAAR5UAAMAAAAVvAAA.3123698 2020-11-19T11:31:28.000Z 2020-11-19T11:31:28.000Z
tfW4HFcrtJlHyw2_nVSHlr AAAR5UAAMAAAAVvAAA.3123725 2020-11-19T11:32:13.000Z 2020-11-19T11:32:13.000Z
tY1UDpd3MfMdAQksN1Ihcu AAAR5UAAMAAAAVvAAA.3123797 2020-11-19T11:33:55.000Z 2020-11-19T11:33:55.000Z
tMpir_9MlY_98p_7eOisLP AAAR5UAAMAAAAVvAAA.3124215 2020-11-19T11:37:09.000Z 2020-11-19T11:37:09.000Z
tpL3mUNitwgWq4Y1EKmNNH AAAR5UAAMAAAAVvAAA.4402573 2020-12-02T14:45:05.000Z 2020-12-02T14:45:05.000Z
tgQrCRMq8SFu17qt532QeS AAAR5UAAMAAAAVvAAA.5564835 2020-12-09T17:47:09.000Z 2020-12-09T17:47:09.000Z
tuoxGe1ErrsgpTwZ6wXvlT AAAR5UAAMAAAAVvAAA.5564926 2020-12-09T17:48:18.000Z 2020-12-09T17:48:18.000Z

What’s Next