deleteSelfExternals.php

Go to the documentation of this file.

<?php
require_once __DIR__ . '/Maintenance.php';
 
class DeleteSelfExternals extends Maintenance {
    public function __construct() {
        parent::__construct();
        $this->addDescription( 'Delete self-references to $wgServer from externallinks' );
        $this->setBatchSize( 1000 );
    }
 
    public function execute() {
        global $wgServer;
        $this->output( "Deleting self externals from $wgServer\n" );
        $db = $this->getDB( DB_MASTER );
        while ( 1 ) {
            $this->commitTransaction( $db, __METHOD__ );
            $q = $db->limitResult( "DELETE /* deleteSelfExternals */ FROM externallinks WHERE el_to"
                . $db->buildLike( $wgServer . '/', $db->anyString() ), $this->getBatchSize() );
            $this->output( "Deleting a batch\n" );
            $db->query( $q );
            if ( !$db->affectedRows() ) {
                return;
            }
        }
    }
}
 
$maintClass = DeleteSelfExternals::class;
require_once RUN_MAINTENANCE_IF_MAIN;