SpecialWantedPages.php

Go to the documentation of this file.

<?php
namespace MediaWiki\Specials;
 
use MediaWiki\Deferred\LinksUpdate\PageLinksTable;
use MediaWiki\Linker\LinksMigration;
use MediaWiki\MainConfigNames;
use MediaWiki\Page\LinkBatchFactory;
use MediaWiki\SpecialPage\WantedQueryPage;
use Wikimedia\Rdbms\IConnectionProvider;
 
class SpecialWantedPages extends WantedQueryPage {
 
    public function __construct(
        IConnectionProvider $dbProvider,
        LinkBatchFactory $linkBatchFactory,
        private readonly LinksMigration $linksMigration
    ) {
        parent::__construct( 'Wantedpages' );
        $this->setDatabaseProvider( $dbProvider );
        $this->setLinkBatchFactory( $linkBatchFactory );
    }
 
    public function isIncludable() {
        return true;
    }
 
    public function execute( $par ) {
        $inc = $this->including();
 
        if ( $inc ) {
            $this->limit = (int)$par;
            $this->offset = 0;
        }
        $this->shownavigation = !$inc;
        parent::execute( $par );
    }
 
    public function getQueryInfo() {
        $dbr = $this->getDatabaseProvider()->getReplicaDatabase();
        $count = $this->getConfig()->get( MainConfigNames::WantedPagesThreshold ) - 1;
        [ $blNamespace, $blTitle ] = $this->linksMigration->getTitleFields( 'pagelinks' );
        $queryInfo = $this->linksMigration->getQueryInfo( 'pagelinks', 'pagelinks' );
        $query = [
            'tables' => array_merge( $queryInfo['tables'], [
                'pg1' => 'page',
                'pg2' => 'page'
            ] ),
            'fields' => [
                'namespace' => $blNamespace,
                'title' => $blTitle,
                'value' => 'COUNT(*)'
            ],
            'conds' => [
                'pg1.page_namespace' => null,
                $dbr->expr( $blNamespace, '!=', [ NS_USER, NS_USER_TALK ] ),
                $dbr->expr( 'pg2.page_namespace', '!=', NS_MEDIAWIKI ),
            ],
            'options' => [
                'HAVING' => [
                    'COUNT(*) > ' . $dbr->addQuotes( $count ),
                    'COUNT(*) > SUM(pg2.page_is_redirect)'
                ],
                'GROUP BY' => [ $blNamespace, $blTitle ]
            ],
            'join_conds' => array_merge( [
                'pg1' => [
                    'LEFT JOIN', [
                        'pg1.page_namespace = ' . $blNamespace,
                        'pg1.page_title = ' . $blTitle
                    ]
                ],
                'pg2' => [ 'LEFT JOIN', 'pg2.page_id = pl_from' ]
            ], $queryInfo['joins'] )
        ];
        // Replacement for the WantedPages::getSQL hook
        $this->getHookRunner()->onWantedPages__getQueryInfo( $this, $query );
 
        return $query;
    }
 
    protected function getRecacheDB() {
        return $this->getDatabaseProvider()->getReplicaDatabase(
            PageLinksTable::VIRTUAL_DOMAIN,
            'vslow'
        );
    }
 
    protected function getGroupName() {
        return 'maintenance';
    }
}
 
class_alias( SpecialWantedPages::class, 'WantedPagesPage' );