Class QueryFactory
Factory class for generating instances of Select, Insert, Update, Delete queries.
Method Summary
-
__construct() public
Constructor/
-
delete() public
Create a new DeleteQuery instance.
-
insert() public
Create a new InsertQuery instance.
-
select() public
Create a new SelectQuery instance.
-
update() public
Create a new UpdateQuery instance.
Method Detail
__construct() ¶ public
__construct(Cake\Database\Connection $connection)Constructor/
Parameters
-
Cake\Database\Connection$connection Connection instance.
delete() ¶ public
delete(string|null $table = null, array $conditions = [], array<string, string> $types = []): Cake\Database\Query\DeleteQueryCreate a new DeleteQuery instance.
Parameters
-
string|null$table optional The table to delete rows from.
-
array$conditions optional Conditions to be set for the delete statement.
-
array<string, string>$types optional Associative array containing the types to be used for casting.
Returns
Cake\Database\Query\DeleteQueryinsert() ¶ public
insert(string|null $table = null, array $values = [], array<int|string, string> $types = []): Cake\Database\Query\InsertQueryCreate a new InsertQuery instance.
Parameters
-
string|null$table optional The table to insert rows into.
-
array$values optional Associative array of column => value to be inserted.
-
array<int|string, string>$types optional Associative array containing the types to be used for casting.
Returns
Cake\Database\Query\InsertQueryselect() ¶ public
select(Cake\Database\ExpressionInterface|Closure|array|string|float|int $fields = [], array|string $table = [], array<string, string> $types = []): Cake\Database\Query\SelectQueryCreate a new SelectQuery instance.
Parameters
-
Cake\Database\ExpressionInterface|Closure|array|string|float|int$fields optional Fields/columns list for the query.
-
array|string$table optional List of tables to query.
-
array<string, string>$types optional Associative array containing the types to be used for casting.
Returns
Cake\Database\Query\SelectQueryupdate() ¶ public
update(Cake\Database\ExpressionInterface|string|null $table = null, array $values = [], array $conditions = [], array<string, string> $types = []): Cake\Database\Query\UpdateQueryCreate a new UpdateQuery instance.
Parameters
-
Cake\Database\ExpressionInterface|string|null$table optional The table to update rows of.
-
array$values optional Values to be updated.
-
array$conditions optional Conditions to be set for the update statement.
-
array<string, string>$types optional Associative array containing the types to be used for casting.
Returns
Cake\Database\Query\UpdateQuery