PHP Класс Ouzo\Db\ModelQueryBuilder

Показать файл Открыть проект Примеры использования класса

Открытые методы

Метод Описание
__clone ( )
__construct ( Model $model, Db $db = null, $alias = null )
_processResults ( $results )
copy ( )
count ( )
deleteAll ( ) Issues "delete from .
deleteEach ( ) Calls Model::delete method for each matching object
fetch ( ) : Model | array
fetchAll ( ) : Model[] | array[]
fetchIterator ( integer $batchSize = 500 ) : Iterator
getQuery ( )
groupBy ( $groupBy )
innerJoin ( $relationSelector, null $aliases = null, array $on = [] ) : ModelQueryBuilder
join ( $relationSelector, null $aliases = null, string $type = 'LEFT', array $on = [] ) : ModelQueryBuilder
leftJoin ( $relationSelector, null $aliases = null, array $on = [] ) : ModelQueryBuilder
limit ( $limit ) : ModelQueryBuilder
lockForUpdate ( ) : ModelQueryBuilder
offset ( $offset ) : ModelQueryBuilder
options ( array $options )
order ( $columns ) : ModelQueryBuilder
rightJoin ( $relationSelector, null $aliases = null, array $on = [] ) : ModelQueryBuilder
select ( $columns, integer $type = PDO::FETCH_NUM ) : ModelQueryBuilder
selectDistinct ( $columns, integer $type = PDO::FETCH_NUM ) : ModelQueryBuilder
update ( array $attributes ) : integer Runs an update query against a set of models
using ( $relationSelector, null $aliases ) : ModelQueryBuilder
where ( string $where = '', array $values = [] ) : ModelQueryBuilder
with ( $relationSelector ) : ModelQueryBuilder

Приватные методы

Метод Описание
_addRelationToFetch ( $relationToFetch )
addJoin ( ModelJoin $modelJoin )
aliasPrefixForSelect ( $alias )
createModelJoins ( $relationSelector, $aliases, $type, $on )
getModelAliasOrTable ( )
isAlreadyAddedToFetch ( RelationToFetch $relationToFetch )
isAlreadyJoined ( ModelJoin $modelJoin )
selectModelColumns ( Model $metaInstance, $alias )

Описание методов

__clone() публичный Метод

public __clone ( )

__construct() публичный Метод

public __construct ( Model $model, Db $db = null, $alias = null )
$model Ouzo\Model
$db Ouzo\Db

_processResults() публичный Метод

public _processResults ( $results )

copy() публичный Метод

public copy ( )

count() публичный Метод

public count ( )

deleteAll() публичный Метод

.. where ..." sql command. Note that overridden Model::delete is not called.
public deleteAll ( )

deleteEach() публичный Метод

Calls Model::delete method for each matching object
public deleteEach ( )

fetch() публичный Метод

public fetch ( ) : Model | array
Результат Ouzo\Model | array

fetchAll() публичный Метод

public fetchAll ( ) : Model[] | array[]
Результат Ouzo\Model[] | array[]

fetchIterator() публичный Метод

public fetchIterator ( integer $batchSize = 500 ) : Iterator
$batchSize integer
Результат Iterator

getQuery() публичный Метод

public getQuery ( )

groupBy() публичный Метод

public groupBy ( $groupBy )

innerJoin() публичный Метод

public innerJoin ( $relationSelector, null $aliases = null, array $on = [] ) : ModelQueryBuilder
$relationSelector - Relation object, relation name or nested relations 'rel1->rel2'
$aliases null - alias of the first joined table or array of aliases for nested joins
$on array
Результат ModelQueryBuilder

join() публичный Метод

public join ( $relationSelector, null $aliases = null, string $type = 'LEFT', array $on = [] ) : ModelQueryBuilder
$relationSelector - Relation object, relation name or nested relations 'rel1->rel2'
$aliases null - alias of the first joined table or array of aliases for nested joins
$type string - join type, defaults to LEFT
$on array
Результат ModelQueryBuilder

leftJoin() публичный Метод

public leftJoin ( $relationSelector, null $aliases = null, array $on = [] ) : ModelQueryBuilder
$relationSelector - Relation object, relation name or nested relations 'rel1->rel2'
$aliases null - alias of the first joined table or array of aliases for nested joins
$on array
Результат ModelQueryBuilder

limit() публичный Метод

public limit ( $limit ) : ModelQueryBuilder
$limit
Результат ModelQueryBuilder

lockForUpdate() публичный Метод

public lockForUpdate ( ) : ModelQueryBuilder
Результат ModelQueryBuilder

offset() публичный Метод

public offset ( $offset ) : ModelQueryBuilder
$offset
Результат ModelQueryBuilder

options() публичный Метод

public options ( array $options )
$options array

order() публичный Метод

public order ( $columns ) : ModelQueryBuilder
$columns
Результат ModelQueryBuilder

rightJoin() публичный Метод

public rightJoin ( $relationSelector, null $aliases = null, array $on = [] ) : ModelQueryBuilder
$relationSelector - Relation object, relation name or nested relations 'rel1->rel2'
$aliases null - alias of the first joined table or array of aliases for nested joins
$on array
Результат ModelQueryBuilder

select() публичный Метод

public select ( $columns, integer $type = PDO::FETCH_NUM ) : ModelQueryBuilder
$columns
$type integer
Результат ModelQueryBuilder

selectDistinct() публичный Метод

public selectDistinct ( $columns, integer $type = PDO::FETCH_NUM ) : ModelQueryBuilder
$columns
$type integer
Результат ModelQueryBuilder

update() публичный Метод

Runs an update query against a set of models
public update ( array $attributes ) : integer
$attributes array
Результат integer

using() публичный Метод

public using ( $relationSelector, null $aliases ) : ModelQueryBuilder
$relationSelector - Relation object, relation name or nested relations 'rel1->rel2'
$aliases null - alias of the first joined table or array of aliases for nested joins
Результат ModelQueryBuilder

where() публичный Метод

public where ( string $where = '', array $values = [] ) : ModelQueryBuilder
$where string
$values array
Результат ModelQueryBuilder

with() публичный Метод

public with ( $relationSelector ) : ModelQueryBuilder
$relationSelector - Relation object, relation name or nested relations 'rel1->rel2'
Результат ModelQueryBuilder