?HAMA

Edit File Size: 5.21 KB

//opt/hc_python/lib/python3.12/site-packages/sqlalchemy/testing/suite/test_deprecations.py

Text Base64

# testing/suite/test_deprecations.py
# Copyright (C) 2005-2025 the SQLAlchemy authors and contributors
# <see AUTHORS file>
#
# This module is part of SQLAlchemy and is released under
# the MIT License: https://www.opensource.org/licenses/mit-license.php
# mypy: ignore-errors

from .. import fixtures
from ..assertions import eq_
from ..schema import Column
from ..schema import Table
from ... import Integer
from ... import select
from ... import testing
from ... import union

class DeprecatedCompoundSelectTest(fixtures.TablesTest):
    __backend__ = True

@classmethod
    def define_tables(cls, metadata):
        Table(
            "some_table",
            metadata,
            Column("id", Integer, primary_key=True),
            Column("x", Integer),
            Column("y", Integer),
        )

@classmethod
    def insert_data(cls, connection):
        connection.execute(
            cls.tables.some_table.insert(),
            [
                {"id": 1, "x": 1, "y": 2},
                {"id": 2, "x": 2, "y": 3},
                {"id": 3, "x": 3, "y": 4},
                {"id": 4, "x": 4, "y": 5},
            ],
        )

def _assert_result(self, conn, select, result, params=()):
        eq_(conn.execute(select, params).fetchall(), result)

def test_plain_union(self, connection):
        table = self.tables.some_table
        s1 = select(table).where(table.c.id == 2)
        s2 = select(table).where(table.c.id == 3)

u1 = union(s1, s2)
        with testing.expect_deprecated(
            "The SelectBase.c and SelectBase.columns "
            "attributes are deprecated"
        ):
            self._assert_result(
                connection, u1.order_by(u1.c.id), [(2, 2, 3), (3, 3, 4)]
            )

# note we've had to remove one use case entirely, which is this
    # one.   the Select gets its FROMS from the WHERE clause and the
    # columns clause, but not the ORDER BY, which means the old ".c" system
    # allowed you to "order_by(s.c.foo)" to get an unnamed column in the
    # ORDER BY without adding the SELECT into the FROM and breaking the
    # query.  Users will have to adjust for this use case if they were doing
    # it before.
    def _dont_test_select_from_plain_union(self, connection):
        table = self.tables.some_table
        s1 = select(table).where(table.c.id == 2)
        s2 = select(table).where(table.c.id == 3)

u1 = union(s1, s2).alias().select()
        with testing.expect_deprecated(
            "The SelectBase.c and SelectBase.columns "
            "attributes are deprecated"
        ):
            self._assert_result(
                connection, u1.order_by(u1.c.id), [(2, 2, 3), (3, 3, 4)]
            )

@testing.requires.order_by_col_from_union
    @testing.requires.parens_in_union_contained_select_w_limit_offset
    def test_limit_offset_selectable_in_unions(self, connection):
        table = self.tables.some_table
        s1 = select(table).where(table.c.id == 2).limit(1).order_by(table.c.id)
        s2 = select(table).where(table.c.id == 3).limit(1).order_by(table.c.id)

u1 = union(s1, s2).limit(2)
        with testing.expect_deprecated(
            "The SelectBase.c and SelectBase.columns "
            "attributes are deprecated"
        ):
            self._assert_result(
                connection, u1.order_by(u1.c.id), [(2, 2, 3), (3, 3, 4)]
            )

@testing.requires.parens_in_union_contained_select_wo_limit_offset
    def test_order_by_selectable_in_unions(self, connection):
        table = self.tables.some_table
        s1 = select(table).where(table.c.id == 2).order_by(table.c.id)
        s2 = select(table).where(table.c.id == 3).order_by(table.c.id)

def test_distinct_selectable_in_unions(self, connection):
        table = self.tables.some_table
        s1 = select(table).where(table.c.id == 2).distinct()
        s2 = select(table).where(table.c.id == 3).distinct()

def test_limit_offset_aliased_selectable_in_unions(self, connection):
        table = self.tables.some_table
        s1 = (
            select(table)
            .where(table.c.id == 2)
            .limit(1)
            .order_by(table.c.id)
            .alias()
            .select()
        )
        s2 = (
            select(table)
            .where(table.c.id == 3)
            .limit(1)
            .order_by(table.c.id)
            .alias()
            .select()
        )

Exit & Reset Text mode: syntax highlighting auto-detects file type.

Name	Size	Perms	Modified	Actions
__pycache__ DIR	-	drwxr-xr-x	2025-04-04 08:02:04	Edit Download recursive recursive
test_cte.py	6.30 KB	lrw-r--r--	2025-04-04 08:02:01	Edit Download recursive recursive
test_ddl.py	11.75 KB	lrw-r--r--	2025-04-04 08:02:01	Edit Download recursive recursive
test_deprecations.py	5.21 KB	lrw-r--r--	2025-04-04 08:02:01	Edit Download recursive recursive
test_dialect.py	22.39 KB	lrw-r--r--	2025-04-04 08:02:01	Edit Download recursive recursive
test_insert.py	18.38 KB	lrw-r--r--	2025-04-04 08:02:01	Edit Download recursive recursive
test_reflection.py	107.27 KB	lrw-r--r--	2025-04-04 08:02:01	Edit Download recursive recursive
test_results.py	16.52 KB	lrw-r--r--	2025-04-04 08:02:01	Edit Download recursive recursive
test_rowcount.py	7.71 KB	lrw-r--r--	2025-04-04 08:02:01	Edit Download recursive recursive
test_select.py	60.59 KB	lrw-r--r--	2025-04-04 08:02:01	Edit Download recursive recursive
test_sequence.py	9.69 KB	lrw-r--r--	2025-04-04 08:02:01	Edit Download recursive recursive
test_types.py	66.42 KB	lrw-r--r--	2025-04-04 08:02:01	Edit Download recursive recursive
test_unicode_ddl.py	6.00 KB	lrw-r--r--	2025-04-04 08:02:01	Edit Download recursive recursive
test_update_delete.py	3.90 KB	lrw-r--r--	2025-04-04 08:02:01	Edit Download recursive recursive
__init__.py	722 B	lrw-r--r--	2025-04-04 08:02:01	Edit Download recursive recursive

Directory Contents