|
MediaWiki REL1_39
|


Public Member Functions | |
| __construct (IDatabase $db, ActorStore $actorStore) | |
| anon () | |
| Only return anonymous users. | |
| fetchUserIdentities () | |
| Fetch UserIdentities for the specified query. | |
| fetchUserIdentity () | |
| Fetch a single UserIdentity that matches specified criteria. | |
| fetchUserNames () | |
| Returns an array of user names matching the query. | |
| hidden (bool $hidden) | |
| Filter based on user hidden status. | |
| orderByName (string $dir=self::SORT_ASC) | |
| Order results by name in $direction. | |
| orderByUserId (string $dir=self::SORT_ASC) | |
| Order results by user id. | |
| registered () | |
| Only return registered users. | |
| userIds ( $userIds) | |
| Find by provided user ids. | |
| userNamePrefix (string $prefix) | |
| Find users with names starting from the provided prefix. | |
| userNames ( $userNames) | |
| Find by provided user names. | |
| whereUserIds ( $userIds) | |
| Find by provided user ids. | |
| whereUserNamePrefix (string $prefix) | |
| Find users with names starting from the provided prefix. | |
| whereUserNames ( $userNames) | |
| Find by provided user names. | |
Public Member Functions inherited from Wikimedia\Rdbms\SelectQueryBuilder | |
| __construct (IDatabase $db) | |
| 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. | |
| conds ( $conds) | |
| Add conditions to the query. | |
| connection (IDatabase $db) | |
| Change the IDatabase 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 IDatabase::select(). | |
| limit ( $limit) | |
| Set the query limit. | |
| lockForUpdate () | |
| Run the SELECT query with the FOR UPDATE option. | |
| lockInShareMode () | |
| Enable the LOCK IN SHARE MODE option. | |
| 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 IDatabase::select() | |
| options (array $options) | |
| Manually set multiple options in the $options array to be passed to IDatabase::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. | |
| 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. | |
Public Member Functions inherited from Wikimedia\Rdbms\JoinGroupBase | |
| 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. | |
Additional Inherited Members | |
Protected Member Functions inherited from Wikimedia\Rdbms\SelectQueryBuilder | |
| getAutoAlias () | |
| Get a table alias which is unique to this SelectQueryBuilder. | |
Protected Attributes inherited from Wikimedia\Rdbms\SelectQueryBuilder | |
| IDatabase | $db |
| array | $options = [] |
| The options to be passed to IDatabase::select() | |
Protected Attributes inherited from Wikimedia\Rdbms\JoinGroupBase | |
| array | $joinConds = [] |
| $lastAlias | |
| array | $tables = [] |
Definition at line 29 of file UserSelectQueryBuilder.php.
| MediaWiki\User\UserSelectQueryBuilder::__construct | ( | IDatabase | $db, |
| ActorStore | $actorStore ) |
| IDatabase | $db | |
| ActorStore | $actorStore |
Definition at line 39 of file UserSelectQueryBuilder.php.
References Wikimedia\Rdbms\SelectQueryBuilder\$db, and Wikimedia\Rdbms\JoinGroupBase\table().
| MediaWiki\User\UserSelectQueryBuilder::anon | ( | ) |
Only return anonymous users.
Definition at line 160 of file UserSelectQueryBuilder.php.
| MediaWiki\User\UserSelectQueryBuilder::fetchUserIdentities | ( | ) |
Fetch UserIdentities for the specified query.
Definition at line 203 of file UserSelectQueryBuilder.php.
| MediaWiki\User\UserSelectQueryBuilder::fetchUserIdentity | ( | ) |
Fetch a single UserIdentity that matches specified criteria.
Definition at line 189 of file UserSelectQueryBuilder.php.
| MediaWiki\User\UserSelectQueryBuilder::fetchUserNames | ( | ) |
Returns an array of user names matching the query.
Definition at line 219 of file UserSelectQueryBuilder.php.
| MediaWiki\User\UserSelectQueryBuilder::hidden | ( | bool | $hidden | ) |
Filter based on user hidden status.
| bool | $hidden | True - only hidden users, false - no hidden users |
Definition at line 172 of file UserSelectQueryBuilder.php.
| MediaWiki\User\UserSelectQueryBuilder::orderByName | ( | string | $dir = self::SORT_ASC | ) |
Order results by name in $direction.
| string | $dir | one of self::SORT_ACS or self::SORT_DESC |
Definition at line 129 of file UserSelectQueryBuilder.php.
| MediaWiki\User\UserSelectQueryBuilder::orderByUserId | ( | string | $dir = self::SORT_ASC | ) |
Order results by user id.
| string | $dir | one of self::SORT_ACS or self::SORT_DESC |
Definition at line 140 of file UserSelectQueryBuilder.php.
| MediaWiki\User\UserSelectQueryBuilder::registered | ( | ) |
Only return registered users.
Definition at line 150 of file UserSelectQueryBuilder.php.
| MediaWiki\User\UserSelectQueryBuilder::userIds | ( | $userIds | ) |
Find by provided user ids.
| int | int[] | $userIds |
Definition at line 63 of file UserSelectQueryBuilder.php.
| MediaWiki\User\UserSelectQueryBuilder::userNamePrefix | ( | string | $prefix | ) |
Find users with names starting from the provided prefix.
| string | $prefix |
Definition at line 119 of file UserSelectQueryBuilder.php.
| MediaWiki\User\UserSelectQueryBuilder::userNames | ( | $userNames | ) |
Find by provided user names.
| string | string[] | $userNames |
Definition at line 88 of file UserSelectQueryBuilder.php.
| MediaWiki\User\UserSelectQueryBuilder::whereUserIds | ( | $userIds | ) |
Find by provided user ids.
| int | int[] | $userIds |
Definition at line 51 of file UserSelectQueryBuilder.php.
| MediaWiki\User\UserSelectQueryBuilder::whereUserNamePrefix | ( | string | $prefix | ) |
Find users with names starting from the provided prefix.
| string | $prefix |
Definition at line 101 of file UserSelectQueryBuilder.php.
| MediaWiki\User\UserSelectQueryBuilder::whereUserNames | ( | $userNames | ) |
Find by provided user names.
| string | string[] | $userNames |
Definition at line 73 of file UserSelectQueryBuilder.php.