interface SelectInterface (View source)

Methods

between(string $key, string $left, string $right)

Converts the "normal" select into an index one.

select(array $projections, boolean $append)

Sets the fields to select within the query ($projections).

orderBy(string $order, boolean $append, boolean $first)

Sets an orderBy part of the SELECT.

limit(integet $limit)

Sets the maximum amount of records retrieved whithin the current SELECT.

skip($records)

Sets the number of records to skip.

Details

Select between(string $key, string $left, string $right)

Converts the "normal" select into an index one.

Index selects can query with the BETWEEN operator: select from index:name where x between 10.3 and 10.7

Parameters

string $key
string $left
string $right

Return Value

Select

Select select(array $projections, boolean $append)

Sets the fields to select within the query ($projections).

Values can be appended through the $append parameter.

Parameters

array $projections
boolean $append

Return Value

Select

Select orderBy(string $order, boolean $append, boolean $first)

Sets an orderBy part of the SELECT.

The $order should contain the property and the ASC/DESC parameter, in a single string: name DESC. With $append you can decide not to override previously-set orders. You can decide wheter to put the $order at $first place among the set orders.

Parameters

string $order
boolean $append
boolean $first

Return Value

Select

Select limit(integet $limit)

Sets the maximum amount of records retrieved whithin the current SELECT.

Parameters

integet $limit

Return Value

Select

skip($records)

Sets the number of records to skip.

Parameters

$records