summaryrefslogtreecommitdiff
path: root/tests/test_postgresql.py
diff options
context:
space:
mode:
authormike bayer <mike_mp@zzzcomputing.com>2023-03-01 21:28:01 +0000
committerGerrit Code Review <gerrit@bbpush.zzzcomputing.com>2023-03-01 21:28:01 +0000
commit5df0ec12369db7f0bd1c5b273be21a6a79a5a895 (patch)
tree65e73e3a31c90a7ab11f647c476aa142a15103e5 /tests/test_postgresql.py
parent192e4de9964e11f7f4f04472af7a1e09b0356a1c (diff)
parent5c71fd120af824d289cf72dd4b5679a4f839a1eb (diff)
downloadalembic-5df0ec12369db7f0bd1c5b273be21a6a79a5a895.tar.gz
Merge "Improved support for expression indexes" into main
Diffstat (limited to 'tests/test_postgresql.py')
-rw-r--r--tests/test_postgresql.py62
1 files changed, 0 insertions, 62 deletions
diff --git a/tests/test_postgresql.py b/tests/test_postgresql.py
index 23d6a8c..a8c284d 100644
--- a/tests/test_postgresql.py
+++ b/tests/test_postgresql.py
@@ -41,7 +41,6 @@ from alembic.migration import MigrationContext
from alembic.operations import ops
from alembic.script import ScriptDirectory
from alembic.testing import assert_raises_message
-from alembic.testing import assertions
from alembic.testing import combinations
from alembic.testing import config
from alembic.testing import eq_
@@ -1306,64 +1305,3 @@ class PGUniqueIndexAutogenerateTest(AutogenFixtureTest, TestBase):
eq_(diffs[0][0], "remove_constraint")
eq_(diffs[0][1].name, "uq_name")
eq_(len(diffs), 1)
-
- def _functional_index_warn(self):
- return (r"Skip.*refl",)
-
- def test_functional_ix_one(self):
- m1 = MetaData()
- m2 = MetaData()
-
- t1 = Table(
- "foo",
- m1,
- Column("id", Integer, primary_key=True),
- Column("email", String(50)),
- )
- Index("email_idx", func.lower(t1.c.email), unique=True)
-
- t2 = Table(
- "foo",
- m2,
- Column("id", Integer, primary_key=True),
- Column("email", String(50)),
- )
- Index("email_idx", func.lower(t2.c.email), unique=True)
-
- with assertions.expect_warnings(*self._functional_index_warn()):
- diffs = self._fixture(m1, m2)
- eq_(diffs, [])
-
- def test_functional_ix_two(self):
- m1 = MetaData()
- m2 = MetaData()
-
- t1 = Table(
- "foo",
- m1,
- Column("id", Integer, primary_key=True),
- Column("email", String(50)),
- Column("name", String(50)),
- )
- Index(
- "email_idx",
- func.coalesce(t1.c.email, t1.c.name).desc(),
- unique=True,
- )
-
- t2 = Table(
- "foo",
- m2,
- Column("id", Integer, primary_key=True),
- Column("email", String(50)),
- Column("name", String(50)),
- )
- Index(
- "email_idx",
- func.coalesce(t2.c.email, t2.c.name).desc(),
- unique=True,
- )
-
- with assertions.expect_warnings(*self._functional_index_warn()):
- diffs = self._fixture(m1, m2)
- eq_(diffs, [])