Méthode |
Description |
|
__call ( $method, $params ) |
Kicker methods trigger execution |
|
__construct ( $connection = null ) |
Constructor |
|
__toString ( ) |
|
|
andOrderBy ( $sql, $params = [] ) |
Convenience method for orderBy, to be consistent with where and andWhere. |
|
andWhere ( $sql = null, $params = [] ) |
Adds an extra criteria to the where clause with an AND |
|
count ( ) |
kicker methods execute the query |
|
distinct ( $value = true ) |
Whether to prefix the SELECT clause with DISTINCT |
|
execute ( ) : Result |
Executes the query with the provided connection |
|
from ( $table ) |
Sets the FROM clause, either a single table, an array or varargs. |
|
getIterator ( ) |
* (non-phpdoc) |
|
groupBy ( $sql, $params = [] ) |
Adds an group by clause |
|
innerJoin ( $mixed, $criteria, $alias = '' ) |
Adds an INNER JOIN clause, either with a {@link Query} object or raw sql |
|
leftJoin ( $mixed, $criteria, $alias = '' ) |
Adds a LEFT JOIN clause, either with a {@link Query} object or raw sql |
|
limit ( $rows, $offset ) |
Adds a limit clause |
|
lock ( $clause = '' ) |
Adds a locking clause after the SELECT, defaults to FOR UPDATE |
|
orWhere ( $sql = null, $params = [] ) |
Adds an extra criteria to the where clause with an OR |
|
orderBy ( $sql, $params = [] ) |
Adds an order by clause |
|
rightJoin ( $mixed, $criteria, $alias = '' ) |
Adds a RIGHT JOIN clause, either with a {@link Query} object or raw sql |
|
select ( $column ) |
Sets the SELECT clause, either a single column, an array or varargs. |
|
toSql ( ) |
Returns the sql for the query |
|
where ( $sql = null, $params = [] ) |
Sets the where clause to the provided sql, optionally binding
parameters into the string. |
|