dumpLinks.php

Go to the documentation of this file.

<?php
require_once __DIR__ . '/Maintenance.php';
 
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->getDB( DB_REPLICA );
 
        $result = $dbr->newSelectQueryBuilder()
            ->select( [
                'page_id',
                'page_namespace',
                'page_title',
                'pl_namespace',
                'pl_title'
            ] )
            ->from( 'page' )
            ->join( 'pagelinks', null, [ 'page_id=pl_from' ] )
            ->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->pl_namespace, $row->pl_title );
            $this->output( " " . $link->getPrefixedURL() );
        }
        if ( $lastPage !== null ) {
            $this->output( "\n" );
        }
    }
}
 
$maintClass = DumpLinks::class;
require_once RUN_MAINTENANCE_IF_MAIN;