print("Installing namespace")
sq1.installNamespace("test1", table_def)
if not sq1.hasNamespace():
print("ERROR: was not able to create database")
sq1.write({"field1":"Test Value 1", "field2":100, "field3":"something"})
many_writes = [
{"field1":"Test Value 2", "field2":200, "field3":"something 2"},
{"field1":"Test Value 3", "field2":300, "field3":"something 3"},
{"field1":"Test Value 4", "field2":400, "field3":"something 4"},
{"field1":"Test Value 5", "field2":500, "field3":"something 5"},
{"field1":"Test Value 6", "field2":600, "field3":"something 6"}]
sq1.writeMany(many_writes)
cond = C.Or(
C.And(
C._("field2", ">", 200),
C._("field2", "<", 600)
),
C._("field1", "=", "Test Value 2")
)
sq1.search(cond)
result = sq1.read()
if len(result) != 4:
print("ERROR: either rows where not added or searcg doesn't work")
