diff options
Diffstat (limited to 'test/sql')
| -rw-r--r-- | test/sql/test_metadata.py | 44 |
1 files changed, 20 insertions, 24 deletions
diff --git a/test/sql/test_metadata.py b/test/sql/test_metadata.py index 2e64e0a90..3e5f7b916 100644 --- a/test/sql/test_metadata.py +++ b/test/sql/test_metadata.py @@ -4926,20 +4926,11 @@ class NamingConventionTest(fixtures.TestBase, AssertsCompiledSQL): dialect="default", ) - def test_uq_defer_name_no_convention(self): - u1 = self._fixture(naming_convention={}) - uq = UniqueConstraint(u1.c.data, name=naming._defer_name("myname")) - self.assert_compile( - schema.AddConstraint(uq), - 'ALTER TABLE "user" ADD CONSTRAINT myname UNIQUE (data)', - dialect="default", - ) - def test_uq_defer_name_convention(self): u1 = self._fixture( naming_convention={"uq": "uq_%(table_name)s_%(column_0_name)s"} ) - uq = UniqueConstraint(u1.c.data, name=naming._defer_name("myname")) + uq = UniqueConstraint(u1.c.data, name=naming._NONE_NAME) self.assert_compile( schema.AddConstraint(uq), 'ALTER TABLE "user" ADD CONSTRAINT uq_user_data UNIQUE (data)', @@ -5139,7 +5130,7 @@ class NamingConventionTest(fixtures.TestBase, AssertsCompiledSQL): u1 = self._fixture( naming_convention={"ck": "ck_%(table_name)s_%(constraint_name)s"} ) - ck = CheckConstraint(u1.c.data == "x", name=naming._defer_name(None)) + ck = CheckConstraint(u1.c.data == "x", name=naming._NONE_NAME) assert_raises_message( exc.InvalidRequestError, @@ -5254,14 +5245,16 @@ class NamingConventionTest(fixtures.TestBase, AssertsCompiledSQL): m1, Column("x", Boolean(name="foo", create_constraint=True)), ) - # constraint is not hit - eq_( - [c for c in u1.constraints if isinstance(c, CheckConstraint)][ - 0 - ].name, - "foo", + + self.assert_compile( + schema.CreateTable(u1), + 'CREATE TABLE "user" (' + "x BOOLEAN, " + "CONSTRAINT ck_user_foo CHECK (x IN (0, 1))" + ")", ) - # but is hit at compile time + + # test no side effects from first compile self.assert_compile( schema.CreateTable(u1), 'CREATE TABLE "user" (' @@ -5302,13 +5295,16 @@ class NamingConventionTest(fixtures.TestBase, AssertsCompiledSQL): m1, Column("x", Enum("a", "b", name="foo", create_constraint=True)), ) - eq_( - [c for c in u1.constraints if isinstance(c, CheckConstraint)][ - 0 - ].name, - "foo", + + self.assert_compile( + schema.CreateTable(u1), + 'CREATE TABLE "user" (' + "x VARCHAR(1), " + "CONSTRAINT ck_user_foo CHECK (x IN ('a', 'b'))" + ")", ) - # but is hit at compile time + + # test no side effects from first compile self.assert_compile( schema.CreateTable(u1), 'CREATE TABLE "user" (' |