X-Git-Url: http://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2FattachLatest.php;h=475cafc971696d88aa501c0ef18eea6a4db84204;hb=ad4ffa3fd59f40457464756c42adea7e245a14b5;hp=d9d0d5dbe656efc6e01b433cb1aa943735560596;hpb=c771fc9c96aacb44b86ade5ecca68334c5d8213f;p=lhc%2Fweb%2Fwiklou.git diff --git a/maintenance/attachLatest.php b/maintenance/attachLatest.php index d9d0d5dbe6..475cafc971 100644 --- a/maintenance/attachLatest.php +++ b/maintenance/attachLatest.php @@ -1,9 +1,8 @@ + * Corrects wrong values in the `page_latest` field in the database. + * + * Copyright © 2005 Brion Vibber * http://www.mediawiki.org/ * * This program is free software; you can redistribute it and/or modify @@ -21,52 +20,67 @@ * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. * http://www.gnu.org/copyleft/gpl.html * - * @addtogroup Maintenance + * @file + * @ingroup Maintenance */ -require_once( 'commandLine.inc' ); - -$fixit = isset( $options['fix'] ); -$fname = 'attachLatest'; +require_once( __DIR__ . '/Maintenance.php' ); -echo "Looking for pages with page_latest set to 0...\n"; -$dbw =& wfGetDB( DB_MASTER ); -$result = $dbw->select( 'page', - array( 'page_id', 'page_namespace', 'page_title' ), - array( 'page_latest' => 0 ), - $fname ); +/** + * Maintenance script to correct wrong values in the `page_latest` field + * in the database. + * + * @ingroup Maintenance + */ +class AttachLatest extends Maintenance { -$n = 0; -while( $row = $dbw->fetchObject( $result ) ) { - $pageId = intval( $row->page_id ); - $title = Title::makeTitle( $row->page_namespace, $row->page_title ); - $name = $title->getPrefixedText(); - $latestTime = $dbw->selectField( 'revision', - 'MAX(rev_timestamp)', - array( 'rev_page' => $pageId ), - $fname ); - if( !$latestTime ) { - echo wfWikiID()." $pageId [[$name]] can't find latest rev time?!\n"; - continue; + public function __construct() { + parent::__construct(); + $this->addOption( "fix", "Actually fix the entries, will dry run otherwise" ); + $this->mDescription = "Fix page_latest entries in the page table"; } - $revision = Revision::loadFromTimestamp( $dbw, $title, $latestTime ); - if( is_null( $revision ) ) { - echo wfWikiID()." $pageId [[$name]] latest time $latestTime, can't find revision id\n"; - continue; - } - $id = $revision->getId(); - echo wfWikiID()." $pageId [[$name]] latest time $latestTime, rev id $id\n"; - if( $fixit ) { - $article = new Article( $title ); - $article->updateRevisionOn( $dbw, $revision ); + public function execute() { + $this->output( "Looking for pages with page_latest set to 0...\n" ); + $dbw = wfGetDB( DB_MASTER ); + $result = $dbw->select( 'page', + array( 'page_id', 'page_namespace', 'page_title' ), + array( 'page_latest' => 0 ), + __METHOD__ ); + + $n = 0; + foreach ( $result as $row ) { + $pageId = intval( $row->page_id ); + $title = Title::makeTitle( $row->page_namespace, $row->page_title ); + $name = $title->getPrefixedText(); + $latestTime = $dbw->selectField( 'revision', + 'MAX(rev_timestamp)', + array( 'rev_page' => $pageId ), + __METHOD__ ); + if ( !$latestTime ) { + $this->output( wfWikiID() . " $pageId [[$name]] can't find latest rev time?!\n" ); + continue; + } + + $revision = Revision::loadFromTimestamp( $dbw, $title, $latestTime ); + if ( is_null( $revision ) ) { + $this->output( wfWikiID() . " $pageId [[$name]] latest time $latestTime, can't find revision id\n" ); + continue; + } + $id = $revision->getId(); + $this->output( wfWikiID() . " $pageId [[$name]] latest time $latestTime, rev id $id\n" ); + if ( $this->hasOption( 'fix' ) ) { + $page = WikiPage::factory( $title ); + $page->updateRevisionOn( $dbw, $revision ); + } + $n++; + } + $this->output( "Done! Processed $n pages.\n" ); + if ( !$this->hasOption( 'fix' ) ) { + $this->output( "This was a dry run; rerun with --fix to update page_latest.\n" ); + } } - $n++; -} -$dbw->freeResult( $result ); -echo "Done! Processed $n pages.\n"; -if( !$fixit ) { - echo "This was a dry run; rerun with --fix to update page_latest.\n"; } -?> +$maintClass = "AttachLatest"; +require_once( RUN_MAINTENANCE_IF_MAIN );