Class CoreFixtures

test/sql/test_compare.py:185–1303

class CoreFixtures:
    class="cm"># lambdas which return a tuple of ColumnElement objects.
    class="cm"># must return at least two objects that should compare differently.
    class="cm"># to test more varieties of class="st">"difference" additional objects can be added.
    fixtures = [
        lambda: (
            column(class="st">"q"),
            column(class="st">"x"),
            column(class="st">"q", Integer),
            column(class="st">"q", String),
        ),
        lambda: (~column(class="st">"q", Boolean), ~column(class="st">"p", Boolean)),
        lambda: (
            table_a.c.a.label(class="st">"foo"),
            table_a.c.a.label(class="st">"bar"),
            table_a.c.b.label(class="st">"foo"),
        ),
        lambda: (
            _label_reference(table_a.c.a.desc()),
            _label_reference(table_a.c.a.asc()),
        ),
        lambda: (
            TypeClause(String(50)),
            TypeClause(DateTime()),
        ),
        lambda: (
            table_a.c.a,
            ElementList([table_a.c.a]),
            ElementList([table_a.c.a, table_a.c.b]),
        ),
        lambda: (
            table_a.c.a,
            OrderByList([table_a.c.a]),
            OrderByList(
                [table_a.c.a, OrderByList([table_a.c.b, table_b.c.a])]
            ),
        ),
        lambda: (_textual_label_reference(class="st">"a"), _textual_label_reference(class="st">"b")),
        lambda: (
            text(class="st">"select a, b from table").columns(a=Integer, b=String),
            text(class="st">"select a, b, c from table").columns(
                a=Integer, b=String, c=Integer
            ),
            text(class="st">"select a, b, c from table where foo=:bar").bindparams(
                bindparam(class="st">"bar", type_=Integer)
            ),
            text(class="st">"select a, b, c from table where foo=:foo").bindparams(
                bindparam(class="st">"foo", type_=Integer)
            ),
            text(class="st">"select a, b, c from table where foo=:bar").bindparams(
                bindparam(class="st">"bar", type_=String)
            ),
        ),
        lambda: (
            class="cm"># test #11471
            text(class="st">"select * from table")
            .columns(a=Integer())
            .add_cte(table_b.select().cte()),