MediaWiki  master
ApiQueryExtLinksUsage.php
Go to the documentation of this file.
1 <?php
27 
28  public function __construct( ApiQuery $query, $moduleName ) {
29  parent::__construct( $query, $moduleName, 'eu' );
30  }
31 
32  public function execute() {
33  $this->run();
34  }
35 
36  public function getCacheMode( $params ) {
37  return 'public';
38  }
39 
40  public function executeGenerator( $resultPageSet ) {
41  $this->run( $resultPageSet );
42  }
43 
48  private function run( $resultPageSet = null ) {
49  $params = $this->extractRequestParams();
50  $db = $this->getDB();
51 
52  $query = $params['query'];
53  $protocol = self::getProtocolPrefix( $params['protocol'] );
54 
55  $this->addTables( [ 'page', 'externallinks' ] );
56  $this->addWhere( 'page_id=el_from' );
57 
58  $miser_ns = [];
59  if ( $this->getConfig()->get( 'MiserMode' ) ) {
60  $miser_ns = $params['namespace'] ?: [];
61  } else {
62  $this->addWhereFld( 'page_namespace', $params['namespace'] );
63  }
64 
65  $orderBy = [];
66 
67  if ( $query !== null && $query !== '' ) {
68  if ( $protocol === null ) {
69  $protocol = 'http://';
70  }
71 
72  // Normalize query to match the normalization applied for the externallinks table
73  $query = Parser::normalizeLinkUrl( $protocol . $query );
74 
75  $conds = LinkFilter::getQueryConditions( $query, [
76  'protocol' => '',
77  'oneWildcard' => true,
78  'db' => $db
79  ] );
80  if ( !$conds ) {
81  $this->dieWithError( 'apierror-badquery' );
82  }
83  $this->addWhere( $conds );
84  if ( !isset( $conds['el_index_60'] ) ) {
85  $orderBy[] = 'el_index_60';
86  }
87  } else {
88  $orderBy[] = 'el_index_60';
89 
90  if ( $protocol !== null ) {
91  $this->addWhere( 'el_index_60' . $db->buildLike( "$protocol", $db->anyString() ) );
92  } else {
93  // We're querying all protocols, filter out duplicate protocol-relative links
94  $this->addWhere( $db->makeList( [
95  'el_to NOT' . $db->buildLike( '//', $db->anyString() ),
96  'el_index_60 ' . $db->buildLike( 'http://', $db->anyString() ),
97  ], LIST_OR ) );
98  }
99  }
100 
101  $orderBy[] = 'el_id';
102  $this->addOption( 'ORDER BY', $orderBy );
103  $this->addFields( $orderBy ); // Make sure
104 
105  $prop = array_flip( $params['prop'] );
106  $fld_ids = isset( $prop['ids'] );
107  $fld_title = isset( $prop['title'] );
108  $fld_url = isset( $prop['url'] );
109 
110  if ( $resultPageSet === null ) {
111  $this->addFields( [
112  'page_id',
113  'page_namespace',
114  'page_title'
115  ] );
116  $this->addFieldsIf( 'el_to', $fld_url );
117  } else {
118  $this->addFields( $resultPageSet->getPageTableFields() );
119  }
120 
121  $limit = $params['limit'];
122  $this->addOption( 'LIMIT', $limit + 1 );
123 
124  if ( $params['continue'] !== null ) {
125  $cont = explode( '|', $params['continue'] );
126  $this->dieContinueUsageIf( count( $cont ) !== count( $orderBy ) );
127  $i = count( $cont ) - 1;
128  $cond = $orderBy[$i] . ' >= ' . $db->addQuotes( rawurldecode( $cont[$i] ) );
129  while ( $i-- > 0 ) {
130  $field = $orderBy[$i];
131  $v = $db->addQuotes( rawurldecode( $cont[$i] ) );
132  $cond = "($field > $v OR ($field = $v AND $cond))";
133  }
134  $this->addWhere( $cond );
135  }
136 
137  $res = $this->select( __METHOD__ );
138 
139  $result = $this->getResult();
140 
141  if ( $resultPageSet === null ) {
142  $this->executeGenderCacheFromResultWrapper( $res, __METHOD__ );
143  }
144 
145  $count = 0;
146  foreach ( $res as $row ) {
147  if ( ++$count > $limit ) {
148  // We've reached the one extra which shows that there are
149  // additional pages to be had. Stop here...
150  $this->setContinue( $orderBy, $row );
151  break;
152  }
153 
154  if ( count( $miser_ns ) && !in_array( $row->page_namespace, $miser_ns ) ) {
155  continue;
156  }
157 
158  if ( $resultPageSet === null ) {
159  $vals = [
160  ApiResult::META_TYPE => 'assoc',
161  ];
162  if ( $fld_ids ) {
163  $vals['pageid'] = (int)$row->page_id;
164  }
165  if ( $fld_title ) {
166  $title = Title::makeTitle( $row->page_namespace, $row->page_title );
168  }
169  if ( $fld_url ) {
170  $to = $row->el_to;
171  // expand protocol-relative urls
172  if ( $params['expandurl'] ) {
173  $to = wfExpandUrl( $to, PROTO_CANONICAL );
174  }
175  $vals['url'] = $to;
176  }
177  $fit = $result->addValue( [ 'query', $this->getModuleName() ], null, $vals );
178  if ( !$fit ) {
179  $this->setContinue( $orderBy, $row );
180  break;
181  }
182  } else {
183  $resultPageSet->processDbRow( $row );
184  }
185  }
186 
187  if ( $resultPageSet === null ) {
188  $result->addIndexedTagName( [ 'query', $this->getModuleName() ],
189  $this->getModulePrefix() );
190  }
191  }
192 
193  private function setContinue( $orderBy, $row ) {
194  $fields = [];
195  foreach ( $orderBy as $field ) {
196  $fields[] = strtr( $row->$field, [ '%' => '%25', '|' => '%7C' ] );
197  }
198  $this->setContinueEnumParameter( 'continue', implode( '|', $fields ) );
199  }
200 
201  public function getAllowedParams() {
202  $ret = [
203  'prop' => [
204  ApiBase::PARAM_ISMULTI => true,
205  ApiBase::PARAM_DFLT => 'ids|title|url',
207  'ids',
208  'title',
209  'url'
210  ],
212  ],
213  'continue' => [
214  ApiBase::PARAM_HELP_MSG => 'api-help-param-continue',
215  ],
216  'protocol' => [
218  ApiBase::PARAM_DFLT => '',
219  ],
220  'query' => null,
221  'namespace' => [
222  ApiBase::PARAM_ISMULTI => true,
223  ApiBase::PARAM_TYPE => 'namespace'
224  ],
225  'limit' => [
226  ApiBase::PARAM_DFLT => 10,
227  ApiBase::PARAM_TYPE => 'limit',
228  ApiBase::PARAM_MIN => 1,
231  ],
232  'expandurl' => false,
233  ];
234 
235  if ( $this->getConfig()->get( 'MiserMode' ) ) {
236  $ret['namespace'][ApiBase::PARAM_HELP_MSG_APPEND] = [
237  'api-help-param-limited-in-miser-mode',
238  ];
239  }
240 
241  return $ret;
242  }
243 
244  public static function prepareProtocols() {
245  global $wgUrlProtocols;
246  $protocols = [ '' ];
247  foreach ( $wgUrlProtocols as $p ) {
248  if ( $p !== '//' ) {
249  $protocols[] = substr( $p, 0, strpos( $p, ':' ) );
250  }
251  }
252 
253  return $protocols;
254  }
255 
256  public static function getProtocolPrefix( $protocol ) {
257  // Find the right prefix
258  global $wgUrlProtocols;
259  if ( $protocol && !in_array( $protocol, $wgUrlProtocols ) ) {
260  foreach ( $wgUrlProtocols as $p ) {
261  if ( substr( $p, 0, strlen( $protocol ) ) === $protocol ) {
262  $protocol = $p;
263  break;
264  }
265  }
266 
267  return $protocol;
268  } else {
269  return null;
270  }
271  }
272 
273  protected function getExamplesMessages() {
274  return [
275  'action=query&list=exturlusage&euquery=www.mediawiki.org'
276  => 'apihelp-query+exturlusage-example-simple',
277  ];
278  }
279 
280  public function getHelpUrls() {
281  return 'https://www.mediawiki.org/wiki/Special:MyLanguage/API:Exturlusage';
282  }
283 }
ContextSource\getConfig
getConfig()
Definition: ContextSource.php:63
ApiQueryExtLinksUsage\getCacheMode
getCacheMode( $params)
Get the cache mode for the data generated by this module.
Definition: ApiQueryExtLinksUsage.php:36
ApiQueryBase\addFields
addFields( $value)
Add a set of fields to select to the internal array.
Definition: ApiQueryBase.php:193
ApiQuery
This is the main query class.
Definition: ApiQuery.php:37
PROTO_CANONICAL
const PROTO_CANONICAL
Definition: Defines.php:203
LinkFilter\getQueryConditions
static getQueryConditions( $filterEntry, array $options=[])
Return query conditions which will match the specified string.
Definition: LinkFilter.php:256
ApiResult\META_TYPE
const META_TYPE
Key for the 'type' metadata item.
Definition: ApiResult.php:110
ApiBase\dieWithError
dieWithError( $msg, $code=null, $data=null, $httpCode=null)
Abort execution with an error.
Definition: ApiBase.php:2015
ApiBase\PARAM_HELP_MSG
const PARAM_HELP_MSG
(string|array|Message) Specify an alternative i18n documentation message for this parameter.
Definition: ApiBase.php:132
ApiQueryExtLinksUsage\getHelpUrls
getHelpUrls()
Return links to more detailed help pages about the module.
Definition: ApiQueryExtLinksUsage.php:280
ApiBase\PARAM_TYPE
const PARAM_TYPE
(string|string[]) Either an array of allowed value strings, or a string type as described below.
Definition: ApiBase.php:95
ApiBase\getResult
getResult()
Get the result object.
Definition: ApiBase.php:644
ApiQueryBase\$fields
$fields
Definition: ApiQueryBase.php:37
ApiQueryExtLinksUsage
Definition: ApiQueryExtLinksUsage.php:26
ApiQueryBase\addOption
addOption( $name, $value=null)
Add an option such as LIMIT or USE INDEX.
Definition: ApiQueryBase.php:369
ApiQueryExtLinksUsage\execute
execute()
Evaluates the parameters, performs the requested query, and sets up the result.
Definition: ApiQueryExtLinksUsage.php:32
$res
$res
Definition: testCompression.php:54
ApiBase\PARAM_HELP_MSG_APPEND
const PARAM_HELP_MSG_APPEND
((string|array|Message)[]) Specify additional i18n messages to append to the normal message for this ...
Definition: ApiBase.php:139
ApiQueryBase\addFieldsIf
addFieldsIf( $value, $condition)
Same as addFields(), but add the fields only if a condition is met.
Definition: ApiQueryBase.php:207
ApiQueryGeneratorBase\setContinueEnumParameter
setContinueEnumParameter( $paramName, $paramValue)
Overridden to set the generator param if in generator mode.
Definition: ApiQueryGeneratorBase.php:84
ApiQueryExtLinksUsage\prepareProtocols
static prepareProtocols()
Definition: ApiQueryExtLinksUsage.php:244
ApiBase\PARAM_MIN
const PARAM_MIN
(integer) Lowest value allowed for the parameter, for PARAM_TYPE 'integer' and 'limit'.
Definition: ApiBase.php:107
ApiQueryBase\executeGenderCacheFromResultWrapper
executeGenderCacheFromResultWrapper(IResultWrapper $res, $fname=__METHOD__, $fieldPrefix='page')
Preprocess the result set to fill the GenderCache with the necessary information before using self::a...
Definition: ApiQueryBase.php:622
LIST_OR
const LIST_OR
Definition: Defines.php:42
ApiBase\LIMIT_BIG1
const LIMIT_BIG1
Fast query, standard limit.
Definition: ApiBase.php:260
ApiQueryBase\getDB
getDB()
Get the Query database connection (read-only)
Definition: ApiQueryBase.php:107
ApiBase\PARAM_MAX
const PARAM_MAX
(integer) Max value allowed for the parameter, for PARAM_TYPE 'integer' and 'limit'.
Definition: ApiBase.php:98
ApiQueryExtLinksUsage\setContinue
setContinue( $orderBy, $row)
Definition: ApiQueryExtLinksUsage.php:193
ApiQueryBase\addTables
addTables( $tables, $alias=null)
Add a set of tables to the internal array.
Definition: ApiQueryBase.php:161
ApiQueryBase\select
select( $method, $extraQuery=[], array &$hookData=null)
Execute a SELECT query based on the values in the internal arrays.
Definition: ApiQueryBase.php:394
ApiBase\extractRequestParams
extractRequestParams( $options=[])
Using getAllowedParams(), this function makes an array of the values provided by the user,...
Definition: ApiBase.php:765
ApiQueryExtLinksUsage\run
run( $resultPageSet=null)
Definition: ApiQueryExtLinksUsage.php:48
$title
$title
Definition: testCompression.php:36
Title\makeTitle
static makeTitle( $ns, $title, $fragment='', $interwiki='')
Create a new Title from a namespace index and a DB key.
Definition: Title.php:584
ApiQueryExtLinksUsage\__construct
__construct(ApiQuery $query, $moduleName)
Definition: ApiQueryExtLinksUsage.php:28
ApiBase\getModulePrefix
getModulePrefix()
Get parameter prefix (usually two letters or an empty string).
Definition: ApiBase.php:532
$wgUrlProtocols
$wgUrlProtocols
URL schemes that should be recognized as valid by wfParseUrl().
Definition: DefaultSettings.php:4184
ApiBase\dieContinueUsageIf
dieContinueUsageIf( $condition)
Die with the 'badcontinue' error.
Definition: ApiBase.php:2210
ApiQueryBase\addWhereFld
addWhereFld( $field, $value)
Equivalent to addWhere( [ $field => $value ] )
Definition: ApiQueryBase.php:267
ApiQueryExtLinksUsage\getAllowedParams
getAllowedParams()
Returns an array of allowed parameters (parameter name) => (default value) or (parameter name) => (ar...
Definition: ApiQueryExtLinksUsage.php:201
ApiQueryGeneratorBase
Definition: ApiQueryGeneratorBase.php:26
ApiQueryExtLinksUsage\getExamplesMessages
getExamplesMessages()
Returns usage examples for this module.
Definition: ApiQueryExtLinksUsage.php:273
ApiBase\LIMIT_BIG2
const LIMIT_BIG2
Fast query, apihighlimits limit.
Definition: ApiBase.php:262
ApiBase\PARAM_DFLT
const PARAM_DFLT
(null|boolean|integer|string) Default value of the parameter.
Definition: ApiBase.php:56
ApiBase\getModuleName
getModuleName()
Get the name of the module being executed by this instance.
Definition: ApiBase.php:524
ApiBase\PARAM_ISMULTI
const PARAM_ISMULTI
(boolean) Accept multiple pipe-separated values for this parameter (e.g.
Definition: ApiBase.php:59
ApiBase\PARAM_MAX2
const PARAM_MAX2
(integer) Max value allowed for the parameter for users with the apihighlimits right,...
Definition: ApiBase.php:104
ApiQueryBase\addWhere
addWhere( $value)
Add a set of WHERE clauses to the internal array.
Definition: ApiQueryBase.php:230
ApiBase\PARAM_HELP_MSG_PER_VALUE
const PARAM_HELP_MSG_PER_VALUE
((string|array|Message)[]) When PARAM_TYPE is an array, this is an array mapping those values to $msg...
Definition: ApiBase.php:165
ApiQueryExtLinksUsage\executeGenerator
executeGenerator( $resultPageSet)
Execute this module as a generator.
Definition: ApiQueryExtLinksUsage.php:40
ApiQueryBase\addTitleInfo
static addTitleInfo(&$arr, $title, $prefix='')
Add information (title and namespace) about a Title object to a result array.
Definition: ApiQueryBase.php:462
wfExpandUrl
wfExpandUrl( $url, $defaultProto=PROTO_CURRENT)
Expand a potentially local URL to a fully-qualified URL.
Definition: GlobalFunctions.php:491
ApiQueryExtLinksUsage\getProtocolPrefix
static getProtocolPrefix( $protocol)
Definition: ApiQueryExtLinksUsage.php:256