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
Updated almost 2 years ago