Method test_assorted_repr

test/sql/test_metadata.py:740–804

(self)

        )

    def test_assorted_repr(self):
        t1 = Table("foo", MetaData(), Column("x", Integer))
        i1 = Index("bar", t1.c.x)
        ck = schema.CheckConstraint("x > y", name="someconstraint")

        for const, exp in (
            (Sequence("my_seq"), "Sequence('my_seq')"),
            (Sequence("my_seq", start=5), "Sequence('my_seq', start=5)"),
            (Column("foo", Integer), "Column('foo', Integer(), table=None)"),
            (
                Column(
                    "foo",
                    Integer,
                    primary_key=True,
                    nullable=False,
                    onupdate=1,
                    default=42,
                    server_default="42",
                    comment="foo",
                ),
                "Column('foo', Integer(), table=None, primary_key=True, "
                f"nullable=False, onupdate={ColumnDefault(1)}, default="
                f"{ColumnDefault(42)}, server_default={DefaultClause('42')}, "
                "comment='foo')",
            ),
            (
                Column(
                    "foo",
                    Integer,
                    primary_key=True,
                    nullable=False,
                    onupdate=1,
                    insert_default=42,
                    server_default="42",
                    comment="foo",
                ),
                "Column('foo', Integer(), table=None, primary_key=True, "
                f"nullable=False, onupdate={ColumnDefault(1)}, default="
                f"{ColumnDefault(42)}, server_default={DefaultClause('42')}, "
                "comment='foo')",
            ),
            (
                Table("bar", MetaData(), Column("x", String)),
                "Table('bar', MetaData(), "
                "Column('x', String(), table=<bar>), schema=None)",
            ),
            (
                schema.DefaultGenerator(for_update=True),
                "DefaultGenerator(for_update=True)",
            ),
            (schema.Index("bar", "c"), "Index('bar', 'c')"),
            (i1, "Index('bar', Column('x', Integer(), table=<foo>))"),
            (schema.FetchedValue(), "FetchedValue()"),
            (
                ck,
                "CheckConstraint("
                "%s"
                ", name='someconstraint')" % repr(ck.sqltext),