3 * Copyright © 2015 Wikimedia Foundation and contributors
5 * This program is free software; you can redistribute it and/or modify
6 * it under the terms of the GNU General Public License as published by
7 * the Free Software Foundation; either version 2 of the License, or
8 * (at your option) any later version.
10 * This program is distributed in the hope that it will be useful,
11 * but WITHOUT ANY WARRANTY; without even the implied warranty of
12 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 * GNU General Public License for more details.
15 * You should have received a copy of the GNU General Public License along
16 * with this program; if not, write to the Free Software Foundation, Inc.,
17 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
18 * http://www.gnu.org/copyleft/gpl.html
23 use MediaWiki\MediaWikiServices
;
24 use MediaWiki\Revision\RevisionRecord
;
27 * Query module to enumerate all revisions.
32 class ApiQueryAllRevisions
extends ApiQueryRevisionsBase
{
34 public function __construct( ApiQuery
$query, $moduleName ) {
35 parent
::__construct( $query, $moduleName, 'arv' );
39 * @param ApiPageSet|null $resultPageSet
42 protected function run( ApiPageSet
$resultPageSet = null ) {
43 global $wgActorTableSchemaMigrationStage;
46 $params = $this->extractRequestParams( false );
47 $revisionStore = MediaWikiServices
::getInstance()->getRevisionStore();
49 $result = $this->getResult();
51 $this->requireMaxOneParameter( $params, 'user', 'excludeuser' );
53 $tsField = 'rev_timestamp';
55 $pageField = 'rev_page';
56 if ( $params['user'] !== null &&
57 ( $wgActorTableSchemaMigrationStage & SCHEMA_COMPAT_READ_NEW
)
59 // The query is probably best done using the actor_timestamp index on
60 // revision_actor_temp. Use the denormalized fields from that table.
61 $tsField = 'revactor_timestamp';
62 $idField = 'revactor_rev';
63 $pageField = 'revactor_page';
66 // Namespace check is likely to be desired, but can't be done
67 // efficiently in SQL.
69 $needPageTable = false;
70 if ( $params['namespace'] !== null ) {
71 $params['namespace'] = array_unique( $params['namespace'] );
72 sort( $params['namespace'] );
73 if ( $params['namespace'] != MWNamespace
::getValidNamespaces() ) {
74 $needPageTable = true;
75 if ( $this->getConfig()->get( 'MiserMode' ) ) {
76 $miser_ns = $params['namespace'];
78 $this->addWhere( [ 'page_namespace' => $params['namespace'] ] );
83 if ( $resultPageSet === null ) {
84 $this->parseParameters( $params );
85 $revQuery = $revisionStore->getQueryInfo(
86 $this->fetchContent ?
[ 'page', 'text' ] : [ 'page' ]
89 $this->limit
= $this->getParameter( 'limit' ) ?
: 10;
91 'tables' => [ 'revision' ],
92 'fields' => [ 'rev_timestamp', 'rev_id' ],
96 if ( $params['generatetitles'] ) {
97 $revQuery['fields'][] = 'rev_page';
100 if ( $params['user'] !== null ||
$params['excludeuser'] !== null ) {
101 $actorQuery = ActorMigration
::newMigration()->getJoin( 'rev_user' );
102 $revQuery['tables'] +
= $actorQuery['tables'];
103 $revQuery['joins'] +
= $actorQuery['joins'];
106 if ( $needPageTable ) {
107 $revQuery['tables'][] = 'page';
108 $revQuery['joins']['page'] = [ 'INNER JOIN', [ "$pageField = page_id" ] ];
109 if ( (bool)$miser_ns ) {
110 $revQuery['fields'][] = 'page_namespace';
115 // If we're going to be using actor_timestamp, we need to swap the order of `revision`
116 // and `revision_actor_temp` in the query (for the straight join) and adjust some field aliases.
117 if ( $idField !== 'rev_id' && isset( $revQuery['tables']['temp_rev_user'] ) ) {
118 $aliasFields = [ 'rev_id' => $idField, 'rev_timestamp' => $tsField, 'rev_page' => $pageField ];
119 $revQuery['fields'] = array_merge(
121 array_diff( $revQuery['fields'], array_keys( $aliasFields ) )
123 unset( $revQuery['tables']['temp_rev_user'] );
124 $revQuery['tables'] = array_merge(
125 [ 'temp_rev_user' => 'revision_actor_temp' ],
128 $revQuery['joins']['revision'] = $revQuery['joins']['temp_rev_user'];
129 unset( $revQuery['joins']['temp_rev_user'] );
132 $this->addTables( $revQuery['tables'] );
133 $this->addFields( $revQuery['fields'] );
134 $this->addJoinConds( $revQuery['joins'] );
136 // Seems to be needed to avoid a planner bug (T113901)
137 $this->addOption( 'STRAIGHT_JOIN' );
139 $dir = $params['dir'];
140 $this->addTimestampWhereRange( $tsField, $dir, $params['start'], $params['end'] );
142 if ( $this->fld_tags
) {
143 $this->addFields( [ 'ts_tags' => ChangeTags
::makeTagSummarySubquery( 'revision' ) ] );
146 if ( $params['user'] !== null ) {
147 $actorQuery = ActorMigration
::newMigration()
148 ->getWhere( $db, 'rev_user', User
::newFromName( $params['user'], false ) );
149 $this->addWhere( $actorQuery['conds'] );
150 } elseif ( $params['excludeuser'] !== null ) {
151 $actorQuery = ActorMigration
::newMigration()
152 ->getWhere( $db, 'rev_user', User
::newFromName( $params['excludeuser'], false ) );
153 $this->addWhere( 'NOT(' . $actorQuery['conds'] . ')' );
156 if ( $params['user'] !== null ||
$params['excludeuser'] !== null ) {
157 // Paranoia: avoid brute force searches (T19342)
158 if ( !$this->getUser()->isAllowed( 'deletedhistory' ) ) {
159 $bitmask = RevisionRecord
::DELETED_USER
;
160 } elseif ( !$this->getUser()->isAllowedAny( 'suppressrevision', 'viewsuppressed' ) ) {
161 $bitmask = RevisionRecord
::DELETED_USER | RevisionRecord
::DELETED_RESTRICTED
;
166 $this->addWhere( $db->bitAnd( 'rev_deleted', $bitmask ) . " != $bitmask" );
170 if ( $params['continue'] !== null ) {
171 $op = ( $dir == 'newer' ?
'>' : '<' );
172 $cont = explode( '|', $params['continue'] );
173 $this->dieContinueUsageIf( count( $cont ) != 2 );
174 $ts = $db->addQuotes( $db->timestamp( $cont[0] ) );
175 $rev_id = (int)$cont[1];
176 $this->dieContinueUsageIf( strval( $rev_id ) !== $cont[1] );
177 $this->addWhere( "$tsField $op $ts OR " .
178 "($tsField = $ts AND " .
179 "$idField $op= $rev_id)" );
182 $this->addOption( 'LIMIT', $this->limit +
1 );
184 $sort = ( $dir == 'newer' ?
'' : ' DESC' );
186 // Targeting index rev_timestamp, user_timestamp, usertext_timestamp, or actor_timestamp.
187 // But 'user' is always constant for the latter three, so it doesn't matter here.
188 $orderby[] = "rev_timestamp $sort";
189 $orderby[] = "rev_id $sort";
190 $this->addOption( 'ORDER BY', $orderby );
193 $res = $this->select( __METHOD__
, [], $hookData );
194 $pageMap = []; // Maps rev_page to array index
198 foreach ( $res as $row ) {
199 if ( $count === 0 && $resultPageSet !== null ) {
200 // Set the non-continue since the list of all revisions is
201 // prone to having entries added at the start frequently.
202 $this->getContinuationManager()->addGeneratorNonContinueParam(
203 $this, 'continue', "$row->rev_timestamp|$row->rev_id"
206 if ( ++
$count > $this->limit
) {
208 $this->setContinueEnumParameter( 'continue', "$row->rev_timestamp|$row->rev_id" );
212 // Miser mode namespace check
213 if ( $miser_ns !== null && !in_array( $row->page_namespace
, $miser_ns ) ) {
217 if ( $resultPageSet !== null ) {
218 if ( $params['generatetitles'] ) {
219 $generated[$row->rev_page
] = $row->rev_page
;
221 $generated[] = $row->rev_id
;
224 $revision = $revisionStore->newRevisionFromRow( $row );
225 $rev = $this->extractRevisionInfo( $revision, $row );
227 if ( !isset( $pageMap[$row->rev_page
] ) ) {
228 $index = $nextIndex++
;
229 $pageMap[$row->rev_page
] = $index;
230 $title = Title
::newFromLinkTarget( $revision->getPageAsLinkTarget() );
232 'pageid' => $title->getArticleID(),
233 'revisions' => [ $rev ],
235 ApiResult
::setIndexedTagName( $a['revisions'], 'rev' );
236 ApiQueryBase
::addTitleInfo( $a, $title );
237 $fit = $this->processRow( $row, $a['revisions'][0], $hookData ) &&
238 $result->addValue( [ 'query', $this->getModuleName() ], $index, $a );
240 $index = $pageMap[$row->rev_page
];
241 $fit = $this->processRow( $row, $rev, $hookData ) &&
242 $result->addValue( [ 'query', $this->getModuleName(), $index, 'revisions' ], null, $rev );
245 $this->setContinueEnumParameter( 'continue', "$row->rev_timestamp|$row->rev_id" );
251 if ( $resultPageSet !== null ) {
252 if ( $params['generatetitles'] ) {
253 $resultPageSet->populateFromPageIDs( $generated );
255 $resultPageSet->populateFromRevisionIDs( $generated );
258 $result->addIndexedTagName( [ 'query', $this->getModuleName() ], 'page' );
262 public function getAllowedParams() {
263 $ret = parent
::getAllowedParams() +
[
265 ApiBase
::PARAM_TYPE
=> 'user',
268 ApiBase
::PARAM_ISMULTI
=> true,
269 ApiBase
::PARAM_TYPE
=> 'namespace',
270 ApiBase
::PARAM_DFLT
=> null,
273 ApiBase
::PARAM_TYPE
=> 'timestamp',
276 ApiBase
::PARAM_TYPE
=> 'timestamp',
279 ApiBase
::PARAM_TYPE
=> [
283 ApiBase
::PARAM_DFLT
=> 'older',
284 ApiBase
::PARAM_HELP_MSG
=> 'api-help-param-direction',
287 ApiBase
::PARAM_TYPE
=> 'user',
290 ApiBase
::PARAM_HELP_MSG
=> 'api-help-param-continue',
292 'generatetitles' => [
293 ApiBase
::PARAM_DFLT
=> false,
297 if ( $this->getConfig()->get( 'MiserMode' ) ) {
298 $ret['namespace'][ApiBase
::PARAM_HELP_MSG_APPEND
] = [
299 'api-help-param-limited-in-miser-mode',
306 protected function getExamplesMessages() {
308 'action=query&list=allrevisions&arvuser=Example&arvlimit=50'
309 => 'apihelp-query+allrevisions-example-user',
310 'action=query&list=allrevisions&arvdir=newer&arvlimit=50'
311 => 'apihelp-query+allrevisions-example-ns-main',
315 public function getHelpUrls() {
316 return 'https://www.mediawiki.org/wiki/Special:MyLanguage/API:Allrevisions';