Method test_cycle_named_fks

test/sql/test_constraints.py:497–562

(self)

    @testing.force_drop_names("a", "b")
    def test_cycle_named_fks(self):
        metadata = MetaData()

        Table(
            "a",
            metadata,
            Column("id", Integer, primary_key=True),
            Column("bid", Integer, ForeignKey("b.id")),
        )

        Table(
            "b",
            metadata,
            Column("id", Integer, primary_key=True),
            Column(
                "aid",
                Integer,
                ForeignKey("a.id", use_alter=True, name="aidfk"),
            ),
        )

        assertions = [
            AllOf(
                CompiledSQL(
                    "CREATE TABLE b ("
                    "id INTEGER NOT NULL, "
                    "aid INTEGER, "
                    "PRIMARY KEY (id)"
                    ")"
                ),
                CompiledSQL(
                    "CREATE TABLE a ("
                    "id INTEGER NOT NULL, "
                    "bid INTEGER, "
                    "PRIMARY KEY (id), "
                    "FOREIGN KEY(bid) REFERENCES b (id)"
                    ")"
                ),
            ),
            CompiledSQL(
                "ALTER TABLE b ADD CONSTRAINT aidfk "
                "FOREIGN KEY(aid) REFERENCES a (id)"
            ),
        ]
        with self.sql_execution_asserter() as asserter:
            metadata.create_all(testing.db, checkfirst=False)

        if testing.db.dialect.supports_alter:
            asserter.assert_(*assertions)

            with self.sql_execution_asserter() as asserter:
                metadata.drop_all(testing.db, checkfirst=False)

            asserter.assert_(
                CompiledSQL("ALTER TABLE b DROP CONSTRAINT aidfk"),
                AllOf(
                    CompiledSQL("DROP TABLE b"), CompiledSQL("DROP TABLE a")
                ),