bcollection.py

This is an example of collection use written in Python.

import sys
import struct
import math
import os
import platform
import json
 
if (platform.system() == "Windows"):
    sys.path.append("C:\\Program Files\\Actian\\Zen\\bin")
else:
    sys.path.append("/usr/local/actianzen/lib64")
 
import btrievePython
 
min_x = 0
max_x = 255
btrieveCollectionName = "squaresAndSquareRoots.btr"
 
# If the incorrect number of arguments were given.
if (len(sys.argv) != 2):
    sys.exit("Usage: " + os.path.basename(sys.argv[0]) + " uint8_value")
 
integerValue = int(sys.argv[1])
 
# If integerValue is out of range.
if (integerValue < min_x) or (integerValue > max_x):
    sys.exit("Usage: " + os.path.basename(sys.argv[0]) + " uint8_value")
 
key = sys.argv[1]
 
btrieveClient = btrievePython.BtrieveClient()
assert(btrieveClient != None)
 
 
rc = btrieveClient.CollectionCreate(btrieveCollectionName)
assert(rc == btrievePython.Btrieve.STATUS_CODE_NO_ERROR), "Error: BtrieveClient::CollectionCreate():%d:%s.\n" % (rc, btrievePython.Btrieve_StatusCodeToString(rc))
 
 
 
btrieveCollection = btrievePython.BtrieveCollection()
assert(btrieveCollection != None)
 
 
 
rc = btrieveClient.CollectionOpen(btrieveCollection, btrieveCollectionName)
assert(rc == btrievePython.Btrieve.STATUS_CODE_NO_ERROR), "Error: BtrieveClient::CollectionOpen():%d:%s.\n" % (rc, btrievePython.Btrieve_StatusCodeToString(rc))
 
 
# For all the values of x.
for i in range(min_x, max_x + 1):
    iSquared = i * i
    iSquareRoot = math.sqrt(i)
    document = {}
    document["x"] = i
    document["xSquared"] = iSquared
    document["xSquareRoot"] = iSquareRoot
    document["text"] = "The square of %d is %d and its square root is %f." % (i, iSquared, iSquareRoot)
    documentJson = json.dumps(document)
 
 
    rc = btrieveCollection.DocumentCreate(documentJson)
    assert(rc >= 0), "Error: BtrieveCollection::DocumentCreate():%d:%s.\n"  % (rc, btrievePython.Btrieve_StatusCodeToString(btrieveCollection.GetLastStatusCode()))
 
 
 
btrieveDocumentSet = btrievePython.BtrieveDocumentSet()
assert(btrieveDocumentSet != None)
 
 
query = '{ "x": ' + key + '}'
 
 
rc = btrieveCollection.Query(btrieveDocumentSet, query)
assert(rc == btrievePython.Btrieve.STATUS_CODE_NO_ERROR), "Error: BtrieveCollection::Query():%d:%s.\n" % (rc, btrievePython.Btrieve_StatusCodeToString(rc))
 
 
 
rc = btrieveDocumentSet.Size()
assert(rc >= 0), "Error: BtrieveDocumentSet::Size():%d:%s\n" % (rc, btrievePython.Btrieve_StatusCodeToString(btrieveDocumentSet.GetLastStatusCode()))
 
 
assert(rc == 1), "Error: BtrieveDocumentSet::Size():%d:%s\n" % (rc, "Unexpected size.  Size should be one.")
 
 
rc = btrieveDocumentSet.PopFirst()
assert(rc >= 0), "Error: BtrieveDocumentSet::Size():%d:%s\n" % (rc, btrievePython.Btrieve_StatusCodeToString(btrieveDocumentSet.GetLastStatusCode()))
 
 
 
rc = btrieveCollection.DocumentRetrieveJson(rc)
assert(rc != None), "Error: BtrieveCollection::DocumentRetrieveJson():%d:%s.\n" % (rc, btrievePython.Btrieve_StatusCodeToString(btrieveCollection.GetLastStatusCode()))
 
 
print ("json:", rc)
 
 
rc = btrieveClient.CollectionClose(btrieveCollection)
assert(rc == btrievePython.Btrieve.STATUS_CODE_NO_ERROR), "Error: BtrieveClient::CollectionClose():%d:%s.\n" % (rc, btrievePython.Btrieve_StatusCodeToString(rc))
 
 
 
rc = btrieveClient.CollectionDelete(btrieveCollectionName)
assert(rc == btrievePython.Btrieve.STATUS_CODE_NO_ERROR), "Error: BtrieveClient::CollectionDelete():%d:%s.\n" % (rc, btrievePython.Btrieve_StatusCodeToString(rc))