def test():
# convert query dict to text (without correct column references)
details = {"sel": 5, "conds": [[3, 0, "SOUTH AUSTRALIA"]], "agg": 0}
test_str = Query(details["sel"], details["agg"], details["conds"])
print(test_str)
db = records.Database('sqlite:///data/train.db')
conn = db.get_connection()
# convert query dict to text with table reference (still does not give the correct columns)
# because header is not supplied
table = Table.from_db(conn, "1-1000181-1")
print(table.query_str(test_str))
# convert query dict to text with table reference after supplying headers
table_data = {
"id":
"1-1000181-1",
"header": [
"State/territory", "Text/background colour", "Format",
"Current slogan", "Current series", "Notes"
],
"types": [],
"rows": []
}
t = Table(table_data["id"], table_data["header"], table_data["types"],
table_data["rows"])
print(t.query_str(test_str))
