コード例 #1
0
 def test_querybuilderorderby_columnorder(self):
     qb = QueryBuilder(self._db)
     qb.From(self._db.Album)
     qb.order_by(self._db.Album.Title,'ASC')
     query = qb.preview()
     expected = "SELECT * FROM Album   ORDER BY Album.Title ASC"
     self.assertEqual(query, expected)
コード例 #2
0
 def test_querybuilder_inner_join_deductfields(self):
     qb = QueryBuilder(self._db)
     qb.From(self._db.Album)
     qb.inner_join(self._db.Artist)
     query = qb.preview()
     expected = "SELECT * FROM Album INNER JOIN Artist ON Album.ArtistId = Artist.ArtistId  "
     self.assertEqual(query, expected)
コード例 #3
0
 def test_where_wherestring_then_appends_string(self):
     qb = QueryBuilder(self._db)
     qb.From(self._db.Album).where('1 = 1')
     query = qb.preview()
     expected = "SELECT * FROM Album  WHERE 1 = 1 "
     self.assertEqual(query, expected)