deleteRevision.php

Go to the documentation of this file.

<?php
require_once __DIR__ . '/Maintenance.php';

class DeleteRevision extends Maintenance {

    public function __construct() {
        parent::__construct();
        $this->addDescription( 'Delete one or more revisions by moving them to the archive table' );
    }

    public function execute() {
        if ( count( $this->mArgs ) == 0 ) {
            $this->error( "No revisions specified", true );
        }

        $this->output( "Deleting revision(s) " . implode( ',', $this->mArgs ) .
            " from " . wfWikiID() . "...\n" );
        $dbw = $this->getDB( DB_MASTER );

        $affected = 0;
        foreach ( $this->mArgs as $revID ) {
            $dbw->insertSelect( 'archive', [ 'page', 'revision' ],
                [
                    'ar_namespace' => 'page_namespace',
                    'ar_title' => 'page_title',
                    'ar_page_id' => 'page_id',
                    'ar_comment' => 'rev_comment',
                    'ar_user' => 'rev_user',
                    'ar_user_text' => 'rev_user_text',
                    'ar_timestamp' => 'rev_timestamp',
                    'ar_minor_edit' => 'rev_minor_edit',
                    'ar_rev_id' => 'rev_id',
                    'ar_text_id' => 'rev_text_id',
                    'ar_deleted' => 'rev_deleted',
                    'ar_len' => 'rev_len',
                ],
                [
                    'rev_id' => $revID,
                    'page_id = rev_page'
                ],
                __METHOD__
            );
            if ( !$dbw->affectedRows() ) {
                $this->output( "Revision $revID not found\n" );
            } else {
                $affected += $dbw->affectedRows();
                $pageID = $dbw->selectField(
                    'revision',
                    'rev_page',
                    [ 'rev_id' => $revID ],
                    __METHOD__
                );
                $pageLatest = $dbw->selectField(
                    'page',
                    'page_latest',
                    [ 'page_id' => $pageID ],
                    __METHOD__
                );
                $dbw->delete( 'revision', [ 'rev_id' => $revID ] );
                if ( $pageLatest == $revID ) {
                    // Database integrity
                    $newLatest = $dbw->selectField(
                        'revision',
                        'rev_id',
                        [ 'rev_page' => $pageID ],
                        __METHOD__,
                        [ 'ORDER BY' => 'rev_timestamp DESC' ]
                    );
                    $dbw->update(
                        'page',
                        [ 'page_latest' => $newLatest ],
                        [ 'page_id' => $pageID ],
                        __METHOD__
                    );
                }
            }
        }
        $this->output( "Deleted $affected revisions\n" );
    }
}

$maintClass = "DeleteRevision";
require_once RUN_MAINTENANCE_IF_MAIN;