Functions

Kind: global mixin

Functions.$inc(column, [value])

Increment a column

Kind: static method of Functions

Param Type Default Description
column string | Array.<*> Name of the column or the result of another function
[value] Number 1 The value to add

Functions.$dec(column, [value])

Decrement a column

Kind: static method of Functions

Param Type Default Description
column string | Array.<*> Name of the column or the result of another function
[value] Number 1 The value to substract

Functions.$div(column, [value])

Divide a column

Kind: static method of Functions

Param Type Default Description
column string | Array.<*> Name of the column or the result of another function
[value] Number 1 The denominator

Functions.$idiv(column, [value])

Integer division of a column

Kind: static method of Functions

Param Type Default Description
column string | Array.<*> Name of the column or the result of another function
[value] Number 1 The denominator

Functions.$mult(column, [value])

Multiply a column

Kind: static method of Functions

Param Type Default Description
column string | Array.<*> Name of the column or the result of another function
[value] Number 1 The value to multiply with

Functions.$mod(column, [value])

Set the remainder of the column divided by the value

Kind: static method of Functions

Param Type Default Description
column string | Array.<*> Name of the column or the result of another function
[value] Number 1 The value

Functions.$upper(column)

Convert to an uppercase column

Kind: static method of Functions

Param Type Description
column string | Array.<*> Name of the column or the result of another function

Functions.$lower(column)

Convert to an lowercase column

Kind: static method of Functions

Param Type Description
column string | Array.<*> Name of the column or the result of another function

Functions.$ceil(column)

Sets the smallest integer value not less than the column

Kind: static method of Functions

Param Type Description
column string | Array.<*> Name of the column or the result of another function

Functions.$floor(column)

Sets the largest integer value not greater than the column

Kind: static method of Functions

Param Type Description
column string | Array.<*> Name of the column or the result of another function

Functions.$ltrim(column)

Remove leading space of the column

Kind: static method of Functions

Param Type Description
column string | Array.<*> Name of the column or the result of another function

Functions.$rtrim(column)

Remove trailing space of the column

Kind: static method of Functions

Param Type Description
column string | Array.<*> Name of the column or the result of another function

Functions.$trim(column)

Remove leading and trailing space of the column

Kind: static method of Functions

Param Type Description
column string | Array.<*> Name of the column or the result of another function

Functions.$rand(column, [seed])

Sets a random floating-point value between 0 and 1.0. If the value is specified, it is used as the seed value.

Kind: static method of Functions

Param Type Description
column string | Array.<*> Name of the column or the result of another function
[seed] * Seed

Functions.$hex(column)

Sets a hexadecimal string representation of a column

Kind: static method of Functions

Param Type Description
column string | Array.<*> Name of the column or the result of another function

Functions.$pi()

Sets the value of pi

Kind: static method of Functions

Functions.$now()

Sets the current date and time

Kind: static method of Functions