Skip to content

arithmetic

IsNullOperator

IsNullOperator(operand, **_)

Bases: UnaryPQLOperator

Computes whether values are null.

Applies ISNULL operator to column.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

AddOperator

AddOperator(lhs_operand, rhs_operand, **_)

Bases: BinaryPQLOperator

Add operator that adds all operands.

Applies ADD operator to column.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

SubtractOperator

SubtractOperator(lhs_operand, rhs_operand, **_)

Bases: BinaryPQLOperator

Subtraction operator that subtracts all operands.

Applies SUB operator to column.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

MultiplyOperator

MultiplyOperator(lhs_operand, rhs_operand, **_)

Bases: BinaryPQLOperator

Multiply operator that multiplies all operands.

Applies MULT operator to column.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

DivideOperator

DivideOperator(lhs_operand, rhs_operand, **_)

Bases: BinaryPQLOperator

Divide operator that divides all operands.

Applies DIV operator to column.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

ModuloOperator

ModuloOperator(lhs_operand, rhs_operand, **_)

Bases: BinaryPQLOperator

Modulo operator that takes modulo of all operands.

Applies MODULO operator to column.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

FloorDivisionOperator

FloorDivisionOperator(lhs_operand, rhs_operand, **_)

Bases: BinaryPQLOperator

Floor division operator that applies floor division to all operands.

Applies FLOOR operator and DIV operator to column.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

PowerOperator

PowerOperator(lhs_operand, rhs_operand, **_)

Bases: BinaryPQLOperator

Power operator that raises the left operand to the power of the right operand.

Applies POWER operator to column.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

AbsOperator

AbsOperator(operand, **_)

Bases: UnaryPQLOperator

Operator that computes the absolute value of a series.

Applies ABS operator to column.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

InverseOperator

InverseOperator(operand, **_)

Bases: UnaryPQLOperator

Operator that computes the inverse value of a series.

Applies INVERSE operator to column.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

RoundOperator

RoundOperator(operand, decimals=0)

Bases: UnaryPQLOperator

Operator that rounds the value of a series.

Applies ROUND operator to column.

Parameters:

  • operand (Union[ScalarValue, PQLOperator]) –

    Operand to which round operator is applied.

  • decimals (int, default: 0 ) –

    Number of decimals.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.