SpecialMostCategories.php

Go to the documentation of this file.

<?php
namespace MediaWiki\Specials;
 
use MediaWiki\Deferred\LinksUpdate\CategoryLinksTable;
use MediaWiki\Html\Html;
use MediaWiki\Linker\Linker;
use MediaWiki\Page\LinkBatchFactory;
use MediaWiki\Skin\Skin;
use MediaWiki\SpecialPage\QueryPage;
use MediaWiki\Title\NamespaceInfo;
use MediaWiki\Title\Title;
use stdClass;
use Wikimedia\Rdbms\IConnectionProvider;
use Wikimedia\Rdbms\IReadableDatabase;
use Wikimedia\Rdbms\IResultWrapper;
 
class SpecialMostCategories extends QueryPage {
 
    public function __construct(
        private readonly NamespaceInfo $namespaceInfo,
        IConnectionProvider $dbProvider,
        LinkBatchFactory $linkBatchFactory
    ) {
        parent::__construct( 'Mostcategories' );
        $this->setDatabaseProvider( $dbProvider );
        $this->setLinkBatchFactory( $linkBatchFactory );
    }
 
    public function isExpensive() {
        return true;
    }
 
    public function isSyndicated() {
        return false;
    }
 
    public function getQueryInfo() {
        return [
            'tables' => [ 'categorylinks', 'page' ],
            'fields' => [
                'namespace' => 'page_namespace',
                'title' => 'page_title',
                'value' => 'COUNT(*)'
            ],
            'conds' => [
                'page_namespace' => $this->namespaceInfo->getContentNamespaces()
            ],
            'options' => [
                'HAVING' => 'COUNT(*) > 1',
                'GROUP BY' => [ 'page_namespace', 'page_title' ]
            ],
            'join_conds' => [
                'page' => [
                    'LEFT JOIN',
                    'page_id = cl_from'
                ]
            ]
        ];
    }
 
    protected function getRecacheDB() {
        return $this->getDatabaseProvider()->getReplicaDatabase(
            CategoryLinksTable::VIRTUAL_DOMAIN,
            'vslow'
        );
    }
 
    public function preprocessResults( $db, $res ) {
        $this->executeLBFromResultWrapper( $res );
    }
 
    public function formatResult( $skin, $result ) {
        $title = Title::makeTitleSafe( $result->namespace, $result->title );
        if ( !$title ) {
            return Html::element(
                'span',
                [ 'class' => 'mw-invalidtitle' ],
                Linker::getInvalidTitleDescription(
                    $this->getContext(),
                    $result->namespace,
                    $result->title
                )
            );
        }
 
        $linkRenderer = $this->getLinkRenderer();
        if ( $this->isCached() ) {
            $link = $linkRenderer->makeLink( $title );
        } else {
            $link = $linkRenderer->makeKnownLink( $title );
        }
 
        $count = $this->msg( 'ncategories' )->numParams( $result->value )->escaped();
 
        return $this->getLanguage()->specialList( $link, $count );
    }
 
    protected function getGroupName() {
        return 'highuse';
    }
}
 
class_alias( SpecialMostCategories::class, 'SpecialMostCategories' );