SpecialMostLinkedTemplates.php

Go to the documentation of this file.

<?php
namespace MediaWiki\Specials;
 
use MediaWiki\Deferred\LinksUpdate\TemplateLinksTable;
use MediaWiki\Html\Html;
use MediaWiki\Linker\Linker;
use MediaWiki\Linker\LinksMigration;
use MediaWiki\Page\LinkBatchFactory;
use MediaWiki\Skin\Skin;
use MediaWiki\SpecialPage\QueryPage;
use MediaWiki\SpecialPage\SpecialPage;
use MediaWiki\Title\Title;
use stdClass;
use Wikimedia\Rdbms\IConnectionProvider;
use Wikimedia\Rdbms\IReadableDatabase;
use Wikimedia\Rdbms\IResultWrapper;
 
class SpecialMostLinkedTemplates extends QueryPage {
 
    public function __construct(
        IConnectionProvider $dbProvider,
        LinkBatchFactory $linkBatchFactory,
        private readonly LinksMigration $linksMigration,
    ) {
        parent::__construct( 'Mostlinkedtemplates' );
        $this->setDatabaseProvider( $dbProvider );
        $this->setLinkBatchFactory( $linkBatchFactory );
    }
 
    public function isExpensive() {
        return true;
    }
 
    public function isSyndicated() {
        return false;
    }
 
    public function sortDescending() {
        return true;
    }
 
    public function getQueryInfo() {
        $queryInfo = $this->linksMigration->getQueryInfo( 'templatelinks' );
        [ $ns, $title ] = $this->linksMigration->getTitleFields( 'templatelinks' );
        return [
            'tables' => $queryInfo['tables'],
            'fields' => [
                'namespace' => $ns,
                'title' => $title,
                'value' => 'COUNT(*)'
            ],
            'options' => [ 'GROUP BY' => [ $ns, $title ] ],
            'join_conds' => $queryInfo['joins']
        ];
    }
 
    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
                )
            );
        }
 
        return $this->getLanguage()->specialList(
            $this->getLinkRenderer()->makeLink( $title ),
            $this->makeWlhLink( $title, $result )
        );
    }
 
    private function makeWlhLink( $title, $result ) {
        $wlh = SpecialPage::getTitleFor( 'Whatlinkshere', $title->getPrefixedText() );
        $label = $this->msg( 'ntransclusions' )->numParams( $result->value )->text();
 
        return $this->getLinkRenderer()->makeLink( $wlh, $label );
    }
 
    protected function getGroupName() {
        return 'highuse';
    }
 
    protected function getRecacheDB() {
        return $this->getDatabaseProvider()->getReplicaDatabase(
            TemplateLinksTable::VIRTUAL_DOMAIN,
            'vslow'
        );
    }
}
 
class_alias( SpecialMostLinkedTemplates::class, 'SpecialMostLinkedTemplates' );