Method copy_fixture

test/sql/test_metadata.py:888–941

(self, metadata)

    @testing.fixture
    def copy_fixture(self, metadata):
        from sqlalchemy.testing.schema import Table

        table = Table(
            "mytable",
            metadata,
            Column("myid", Integer, Sequence("foo_id_seq"), primary_key=True),
            Column("name", String(40), nullable=True),
            Column("status", Boolean(create_constraint=True)),
            Column(
                "entry",
                Enum(
                    "one",
                    "two",
                    "three",
                    name="entry_enum",
                    create_constraint=True,
                ),
            ),
            Column(
                "foo",
                String(40),
                nullable=False,
                server_default="x",
                server_onupdate="q",
            ),
            Column(
                "bar", String(40), nullable=False, default="y", onupdate="z"
            ),
            Column(
                "description", String(30), CheckConstraint("description='hi'")
            ),
            UniqueConstraint("name"),
            test_needs_fk=True,
        )

        table2 = Table(
            "othertable",
            metadata,
            Column("id", Integer, Sequence("foo_seq"), primary_key=True),
            Column("myid", Integer, ForeignKey("mytable.myid")),
            test_needs_fk=True,
        )

        table3 = Table(
            "has_comments",
            metadata,
            Column("foo", Integer, comment="some column"),
            comment="table comment",
        )

        metadata.create_all(testing.db)

        return table, table2, table3

    @testing.fixture(
        params=[