Python Select Examples

Example #1

File: test_models.py Project: tonybenoy/sqlitis

 def test_select_from_many_joined_tables(self):
     m = Select().Columns(['foo.a', 'bar.b', 'baz.c', 'wumbo.d']).\
         From().Table('foo').Join('bar').Join('baz').Join('wumbo')
     self.assertEqual(
         m.render(), 'select([foo.c.a, bar.c.b, baz.c.c, wumbo.c.d])'
         '.select_from(foo.join(bar).join(baz).join(wumbo))'
     )

Example #2

 def test_select_from_many_joined_tables(self):
     m = (
         Select()
         .Columns(["foo.a", "bar.b", "baz.c", "wumbo.d"])
         .From()
         .Table("foo")
         .Join("bar")
         .Join("baz")
         .Join("wumbo")
     )
     self.assertEqual(
         m.render(),
         "select([foo.c.a, bar.c.b, baz.c.c, wumbo.c.d])"
         ".select_from(foo.join(bar).join(baz).join(wumbo))",
     )

Example #3

 def test_select_from_joined_table(self):
     m = Select().Columns(["foo.a", "bar.b"]).From().Table("foo").Join("bar")
     self.assertEqual(
         m.render(), "select([foo.c.a, bar.c.b]).select_from(foo.join(bar))"
     )

Example #4

 def test_select_qualified_columns_from_table(self):
     m = Select().Columns(["foo.a", "foo.b"]).From().Table("foo")
     self.assertEqual(m.render(), "select([foo.c.a, foo.c.b])")

Example #5

 def test_select_unqualified_columns_from_table(self):
     # recognize that column 'id' + table 'foo' = foo.c.id
     m = Select().Columns(["a", "b"]).From().Table("foo")
     self.assertEqual(m.render(), "select([foo.c.a, foo.c.b])")

Example #6

 def test_select_star_from_table(self):
     m = Select().Star().From().Table("foo")
     self.assertEqual(m.render(), "select([foo])")

Example #7

 def test_select_star_from_nothing_raises(self):
     m = Select().Star()
     self.assertRaises(Exception, m.render)

Example #8

File: test_models.py Project: robin900/sqlitis

 def test_select_from_joined_table(self):
     m = Select().Columns(['foo.a', 'bar.b']).\
         From().Table('foo').Join('bar')
     self.assertEqual(
         m.render(),
         'select([foo.c.a, bar.c.b]).select_from(foo.join(bar))')

Example #9

File: test_models.py Project: pglass/sqlitis

 def test_select_unqualified_columns_from_table(self):
     # recognize that column 'id' + table 'foo' = foo.c.id
     m = Select().Columns(['a', 'b']).From().Table('foo')
     self.assertEqual(m.render(), 'select([foo.c.a, foo.c.b])')

Example #10

File: test_models.py Project: robin900/sqlitis

 def test_select_unqualified_columns_from_table(self):
     # recognize that column 'id' + table 'foo' = foo.c.id
     m = Select().Columns(['a', 'b']).From().Table('foo')
     self.assertEqual(m.render(), 'select([foo.c.a, foo.c.b])')

Example #11

File: test_models.py Project: robin900/sqlitis

 def test_select_star_from_table(self):
     m = Select().Star().From().Table('foo')
     self.assertEqual(m.render(), 'select([foo])')

Example #12

File: test_models.py Project: pglass/sqlitis

 def test_select_nothing(self):
     m = Select()
     self.assertEqual(m.render(), "select()")

Example #13

File: test_models.py Project: pglass/sqlitis

 def test_select_from_joined_table(self):
     m = Select().Columns(['foo.a', 'bar.b']).\
         From().Table('foo').Join('bar')
     self.assertEqual(
         m.render(), 'select([foo.c.a, bar.c.b]).select_from(foo.join(bar))'
     )

Example #14

File: test_models.py Project: pglass/sqlitis

 def test_select_qualified_columns_from_table(self):
     m = Select().Columns(['foo.a', 'foo.b']).From().Table('foo')
     self.assertEqual(m.render(), 'select([foo.c.a, foo.c.b])')

Example #15

File: test_models.py Project: robin900/sqlitis

 def test_select_qualified_columns_from_table(self):
     m = Select().Columns(['foo.a', 'foo.b']).From().Table('foo')
     self.assertEqual(m.render(), 'select([foo.c.a, foo.c.b])')

Example #16

 def test_select_nothing(self):
     m = Select()
     self.assertEqual(m.render(), "select()")

Example #17

File: test_models.py Project: pglass/sqlitis

 def test_select_star_from_table(self):
     m = Select().Star().From().Table('foo')
     self.assertEqual(m.render(), 'select([foo])')