def test_with_columns(self):
with AliasManager():
second = With('a', query=self.table.select(self.table.a))
self.assertEqual(second.statement(),
'"a"("a") AS ('
'SELECT "b"."a" FROM "t" AS "b"'
')')
self.assertEqual(second.statement_params(), ())
def test_with_columns(self):
with AliasManager():
second = With('a', query=self.table.select(self.table.a))
self.assertEqual(
second.statement(), '"a" ("a") AS ('
'SELECT "b"."a" FROM "t" AS "b"'
')')
self.assertEqual(second.statement_params(), ())
def test_with(self):
with AliasManager():
simple = With(query=self.table.select(self.table.id,
where=self.table.id == 1))
self.assertEqual(simple.statement(),
'"a" AS ('
'SELECT "b"."id" FROM "t" AS "b" WHERE ("b"."id" = %s)'
')')
self.assertEqual(simple.statement_params(), (1,))
def test_with(self):
with AliasManager():
simple = With(query=self.table.select(self.table.id,
where=self.table.id == 1))
self.assertEqual(
simple.statement(), '"a" AS ('
'SELECT "b"."id" FROM "t" AS "b" WHERE ("b"."id" = %s)'
')')
self.assertEqual(simple.statement_params(), (1, ))
