Method test_retain_table_schema

test/sql/test_metadata.py:1181–1215

(self)

        )

    def test_retain_table_schema(self):
        meta = MetaData()

        table = Table(
            "mytable",
            meta,
            Column("myid", Integer, primary_key=True),
            Column("name", String(40), nullable=True),
            Column(
                "description", String(30), CheckConstraint("description='hi'")
            ),
            UniqueConstraint("name"),
            schema="myschema",
        )

        table2 = Table(
            "othertable",
            meta,
            Column("id", Integer, primary_key=True),
            Column("myid", Integer, ForeignKey("myschema.mytable.myid")),
            schema="myschema",
        )

        meta2 = MetaData()
        table_c = table.to_metadata(meta2)
        table2_c = table2.to_metadata(meta2)

        eq_(
            str(table_c.join(table2_c).onclause),
            str(table_c.c.myid == table2_c.c.myid),
        )
        eq_(
            str(table_c.join(table2_c).onclause),
            "myschema.mytable.myid = myschema.othertable.myid",
        )

    def test_change_name_retain_metadata(self):
        meta = MetaData()