PHP Interface Doctrine\OrientDB\Query\Command\SelectInterface

Show file Open project: doctrine/orientdb-odm

Public Methods

Method Description
between ( string $key, string $left, string $right ) : Select Converts the "normal" select into an index one.
limit ( integet $limit ) : Select Sets the maximum amount of records retrieved whithin the current SELECT.
orderBy ( string $order, boolean $append, boolean $first ) : Select Sets an orderBy part of the SELECT.
select ( array $projections, boolean $append ) : Select Sets the fields to select within the query ($projections).
skip ( $records ) Sets the number of records to skip.

Method Details

between() public method

Index selects can query with the BETWEEN operator: select from index:name where x between 10.3 and 10.7
public between ( string $key, string $left, string $right ) : Select
$key string
$left string
$right string
return Select

limit() public method

Sets the maximum amount of records retrieved whithin the current SELECT.
public limit ( integet $limit ) : Select
$limit integet
return Select

orderBy() public method

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.
public orderBy ( string $order, boolean $append, boolean $first ) : Select
$order string
$append boolean
$first boolean
return Select

select() public method

Values can be appended through the $append parameter.
public select ( array $projections, boolean $append ) : Select
$projections array
$append boolean
return Select

skip() public method

Sets the number of records to skip.
public skip ( $records )