cycquery.ops.AddDeltaConstant

class AddDeltaConstant(add_to, delta, new_col_labels=None)

Bases: QueryOp

Construct and add a datetime.timedelta object to some columns.

Parameters:

• add_to (Union[str, List[str]]) – Column names specifying to which columns is being added.

• delta (timedelta) – A timedelta object.

• new_col_labels (Union[str, List[str], None]) – If specified, create new columns with these labels. Otherwise, apply the function to the existing columns.

Examples

>>> AddDeltaConstant("col1", datetime.timedelta(days=1))(table)
>>> AddDeltaConstant(["col1", "col2"], datetime.timedelta(days=1))(table)
>>> AddDeltaConstant("col1", datetime.timedelta(days=1), "col1_plus_1")(table)

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