byp4a55 professor6T9

Linux host69.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64
Apache
68.65.123.79

File Name : test_autogen_computed.py

import sqlalchemy as sa
from sqlalchemy import Column
from sqlalchemy import Integer
from sqlalchemy import MetaData
from sqlalchemy import Table

from ._autogen_fixtures import AutogenFixtureTest
from ... import testing
from ...testing import eq_
from ...testing import is_
from ...testing import is_true
from ...testing import mock
from ...testing import TestBase

class AutogenerateComputedTest(AutogenFixtureTest, TestBase):
    __requires__ = ("computed_columns",)
    __backend__ = True

def test_add_computed_column(self):
        m1 = MetaData()
        m2 = MetaData()

Table("user", m1, Column("id", Integer, primary_key=True))

Table(
            "user",
            m2,
            Column("id", Integer, primary_key=True),
            Column("foo", Integer, sa.Computed("5")),
        )

diffs = self._fixture(m1, m2)

eq_(diffs[0][0], "add_column")
        eq_(diffs[0][2], "user")
        eq_(diffs[0][3].name, "foo")
        c = diffs[0][3].computed

is_true(isinstance(c, sa.Computed))
        is_(c.persisted, None)
        eq_(str(c.sqltext), "5")

def test_remove_computed_column(self):
        m1 = MetaData()
        m2 = MetaData()

Table(
            "user",
            m1,
            Column("id", Integer, primary_key=True),
            Column("foo", Integer, sa.Computed("5")),
        )

Table("user", m2, Column("id", Integer, primary_key=True))

diffs = self._fixture(m1, m2)

eq_(diffs[0][0], "remove_column")
        eq_(diffs[0][2], "user")
        c = diffs[0][3]
        eq_(c.name, "foo")

is_true(isinstance(c.computed, sa.Computed))
        is_true(isinstance(c.server_default, sa.Computed))

@testing.combinations(
        lambda: (None, sa.Computed("bar*5")),
        (lambda: (sa.Computed("bar*5"), None)),
        lambda: (
            sa.Computed("bar*5"),
            sa.Computed("bar * 42", persisted=True),
        ),
        lambda: (sa.Computed("bar*5"), sa.Computed("bar * 42")),
    )
    def test_cant_change_computed_warning(self, test_case):
        arg_before, arg_after = testing.resolve_lambda(test_case, **locals())
        m1 = MetaData()
        m2 = MetaData()

arg_before = [] if arg_before is None else [arg_before]
        arg_after = [] if arg_after is None else [arg_after]

Table(
            "user",
            m1,
            Column("id", Integer, primary_key=True),
            Column("bar", Integer),
            Column("foo", Integer, *arg_before),
        )

Table(
            "user",
            m2,
            Column("id", Integer, primary_key=True),
            Column("bar", Integer),
            Column("foo", Integer, *arg_after),
        )

with mock.patch("alembic.util.warn") as mock_warn:
            diffs = self._fixture(m1, m2)

eq_(
            mock_warn.mock_calls,
            [mock.call("Computed default on user.foo cannot be modified")],
        )

eq_(list(diffs), [])

@testing.combinations(
        lambda: (None, None),
        lambda: (sa.Computed("5"), sa.Computed("5")),
        lambda: (sa.Computed("bar*5"), sa.Computed("bar*5")),
        lambda: (sa.Computed("bar*5"), sa.Computed("bar * \r\n\t5")),
    )
    def test_computed_unchanged(self, test_case):
        arg_before, arg_after = testing.resolve_lambda(test_case, **locals())
        m1 = MetaData()
        m2 = MetaData()

arg_before = [] if arg_before is None else [arg_before]
        arg_after = [] if arg_after is None else [arg_after]

Table(
            "user",
            m1,
            Column("id", Integer, primary_key=True),
            Column("bar", Integer),
            Column("foo", Integer, *arg_before),
        )

Table(
            "user",
            m2,
            Column("id", Integer, primary_key=True),
            Column("bar", Integer),
            Column("foo", Integer, *arg_after),
        )

with mock.patch("alembic.util.warn") as mock_warn:
            diffs = self._fixture(m1, m2)
        eq_(mock_warn.mock_calls, [])

eq_(list(diffs), [])

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	root/root	0755	2025-04-04 08:09:14
..	dir	-	root/root	0755	2025-04-04 08:09:14
__pycache__	dir	-	root/root	0755	2025-04-04 08:09:14
__init__.py	text/x-script.python	288 B	root/root	0644	2025-04-04 08:09:14
_autogen_fixtures.py	text/x-script.python	9.65 KB	root/root	0644	2025-04-04 08:09:14
test_autogen_comments.py	text/x-script.python	6.14 KB	root/root	0644	2025-04-04 08:09:14
test_autogen_computed.py	text/x-script.python	4.03 KB	root/root	0644	2025-04-04 08:09:14
test_autogen_diffs.py	text/x-script.python	8.2 KB	root/root	0644	2025-04-04 08:09:14
test_autogen_fks.py	text/x-script.python	32.16 KB	root/root	0644	2025-04-04 08:09:14
test_autogen_identity.py	text/x-script.python	5.69 KB	root/root	0644	2025-04-04 08:09:14
test_environment.py	text/x-script.python	11.6 KB	root/root	0644	2025-04-04 08:09:14
test_op.py	text/plain	1.31 KB	root/root	0644	2025-04-04 08:09:14

Team Anon Force

https://t.me/Professor6T9x