Method test_change_schema

test/sql/test_metadata.py:1147–1179

(self)

        )

    def test_change_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"),
        )

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

        meta2 = MetaData()
        table_c = table.to_metadata(meta2, schema="someschema")
        table2_c = table2.to_metadata(meta2, schema="someschema")

        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),
            "someschema.mytable.myid = someschema.othertable.myid",
        )

    def test_retain_table_schema(self):
        meta = MetaData()