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")
print ("Test of value: " + result[0]["field1"])
sq1.deleteOne(2)
sq1.search(C._("id", "=", 2))
result = sq1.read()
if result:
print ("ERROR: Could not remove the row.")
sq1.deleteMany([2,3,4])
sq1.search(C._raw("id", "IN", "(2,3,4)"))
result = sq1.read()
if result:
