Query/Builder.php
Show:
inherited
inherited
Classes
- Package
- Default
\ShSo\Lacassa\Query\Builder
Package: Default
- Parent(s)
- \Illuminate\Database\Query\Builder
Properties
$allowFiltering = falseDefault value
falseDetails- Type
- n/a
array $bindings = array('select' => array(), 'where' => array(), 'updateCollection' => array(), 'insertCollection' => array())The current query value bindings.
Default value
array('select' => array(), 'where' => array(), 'updateCollection' => array(), 'insertCollection' => array())Details- Type
- array
array $collectionTypes = array('set', 'list', 'map')Default value
array('set', 'list', 'map')Details- Type
- array
array $conversion = array('=' => '$eq', '!=' => '$ne', '<>' => '$ne', '<' => '$lt', '<=' => '$lte', '>' => '$gt', '>=' => '$gte')Operator conversion.
Default value
array('=' => '$eq', '!=' => '$ne', '<>' => '$ne', '<' => '$lt', '<=' => '$lte', '>' => '$gt', '>=' => '$gte')Details- Type
- array
$distinct = falseDefault value
falseDetails- Type
- n/a
array $insertCollectionsThe where constraints for the query.
Details
- Type
- array
array $operators = array('=', '<', '>', '<=', '>=', 'like', 'contains', 'contains key')All of the available clause operators.
Default value
array('=', '<', '>', '<=', '>=', 'like', 'contains', 'contains key')Details- Type
- array
array $updateCollectionsThe where constraints for the query.
Details
- Type
- array
Methods
__construct(\ShSo\Lacassa\Connection $connection) : voidParameters
| Name | Type | Description |
|---|---|---|
| $connection | \ShSo\Lacassa\Connection |
addCollectionBinding(array $value, string $type = 'updateCollection') : \ShSo\Lacassa\Query\BuilderAdd a binding to the query.
Parameters
Returns
Throws
Details
| Name | Type | Description |
|---|---|---|
| $value | array | |
| $type | string |
| Type | Description |
|---|---|
| \ShSo\Lacassa\Query\Builder |
| Exception | Description |
|---|---|
| \InvalidArgumentException |
- Fluent
- This method is part of a fluent interface and will return the same instance
allowFiltering() : voidcount(string $columns = '*') : \Cassandra\RowsRetrieve the "count" result of the query.
Parameters
Returns
| Name | Type | Description |
|---|---|---|
| $columns | string |
| Type | Description |
|---|---|
| \Cassandra\Rows |
deleteColumn(array $columns) : \Cassandra\RowsDelete a column from the database.
Parameters
Returns
| Name | Type | Description |
|---|---|---|
| $columns | array |
| Type | Description |
|---|---|
| \Cassandra\Rows |
deleteRow() : \Cassandra\RowsDelete a record from the database.
Returns
| Type | Description |
|---|---|
| \Cassandra\Rows |
distinct() : voidexecute(string $cql) : \Cassandra\RowsExecute the CQL query.
Parameters
Returns
| Name | Type | Description |
|---|---|---|
| $cql | string |
| Type | Description |
|---|---|
| \Cassandra\Rows |
executeAsync(string $cql) : \Cassandra\FutureRowsExecute the CQL query asyncronously.
Parameters
Returns
| Name | Type | Description |
|---|---|---|
| $cql | string |
| Type | Description |
|---|---|
| \Cassandra\FutureRows |
get(array $columns = array('*')) : \Cassandra\RowsExecute the query as a "select" statement.
Parameters
Returns
| Name | Type | Description |
|---|---|---|
| $columns | array |
| Type | Description |
|---|---|
| \Cassandra\Rows |
getAsync(array $columns = array('*')) : \Cassandra\FutureRowsExecute the query as a "select" statement.
Parameters
Returns
| Name | Type | Description |
|---|---|---|
| $columns | array |
| Type | Description |
|---|---|
| \Cassandra\FutureRows |
index(array $columns = array()) : \Cassandra\RowsParameters
Returns
| Name | Type | Description |
|---|---|---|
| $columns | array |
| Type | Description |
|---|---|
| \Cassandra\Rows |
insert(array $values = array()) : booleanInsert a new record into the database.
Parameters
Returns
| Name | Type | Description |
|---|---|---|
| $values | array |
| Type | Description |
|---|---|
| boolean |
insertCollection(string $type, string $column, string $value) : \ShSo\Lacassa\Query\BuilderInsert a colletion type in cassandra.
Parameters
Returns
Details
| Name | Type | Description |
|---|---|---|
| $type | string | |
| $column | string | |
| $value | string |
| Type | Description |
|---|---|
| \ShSo\Lacassa\Query\Builder |
- Fluent
- This method is part of a fluent interface and will return the same instance
update(array $values = array()) : integerUpdate a record in the database.
Parameters
Returns
| Name | Type | Description |
|---|---|---|
| $values | array |
| Type | Description |
|---|---|
| integer |
updateCollection(string $type, string $column, string $operation = null, string $value = null) : stringUsed to update the colletions like set, list and map.
Parameters
Returns
| Name | Type | Description |
|---|---|---|
| $type | string | |
| $column | string | |
| $operation | string | |
| $value | string |
| Type | Description |
|---|---|
| string |