test when the order_by_labels feature is disabled entirely
(self)
| 1798 | ) |
| 1799 | |
| 1800 | def test_order_by_labels_disabled(self): |
| 1801 | """test when the order_by_labels feature is disabled entirely""" |
| 1802 | |
| 1803 | lab1 = (table1.c.myid + 12).label("foo") |
| 1804 | lab2 = func.somefunc(table1.c.name).label("bar") |
| 1805 | dialect = default.DefaultDialect() |
| 1806 | dialect.supports_simple_order_by_label = False |
| 1807 | self.assert_compile( |
| 1808 | select(lab1, lab2).order_by(lab1, desc(lab2)), |
| 1809 | "SELECT mytable.myid + :myid_1 AS foo, " |
| 1810 | "somefunc(mytable.name) AS bar FROM mytable " |
| 1811 | "ORDER BY mytable.myid + :myid_1, somefunc(mytable.name) DESC", |
| 1812 | dialect=dialect, |
| 1813 | ) |
| 1814 | self.assert_compile( |
| 1815 | select(lab1, lab2).order_by(func.hoho(lab1), desc(lab2)), |
| 1816 | "SELECT mytable.myid + :myid_1 AS foo, " |
| 1817 | "somefunc(mytable.name) AS bar FROM mytable " |
| 1818 | "ORDER BY hoho(mytable.myid + :myid_1), " |
| 1819 | "somefunc(mytable.name) DESC", |
| 1820 | dialect=dialect, |
| 1821 | ) |
| 1822 | |
| 1823 | def test_no_group_by_labels(self): |
| 1824 | lab1 = (table1.c.myid + 12).label("foo") |