Find an Object State

Search…

Find an object state at a given time in Python.

Step 1. Connect to a database
Connect to an existing database with multiple commit activities.
Code: Connect to an existing database
import os
import time
import datetime
from   terminusdb_client import WOQLClient
from   terminusdb_client import WOQLQuery as WOQL
​
server_url = "http://127.0.0.1:6363"
db         = "seshat"
user       = "admin"
account    = "admin"
key        = "root"
client     = WOQLClient(server_url)
​
client.connect(user=user, account=account, key=key, db=db)
Step 2. Get the initial commit
Get the timestamp of the last commit before the date specified in date_string, using the timetuple() method.
Code: Get the timestamp of a commit
date_string = "14/10/2020"
timestamp   = time.mktime(datetime.datetime.strptime(date_string, "%d/%m/%Y").timetuple())
Step 3. Get the subsequent commit
Get the next commit after the timestamp retrieved in step 2 and store commit data in commit_query.
Code: Get the details of the subsequent commit
commit_query = WOQL().using("admin/seshat/local/_commits",
    WOQL().limit(1,
       WOQL.woql_and(
           WOQL().triple("v:Branch", "ref:branch_name",      "v2"),
           WOQL().triple("v:Branch", "ref:ref_commit", "     v:Head"),
           WOQL().path("v:Head",     "ref:commit_parent+",   "v:Tail", "v:Path"),
           WOQL().triple("v:Tail",   "ref:commit_id",        "v:TailID"),
           WOQL().triple("v:Tail",   "ref:commit_timestamp", "v:TimeStamp"),
           WOQL().greater(timestamp, "v:TimeStamp"),
)))
Step 4. Get the commit identifier
Get the commit identifier into variable commit_id after running the commit_query defined in step 3.
Code: Get the commit id
results   = client.query(commit_query)
commit_id = results['bindings'][0]['TailID']['@value']
Step 5. Get the commit object state
Get the commit object associated with the commit_id obtained in step 4. Note the full path of the commit_id.
Code: Get the commit object state
path = f"admin/seshat/local/commit/{commit_id}"
​
object_query = WOQL().using(path,
        WOQL().read_object("terminusdb:///data/afghazn", "v:Document"))
​
results = client.query(object_query)
​
print(results)

Use Regular Expressions

Use the Document UI SDK

Last modified 1mo ago

Export as PDF

Copy link

On this page

Step 1. Connect to a database

Step 2. Get the initial commit

Step 3. Get the subsequent commit

Step 4. Get the commit identifier

Step 5. Get the commit object state