Method test_aggregate_order_by_adapt

test/sql/test_functions.py:1247–1260

(self)

        )

    def test_aggregate_order_by_adapt(self):
        table = Table(
            "table1", MetaData(), Column("a", Integer), Column("b", Integer)
        )
        expr = aggregate_order_by(func.array_agg(table.c.a), table.c.b.desc())
        stmt = select(expr)

        a1 = table.alias("foo")
        stmt2 = util.ClauseAdapter(a1).traverse(stmt)
        self.assert_compile(
            stmt2,
            "SELECT array_agg(foo.a ORDER BY foo.b DESC) AS array_agg_1 "
            "FROM table1 AS foo",
        )


class CollectionAggregateFunctionTest(fixtures.TestBase, AssertsCompiledSQL):