MediaWiki
master
|
Public Member Functions | |
__construct (IReadableDatabase $db, ActorStore $actorStore, TempUserConfig $tempUserConfig) | |
anon () | |
Only return anonymous users. More... | |
fetchUserIdentities () | |
Fetch UserIdentities for the specified query. More... | |
fetchUserIdentity () | |
Fetch a single UserIdentity that matches specified criteria. More... | |
fetchUserNames () | |
Returns an array of user names matching the query. More... | |
hidden (bool $hidden) | |
Filter based on user hidden status. More... | |
named () | |
Only return named users. More... | |
orderByName (string $dir=self::SORT_ASC) | |
Order results by name in $direction. More... | |
orderByUserId (string $dir=self::SORT_ASC) | |
Order results by user id. More... | |
registered () | |
Only return registered users. More... | |
temp () | |
Only return temp users. More... | |
userIds ( $userIds) | |
Find by provided user ids. More... | |
userNamePrefix (string $prefix) | |
Find users with names starting from the provided prefix. More... | |
userNames ( $userNames) | |
Find by provided user names. More... | |
whereUserIds ( $userIds) | |
Find by provided user ids. More... | |
whereUserNamePrefix (string $prefix) | |
Find users with names starting from the provided prefix. More... | |
whereUserNames ( $userNames) | |
Find by provided user names. More... | |
![]() | |
__construct (IReadableDatabase $db) | |
Only for use in subclasses. More... | |
acquireRowLocks () | |
Execute the query, but throw away the results. More... | |
andWhere ( $conds) | |
Add conditions to the query. More... | |
bigResult () | |
Enable the SQL_BIG_RESULT option. More... | |
bufferResult () | |
Enable the SQL_BUFFER_RESULT option. More... | |
buildGroupConcatField ( $delim) | |
Build a GROUP_CONCAT or equivalent statement for a query. More... | |
calcFoundRows () | |
Enable the SQL_CALC_FOUND_ROWS option. More... | |
caller ( $fname) | |
Set the method name to be included in an SQL comment. More... | |
clearFields () | |
Remove all fields from the query. More... | |
conds ( $conds) | |
Add conditions to the query. More... | |
connection (IReadableDatabase $db) | |
Change the IReadableDatabase object the query builder is bound to. More... | |
distinct () | |
Enable the DISTINCT option. More... | |
estimateRowCount () | |
Estimate the number of rows in dataset. More... | |
explain () | |
Make the query be an EXPLAIN SELECT query instead of a SELECT query. More... | |
fetchField () | |
Run the constructed SELECT query, and return a single field extracted from the first result row. More... | |
fetchFieldValues () | |
Run the constructed SELECT query, and extract a single field from each result row, returning an array containing all the values. More... | |
fetchResultSet () | |
Run the constructed SELECT query and return all results. More... | |
fetchRow () | |
Run the constructed SELECT query, and return the first result row. More... | |
fetchRowCount () | |
Run the SELECT query, and return the number of results. More... | |
field ( $field, $alias=null) | |
Add a single field to the query, optionally with an alias. More... | |
fields ( $fields) | |
Add a field or an array of fields to the query. More... | |
forUpdate () | |
Enable the FOR UPDATE option. More... | |
from ( $table, $alias=null) | |
Add a single table to the SELECT query. More... | |
getQueryInfo ( $joinsName='join_conds') | |
Get an associative array describing the query in terms of its raw parameters to Database::select(). More... | |
getSQL () | |
Get the SQL query string which would be used by fetchResultSet(). More... | |
groupBy ( $group) | |
Add a GROUP BY clause. More... | |
having ( $having) | |
Add a HAVING clause. More... | |
ignoreIndex ( $index) | |
Set the IGNORE INDEX option. More... | |
joinConds (array $joinConds) | |
Manually append to the $join_conds array which will be passed to IReadableDatabase::select(). More... | |
limit ( $limit) | |
Set the query limit. More... | |
lockInShareMode () | |
Enable the LOCK IN SHARE MODE option. More... | |
merge (SelectQueryBuilder $builder) | |
Merge another query builder with this one. More... | |
newJoinGroup () | |
Create a parenthesized group of joins which can be added to the object like a table. More... | |
newSubquery () | |
Get an empty SelectQueryBuilder which can be used to build a subquery of this query. More... | |
offset ( $offset) | |
Set the offset. More... | |
option ( $name, $value=null) | |
Manually set an option in the $options array to be passed to IReadableDatabase::select() More... | |
options (array $options) | |
Manually set multiple options in the $options array to be passed to IReadableDatabase::select(). More... | |
orderBy ( $fields, $direction=null) | |
Set the ORDER BY clause. More... | |
queryInfo ( $info) | |
Set the query parameters to the given values, appending to the values which were already set. More... | |
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. More... | |
select ( $fields) | |
Add a field or an array of fields to the query. More... | |
setMaxExecutionTime (int $time) | |
Set MAX_EXECUTION_TIME for queries. More... | |
smallResult () | |
Enable the SQL_SMALL_RESULT option. More... | |
straightJoinOption () | |
Enable the STRAIGHT_JOIN query option. More... | |
tables ( $tables) | |
Add multiple tables. More... | |
useIndex ( $index) | |
Set a USE INDEX option. More... | |
where ( $conds) | |
Add conditions to the query. More... | |
![]() | |
join ( $table, $alias=null, $conds=[]) | |
Inner join a table or group of tables. More... | |
leftJoin ( $table, $alias=null, $conds=[]) | |
Left join a table or group of tables. More... | |
straightJoin ( $table, $alias=null, $conds=[]) | |
Straight join a table or group of tables. More... | |
table ( $table, $alias=null) | |
Add a single table or a single parenthesized group. More... | |
Additional Inherited Members | |
![]() | |
getAutoAlias () | |
Get a table alias which is unique to this SelectQueryBuilder. More... | |
![]() | |
IReadableDatabase IReadableDatabase | $db |
array | $options = [] |
The options to be passed to IReadableDatabase::select() More... | |
![]() | |
array | $joinConds = [] |
$lastAlias | |
array | $tables = [] |
Definition at line 30 of file UserSelectQueryBuilder.php.
MediaWiki\User\UserSelectQueryBuilder::__construct | ( | IReadableDatabase | $db, |
ActorStore | $actorStore, | ||
TempUserConfig | $tempUserConfig | ||
) |
IReadableDatabase | $db | |
ActorStore | $actorStore | |
TempUserConfig | $tempUserConfig |
Definition at line 42 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 168 of file UserSelectQueryBuilder.php.
MediaWiki\User\UserSelectQueryBuilder::fetchUserIdentities | ( | ) |
Fetch UserIdentities for the specified query.
Definition at line 247 of file UserSelectQueryBuilder.php.
MediaWiki\User\UserSelectQueryBuilder::fetchUserIdentity | ( | ) |
Fetch a single UserIdentity that matches specified criteria.
Definition at line 233 of file UserSelectQueryBuilder.php.
MediaWiki\User\UserSelectQueryBuilder::fetchUserNames | ( | ) |
Returns an array of user names matching the query.
Definition at line 262 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 216 of file UserSelectQueryBuilder.php.
MediaWiki\User\UserSelectQueryBuilder::named | ( | ) |
Only return named users.
Definition at line 178 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 137 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 148 of file UserSelectQueryBuilder.php.
MediaWiki\User\UserSelectQueryBuilder::registered | ( | ) |
Only return registered users.
Definition at line 158 of file UserSelectQueryBuilder.php.
MediaWiki\User\UserSelectQueryBuilder::temp | ( | ) |
Only return temp users.
Definition at line 196 of file UserSelectQueryBuilder.php.
MediaWiki\User\UserSelectQueryBuilder::userIds | ( | $userIds | ) |
Find by provided user ids.
int | int[] | $userIds |
Definition at line 72 of file UserSelectQueryBuilder.php.
MediaWiki\User\UserSelectQueryBuilder::userNamePrefix | ( | string | $prefix | ) |
Find users with names starting from the provided prefix.
string | $prefix |
Definition at line 127 of file UserSelectQueryBuilder.php.
MediaWiki\User\UserSelectQueryBuilder::userNames | ( | $userNames | ) |
Find by provided user names.
string | string[] | $userNames |
Definition at line 97 of file UserSelectQueryBuilder.php.
MediaWiki\User\UserSelectQueryBuilder::whereUserIds | ( | $userIds | ) |
Find by provided user ids.
int | int[] | $userIds |
Definition at line 60 of file UserSelectQueryBuilder.php.
MediaWiki\User\UserSelectQueryBuilder::whereUserNamePrefix | ( | string | $prefix | ) |
Find users with names starting from the provided prefix.
string | $prefix |
Definition at line 110 of file UserSelectQueryBuilder.php.
MediaWiki\User\UserSelectQueryBuilder::whereUserNames | ( | $userNames | ) |
Find by provided user names.
string | string[] | $userNames |
Definition at line 82 of file UserSelectQueryBuilder.php.