MediaWiki
1.30.0
|
IndexPager is an efficient pager which uses a (roughly unique) index in the data set to implement paging, rather than a "LIMIT offset,limit" clause. More...
Public Member Functions | |
__construct (IContextSource $context=null) | |
doQuery () | |
Do the query, using information from the object context. More... | |
extractResultInfo ( $isFirst, $limit, ResultWrapper $res) | |
Extract some useful data from the result object for use by the navigation bar, put it into $this. More... | |
formatRow ( $row) | |
Abstract formatting function. More... | |
getBody () | |
Get the formatted result list. More... | |
getDatabase () | |
Get the Database object in use. More... | |
getDefaultQuery () | |
Get an array of query parameters that should be put into self-links. More... | |
getIndexField () | |
This function should be overridden to return the name of the index fi- eld. More... | |
getLimit () | |
Get the current limit. More... | |
getLimitLinks () | |
getNumRows () | |
Get the number of rows in the result set. More... | |
getPagingLinks ( $linkTexts, $disabledTexts=[]) | |
Get paging links. More... | |
getPagingQueries () | |
Get a URL query array for the prev, next, first and last links. More... | |
getQueryInfo () | |
This function should be overridden to provide all parameters needed for the main paged query. More... | |
getResult () | |
getSqlComment () | |
Get some text to go in brackets in the "function name" part of the SQL comment. More... | |
isNavigationBarShown () | |
Returns whether to show the "navigation bar". More... | |
makeLink ( $text, array $query=null, $type=null) | |
Make a self-link. More... | |
reallyDoQuery ( $offset, $limit, $descending) | |
Do a query with specified parameters, rather than using the object context. More... | |
setIncludeOffset ( $include) | |
Set whether a row matching exactly the offset should be also included in the result or not. More... | |
setLimit ( $limit) | |
Set the limit from an other source than the request. More... | |
setOffset ( $offset) | |
Set the offset from an other source than the request. More... | |
Public Member Functions inherited from ContextSource | |
canUseWikiPage () | |
Check whether a WikiPage object can be get with getWikiPage(). More... | |
exportSession () | |
Export the resolved user IP, HTTP headers, user ID, and session ID. More... | |
getConfig () | |
Get the Config object. More... | |
getContext () | |
Get the base IContextSource object. More... | |
getLanguage () | |
Get the Language object. More... | |
getOutput () | |
Get the OutputPage object. More... | |
getRequest () | |
Get the WebRequest object. More... | |
getSkin () | |
Get the Skin object. More... | |
getStats () | |
Get the Stats object. More... | |
getTiming () | |
Get the Timing object. More... | |
getTitle () | |
Get the Title object. More... | |
getUser () | |
Get the User object. More... | |
getWikiPage () | |
Get the WikiPage object. More... | |
msg ( $key) | |
Get a Message object with context set Parameters are the same as wfMessage() More... | |
setContext (IContextSource $context) | |
Set the IContextSource object. More... | |
Public Member Functions inherited from Pager | |
getNavigationBar () | |
Public Attributes | |
$mDb | |
$mDefaultDirection | |
$mDefaultDirection gives the direction to use when sorting results: DIR_ASCENDING or DIR_DESCENDING. More... | |
$mDefaultLimit = 50 | |
$mDefaultQuery | |
$mFirstShown | |
$mIsBackwards | |
$mIsFirst | |
True if the current result set is the first one. More... | |
$mIsLast | |
$mLimit | |
$mLimitsShown = [ 20, 50, 100, 250, 500 ] | |
$mNavigationBar | |
$mOffset | |
$mPastTheEndIndex | |
$mPastTheEndRow | |
$mQueryDone = false | |
$mRequest | |
ResultWrapper | $mResult |
Result object for the query. More... | |
const | DIR_ASCENDING = false |
Constants for the $mDefaultDirection field. More... | |
const | DIR_DESCENDING = true |
Protected Member Functions | |
buildQueryInfo ( $offset, $limit, $descending) | |
Build variables to use by the database wrapper. More... | |
doBatchLookups () | |
Called from getBody(), before getStartBody() is called and after doQuery() was called. More... | |
getDefaultDirections () | |
Return the default sorting direction: DIR_ASCENDING or DIR_DESCENDING. More... | |
getEmptyBody () | |
Hook into getBody(), for the bit between the start and the end when there are no rows. More... | |
getEndBody () | |
Hook into getBody() for the end of the list. More... | |
getExtraSortFields () | |
This function should be overridden to return the names of secondary columns to order by in addition to the column in getIndexField(). More... | |
getStartBody () | |
Hook into getBody(), allows text to be inserted at the start. More... | |
preprocessResults ( $result) | |
Pre-process results; useful for performing batch existence checks, etc. More... | |
Protected Attributes | |
$mExtraSortFields | |
An array of secondary columns to order by. More... | |
$mIncludeOffset = false | |
Whether to include the offset in the query. More... | |
$mIndexField | |
The index to actually be used for ordering. More... | |
$mLastShown | |
$mOrderType | |
For pages that support multiple types of ordering, which one to use. More... | |
IndexPager is an efficient pager which uses a (roughly unique) index in the data set to implement paging, rather than a "LIMIT offset,limit" clause.
In MySQL, such a limit/offset clause requires counting through the specified number of offset rows to find the desired data, which can be expensive for large offsets.
ReverseChronologicalPager is a child class of the abstract IndexPager, and contains some formatting and display code which is specific to the use of timestamps as indexes. Here is a synopsis of its operation:
Subclassing the pager to implement concrete functionality should be fairly simple, please see the examples in HistoryAction.php and SpecialBlockList.php. You just need to override formatRow(), getQueryInfo() and getIndexField(). Don't forget to call the parent constructor if you override it.
Definition at line 69 of file IndexPager.php.
IndexPager::__construct | ( | IContextSource | $context = null | ) |
Reimplemented in TablePager.
Definition at line 131 of file IndexPager.php.
References ContextSource\$context, $dir, $mOrderType, array(), DB_REPLICA, getDefaultDirections(), getExtraSortFields(), getIndexField(), ContextSource\getRequest(), ContextSource\getUser(), list, ContextSource\setContext(), and wfGetDB().
|
protected |
Build variables to use by the database wrapper.
string | $offset | Index offset, inclusive |
int | $limit | Exact query limit |
bool | $descending | Query direction, false for ascending, true for descending |
Reimplemented in RangeChronologicalPager.
Definition at line 379 of file IndexPager.php.
References $fname, $options, $tables, as, getQueryInfo(), and getSqlComment().
Referenced by ImageListPager\reallyDoQuery(), and reallyDoQuery().
|
protected |
Called from getBody(), before getStartBody() is called and after doQuery() was called.
This will be called only if there are rows in the result set.
Reimplemented in HistoryPager, ImageListPager, ContribsPager, UsersPager, and ActiveUsersPager.
Definition at line 497 of file IndexPager.php.
Referenced by getBody().
IndexPager::doQuery | ( | ) |
Do the query, using information from the object context.
This function has been kept minimal to make it overridable if necessary, to allow for result sets formed from multiple DB queries.
Reimplemented in LogPager, and ImageHistoryPseudoPager.
Definition at line 199 of file IndexPager.php.
References $fname, $mDefaultDirection, $mIncludeOffset, $section, class, extractResultInfo(), Profiler\instance(), preprocessResults(), and reallyDoQuery().
Referenced by getBody(), getNumRows(), getPagingQueries(), and isNavigationBarShown().
IndexPager::extractResultInfo | ( | $isFirst, | |
$limit, | |||
ResultWrapper | $res | ||
) |
Extract some useful data from the result object for use by the navigation bar, put it into $this.
bool | $isFirst | False if there are rows before those fetched (i.e. if a "previous" link would make sense) |
int | $limit | Exact query limit |
ResultWrapper | $res |
Definition at line 297 of file IndexPager.php.
References $res.
Referenced by doQuery().
|
abstract |
Abstract formatting function.
This should return an HTML string representing the result row $row. Rows will be concatenated and returned by getBody()
array | stdClass | $row | Database row |
Reimplemented in HistoryPager, ContribsPager, LogPager, AllMessagesTablePager, DeletedContribsPager, TablePager, NewFilesPager, UsersPager, ActiveUsersPager, NewPagesPager, ImageHistoryPseudoPager, MergeHistoryPager, ProtectedTitlesPager, and CategoryPager.
Referenced by getBody().
IndexPager::getBody | ( | ) |
Get the formatted result list.
Calls getStartBody(), formatRow() and getEndBody(), concatenates the results and returns them.
Implements Pager.
Reimplemented in ImageHistoryPseudoPager, CategoryPager, and TablePager.
Definition at line 420 of file IndexPager.php.
References $mLimit, $s, doBatchLookups(), doQuery(), formatRow(), getEmptyBody(), getEndBody(), and getStartBody().
IndexPager::getDatabase | ( | ) |
Get the Database object in use.
Reimplemented in DeletedContribsPager.
Definition at line 190 of file IndexPager.php.
References $mDb.
Referenced by ActiveUsersPager\doBatchLookups(), ActiveUsersPager\getQueryInfo(), BlockListPager\getQueryInfo(), and BlockListPager\getTotalAutoblocks().
|
protected |
Return the default sorting direction: DIR_ASCENDING or DIR_DESCENDING.
You can also have an associative array of ordertype => dir, if multiple order types are supported. In this case getIndexField() must return an array, and the keys of that must exactly match the keys of this.
For backward compatibility, this method's return value will be ignored if $this->mDefaultDirection is already set when the constructor is called, for instance if it's statically initialized. In that case the value of that variable (which must be a boolean) will be used.
Note that despite its name, this does not return the value of the $this->mDefaultDirection member variable. That's the default for this particular instantiation, which is a single value. This is the set of all defaults for the class.
Definition at line 739 of file IndexPager.php.
References DIR_ASCENDING.
Referenced by __construct().
IndexPager::getDefaultQuery | ( | ) |
Get an array of query parameters that should be put into self-links.
By default, all parameters passed in the URL are used, except for a short blacklist.
Reimplemented in ImageListPager, UsersPager, ContribsPager, LogPager, CategoryPager, and DeletedContribsPager.
Definition at line 536 of file IndexPager.php.
References $mDefaultQuery, and ContextSource\getRequest().
Referenced by makeLink().
|
protected |
Hook into getBody(), for the bit between the start and the end when there are no rows.
Reimplemented in TablePager.
Definition at line 525 of file IndexPager.php.
Referenced by getBody().
|
protected |
Hook into getBody() for the end of the list.
Reimplemented in HistoryPager, ContribsPager, NewFilesPager, TablePager, NewPagesPager, and DeletedContribsPager.
Definition at line 515 of file IndexPager.php.
Referenced by getBody().
|
protected |
This function should be overridden to return the names of secondary columns to order by in addition to the column in getIndexField().
These fields will not be used in the pager offset or in any links for users.
If getIndexField() returns an array of 'querykey' => 'indexfield' pairs then this must return a corresponding array of 'querykey' => [ fields... ] pairs in order for a request with &count=querykey to use [ fields... ] to sort.
This is useful for pagers that GROUP BY a unique column (say page_id) and ORDER BY another (say page_len). Using GROUP BY and ORDER BY both on page_len,page_id avoids temp tables (given a page_len index). This would also work if page_id was non-unique but we had a page_len,page_id index.
Definition at line 716 of file IndexPager.php.
Referenced by __construct().
|
abstract |
This function should be overridden to return the name of the index fi- eld.
If the pager supports multiple orders, it may return an array of 'querykey' => 'indexfield' pairs, so that a request with &count=querykey will use indexfield to sort. In this case, the first returned key is the default.
Needless to say, it's really not a good idea to use a non-unique index for this! That won't page right.
Reimplemented in HistoryPager, ContribsPager, LogPager, ProtectedPagesPager, BlockListPager, TablePager, NewFilesPager, DeletedContribsPager, NewPagesPager, MergeHistoryPager, UsersPager, ProtectedTitlesPager, ImageHistoryPseudoPager, ActiveUsersPager, and CategoryPager.
Referenced by __construct(), and AlphabeticPager\getNavigationBar().
IndexPager::getLimit | ( | ) |
Get the current limit.
Definition at line 273 of file IndexPager.php.
References $mLimit.
IndexPager::getLimitLinks | ( | ) |
Definition at line 645 of file IndexPager.php.
References $mOffset, $mPastTheEndIndex, as, ContextSource\getLanguage(), and makeLink().
Referenced by ReverseChronologicalPager\getNavigationBar(), and AlphabeticPager\getNavigationBar().
IndexPager::getNumRows | ( | ) |
Get the number of rows in the result set.
Definition at line 555 of file IndexPager.php.
References doQuery().
Referenced by HistoryPager\diffButtons(), HistoryPager\getEndBody(), LogPager\getStartBody(), SpecialAutoblockList\showList(), SpecialBlockList\showList(), and HistoryPager\submitButton().
IndexPager::getPagingLinks | ( | $linkTexts, | |
$disabledTexts = [] |
|||
) |
Get paging links.
If a link is disabled, the item from $disabledTexts will be used. If there is no such item, the unlinked text from $linkTexts will be used. Both $linkTexts and $disabledTexts are arrays of HTML.
array | $linkTexts | |
array | $disabledTexts |
Definition at line 624 of file IndexPager.php.
References $queries, $query, $type, as, getPagingQueries(), and makeLink().
Referenced by ReverseChronologicalPager\getNavigationBar(), and AlphabeticPager\getNavigationBar().
IndexPager::getPagingQueries | ( | ) |
Get a URL query array for the prev, next, first and last links.
Reimplemented in ImageListPager.
Definition at line 567 of file IndexPager.php.
References $last, $mFirstShown, $mLastShown, $mLimit, and doQuery().
Referenced by TablePager\getNavigationBar(), and getPagingLinks().
|
abstract |
This function should be overridden to provide all parameters needed for the main paged query.
It returns an associative array with the following elements: tables => Table(s) for passing to Database::select() fields => Field(s) for passing to Database::select(), may be * conds => WHERE conditions options => option array join_conds => JOIN conditions
Reimplemented in AllMessagesTablePager, HistoryPager, LogPager, ProtectedPagesPager, ImageListPager, BlockListPager, ContribsPager, UsersPager, MergeHistoryPager, ActiveUsersPager, ImageHistoryPseudoPager, ProtectedTitlesPager, DeletedContribsPager, NewFilesPager, CategoryPager, and NewPagesPager.
Referenced by buildQueryInfo().
IndexPager::getResult | ( | ) |
Definition at line 237 of file IndexPager.php.
References $mResult.
IndexPager::getSqlComment | ( | ) |
Get some text to go in brackets in the "function name" part of the SQL comment.
Reimplemented in ContribsPager, and HistoryPager.
Definition at line 351 of file IndexPager.php.
References class.
Referenced by buildQueryInfo().
|
protected |
Hook into getBody(), allows text to be inserted at the start.
This will be called even if there are no rows in the result set.
Reimplemented in HistoryPager, ContribsPager, LogPager, AllMessagesTablePager, NewFilesPager, NewPagesPager, DeletedContribsPager, TablePager, MergeHistoryPager, and ProtectedTitlesPager.
Definition at line 506 of file IndexPager.php.
Referenced by getBody().
IndexPager::isNavigationBarShown | ( | ) |
Returns whether to show the "navigation bar".
Definition at line 606 of file IndexPager.php.
References $mIsLast, and doQuery().
Referenced by ReverseChronologicalPager\getNavigationBar(), AlphabeticPager\getNavigationBar(), and TablePager\getNavigationBar().
IndexPager::makeLink | ( | $text, | |
array | $query = null , |
||
$type = null |
|||
) |
Make a self-link.
string | $text | Text displayed on the link |
array | $query | Associative array of parameter to be in the query string |
string | $type | Link type used to create additional attributes, like "rel", "class" or "title". Valid values (non-exhaustive list): 'first', 'last', 'prev', 'next', 'asc', 'desc'. |
Definition at line 464 of file IndexPager.php.
References $query, $type, getDefaultQuery(), ContextSource\getTitle(), Linker\linkKnown(), and wfMessage().
Referenced by getLimitLinks(), AlphabeticPager\getNavigationBar(), getPagingLinks(), and TablePager\getStartBody().
|
protected |
Pre-process results; useful for performing batch existence checks, etc.
ResultWrapper | $result |
Reimplemented in BlockListPager, and ProtectedPagesPager.
Definition at line 411 of file IndexPager.php.
Referenced by doQuery().
IndexPager::reallyDoQuery | ( | $offset, | |
$limit, | |||
$descending | |||
) |
Do a query with specified parameters, rather than using the object context.
string | $offset | Index offset, inclusive |
int | $limit | Exact query limit |
bool | $descending | Query direction, false for ascending, true for descending |
Reimplemented in AllMessagesTablePager, ContribsPager, DeletedContribsPager, and ImageListPager.
Definition at line 364 of file IndexPager.php.
References $fname, $options, $tables, buildQueryInfo(), and list.
Referenced by doQuery().
IndexPager::setIncludeOffset | ( | $include | ) |
Set whether a row matching exactly the offset should be also included in the result or not.
By default this is not the case, but when the offset is user-supplied this might be wanted.
bool | $include |
Definition at line 284 of file IndexPager.php.
Referenced by CategoryPager\__construct().
IndexPager::setLimit | ( | $limit | ) |
Set the limit from an other source than the request.
Verifies limit is between 1 and 5000
int | string | $limit |
Definition at line 257 of file IndexPager.php.
Referenced by NewFilesPager\__construct().
IndexPager::setOffset | ( | $offset | ) |
Set the offset from an other source than the request.
int | string | $offset |
Definition at line 246 of file IndexPager.php.
Referenced by CategoryPager\__construct().
IndexPager::$mDb |
Definition at line 83 of file IndexPager.php.
Referenced by getDatabase(), and LogPager\limitTitle().
IndexPager::$mDefaultDirection |
$mDefaultDirection gives the direction to use when sorting results: DIR_ASCENDING or DIR_DESCENDING.
If $mIsBackwards is set, we start from the opposite end, but we still sort the page itself according to $mDefaultDirection. E.g., if $mDefaultDirection is false but we're going backwards, we'll display the last page of results, but the last result will be at the bottom, not the top.
Like $mIndexField, $mDefaultDirection will be a single value even if the class supports multiple default directions for different order types.
Definition at line 110 of file IndexPager.php.
Referenced by doQuery(), and UsersPager\getPageHeader().
IndexPager::$mDefaultLimit = 50 |
Definition at line 80 of file IndexPager.php.
IndexPager::$mDefaultQuery |
Definition at line 117 of file IndexPager.php.
Referenced by CategoryPager\getDefaultQuery(), and getDefaultQuery().
|
protected |
An array of secondary columns to order by.
These fields are not part of the offset. This is a column list for one ordering, even if multiple orderings are supported.
Definition at line 95 of file IndexPager.php.
IndexPager::$mFirstShown |
Definition at line 117 of file IndexPager.php.
Referenced by getPagingQueries().
|
protected |
Whether to include the offset in the query.
Definition at line 122 of file IndexPager.php.
Referenced by doQuery().
|
protected |
The index to actually be used for ordering.
This is a single column, for one ordering, even if multiple orderings are supported.
Definition at line 90 of file IndexPager.php.
Referenced by ImageListPager\reallyDoQuery().
IndexPager::$mIsBackwards |
Definition at line 111 of file IndexPager.php.
IndexPager::$mIsFirst |
True if the current result set is the first one.
Definition at line 114 of file IndexPager.php.
Referenced by HistoryPager\formatRow(), and HistoryPager\getEndBody().
IndexPager::$mIsLast |
Definition at line 115 of file IndexPager.php.
Referenced by isNavigationBarShown().
|
protected |
Definition at line 117 of file IndexPager.php.
Referenced by getPagingQueries().
IndexPager::$mLimit |
Definition at line 81 of file IndexPager.php.
Referenced by getBody(), getLimit(), TablePager\getLimitSelectList(), UsersPager\getPageHeader(), getPagingQueries(), and TablePager\getStartBody().
IndexPager::$mLimitsShown = [ 20, 50, 100, 250, 500 ] |
Definition at line 79 of file IndexPager.php.
IndexPager::$mNavigationBar |
Definition at line 117 of file IndexPager.php.
Referenced by ReverseChronologicalPager\getNavigationBar(), and AlphabeticPager\getNavigationBar().
IndexPager::$mOffset |
Definition at line 81 of file IndexPager.php.
Referenced by ImageHistoryPseudoPager\doQuery(), ReverseChronologicalPager\getDateCond(), RangeChronologicalPager\getDateCond(), and getLimitLinks().
|
protected |
For pages that support multiple types of ordering, which one to use.
Definition at line 98 of file IndexPager.php.
Referenced by __construct().
IndexPager::$mPastTheEndIndex |
Definition at line 117 of file IndexPager.php.
Referenced by getLimitLinks().
IndexPager::$mPastTheEndRow |
Definition at line 84 of file IndexPager.php.
Referenced by HistoryPager\getEndBody().
IndexPager::$mQueryDone = false |
Definition at line 82 of file IndexPager.php.
IndexPager::$mRequest |
Definition at line 78 of file IndexPager.php.
ResultWrapper IndexPager::$mResult |
Result object for the query.
Warning: seek before use.
Definition at line 129 of file IndexPager.php.
Referenced by getResult().
const IndexPager::DIR_ASCENDING = false |
Constants for the $mDefaultDirection field.
These are boolean for historical reasons and should stay boolean for backwards-compatibility.
Definition at line 75 of file IndexPager.php.
Referenced by TablePager\__construct(), UsersPager\__construct(), ImageListPager\__construct(), and getDefaultDirections().
const IndexPager::DIR_DESCENDING = true |
Definition at line 76 of file IndexPager.php.
Referenced by TablePager\__construct(), BlockListPager\__construct(), UsersPager\__construct(), AllMessagesTablePager\__construct(), ImageListPager\__construct(), and TablePager\getStartBody().