本文整理汇总了Python中query.Query.get_sql方法的典型用法代码示例。如果您正苦于以下问题:Python Query.get_sql方法的具体用法?Python Query.get_sql怎么用?Python Query.get_sql使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类query.Query
的用法示例。
在下文中一共展示了Query.get_sql方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: test_sql
# 需要导入模块: from query import Query [as 别名]
# 或者: from query.Query import get_sql [as 别名]
def test_sql(self):
phrases = [ Phrase('actor', { 'dims' : 'athlete' }, []),
Phrase('actor', { 'dims' : 'country' }, []),
Phrase('medals', { 'stats' : 'sum(gold_medals)' }, []),
Phrase('medals', { 'stats' : 'sum(silver_medals)', 'limit' : '500' }, []),
Phrase('most', { 'orderbys' : 'sum(gold_medals) desc', 'limit' : '300' }, []),
Phrase('when', { 'conditions' : 'year = 2008' }, []),
Phrase('what_sport', { 'conditions' : "sport = 'Swimming'" }, []) ]
query = Query('medal_table', phrases)
sql = "SELECT athlete, country, sum(gold_medals), sum(silver_medals) FROM medal_table WHERE year = 2008 AND sport = 'Swimming' GROUP BY athlete, country ORDER BY sum(gold_medals) desc LIMIT 300"
self.assertEqual(query.get_sql(), sql)
示例2: test_minimal_sql
# 需要导入模块: from query import Query [as 别名]
# 或者: from query.Query import get_sql [as 别名]
def test_minimal_sql(self):
query = Query('the_table', [ Phrase('t', { 'stats' : 'count(*)', 'limit' : '10' }, []) ])
self.assertEqual(query.get_sql(), 'SELECT count(*) FROM the_table LIMIT 10')