def test_bool_false_as_zero(self):
q = SQLLiteQuery.from_('abc').select(False)
self.assertEqual('SELECT 0 FROM "abc"', str(q))
def test_bool_true_as_one(self):
q = SQLLiteQuery.from_('abc').select(True)
self.assertEqual('SELECT 1 FROM "abc"', str(q))
def test_replace_subquery(self):
query = SQLLiteQuery.into("abc").replace(SQLLiteQuery.from_("def").select("f1", "f2"))
expected_output = 'REPLACE INTO "abc" VALUES ((SELECT "f1","f2" FROM "def"))'
self.assertEqual(expected_output, str(query))