cycquery.ops.Union

class Union(union_table, union_all=False)

Bases: QueryOp

Union two tables.

Parameters:

• union_table (Union[Select, Subquery, Table, DBTable]) – Table to union with the first table.

• union_all (Optional[bool]) – Whether to use the all keyword in the union.

Examples

>>> Union(table2)(table1)
>>> Union(table2, union_all=True)(table1)

Methods

__call__(table)

Process the table.

Parameters:

table (Union[Select, Subquery, Table, DBTable]) – Table on which to perform the operation.

Returns:

Processed table.

Return type:

sqlalchemy.sql.selectable.Subquery