• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号
登陆 注册
描述文字

Python sql_select.SqlSelect类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了Python中sql_select.SqlSelect类的典型用法代码示例。如果您正苦于以下问题：Python SqlSelect类的具体用法？Python SqlSelect怎么用？Python SqlSelect使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。



在下文中一共展示了SqlSelect类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的Python代码示例。

示例1: test_group_by_case_when

 def test_group_by_case_when(self):
     sql_select = SqlSelect.parse(
         "SELECT * FROM symbol GROUP BY CASE WHEN price > 10 THEN 'high' ELSE 'low' END AS hl")
     self.assertEqual(['hl'], sql_select.group_by.keys())
     self.assertEqual(stypes.Case, type(sql_select.group_by['hl']))
     sql_select = SqlSelect.parse(
         "SELECT * FROM symbol GROUP BY ( CASE WHEN price > 10 THEN 'high' ELSE 'low' END) AS hl")
     self.assertEqual(['hl'], sql_select.group_by.keys())
     self.assertEqual(stypes.Case, type(sql_select.group_by['hl']))
开发者ID:gitter-badger，项目名称:es-monitor，代码行数:9，代码来源:sql_select_test.py


示例2: test_not_like

 def test_not_like(self):
     sql_select = SqlSelect.parse("SELECT * FROM symbol WHERE a NOT LIKE 'abc%'")
     comparison = sql_select.where.tokens[-1]
     self.assertEqual(stypes.Comparison, type(comparison))
     self.assertEqual('NOT LIKE', comparison.operator)
     self.assertEqual('a', str(comparison.left))
     self.assertEqual("'abc%'", str(comparison.right))
开发者ID:gitter-badger，项目名称:es-monitor，代码行数:7，代码来源:sql_select_test.py


示例3: test_bigger_than_function_expression

 def test_bigger_than_function_expression(self):
     sql_select = SqlSelect.parse("SELECT * FROM symbol WHERE a > now() - INTERVAL '5 DAYS'")
     comparison = sql_select.where.tokens[-1]
     self.assertEqual(stypes.Comparison, type(comparison))
     self.assertEqual('>', comparison.operator)
     self.assertEqual('a', str(comparison.left))
     self.assertEqual("now() - eval_datetime('INTERVAL', '5 DAYS')", str(comparison.right))
开发者ID:gitter-badger，项目名称:es-monitor，代码行数:7，代码来源:sql_select_test.py


示例4: test_not_in

 def test_not_in(self):
     sql_select = SqlSelect.parse('SELECT * FROM symbol WHERE a NOT IN (1,2,3)')
     comparison = sql_select.where.tokens[-1]
     self.assertEqual(stypes.Comparison, type(comparison))
     self.assertEqual('NOT IN', comparison.operator)
     self.assertEqual('a', str(comparison.left))
     self.assertEqual('(1,2,3)', str(comparison.right))
开发者ID:gitter-badger，项目名称:es-monitor，代码行数:7，代码来源:sql_select_test.py


示例5: test_is

 def test_is(self):
     sql_select = SqlSelect.parse('SELECT * FROM symbol WHERE a IS NULL')
     comparison = sql_select.where.tokens[-1]
     self.assertEqual(stypes.Comparison, type(comparison))
     self.assertEqual('IS', comparison.operator)
     self.assertEqual('a', str(comparison.left))
     self.assertEqual('NULL', str(comparison.right))
开发者ID:gitter-badger，项目名称:es-monitor，代码行数:7，代码来源:sql_select_test.py


示例6: test_in

 def test_in(self):
     sql_select = SqlSelect.parse("SELECT * FROM symbol WHERE symbol IN ('AAPL', 'GOOG')")
     comparison = sql_select.where.tokens[-1]
     self.assertEqual(stypes.Comparison, type(comparison))
     self.assertEqual('IN', comparison.operator)
     self.assertEqual('symbol', str(comparison.left))
     self.assertEqual("('AAPL', 'GOOG')", str(comparison.right))
开发者ID:coofucoo，项目名称:es-monitor，代码行数:7，代码来源:sql_select_test.py


示例7: test_bigger_than

 def test_bigger_than(self):
     sql_select = SqlSelect.parse('SELECT * FROM symbol WHERE a > 0')
     comparison = sql_select.where.tokens[-1]
     self.assertEqual(stypes.Comparison, type(comparison))
     self.assertEqual('>', comparison.operator)
     self.assertEqual('a', str(comparison.left))
     self.assertEqual('0', str(comparison.right))
开发者ID:gitter-badger，项目名称:es-monitor，代码行数:7，代码来源:sql_select_test.py


示例8: test_projection_is_wildcard

 def test_projection_is_wildcard(self):
     sql_select = SqlSelect.parse('SELECT * FROM symbol')
     self.assertEqual(['*'], sql_select.projections.keys())
     self.assertEqual(ttypes.Wildcard, sql_select.projections['*'].ttype)
     self.assertIsNone(sql_select.where)
     self.assertEqual(dict(), sql_select.group_by)
     self.assertEqual([], sql_select.order_by)
     self.assertEqual([], sql_select.having)
     self.assertIsNone(sql_select.limit)
开发者ID:gitter-badger，项目名称:es-monitor，代码行数:9，代码来源:sql_select_test.py


示例9: test_projection_is_expression_without_function

 def test_projection_is_expression_without_function(self):
     sql_select = SqlSelect.parse('SELECT a/2 AS abc FROM symbol')
     self.assertEqual(['abc'], sql_select.projections.keys())
     self.assertEqual(stypes.Expression, type(sql_select.projections['abc']))
     self.assertEqual('a/2', str(sql_select.projections['abc']))
     self.assertIsNone(sql_select.where)
     self.assertEqual(dict(), sql_select.group_by)
     self.assertEqual([], sql_select.order_by)
     self.assertEqual([], sql_select.having)
     self.assertIsNone(sql_select.limit)
开发者ID:gitter-badger，项目名称:es-monitor，代码行数:10，代码来源:sql_select_test.py


示例10: test_projection_is_named

 def test_projection_is_named(self):
     sql_select = SqlSelect.parse('SELECT COUNT(*) AS abc FROM symbol')
     self.assertEqual(['abc'], sql_select.projections.keys())
     self.assertEqual(stypes.Function, type(sql_select.projections['abc']))
     self.assertEqual('COUNT', sql_select.projections['abc'].get_name())
     self.assertEqual(ttypes.Wildcard, sql_select.projections['abc'].get_parameters()[0].ttype)
     self.assertIsNone(sql_select.where)
     self.assertEqual(dict(), sql_select.group_by)
     self.assertEqual([], sql_select.order_by)
     self.assertEqual([], sql_select.having)
     self.assertIsNone(sql_select.limit)
开发者ID:gitter-badger，项目名称:es-monitor，代码行数:11，代码来源:sql_select_test.py


示例11: test_group_by_function

 def test_group_by_function(self):
     sql_select = SqlSelect.parse("SELECT * FROM symbol GROUP BY date_trunc('minute', ts) AS m")
     self.assertEqual(['m'], sql_select.group_by.keys())
     self.assertEqual(stypes.Function, type(sql_select.group_by['m']))
开发者ID:gitter-badger，项目名称:es-monitor，代码行数:4，代码来源:sql_select_test.py


示例12: test_limit

 def test_limit(self):
     sql_select = SqlSelect.parse('SELECT * FROM symbol LIMIT 1')
     self.assertEqual(1, sql_select.limit)
开发者ID:gitter-badger，项目名称:es-monitor，代码行数:3，代码来源:sql_select_test.py


示例13: test_join_one_field

 def test_join_one_field(self):
     sql_select = SqlSelect.parse(
         'SELECT * FROM quote JOIN matched_symbols ON quote.symbol = matched_symbols.symbol')
     self.assertEqual('matched_symbols', sql_select.join_table)
     self.assertTrue(len(sql_select.join_conditions) > 0)
开发者ID:gitter-badger，项目名称:es-monitor，代码行数:5，代码来源:sql_select_test.py


示例14: test_order_by_desc

 def test_order_by_desc(self):
     sql_select = SqlSelect.parse("SELECT * FROM symbol ORDER BY name   DESC")
     self.assertEqual(1, len(sql_select.order_by))
     self.assertEqual('name   DESC', str(sql_select.order_by[0]))
开发者ID:gitter-badger，项目名称:es-monitor，代码行数:4，代码来源:sql_select_test.py


示例15: test_single_year_month

 def test_single_year_month(self):
     sql_select = SqlSelect.parse("SELECT * FROM index('symbol-%Y-%m', '2015-06') AS my_table GROUP BY name")
     self.assertEqual('symbol-2015-06', sql_select.from_indices)
开发者ID:gitter-badger，项目名称:es-monitor，代码行数:3，代码来源:sql_select_test.py


示例16: test_from_single_index_as_alias

 def test_from_single_index_as_alias(self):
     sql_select = SqlSelect.parse("SELECT * FROM index('symbol') AS my_table GROUP BY name")
     self.assertEqual('my_table', sql_select.from_table)
     self.assertEqual('symbol', sql_select.from_indices)
开发者ID:gitter-badger，项目名称:es-monitor，代码行数:4，代码来源:sql_select_test.py


示例17: test_order_by_multiple_fields

 def test_order_by_multiple_fields(self):
     sql_select = SqlSelect.parse("SELECT * FROM symbol ORDER BY name1, name2")
     self.assertEqual(2, len(sql_select.order_by))
     self.assertEqual('name1', str(sql_select.order_by[0]))
     self.assertEqual('name2', str(sql_select.order_by[1]))
开发者ID:gitter-badger，项目名称:es-monitor，代码行数:5，代码来源:sql_select_test.py


示例18: test_projections_mixed_with_symbol

 def test_projections_mixed_with_symbol(self):
     sql_select = SqlSelect.parse('SELECT "a",b FROM symbol')
     self.assertEqual(['a', 'b'], sql_select.projections.keys())
开发者ID:gitter-badger，项目名称:es-monitor，代码行数:3，代码来源:sql_select_test.py


示例19: test_single_year_range

 def test_single_year_range(self):
     sql_select = SqlSelect.parse("SELECT * FROM index('symbol-%Y-%m-%d', '2015-01-01', '2015-01-03') AS my_table GROUP BY name")
     self.assertEqual('symbol-2015-01-01,symbol-2015-01-02,symbol-2015-01-03', sql_select.from_indices)
开发者ID:gitter-badger，项目名称:es-monitor，代码行数:3，代码来源:sql_select_test.py


示例20: test_count_distinct_dot

 def test_count_distinct_dot(self):
     sql_select = SqlSelect.parse('SELECT COUNT(DISTINCT a.b) AS c FROM symbol')
     self.assertEqual('a.b', str(sql_select.projections['c'].get_parameters()[-1]))
开发者ID:coofucoo，项目名称:es-monitor，代码行数:3，代码来源:sql_select_test.py



注：本文中的sql_select.SqlSelect类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花
握手
雷人
路过
鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
More+
上一篇：
Python sqlahelper.add_engine函数代码示例发布时间：2022-05-27
下一篇：
Python sql_manager.register函数代码示例发布时间：2022-05-27
热门推荐
More+
热门话题
More+
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服（服务时间 9:00～18:00）

在线QQ客服
地址：深圳市南山区西丽大学城创智工业园
电邮：jeky_zhao#qq.com
移动电话：139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap