SpecialLonelyPages.php

Go to the documentation of this file.

<?php
use MediaWiki\Cache\LinkBatchFactory;
use MediaWiki\Languages\LanguageConverterFactory;
use Wikimedia\Rdbms\ILoadBalancer;
 
class SpecialLonelyPages extends PageQueryPage {
 
    private $namespaceInfo;
 
    public function __construct(
        NamespaceInfo $namespaceInfo,
        ILoadBalancer $loadBalancer,
        LinkBatchFactory $linkBatchFactory,
        LanguageConverterFactory $languageConverterFactory
    ) {
        parent::__construct( 'Lonelypages' );
        $this->namespaceInfo = $namespaceInfo;
        $this->setDBLoadBalancer( $loadBalancer );
        $this->setLinkBatchFactory( $linkBatchFactory );
        $this->setLanguageConverter( $languageConverterFactory->getLanguageConverter( $this->getContentLanguage() ) );
    }
 
    protected function getPageHeader() {
        return $this->msg( 'lonelypagestext' )->parseAsBlock();
    }
 
    protected function sortDescending() {
        return false;
    }
 
    public function isExpensive() {
        return true;
    }
 
    public function isSyndicated() {
        return false;
    }
 
    public function getQueryInfo() {
        $tables = [ 'page', 'pagelinks', 'templatelinks' ];
        $conds = [
            'pl_namespace IS NULL',
            'page_namespace' => $this->namespaceInfo->getContentNamespaces(),
            'page_is_redirect' => 0,
            'tl_namespace IS NULL'
        ];
        $joinConds = [
            'pagelinks' => [
                'LEFT JOIN', [
                    'pl_namespace = page_namespace',
                    'pl_title = page_title'
                ]
            ],
            'templatelinks' => [
                'LEFT JOIN', [
                    'tl_namespace = page_namespace',
                    'tl_title = page_title'
                ]
            ]
        ];
 
        // Allow extensions to modify the query
        $this->getHookRunner()->onLonelyPagesQuery( $tables, $conds, $joinConds );
 
        return [
            'tables' => $tables,
            'fields' => [
                'namespace' => 'page_namespace',
                'title' => 'page_title',
            ],
            'conds' => $conds,
            'join_conds' => $joinConds
        ];
    }
 
    protected function getOrderFields() {
        // For some crazy reason ordering by a constant
        // causes a filesort in MySQL 5
        if ( count( $this->namespaceInfo->getContentNamespaces() ) > 1 ) {
            return [ 'page_namespace', 'page_title' ];
        } else {
            return [ 'page_title' ];
        }
    }
 
    protected function getGroupName() {
        return 'maintenance';
    }
}