Method propagate_cases

test/orm/test_core_compilation.py:420–529

()

    __sparse_driver_backend__ = True

    def propagate_cases():
        def distinct_deprecated(User, user_table):
            with expect_deprecated(class="st">"Passing expression to"):
                return select(1).distinct(User.id).select_from(user_table)

        return testing.combinations(
            (lambda: select(1), False),
            (lambda User: select(User.id), True),
            (lambda User: select(User.id + User.id), True),
            (lambda User: select(User.id + User.id + User.id), True),
            (lambda User: select(sum([User.id] * 10, User.id)), True),  class="cm"># type: ignore  # noqa: E501
            (
                lambda User: select(literal_column(class="st">"3") + User.id + User.id),
                True,
            ),
            (lambda User: select(func.count(User.id)), True),
            (
                lambda User: select(1).select_from(select(User).subquery()),
                True,
            ),
            (
                lambda User: select(
                    select(User.id).where(User.id == 5).scalar_subquery()
                ),
                True,
            ),
            (
                lambda User: select(
                    select(User.id).where(User.id == 5).label(class="st">"x")
                ),
                True,
            ),
            (lambda User: select(1).select_from(User), True),
            (lambda User: select(1).where(exists(User.id)), True),
            (lambda User: select(1).where(~exists(User.id)), True),
            (
                class="cm"># changed as part of #9805
                lambda User: select(1).where(User.id == 1),
                True,
            ),
            (
                class="cm"># changed as part of #9805
                lambda User, user_table: select(func.count(1))
                .select_from(user_table)
                .group_by(user_table.c.id)
                .having(User.id == 1),
                True,
            ),
            (
                class="cm"># changed as part of #9805
                lambda User, user_table: select(1)
                .select_from(user_table)
                .order_by(User.id),
                True,
            ),
            (
                class="cm"># changed as part of #9805
                lambda User, user_table: select(1)