Python reorder_select Examples

Example #1

File: test_syntax.py Project: DarshanKumar89/Delivery-Optimization

 def test_reorder_groupby(self):
     expr = QGroupBy(QWhere(col1, Expr([col1, '<', col2])), [col2])
     query = reorder_select(expr)
     assert_query(emit(query),
                  "SELECT Table.attr1 "
                  "FROM Table "
                  "WHERE (Table.attr1 < Table.attr2) "
                  "GROUP BY Table.attr2 ")

Example #2

 def test_reorder_groupby(self):
     expr = QGroupBy(QWhere(col1, Expr([col1, '<', col2])), [col2])
     query = reorder_select(expr)
     assert_query(
         emit(query), "SELECT Table.attr1 "
         "FROM Table "
         "WHERE (Table.attr1 < Table.attr2) "
         "GROUP BY Table.attr2 ")

Example #3

 def test_reorder_orderby(self):
     expr = QOrderBy(
         QGroupBy(QWhere(col1, Expr([col1, '<', col2])), [col2]),
         [Call('SUM', [col1])], True)
     query = reorder_select(expr)
     assert_query(
         emit(query), "SELECT Table.attr1 "
         "FROM Table "
         "WHERE (Table.attr1 < Table.attr2) "
         "GROUP BY Table.attr2 "
         "ORDER BY SUM(Table.attr1) ASC")

Example #4

File: test_syntax.py Project: DarshanKumar89/Delivery-Optimization

 def test_reorder_orderby(self):
     expr = QOrderBy(
                 QGroupBy(
                     QWhere(col1,
                            Expr([col1, '<', col2])),
                     [col2]),
                 [Call('SUM', [col1])],
                 True)
     query = reorder_select(expr)
     assert_query(emit(query),
                  "SELECT Table.attr1 "
                  "FROM Table "
                  "WHERE (Table.attr1 < Table.attr2) "
                  "GROUP BY Table.attr2 "
                  "ORDER BY SUM(Table.attr1) ASC")

Example #5

File: test_syntax.py Project: DarshanKumar89/Delivery-Optimization

 def test_reorder_where(self):
     expr = QWhere(col1, Expr([col1, '<', col2]))
     query = reorder_select(expr)
     assert_query(emit(query),
                  "SELECT Table.attr1 FROM Table WHERE "
                  "(Table.attr1 < Table.attr2)")

Example #6

 def test_reorder_where(self):
     expr = QWhere(col1, Expr([col1, '<', col2]))
     query = reorder_select(expr)
     assert_query(
         emit(query), "SELECT Table.attr1 FROM Table WHERE "
         "(Table.attr1 < Table.attr2)")