dumpLinks.php

Go to the documentation of this file.

<?php
// @codeCoverageIgnoreStart
require_once __DIR__ . '/Maintenance.php';
// @codeCoverageIgnoreEnd
 
use MediaWiki\Deferred\LinksUpdate\PageLinksTable;
use MediaWiki\Maintenance\Maintenance;
use MediaWiki\Title\Title;
 
class DumpLinks extends Maintenance {
    public function __construct() {
        parent::__construct();
        $this->addDescription( 'Quick demo hack to generate a plaintext link dump' );
    }
 
    public function execute() {
        $dbr = $this->getServiceContainer()
            ->getConnectionProvider()
            ->getReplicaDatabase( PageLinksTable::VIRTUAL_DOMAIN );
        $linksMigration = $this->getServiceContainer()->getLinksMigration();
        $queryInfo = $linksMigration->getQueryInfo( 'pagelinks' );
        $queryInfo['tables'] = array_diff( $queryInfo['tables'], [ 'pagelinks' ] );
        [ $blNamespace, $blTitle ] = $linksMigration->getTitleFields( 'pagelinks' );
 
        $result = $dbr->newSelectQueryBuilder()
            ->select( array_merge( [
                'page_id',
                'page_namespace',
                'page_title',
            ], $queryInfo['fields'] ) )
            ->from( 'page' )
            ->join( 'pagelinks', null, [ 'page_id=pl_from' ] )
            ->joinConds( $queryInfo['joins'] )
            ->tables( $queryInfo['tables'] )
            ->orderBy( 'page_id' )
            ->caller( __METHOD__ )
            ->fetchResultSet();
 
        $lastPage = null;
        foreach ( $result as $row ) {
            if ( $lastPage != $row->page_id ) {
                if ( $lastPage !== null ) {
                    $this->output( "\n" );
                }
                $page = Title::makeTitle( $row->page_namespace, $row->page_title );
                $this->output( $page->getPrefixedURL() );
                $lastPage = $row->page_id;
            }
            $link = Title::makeTitle( $row->$blNamespace, $row->$blTitle );
            $this->output( " " . $link->getPrefixedURL() );
        }
        if ( $lastPage !== null ) {
            $this->output( "\n" );
        }
    }
}
 
// @codeCoverageIgnoreStart
$maintClass = DumpLinks::class;
require_once RUN_MAINTENANCE_IF_MAIN;
// @codeCoverageIgnoreEnd