Module Expr Str ImportFrom alias alias ImportFrom alias alias ImportFrom alias alias ImportFrom alias ImportFrom alias ImportFrom alias alias alias alias alias alias alias ImportFrom alias alias alias alias ImportFrom alias Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr Str ImportFrom alias alias alias ImportFrom alias ImportFrom alias FunctionDef arguments args NameParam NameParam defaults body Expr Str Assign NameStore Call NameLoad Call NameLoad NameLoad For TupleStore NameStore NameStore Call NameLoad NameLoad body For NameStore NameLoad body If Call AttributeLoad NameLoad attr NameLoad body Return TupleLoad NameLoad NameLoad orelse Return TupleLoad NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Assign NameStore ListLoad FunctionDef arguments args NameParam defaults body If Call NameLoad NameLoad NameLoad body Expr Yield NameLoad orelse If BoolOpAnd CompareEq AttributeLoad NameLoad attr Str Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr Num NameLoad For NameStore Call NameLoad AttributeLoad NameLoad attr body For NameStore Call NameLoad AttributeLoad NameLoad attr body Expr Call NameLoad SubscriptLoad NameLoad Index Num NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Num For NameStore Call AttributeLoad NameLoad attr body Expr Call NameLoad NameLoad orelse If Call NameLoad NameLoad NameLoad body Expr Yield NameLoad For NameStore Call AttributeLoad NameLoad attr body For NameStore Call NameLoad NameLoad body Expr Yield NameLoad decorator_list Expr Call NameLoad Call NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam NameParam defaults NameLoad NameLoad NameLoad NameLoad NameLoad body Expr Str Assign NameStore ListLoad Assign NameStore Dict If NameLoad body Assign SubscriptStore NameLoad Index Str SubscriptStore NameLoad Index Str AttributeLoad NameLoad attr If NameLoad body Assign SubscriptStore NameLoad Index Str AttributeLoad NameLoad attr If NameLoad body Assign SubscriptStore NameLoad Index Str AttributeLoad NameLoad attr If NameLoad body Assign SubscriptStore NameLoad Index Str SubscriptStore NameLoad Index Str SubscriptStore NameLoad Index Str Lambda arguments args NameParam defaults Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr If NameLoad body FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr decorator_list Assign SubscriptStore NameLoad Index Str NameLoad Assign SubscriptStore NameLoad Index Str AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr NameLoad Dict Str NameLoad NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Str Assign NameStore Call AttributeLoad NameLoad attr Assign NameStore Call NameLoad ListLoad NameLoad While NameLoad body Assign NameStore Call AttributeLoad NameLoad attr If BoolOpAnd Call NameLoad NameLoad NameLoad BoolOpOr UnaryOpNot Call NameLoad NameLoad NameLoad UnaryOpNot Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr NameLoad orelse For NameStore Call AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str For NameStore Call NameLoad NameLoad body If CompareEq NameLoad NameLoad body Return NameLoad orelse Return NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore ListLoad NameLoad While NameLoad body Assign NameStore Call AttributeLoad NameLoad attr Expr Yield NameLoad If Call NameLoad NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr TupleLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr orelse If Call NameLoad NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Return Call NameLoad Call AttributeLoad Call NameLoad Call NameLoad NameLoad attr Call NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Str Assign NameStore ListLoad FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr decorator_list Expr Call AttributeLoad NameLoad attr NameLoad Dict Dict Str NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam defaults body If Call NameLoad NameLoad AttributeLoad NameLoad attr body Assign NameStore Call AttributeLoad NameLoad attr Str Str Return BinOpMod Str NameLoad orelse Return Call NameLoad NameLoad decorator_list ClassDef bases NameLoad body Expr Str FunctionDef arguments args NameParam NameParam NameParam defaults body Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body If BoolOpAnd Call NameLoad AttributeLoad NameLoad attr TupleLoad NameLoad NameLoad CompareGt Call NameLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr Call NameLoad SubscriptLoad AttributeLoad NameLoad attr Index Num TupleLoad NameLoad NameLoad NameLoad body Assign NameStore Str Return Call AttributeLoad Str attr TupleLoad SubscriptLoad Call NameLoad SubscriptLoad AttributeLoad NameLoad attr Slice BinOpSub AttributeLoad NameLoad attr Num Slice Num Num BinOpMod NameLoad TupleLoad AttributeLoad NameLoad attr Call NameLoad AttributeLoad NameLoad attr SubscriptLoad Call NameLoad SubscriptLoad AttributeLoad NameLoad attr Slice Num Slice Num orelse Return Call NameLoad AttributeLoad NameLoad attr decorator_list decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str FunctionDef arguments args NameParam defaults body If BoolOpAnd Call NameLoad AttributeLoad NameLoad attr NameLoad CompareIn AttributeLoad AttributeLoad NameLoad attr attr NameLoad body Assign AttributeStore NameLoad attr AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr Call NameLoad Assign AttributeStore NameLoad attr AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr AttributeLoad NameLoad attr orelse If BoolOpAnd Call NameLoad AttributeLoad NameLoad attr NameLoad CompareIn AttributeLoad AttributeLoad NameLoad attr attr NameLoad body Assign AttributeStore NameLoad attr Call NameLoad Assign AttributeStore NameLoad attr AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr AttributeLoad NameLoad attr decorator_list Return Call AttributeLoad NameLoad attr NameLoad Dict Dict Str NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults NameLoad body If CompareIs NameLoad NameLoad body Return NameLoad Assign NameStore ListLoad TupleLoad NameLoad NameLoad Assign NameStore Call NameLoad NameLoad Assign NameStore NameLoad While NameLoad body Assign TupleStore NameStore NameStore Call AttributeLoad NameLoad attr If BoolOpAnd Call NameLoad NameLoad NameLoad CompareIsNot NameLoad NameLoad body Assign NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr TupleLoad AttributeLoad NameLoad attr NameLoad orelse Assign NameStore Call AttributeLoad NameLoad attr NameLoad If CompareIsNot NameLoad NameLoad body Assign AttributeStore NameLoad attr NameLoad If CompareIs NameLoad NameLoad body Assign NameStore NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam defaults vararg kwarg body Expr Str Assign NameStore Call AttributeLoad NameLoad attr Str NameLoad Assign NameStore Call AttributeLoad NameLoad attr Str NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr For NameStore NameLoad body For NameStore Call NameLoad ListComp AttributeLoad NameLoad attr comprehension NameStore AttributeLoad NameLoad attr body For NameStore NameLoad body If CompareIs NameLoad NameLoad body Continue TryExcept body Assign NameStore AttributeLoad NameLoad attr handlers ExceptHandler type AttributeLoad NameLoad attr body If NameLoad body Continue orelse Raise ExceptHandler type AttributeLoad NameLoad attr body If NameLoad body Continue orelse Raise If BoolOpAnd Call AttributeLoad NameLoad attr NameLoad BoolOpOr UnaryOpNot NameLoad CompareEq AttributeLoad NameLoad attr AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr NameLoad Break If NameLoad body FunctionDef arguments args NameParam defaults body If CompareEq AttributeLoad NameLoad attr AttributeLoad NameLoad attr body Assign NameStore Call AttributeLoad NameLoad attr Call NameLoad ListComp AttributeLoad NameLoad attr comprehension NameStore Call AttributeLoad NameLoad attr NameLoad If BoolOpAnd CompareIn AttributeLoad NameLoad attr NameLoad CompareIn AttributeLoad NameLoad attr NameLoad body For NameStore Call NameLoad NameLoad body If BoolOpAnd Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr BoolOpOr UnaryOpNot NameLoad CompareEq AttributeLoad NameLoad attr AttributeLoad AttributeLoad NameLoad attr attr body Expr Call AttributeLoad NameLoad attr NameLoad Break decorator_list For NameStore NameLoad body If CompareIsNot NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad Dict Dict Str NameLoad Return Call NameLoad Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam defaults NameLoad NameLoad NameLoad body Expr Str If BoolOpAnd NameLoad NameLoad body Raise Call AttributeLoad NameLoad attr Str FunctionDef arguments args NameParam NameParam defaults body Return Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body If BoolOpAnd UnaryOpNot NameLoad CompareIsNot AttributeLoad NameLoad attr AttributeLoad NameLoad attr body Return If BoolOpOr UnaryOpNot Call NameLoad AttributeLoad NameLoad attr NameLoad UnaryOpNot Call NameLoad AttributeLoad NameLoad attr NameLoad body Return If NameLoad body If BoolOpAnd CompareIn AttributeLoad NameLoad attr NameLoad BoolOpOr Call NameLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr CompareNotIn AttributeLoad NameLoad attr NameLoad body Expr Call AttributeLoad NameLoad attr TupleLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr orelse If BoolOpAnd CompareIn AttributeLoad NameLoad attr NameLoad BoolOpOr Call NameLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr CompareNotIn AttributeLoad NameLoad attr NameLoad body Expr Call AttributeLoad NameLoad attr TupleLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr orelse If NameLoad body If BoolOpAnd CompareIn AttributeLoad NameLoad attr NameLoad BoolOpOr Call NameLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr CompareNotIn AttributeLoad NameLoad attr NameLoad body Expr Call AttributeLoad NameLoad attr TupleLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr orelse If BoolOpAnd CompareIn AttributeLoad NameLoad attr NameLoad BoolOpOr Call NameLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr CompareNotIn AttributeLoad NameLoad attr NameLoad body Expr Call AttributeLoad NameLoad attr TupleLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr orelse If BoolOpAnd Call NameLoad AttributeLoad NameLoad attr NameLoad Call NameLoad AttributeLoad NameLoad attr NameLoad body If Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr TupleLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr orelse If Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr TupleLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr decorator_list Assign NameStore ListLoad Expr Call AttributeLoad NameLoad attr NameLoad Dict Dict Str NameLoad Return NameLoad decorator_list ClassDef bases NameLoad body Expr Str FunctionDef arguments args NameParam NameParam NameParam defaults body If Call NameLoad NameLoad NameLoad body Assign AttributeStore NameLoad attr AttributeLoad NameLoad attr orelse Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Return CompareIn SubscriptLoad AttributeLoad NameLoad attr Index NameLoad AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam defaults body Return CompareIn NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Return SubscriptLoad AttributeLoad NameLoad attr Index SubscriptLoad AttributeLoad NameLoad attr Index NameLoad decorator_list FunctionDef arguments args NameParam defaults body Return Call AttributeLoad AttributeLoad NameLoad attr attr decorator_list decorator_list ClassDef bases AttributeLoad NameLoad attr body Expr Str FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam defaults NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad body Assign AttributeStore NameLoad attr Dict Str ListLoad NameLoad Assign AttributeStore NameLoad attr NameLoad If NameLoad body Assert UnaryOpNot NameLoad Assign AttributeStore NameLoad attr Lambda arguments args NameParam defaults CompareIn NameLoad NameLoad orelse Assign AttributeStore NameLoad attr NameLoad If NameLoad body Assert UnaryOpNot NameLoad Assign AttributeStore NameLoad attr Lambda arguments args NameParam defaults CompareIn NameLoad NameLoad orelse Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr Call AttributeLoad NameLoad attr BoolOpOr NameLoad Dict Assign AttributeStore NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam defaults AttributeLoad NameLoad attr body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad keyword NameLoad If BoolOpAnd CompareIs NameLoad NameLoad CompareIn NameLoad AttributeLoad NameLoad attr CompareNotIn NameLoad NameLoad body For NameStore SubscriptLoad AttributeLoad NameLoad attr Index NameLoad body Assign NameStore Call AttributeLoad NameLoad attr NameLoad keyword NameLoad keyword Call AttributeLoad NameLoad attr ListLoad NameLoad If CompareIsNot NameLoad NameLoad body Return NameLoad If BoolOpAnd AttributeLoad NameLoad attr CompareIs NameLoad NameLoad body Assign NameStore Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr AttributeLoad NameLoad attr Return NameLoad decorator_list Assign NameStore NameLoad FunctionDef arguments args NameParam NameParam defaults body If BoolOpAnd UnaryOpNot AttributeLoad NameLoad attr Call NameLoad NameLoad NameLoad Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad body Return AttributeLoad NameLoad attr orelse If UnaryOpNot Call NameLoad NameLoad NameLoad body Return NameLoad orelse If BoolOpAnd AttributeLoad NameLoad attr UnaryOpNot Call AttributeLoad NameLoad attr NameLoad body Return NameLoad orelse If BoolOpAnd AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr NameLoad body Return NameLoad orelse Return Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list decorator_list ClassDef bases NameLoad body Expr Str FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam NameParam NameParam defaults NameLoad NameLoad NameLoad NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad NameLoad NameLoad If NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad Assign AttributeStore NameLoad attr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr Assign AttributeStore NameLoad attr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr Return NameLoad decorator_list Assign NameStore AttributeLoad NameLoad attr Assign NameStore AttributeLoad NameLoad attr FunctionDef arguments args NameParam NameParam NameParam defaults body FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad NameLoad Return Call NameLoad NameLoad decorator_list Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Assign NameStore Call AttributeLoad NameLoad attr NameLoad NameLoad If CompareIs NameLoad NameLoad body Assign NameStore Call AttributeLoad NameLoad attr NameLoad If Call NameLoad NameLoad NameLoad body Assign NameStore Call AttributeLoad NameLoad attr NameLoad If BoolOpAnd AttributeLoad NameLoad attr CompareIs NameLoad NameLoad body Return NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Return Call NameLoad NameLoad AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr Delete SubscriptDel NameLoad Index Str Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Assign AttributeStore NameLoad attr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr decorator_list decorator_list
N/A N/A High level utilities which build upon other modules here.

 N/A exc util base _from_objects ColumnSet N/A operators visitors itertools chain collections deque elements BindParameter ColumnClause ColumnElement Null UnaryExpression literal_column Label selectable ScalarSelect Join FromClause FromGrouping schema Column N/A join_condition N/A N/A N/A util langhelpers public_factory N/A Join _join_condition .sql.util.join_condition annotation _shallow_annotate _deep_annotate _deep_deannotate elements _find_columns ddl sort_tables find_join_source N/A N/A clauses join_to N/A N/A N/A Given a list of FROM clauses and a selectable,
    return the first index and element from the list of
    clauses which can be joined against the selectable.  returns
    None, None if no match is found.

    e.g.::

        clause1 = table1.join(table2)
        clause2 = table4.join(table5)

        join_to = table2.join(table3)

        find_join_source([clause1, clause2], join_to) == clause1

     N/A selectables N/A list N/A _from_objects join_to N/A N/A i f N/A enumerate clauses N/A N/A s selectables N/A N/A N/A N/A f is_derived_from s N/A N/A N/A i f N/A N/A N/A None None N/A visit_binary_product N/A N/A fn expr N/A N/A N/A Produce a traversal of the given expression, delivering
    column comparisons to the given function.

    The function is of the form::

        def my_fn(binary, left, right)

    For each binary expression located which has a
    comparison operator, the product of "left" and
    "right" will be delivered to that function,
    in terms of that binary.

    Hence an expression like::

        and_(
            (a + b) == q + func.sum(e + f),
            j == r
        )

    would have the traversal::

        a <eq> q
        a <eq> e
        a <eq> f
        b <eq> q
        b <eq> e
        b <eq> f
        j <eq> r

    That is, every combination of "left" and
    "right" that doesn't further contain
    a binary comparison is passed as pairs.

     N/A stack N/A visit N/A N/A element N/A N/A N/A N/A isinstance element ScalarSelect N/A N/A N/A element N/A N/A N/A N/A N/A element __visit_name__ binary N/A N/A operators is_comparison N/A element operator N/A N/A N/A N/A stack insert 0 element N/A l N/A visit N/A element left N/A N/A r N/A visit N/A element right N/A N/A N/A fn N/A stack N/A 0 l r N/A N/A N/A stack pop 0 N/A elem N/A N/A element get_children N/A N/A N/A visit elem N/A N/A N/A isinstance element ColumnClause N/A N/A N/A element N/A elem N/A N/A element get_children N/A N/A e N/A visit elem N/A N/A N/A e N/A N/A N/A list N/A visit expr N/A find_tables N/A N/A clause check_columns include_aliases include_joins include_selects include_crud N/A False False False False False N/A N/A locate Table objects within the given expression. N/A tables N/A N/A _visitors N/A N/A include_selects N/A N/A N/A _visitors N/A select N/A _visitors N/A compound_select N/A tables append N/A include_joins N/A N/A N/A _visitors N/A join N/A tables append N/A include_aliases N/A N/A N/A _visitors N/A alias N/A tables append N/A include_crud N/A N/A N/A _visitors N/A insert N/A _visitors N/A update N/A _visitors N/A delete N/A N/A N/A ent N/A N/A N/A tables append N/A ent table N/A check_columns N/A visit_column N/A N/A column N/A N/A N/A N/A N/A tables append N/A column table N/A N/A N/A _visitors N/A column visit_column N/A N/A _visitors N/A table N/A tables append N/A N/A N/A visitors traverse clause N/A column_collections False _visitors N/A tables N/A unwrap_order_by N/A N/A clause N/A N/A N/A Break up an 'order by' expression into individual column-expressions,
    without DESC/ASC/NULLS FIRST/NULLS LAST N/A cols N/A N/A util column_set N/A stack N/A deque N/A clause N/A stack N/A N/A t N/A N/A stack popleft N/A N/A N/A isinstance t ColumnElement N/A N/A N/A isinstance t UnaryExpression N/A N/A N/A operators is_ordering_modifier N/A t modifier N/A N/A N/A N/A cols add t N/A N/A c N/A N/A t get_children N/A N/A N/A N/A stack append c N/A cols N/A clause_is_present N/A N/A clause search N/A N/A N/A Given a target clause and a second to search within, return True
    if the target is plainly present in the search without any
    subqueries or aliases involved.

    Basically descends through Joins.

     N/A elem N/A surface_selectables search N/A N/A N/A clause elem N/A N/A True N/A N/A False N/A surface_selectables N/A N/A clause N/A N/A N/A stack N/A clause N/A stack N/A N/A elem N/A N/A stack pop N/A N/A elem N/A N/A isinstance elem Join N/A N/A N/A N/A stack extend N/A N/A elem left N/A elem right N/A N/A N/A isinstance elem FromGrouping N/A N/A N/A N/A stack append N/A elem element N/A selectables_overlap N/A N/A left right N/A N/A N/A Return True if left/right have some overlapping selectable N/A N/A bool N/A N/A N/A set N/A surface_selectables left intersection N/A surface_selectables right N/A bind_values N/A N/A clause N/A N/A N/A Return an ordered list of "bound" values in the given clause.

    E.g.::

        >>> expr = and_(
        ...    table.c.foo==5, table.c.foo==7
        ... )
        >>> bind_values(expr)
        [5, 7]
     N/A v N/A visit_bindparam N/A N/A bind N/A N/A N/A N/A N/A v append N/A bind effective_value N/A N/A N/A N/A visitors traverse clause N/A N/A bindparam visit_bindparam N/A v N/A _quote_ddl_expr N/A N/A element N/A N/A N/A N/A isinstance element N/A util string_types N/A N/A element N/A N/A element replace ' '' N/A N/A '%s' element N/A N/A N/A repr element N/A _repr_params N/A object N/A N/A A string view of bound parameters, truncating
    display to the given number of 'multi' parameter sets.

     __init__ N/A N/A self params batches N/A N/A N/A N/A self params params N/A N/A self batches batches N/A __repr__ N/A N/A self N/A N/A N/A N/A N/A isinstance N/A self params N/A list tuple N/A N/A len N/A self params N/A self batches N/A isinstance N/A N/A self params N/A 0 N/A list dict tuple N/A N/A msg  ... displaying %i of %i total bound parameter sets ...  N/A N/A N/A join N/A N/A N/A repr N/A N/A self params N/A N/A N/A self batches 2 N/A 0 -1 N/A msg N/A N/A self batches N/A len N/A self params N/A N/A repr N/A N/A self params N/A -2 N/A 1 N/A N/A N/A repr N/A self params N/A N/A adapt_criterion_to_null N/A N/A crit nulls N/A N/A N/A given criterion containing bind params, convert selected elements
    to IS NULL.

     visit_binary N/A N/A binary N/A N/A N/A N/A N/A isinstance N/A binary left BindParameter N/A N/A N/A binary left _identifying_key nulls N/A N/A N/A binary left N/A binary right N/A N/A binary right N/A Null N/A N/A binary operator N/A operators is_ N/A N/A binary negate N/A operators isnot N/A N/A N/A N/A isinstance N/A binary right BindParameter N/A N/A N/A binary right _identifying_key nulls N/A N/A N/A binary right N/A Null N/A N/A binary operator N/A operators is_ N/A N/A binary negate N/A operators isnot N/A N/A N/A N/A visitors cloned_traverse crit N/A N/A binary visit_binary N/A splice_joins N/A N/A left right stop_on N/A None N/A N/A N/A left None N/A N/A right N/A stack N/A N/A right None N/A adapter N/A ClauseAdapter left N/A ret None N/A stack N/A N/A N/A right prevright N/A N/A stack pop N/A N/A N/A isinstance right Join N/A right stop_on N/A N/A right N/A N/A right _clone N/A N/A N/A right _reset_exported N/A N/A right onclause N/A N/A adapter traverse N/A right onclause N/A N/A N/A stack append N/A N/A right left right N/A N/A right N/A N/A adapter traverse right N/A N/A prevright None N/A N/A N/A prevright left right N/A N/A ret None N/A N/A ret right N/A ret N/A reduce_columns N/A N/A columns N/A clauses kw N/A N/A given a list of columns, return a 'reduced' set based on natural
    equivalents.

    the set is reduced to the smallest list of columns which have no natural
    equivalent present in the list.  A "natural equivalent" means that two
    columns will ultimately represent the same value because they are related
    by a foreign key.

    \*clauses is an optional list of join clauses which will be traversed
    to further identify columns that are "equivalent".

    \**kw may specify 'ignore_nonexistent_tables' to ignore foreign keys
    whose tables are not yet configured, or columns that aren't yet present.

    This function is primarily used to determine the most minimal "primary
    key" from a selectable, by reducing the set of primary key columns present
    in the selectable to just those that are not repeated.

     N/A ignore_nonexistent_tables N/A N/A kw pop ignore_nonexistent_tables False N/A only_synonyms N/A N/A kw pop only_synonyms False N/A columns N/A N/A util ordered_column_set columns N/A omit N/A N/A util column_set N/A col columns N/A N/A fk N/A chain N/A N/A c foreign_keys N/A c N/A col proxy_set N/A N/A c columns N/A N/A N/A c col N/A N/A N/A N/A N/A fk_col N/A fk column N/A N/A N/A N/A exc NoReferencedColumnError N/A N/A ignore_nonexistent_tables N/A N/A N/A N/A N/A N/A N/A exc NoReferencedTableError N/A N/A ignore_nonexistent_tables N/A N/A N/A N/A N/A N/A N/A N/A fk_col shares_lineage c N/A N/A only_synonyms N/A N/A c name N/A col name N/A N/A N/A N/A omit add col N/A N/A clauses N/A visit_binary N/A N/A binary N/A N/A N/A N/A N/A binary operator N/A operators eq N/A N/A cols N/A N/A util column_set N/A chain N/A N/A c proxy_set N/A c N/A N/A columns difference omit N/A N/A N/A N/A binary left cols N/A N/A binary right cols N/A N/A c N/A reversed columns N/A N/A N/A N/A N/A c shares_lineage N/A binary right N/A N/A only_synonyms N/A N/A c name N/A N/A binary left name N/A N/A N/A N/A omit add c N/A N/A N/A clause clauses N/A N/A N/A clause None N/A N/A N/A N/A visitors traverse clause N/A N/A binary visit_binary N/A N/A ColumnSet N/A N/A columns difference omit N/A criterion_as_pairs N/A N/A expression consider_as_foreign_keys consider_as_referenced_keys any_operator N/A None None False N/A N/A traverse an expression and locate binary criterion pairs. N/A N/A consider_as_foreign_keys consider_as_referenced_keys N/A N/A N/A N/A exc ArgumentError Can only specify one of 'consider_as_foreign_keys' or 'consider_as_referenced_keys' col_is N/A N/A a b N/A N/A N/A N/A N/A a compare b N/A visit_binary N/A N/A binary N/A N/A N/A N/A N/A any_operator N/A N/A binary operator N/A operators eq N/A N/A N/A N/A N/A N/A isinstance N/A binary left ColumnElement N/A N/A isinstance N/A binary right ColumnElement N/A N/A N/A consider_as_foreign_keys N/A N/A N/A N/A N/A binary left consider_as_foreign_keys N/A N/A col_is N/A binary right N/A binary left N/A N/A binary right consider_as_foreign_keys N/A N/A N/A N/A pairs append N/A N/A binary right N/A binary left N/A N/A N/A N/A N/A binary right consider_as_foreign_keys N/A N/A col_is N/A binary left N/A binary right N/A N/A binary left consider_as_foreign_keys N/A N/A N/A N/A pairs append N/A N/A binary left N/A binary right N/A N/A consider_as_referenced_keys N/A N/A N/A N/A N/A binary left consider_as_referenced_keys N/A N/A col_is N/A binary right N/A binary left N/A N/A binary right consider_as_referenced_keys N/A N/A N/A N/A pairs append N/A N/A binary left N/A binary right N/A N/A N/A N/A N/A binary right consider_as_referenced_keys N/A N/A col_is N/A binary left N/A binary right N/A N/A binary left consider_as_referenced_keys N/A N/A N/A N/A pairs append N/A N/A binary right N/A binary left N/A N/A N/A N/A isinstance N/A binary left Column N/A isinstance N/A binary right Column N/A N/A N/A N/A N/A binary left references N/A binary right N/A N/A N/A N/A pairs append N/A N/A binary right N/A binary left N/A N/A N/A N/A N/A binary right references N/A binary left N/A N/A N/A N/A pairs append N/A N/A binary left N/A binary right N/A N/A pairs N/A N/A N/A N/A visitors traverse expression N/A N/A binary visit_binary N/A pairs N/A AliasedRow N/A object N/A N/A Wrap a RowProxy with a translation map.

    This object allows a set of keys to be translated
    to those present in a RowProxy.

     __init__ N/A N/A self row map N/A N/A N/A N/A isinstance row AliasedRow N/A N/A N/A self row N/A row row N/A N/A N/A self row row N/A N/A self map map N/A __contains__ N/A N/A self key N/A N/A N/A N/A N/A N/A self map N/A key N/A self row N/A has_key N/A N/A self key N/A N/A N/A N/A key self N/A __getitem__ N/A N/A self key N/A N/A N/A N/A N/A self row N/A N/A N/A self map N/A key N/A keys N/A N/A self N/A N/A N/A N/A N/A N/A self row keys N/A N/A ClauseAdapter N/A N/A visitors ReplacingCloningVisitor N/A N/A Clones and modifies clauses based on column correspondence.

    E.g.::

      table1 = Table('sometable', metadata,
          Column('col1', Integer),
          Column('col2', Integer)
          )
      table2 = Table('someothertable', metadata,
          Column('col1', Integer),
          Column('col2', Integer)
          )

      condition = table1.c.col1 == table2.c.col1

    make an alias of table1::

      s = table1.alias('foo')

    calling ``ClauseAdapter(s).traverse(condition)`` converts
    condition to read::

      s.c.col1 == table2.c.col1

     __init__ N/A N/A self selectable equivalents include exclude include_fn exclude_fn adapt_on_names N/A None None None None None False N/A N/A N/A self __traverse_options__ N/A stop_on N/A selectable N/A N/A self selectable selectable N/A include N/A N/A N/A include_fn N/A N/A self include_fn N/A N/A N/A e N/A N/A e include N/A N/A N/A self include_fn include_fn N/A exclude N/A N/A N/A exclude_fn N/A N/A self exclude_fn N/A N/A N/A e N/A N/A e exclude N/A N/A N/A self exclude_fn exclude_fn N/A N/A self equivalents N/A N/A util column_dict N/A equivalents N/A N/A N/A self adapt_on_names adapt_on_names N/A _corresponding_column N/A N/A self col require_embedded _seen N/A N/A util EMPTY_SET N/A N/A newcol N/A N/A N/A self selectable corresponding_column col require_embedded require_embedded N/A N/A N/A newcol None N/A col N/A self equivalents N/A col _seen N/A N/A equiv N/A N/A self equivalents N/A col N/A N/A newcol N/A N/A self _corresponding_column equiv require_embedded require_embedded _seen N/A N/A _seen union N/A col N/A N/A newcol None N/A N/A newcol N/A N/A N/A self adapt_on_names N/A newcol None N/A N/A newcol N/A N/A N/A N/A self selectable c get N/A col name N/A newcol N/A N/A magic_flag False replace N/A N/A self col N/A N/A N/A N/A N/A N/A self magic_flag N/A isinstance col FromClause N/A N/A N/A self selectable is_derived_from col N/A N/A N/A self selectable N/A N/A N/A N/A isinstance col ColumnElement N/A N/A None N/A N/A N/A N/A self include_fn N/A N/A N/A self include_fn col N/A N/A None N/A N/A N/A N/A self exclude_fn N/A N/A self exclude_fn col N/A N/A None N/A N/A N/A N/A self _corresponding_column col True N/A N/A ColumnAdapter N/A ClauseAdapter N/A N/A Extends ClauseAdapter with extra utility functions.

    Provides the ability to "wrap" this ClauseAdapter
    around another, a columns dictionary which returns
    adapted elements given an original, and an
    adapted_row() factory.

     __init__ N/A N/A self selectable equivalents chain_to include exclude adapt_required N/A None None None None False N/A N/A N/A N/A ClauseAdapter __init__ self selectable equivalents include exclude N/A chain_to N/A N/A N/A N/A self chain chain_to N/A N/A self columns N/A N/A util populate_column_dict N/A self _locate_col N/A N/A self adapt_required adapt_required N/A wrap N/A N/A self adapter N/A N/A N/A ac N/A N/A N/A self __class__ __new__ N/A self __class__ N/A N/A ac __dict__ N/A N/A N/A self __dict__ copy N/A N/A ac _locate_col N/A N/A ac _wrap N/A ac _locate_col N/A adapter _locate_col N/A N/A ac adapt_clause N/A N/A ac _wrap N/A ac adapt_clause N/A adapter adapt_clause N/A N/A ac adapt_list N/A N/A ac _wrap N/A ac adapt_list N/A adapter adapt_list N/A N/A ac columns N/A N/A util populate_column_dict N/A ac _locate_col N/A ac N/A N/A adapt_clause N/A ClauseAdapter traverse N/A adapt_list N/A ClauseAdapter copy_and_process _wrap N/A N/A self local wrapped N/A N/A locate N/A N/A col N/A N/A N/A col N/A local col N/A N/A wrapped col N/A N/A locate N/A _locate_col N/A N/A self col N/A N/A N/A c N/A N/A self _corresponding_column col True N/A N/A c None N/A N/A c N/A N/A self adapt_clause col N/A N/A isinstance c Label N/A N/A c N/A N/A c label None N/A N/A N/A self adapt_required N/A c col N/A N/A None N/A c N/A adapted_row N/A N/A self row N/A N/A N/A N/A AliasedRow row N/A self columns N/A __getstate__ N/A N/A self N/A N/A N/A d N/A N/A N/A self __dict__ copy N/A N/A d N/A columns N/A d N/A __setstate__ N/A N/A self state N/A N/A N/A N/A N/A N/A self __dict__ update state N/A N/A self columns N/A N/A util PopulateDict N/A self _locate_col N/A N/A