class CompoundSelect(HasCompileState, GenerativeSelect):
Forms the basis of UNION, UNION ALL, and other SELECT-based set operations.
See Also
_expression.union
_expression.union_all
_expression.intersect
_expression.intersect_all
_expression.except
_expression.except_all
Method | self_group |
Apply a 'grouping' to this _expression.ClauseElement . |
Constant | EXCEPT |
Undocumented |
Constant | EXCEPT_ALL |
Undocumented |
Constant | INTERSECT |
Undocumented |
Constant | INTERSECT_ALL |
Undocumented |
Constant | UNION |
Undocumented |
Constant | UNION_ALL |
Undocumented |
Class Method | _create_except |
Return an EXCEPT of multiple selectables. |
Class Method | _create_except_all |
Return an EXCEPT ALL of multiple selectables. |
Class Method | _create_intersect |
Return an INTERSECT of multiple selectables. |
Class Method | _create_intersect_all |
Return an INTERSECT ALL of multiple selectables. |
Class Method | _create_union |
Return a UNION of multiple selectables. |
Class Method | _create_union_all |
Return a UNION ALL of multiple selectables. |
Method | __init__ |
Undocumented |
Method | _ensure_disambiguated_names |
Ensure that the names generated by this selectbase will be disambiguated in some way, if possible. |
Method | _generate_fromclause_column_proxies |
Undocumented |
Method | _refresh_for_new_column |
Undocumented |
Method | _scalar_type |
Undocumented |
Method | _set_label_style |
Undocumented |
Method | bind.setter |
Undocumented |
Method | is_derived_from |
Undocumented |
Class Variable | __visit_name__ |
Undocumented |
Class Variable | _is_from_container |
Undocumented |
Class Variable | _traverse_internals |
Undocumented |
Instance Variable | _auto_correlate |
Undocumented |
Instance Variable | _bind |
Undocumented |
Instance Variable | keyword |
Undocumented |
Instance Variable | selects |
Undocumented |
Property | _all_selected_columns |
A sequence of expressions that correspond to what is rendered in the columns clause, including _sql.TextClause constructs. |
Property | bind |
Returns the _engine.Engine or _engine.Connection to which this .Executable is bound, or None if none found. |
Property | selected_columns |
No summary |
Inherited from HasCompileState
:
Class Variable | _attributes |
Undocumented |
Class Variable | _compile_state_plugin |
Undocumented |
Inherited from Generative
(via HasCompileState
):
Method | _generate |
Undocumented |
Inherited from GenerativeSelect
:
Method | _offset_or_limit_clause |
Convert the given value to an "offset or limit" clause. |
Method | _offset_or_limit_clause_asint |
Convert the "offset or limit" clause of a select construct to an integer. |
Method | _simple_int_clause |
True if the clause is a simple integer, False if it is not present or is a SQL expression. |
Method | apply_labels |
Undocumented |
Method | fetch |
Return a new selectable with the given FETCH FIRST criterion applied. |
Method | get_label_style |
Retrieve the current label style. |
Method | group_by |
Return a new selectable with the given list of GROUP BY criterion applied. |
Method | limit |
Return a new selectable with the given LIMIT criterion applied. |
Method | offset |
Return a new selectable with the given OFFSET criterion applied. |
Method | order_by |
Return a new selectable with the given list of ORDER BY criteria applied. |
Method | set_label_style |
Return a new selectable with the specified label style. |
Method | slice |
Apply LIMIT / OFFSET to this statement based on a slice. |
Method | with_for_update |
Specify a FOR UPDATE clause for this _expression.GenerativeSelect . |
Instance Variable | _fetch_clause |
Undocumented |
Instance Variable | _fetch_clause_options |
Undocumented |
Instance Variable | _for_update_arg |
Undocumented |
Instance Variable | _group_by_clauses |
Undocumented |
Instance Variable | _label_style |
Undocumented |
Instance Variable | _limit_clause |
Undocumented |
Instance Variable | _offset_clause |
Undocumented |
Instance Variable | _order_by_clauses |
Undocumented |
Property | _group_by_clause |
ClauseList access to group_by_clauses for legacy dialects |
Property | _has_row_limiting_clause |
Undocumented |
Property | _limit |
No summary |
Property | _offset |
No summary |
Property | _order_by_clause |
ClauseList access to order_by_clauses for legacy dialects |
Inherited from DeprecatedSelectBaseGenerations
(via GenerativeSelect
):
Method | append_group_by |
Append the given GROUP BY criterion applied to this selectable. |
Method | append_order_by |
Append the given ORDER BY criterion applied to this selectable. |
Inherited from SelectBase
(via GenerativeSelect
):
Method | _implicit_subquery |
Undocumented |
Method | alias |
Return a named subquery against this _expression.SelectBase . |
Method | as_scalar |
Undocumented |
Method | exists |
Return an _sql.Exists representation of this selectable, which can be used as a column expression. |
Method | label |
Return a 'scalar' representation of this selectable, embedded as a subquery with a label. |
Method | lateral |
Return a LATERAL alias of this _expression.Selectable . |
Method | scalar_subquery |
Return a 'scalar' representation of this selectable, which can be used as a column expression. |
Method | select |
Undocumented |
Method | subquery |
Return a subquery of this _expression.SelectBase . |
Class Variable | _is_select_statement |
Undocumented |
Class Variable | is_select |
Undocumented |
Property | _from_objects |
Undocumented |
Property | c |
Undocumented |
Property | columns |
Undocumented |
Property | exported_columns |
No summary |
Inherited from SelectStatementRole
(via GenerativeSelect
, SelectBase
):
Class Variable | _role_name |
Undocumented |
Inherited from StatementRole
(via GenerativeSelect
, SelectBase
, SelectStatementRole
):
Class Variable | _propagate_attrs |
Undocumented |
Inherited from SQLRole
(via GenerativeSelect
, SelectBase
, SelectStatementRole
, StatementRole
):
Class Variable | allows_lambda |
Undocumented |
Class Variable | uses_inspection |
Undocumented |
Inherited from SQLRole
(via GenerativeSelect
, SelectBase
, SelectStatementRole
, ReturnsRowsRole
):
Class Variable | allows_lambda |
Undocumented |
Class Variable | uses_inspection |
Undocumented |
Inherited from DMLSelectRole
(via GenerativeSelect
, SelectBase
):
Class Variable | _role_name |
Undocumented |
Inherited from SQLRole
(via GenerativeSelect
, SelectBase
, DMLSelectRole
):
Class Variable | allows_lambda |
Undocumented |
Class Variable | uses_inspection |
Undocumented |
Inherited from CompoundElementRole
(via GenerativeSelect
, SelectBase
):
Class Variable | _role_name |
Undocumented |
Inherited from AllowsLambdaRole
(via GenerativeSelect
, SelectBase
, CompoundElementRole
):
Class Variable | allows_lambda |
Undocumented |
Inherited from SQLRole
(via GenerativeSelect
, SelectBase
, CompoundElementRole
):
Class Variable | allows_lambda |
Undocumented |
Class Variable | uses_inspection |
Undocumented |
Inherited from InElementRole
(via GenerativeSelect
, SelectBase
):
Class Variable | _role_name |
Undocumented |
Inherited from SQLRole
(via GenerativeSelect
, SelectBase
, InElementRole
):
Class Variable | allows_lambda |
Undocumented |
Class Variable | uses_inspection |
Undocumented |
Inherited from HasCTE
(via GenerativeSelect
, SelectBase
):
Method | add_cte |
Add a _sql.CTE to this statement object that will be independently rendered even if not referenced in the statement otherwise. |
Method | cte |
Return a new _expression.CTE , or Common Table Expression instance. |
Class Variable | _has_ctes_traverse_internals |
Undocumented |
Class Variable | _independent_ctes |
Undocumented |
Inherited from ReturnsRowsRole
(via GenerativeSelect
, SelectBase
, HasCTE
, HasCTERole
):
Class Variable | _role_name |
Undocumented |
Inherited from SQLRole
(via GenerativeSelect
, SelectBase
, HasCTE
, HasCTERole
, ReturnsRowsRole
):
Class Variable | allows_lambda |
Undocumented |
Class Variable | uses_inspection |
Undocumented |
Inherited from Executable
(via GenerativeSelect
, SelectBase
):
Method | _add_context_option |
Add a context option to this statement. |
Method | _set_compile_options |
Assign the compile options to a new value. |
Method | _update_compile_options |
update the _compile_options with new keys. |
Method | execute |
Compile and execute this .Executable . |
Method | execution_options |
Set non-SQL options for the statement which take effect during execution. |
Method | get_execution_options |
Get the non-SQL options which will take effect during execution. |
Method | options |
Apply options to this statement. |
Method | scalar |
Compile and execute this .Executable , returning the result's scalar representation. |
Class Variable | _executable_traverse_internals |
Undocumented |
Class Variable | _with_context_options |
Undocumented |
Class Variable | _with_options |
Undocumented |
Class Variable | is_delete |
Undocumented |
Class Variable | is_dml |
Undocumented |
Class Variable | is_insert |
Undocumented |
Class Variable | is_text |
Undocumented |
Class Variable | is_update |
Undocumented |
Class Variable | supports_execution |
Undocumented |
Instance Variable | _compile_options |
Undocumented |
Instance Variable | _execution_options |
Undocumented |
Property | _effective_plugin_target |
Undocumented |
Inherited from StatementRole
(via GenerativeSelect
, SelectBase
, Executable
):
Class Variable | _propagate_attrs |
Undocumented |
Class Variable | _role_name |
Undocumented |
Inherited from SQLRole
(via GenerativeSelect
, SelectBase
, Executable
, StatementRole
):
Class Variable | allows_lambda |
Undocumented |
Class Variable | uses_inspection |
Undocumented |
Inherited from Generative
(via GenerativeSelect
, SelectBase
, Executable
):
Method | _generate |
Undocumented |
Inherited from SupportsCloneAnnotations
(via GenerativeSelect
, SelectBase
):
Method | _annotate |
return a copy of this ClauseElement with annotations updated by the given dictionary. |
Method | _deannotate |
return a copy of this _expression.ClauseElement with annotations removed. |
Method | _with_annotations |
return a copy of this ClauseElement with annotations replaced by the given dictionary. |
Class Variable | _clone_annotations_traverse_internals |
Undocumented |
Inherited from SupportsAnnotations
(via GenerativeSelect
, SelectBase
, SupportsCloneAnnotations
):
Property | _annotations_cache_key |
Undocumented |
Inherited from Selectable
(via GenerativeSelect
, SelectBase
):
Method | corresponding_column |
No summary |
Method | replace_selectable |
Replace all occurrences of _expression.FromClause 'old' with the given _expression.Alias object, returning a copy of this _expression.FromClause . |
Class Variable | is_selectable |
Undocumented |
Inherited from ReturnsRows
(via GenerativeSelect
, SelectBase
, Selectable
):
Class Variable | _is_from_clause |
Undocumented |
Class Variable | _is_lateral |
Undocumented |
Class Variable | _is_returns_rows |
Undocumented |
Property | selectable |
Undocumented |
Inherited from ReturnsRowsRole
(via GenerativeSelect
, SelectBase
, Selectable
, ReturnsRows
):
Class Variable | _role_name |
Undocumented |
Inherited from SQLRole
(via GenerativeSelect
, SelectBase
, Selectable
, ReturnsRows
, ReturnsRowsRole
):
Class Variable | allows_lambda |
Undocumented |
Class Variable | uses_inspection |
Undocumented |
Inherited from ClauseElement
(via GenerativeSelect
, SelectBase
, Selectable
, ReturnsRows
):
Method | compare |
Compare this _expression.ClauseElement to the given _expression.ClauseElement . |
Method | compile |
Compile this SQL expression. |
Method | params |
Return a copy with _expression.bindparam elements replaced. |
Method | unique_params |
Return a copy with _expression.bindparam elements replaced. |
Method | __bool__ |
Undocumented |
Method | __getstate__ |
Undocumented |
Method | __invert__ |
Undocumented |
Method | __repr__ |
Undocumented |
Method | __str__ |
Undocumented |
Method | _clone |
Create a shallow copy of this ClauseElement. |
Method | _cloned_set |
Return the set consisting all cloned ancestors of this ClauseElement. |
Method | _compile_w_cache |
Undocumented |
Method | _compiler |
Return a compiler appropriate for this ClauseElement, given a Dialect. |
Method | _execute_on_connection |
Undocumented |
Method | _negate |
Undocumented |
Method | _negate_in_binary |
a hook to allow the right side of a binary expression to respond to a negation of the binary expression. |
Method | _replace_params |
Undocumented |
Method | _set_propagate_attrs |
Undocumented |
Method | _ungroup |
Return this _expression.ClauseElement without any groupings. |
Method | _with_binary_element_type |
in the context of binary expression, convert the type of this object to the one given. |
Class Variable | _cache_key_traversal |
Undocumented |
Class Variable | _is_bind_parameter |
Undocumented |
Class Variable | _is_clause_list |
Undocumented |
Class Variable | _is_clone_of |
Undocumented |
Class Variable | _is_immutable |
Undocumented |
Class Variable | _is_lambda_element |
Undocumented |
Class Variable | _is_select_container |
Undocumented |
Class Variable | _is_singleton_constant |
Undocumented |
Class Variable | _is_text_clause |
Undocumented |
Class Variable | _is_textual |
Undocumented |
Class Variable | _order_by_label_element |
Undocumented |
Class Variable | description |
Undocumented |
Class Variable | is_clause_element |
Undocumented |
Class Variable | stringify_dialect |
Undocumented |
Class Variable | supports_execution |
Undocumented |
Instance Variable | _propagate_attrs |
like annotations, however these propagate outwards liberally as SQL constructs are built, and are set up at construction time. |
Property | _constructor |
return the 'constructor' for this ClauseElement. |
Property | entity_namespace |
Undocumented |
Inherited from SQLRole
(via GenerativeSelect
, SelectBase
, Selectable
, ReturnsRows
, ClauseElement
):
Class Variable | allows_lambda |
Undocumented |
Class Variable | uses_inspection |
Undocumented |
Inherited from SupportsWrappingAnnotations
(via GenerativeSelect
, SelectBase
, Selectable
, ReturnsRows
, ClauseElement
):
Method | _annotate |
return a copy of this ClauseElement with annotations updated by the given dictionary. |
Method | _deannotate |
return a copy of this _expression.ClauseElement with annotations removed. |
Method | _with_annotations |
return a copy of this ClauseElement with annotations replaced by the given dictionary. |
Inherited from SupportsAnnotations
(via GenerativeSelect
, SelectBase
, Selectable
, ReturnsRows
, ClauseElement
, SupportsWrappingAnnotations
):
Property | _annotations_cache_key |
Undocumented |
Inherited from MemoizedHasCacheKey
(via GenerativeSelect
, SelectBase
, Selectable
, ReturnsRows
, ClauseElement
):
Method | _generate_cache_key |
return a cache key. |
Inherited from HasCacheKey
(via GenerativeSelect
, SelectBase
, Selectable
, ReturnsRows
, ClauseElement
, MemoizedHasCacheKey
):
Class Variable | inherit_cache |
Indicate if this .HasCacheKey instance should make use of the cache key generation scheme used by its immediate superclass. |
Class Method | _generate_cache_attrs |
generate cache key dispatcher for a new class. |
Class Method | _generate_cache_key_for_object |
Undocumented |
Method | _gen_cache_key |
return an optional cache key. |
Class Variable | __slots__ |
Undocumented |
Class Variable | _hierarchy_supports_caching |
private attribute which may be set to False to prevent the inherit_cache warning from being emitted for a hierarchy of subclasses. |
Class Variable | _is_has_cache_key |
Undocumented |
Inherited from HasCopyInternals
(via GenerativeSelect
, SelectBase
, Selectable
, ReturnsRows
, ClauseElement
):
Method | _copy_internals |
Reassign internal elements to be clones of themselves. |
Inherited from Traversible
(via GenerativeSelect
, SelectBase
, Selectable
, ReturnsRows
, ClauseElement
):
Method | get_children |
Return immediate child .visitors.Traversible elements of this .visitors.Traversible . |
Method | __class_getitem__ |
Undocumented |
Apply a 'grouping' to this _expression.ClauseElement
.
This method is overridden by subclasses to return a "grouping"
construct, i.e. parenthesis. In particular it's used by "binary"
expressions to provide a grouping around themselves when placed into a
larger expression, as well as by _expression.select
constructs when placed into the FROM clause of another
_expression.select
. (Note that subqueries should be
normally created using the _expression.Select.alias
method,
as many
platforms require nested SELECT statements to be named).
As expressions are composed together, the application of
self_group
is automatic - end-user code should never
need to use this method directly. Note that SQLAlchemy's
clause constructs take operator precedence into account -
so parenthesis might not be needed, for example, in
an expression like x OR (y AND z) - AND takes precedence
over OR.
The base self_group
method of
_expression.ClauseElement
just returns self.
Return an EXCEPT of multiple selectables.
The returned object is an instance of
_expression.CompoundSelect
.
Parameters | |
*selects | a list of _expression.Select instances. |
**kwargs | available keyword arguments are the same as those of
select . |
Return an EXCEPT ALL of multiple selectables.
The returned object is an instance of
_expression.CompoundSelect
.
Parameters | |
*selects | a list of _expression.Select instances. |
**kwargs | available keyword arguments are the same as those of
select . |
Return an INTERSECT of multiple selectables.
The returned object is an instance of
_expression.CompoundSelect
.
Parameters | |
*selects | a list of _expression.Select instances. |
**kwargs | available keyword arguments are the same as those of
select . |
Return an INTERSECT ALL of multiple selectables.
The returned object is an instance of
_expression.CompoundSelect
.
Parameters | |
*selects | a list of _expression.Select instances. |
**kwargs | available keyword arguments are the same as those of
select . |
Return a UNION of multiple selectables.
The returned object is an instance of
_expression.CompoundSelect
.
A similar union()
method is available on all
_expression.FromClause
subclasses.
Parameters | |
*selects | a list of _expression.Select instances. |
**kwargs | available keyword arguments are the same as those of
select . |
Return a UNION ALL of multiple selectables.
The returned object is an instance of
_expression.CompoundSelect
.
A similar union_all()
method is available on all
_expression.FromClause
subclasses.
Parameters | |
*selects | a list of _expression.Select instances. |
**kwargs | available keyword arguments are the same as those of
select . |
A sequence of expressions that correspond to what is rendered
in the columns clause, including _sql.TextClause
constructs.
See Also
_sql.SelectBase.exported_columns
sqlalchemy.sql.base.Executable.bind
_engine.Engine
or _engine.Connection
to which this .Executable
is bound, or None if none found.A _expression.ColumnCollection
representing the columns that
this SELECT statement or similar construct returns in its result set,
not including _sql.TextClause
constructs.
For a _expression.CompoundSelect
, the
_expression.CompoundSelect.selected_columns
attribute returns the selected
columns of the first SELECT statement contained within the series of
statements within the set operation.
See Also
_sql.Select.selected_columns