PHP Class Ouzo\Db\ModelQueryBuilder

Afficher le fichier Open project: letsdrink/ouzo Class Usage Examples

Méthodes publiques

Méthode Description
__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

Private Methods

Méthode Description
_addRelationToFetch ( $relationToFetch )
addJoin ( ModelJoin $modelJoin )
aliasPrefixForSelect ( $alias )
createModelJoins ( $relationSelector, $aliases, $type, $on )
getModelAliasOrTable ( )
isAlreadyAddedToFetch ( RelationToFetch $relationToFetch )
isAlreadyJoined ( ModelJoin $modelJoin )
selectModelColumns ( Model $metaInstance, $alias )

Method Details

__clone() public méthode

public __clone ( )

__construct() public méthode

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

_processResults() public méthode

public _processResults ( $results )

copy() public méthode

public copy ( )

count() public méthode

public count ( )

deleteAll() public méthode

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

deleteEach() public méthode

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

fetch() public méthode

public fetch ( ) : Model | array
Résultat Ouzo\Model | array

fetchAll() public méthode

public fetchAll ( ) : Model[] | array[]
Résultat Ouzo\Model[] | array[]

fetchIterator() public méthode

public fetchIterator ( integer $batchSize = 500 ) : Iterator
$batchSize integer
Résultat Iterator

getQuery() public méthode

public getQuery ( )

groupBy() public méthode

public groupBy ( $groupBy )

innerJoin() public méthode

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
Résultat ModelQueryBuilder

join() public méthode

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
Résultat ModelQueryBuilder

leftJoin() public méthode

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
Résultat ModelQueryBuilder

limit() public méthode

public limit ( $limit ) : ModelQueryBuilder
$limit
Résultat ModelQueryBuilder

lockForUpdate() public méthode

public lockForUpdate ( ) : ModelQueryBuilder
Résultat ModelQueryBuilder

offset() public méthode

public offset ( $offset ) : ModelQueryBuilder
$offset
Résultat ModelQueryBuilder

options() public méthode

public options ( array $options )
$options array

order() public méthode

public order ( $columns ) : ModelQueryBuilder
$columns
Résultat ModelQueryBuilder

rightJoin() public méthode

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
Résultat ModelQueryBuilder

select() public méthode

public select ( $columns, integer $type = PDO::FETCH_NUM ) : ModelQueryBuilder
$columns
$type integer
Résultat ModelQueryBuilder

selectDistinct() public méthode

public selectDistinct ( $columns, integer $type = PDO::FETCH_NUM ) : ModelQueryBuilder
$columns
$type integer
Résultat ModelQueryBuilder

update() public méthode

Runs an update query against a set of models
public update ( array $attributes ) : integer
$attributes array
Résultat integer

using() public méthode

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
Résultat ModelQueryBuilder

where() public méthode

public where ( string $where = '', array $values = [] ) : ModelQueryBuilder
$where string
$values array
Résultat ModelQueryBuilder

with() public méthode

public with ( $relationSelector ) : ModelQueryBuilder
$relationSelector - Relation object, relation name or nested relations 'rel1->rel2'
Résultat ModelQueryBuilder