|
| __construct (IReadableDatabase $db, string $type='file', array $options=[]) |
|
| __construct (IReadableDatabase $db) |
| Only for use in subclasses.
|
|
| acquireRowLocks () |
| Execute the query, but throw away the results.
|
|
| andWhere ( $conds) |
| Add conditions to the query.
|
|
| bigResult () |
| Enable the SQL_BIG_RESULT option.
|
|
| bufferResult () |
| Enable the SQL_BUFFER_RESULT option.
|
|
| buildGroupConcatField ( $delim) |
| Build a GROUP_CONCAT or equivalent statement for a query.
|
|
| calcFoundRows () |
| Enable the SQL_CALC_FOUND_ROWS option.
|
|
| caller ( $fname) |
| Set the method name to be included in an SQL comment.
|
|
| clearFields () |
| Remove all fields from the query.
|
|
| conds ( $conds) |
| Add conditions to the query.
|
|
| connection (IReadableDatabase $db) |
| Change the IReadableDatabase object the query builder is bound to.
|
|
| distinct () |
| Enable the DISTINCT option.
|
|
| estimateRowCount () |
| Estimate the number of rows in dataset.
|
|
| explain () |
| Make the query be an EXPLAIN SELECT query instead of a SELECT query.
|
|
| fetchField () |
| Run the constructed SELECT query, and return a single field extracted from the first result row.
|
|
| fetchFieldValues () |
| Run the constructed SELECT query, and extract a single field from each result row, returning an array containing all the values.
|
|
| fetchResultSet () |
| Run the constructed SELECT query and return all results.
|
|
| fetchRow () |
| Run the constructed SELECT query, and return the first result row.
|
|
| fetchRowCount () |
| Run the SELECT query, and return the number of results.
|
|
| field ( $field, $alias=null) |
| Add a single field to the query, optionally with an alias.
|
|
| fields ( $fields) |
| Add a field or an array of fields to the query.
|
|
| forUpdate () |
| Enable the FOR UPDATE option.
|
|
| from ( $table, $alias=null) |
| Add a single table to the SELECT query.
|
|
| getQueryInfo ( $joinsName='join_conds') |
| Get an associative array describing the query in terms of its raw parameters to Database::select().
|
|
| getSQL () |
| Get the SQL query string which would be used by fetchResultSet().
|
|
| groupBy ( $group) |
| Add a GROUP BY clause.
|
|
| having ( $having) |
| Add a HAVING clause.
|
|
| ignoreIndex ( $index) |
| Set the IGNORE INDEX option.
|
|
| joinConds (array $joinConds) |
| Manually append to the $join_conds array which will be passed to IReadableDatabase::select().
|
|
| limit ( $limit) |
| Set the query limit.
|
|
| lockInShareMode () |
| Enable the LOCK IN SHARE MODE option.
|
|
| merge (SelectQueryBuilder $builder) |
| Merge another query builder with this one.
|
|
| newJoinGroup () |
| Create a parenthesized group of joins which can be added to the object like a table.
|
|
| newSubquery () |
| Get an empty SelectQueryBuilder which can be used to build a subquery of this query.
|
|
| offset ( $offset) |
| Set the offset.
|
|
| option ( $name, $value=null) |
| Manually set an option in the $options array to be passed to IReadableDatabase::select()
|
|
| options (array $options) |
| Manually set multiple options in the $options array to be passed to IReadableDatabase::select().
|
|
| orderBy ( $fields, $direction=null) |
| Set the ORDER BY clause.
|
|
| queryInfo ( $info) |
| Set the query parameters to the given values, appending to the values which were already set.
|
|
| rawTables ( $tables) |
| Given a table or table array as might be passed to Database::select(), append it to the existing tables, interpreting nested arrays as join groups.
|
|
| recency ( $recency) |
|
| select ( $fields) |
| Add a field or an array of fields to the query.
|
|
| setMaxExecutionTime (int $time) |
| Set MAX_EXECUTION_TIME for queries.
|
|
| smallResult () |
| Enable the SQL_SMALL_RESULT option.
|
|
| straightJoinOption () |
| Enable the STRAIGHT_JOIN query option.
|
|
| tables ( $tables) |
| Add multiple tables.
|
|
| useIndex ( $index) |
| Set a USE INDEX option.
|
|
| where ( $conds) |
| Add conditions to the query.
|
|
| join ( $table, $alias=null, $conds=[]) |
| Inner join a table or group of tables.
|
|
| leftJoin ( $table, $alias=null, $conds=[]) |
| Left join a table or group of tables.
|
|
| straightJoin ( $table, $alias=null, $conds=[]) |
| Straight join a table or group of tables.
|
|
| table ( $table, $alias=null) |
| Add a single table or a single parenthesized group.
|
|
Definition at line 27 of file FileSelectQueryBuilder.php.