cycquery.ops.Union¶

class Union(union_table, union_all=False)[source]¶

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)

Initialize the operation.

Methods

__call__(table)[source]¶

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

__init__(union_table, union_all=False)[source]¶: Initialize the operation.