Method test_order_by_list

test/sql/test_compiler.py:8418–8456

Test standalone OrderByList with various operators

(self)

    __dialect__ = "default"

    def test_order_by_list(self):
        """Test standalone OrderByList with various operators"""
        col1 = Column("x", Integer)
        col2 = Column("y", Integer)

        # Test basic OrderByList creation
        order_list = OrderByList([col1, col2])
        self.assert_compile(
            select(literal(1)).order_by(order_list),
            "SELECT :param_1 AS anon_1 ORDER BY x, y",
        )

        # Test OrderByList with desc
        order_list_desc = order_list.desc()
        self.assert_compile(
            select(literal(1)).order_by(order_list_desc),
            "SELECT :param_1 AS anon_1 ORDER BY x DESC, y DESC",
        )

        # Test OrderByList with asc
        order_list_asc = order_list.asc()
        self.assert_compile(
            select(literal(1)).order_by(order_list_asc),
            "SELECT :param_1 AS anon_1 ORDER BY x ASC, y ASC",
        )

        # Test OrderByList with nulls_first
        order_list_nf = order_list.nulls_first()
        self.assert_compile(
            select(literal(1)).order_by(order_list_nf),
            "SELECT :param_1 AS anon_1 ORDER BY x NULLS FIRST, y NULLS FIRST",
        )

        # Test OrderByList with nulls_last
        order_list_nl = order_list.nulls_last()
        self.assert_compile(
            select(literal(1)).order_by(order_list_nl),
            "SELECT :param_1 AS anon_1 ORDER BY x NULLS LAST, y NULLS LAST",
        )

    def test_order_by_list_chained_ops(self):
        """Test chained operations on OrderByList"""