X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2FpopulateParentId.php;h=bf81cb688de9c8e25e1ae131fdcd18305fa87d2d;hb=03cda809006379ee1e5abaac6386a583a0cf5c91;hp=dd114fdd26748a826f3f757150b7df7ef6ba66b4;hpb=59b60fc31194b3b09bba2c95b8ddf85c3f9e81bb;p=lhc%2Fweb%2Fwiklou.git diff --git a/maintenance/populateParentId.php b/maintenance/populateParentId.php index dd114fdd26..bf81cb688d 100644 --- a/maintenance/populateParentId.php +++ b/maintenance/populateParentId.php @@ -3,24 +3,38 @@ * Makes the required database updates for rev_parent_id * to be of any use. It can be used for some simple tracking * and to find new page edits by users. + * + * This program is free software; you can redistribute it and/or modify + * it under the terms of the GNU General Public License as published by + * the Free Software Foundation; either version 2 of the License, or + * (at your option) any later version. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU General Public License for more details. + * + * You should have received a copy of the GNU General Public License along + * with this program; if not, write to the Free Software Foundation, Inc., + * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. + * http://www.gnu.org/copyleft/gpl.html + * + * @ingroup Maintenance */ -require_once( "Maintenance.php" ); +require_once( dirname(__FILE__) . '/Maintenance.php' ); class PopulateParentId extends Maintenance { - - // Batch size - const BATCH_SIZE = 200; - public function __construct() { parent::__construct(); $this->mDescription = "Populates rev_parent_id"; + $this->setBatchSize( 200 ); } public function execute() { $db = wfGetDB( DB_MASTER ); if ( !$db->tableExists( 'revision' ) ) { - $this->error( "revision table does not exist\n", true ); + $this->error( "revision table does not exist", true ); } $this->output( "Populating rev_parent_id column\n" ); $start = $db->selectField( 'revision', 'MIN(rev_id)', false, __FUNCTION__ ); @@ -29,14 +43,14 @@ class PopulateParentId extends Maintenance { $this->output( "...revision table seems to be empty.\n" ); $db->insert( 'updatelog', array( 'ul_key' => 'populate rev_parent_id' ), - __FUNCTION__, + __METHOD__, 'IGNORE' ); return; } # Do remaining chunk - $end += self::BATCH_SIZE - 1; + $end += $this->mBatchSize - 1; $blockStart = intval( $start ); - $blockEnd = intval( $start ) + self::BATCH_SIZE - 1; + $blockEnd = intval( $start ) + $this->mBatchSize - 1; $count = 0; $changed = 0; while( $blockEnd <= $end ) { @@ -44,7 +58,7 @@ class PopulateParentId extends Maintenance { $cond = "rev_id BETWEEN $blockStart AND $blockEnd"; $res = $db->select( 'revision', array('rev_id','rev_page','rev_timestamp','rev_parent_id'), - $cond, __FUNCTION__ ); + $cond, __METHOD__ ); # Go through and update rev_parent_id from these rows. # Assume that the previous revision of the title was # the original previous revision of the title when the @@ -56,20 +70,20 @@ class PopulateParentId extends Maintenance { $previousID = $db->selectField( 'revision', 'rev_id', array( 'rev_page' => $row->rev_page, 'rev_timestamp' => $row->rev_timestamp, "rev_id < " . intval( $row->rev_id ) ), - __FUNCTION__, + __METHOD__, array( 'ORDER BY' => 'rev_id DESC' ) ); # If there are none, check the the highest ID with a lower timestamp if( !$previousID ) { # Get the highest older timestamp $lastTimestamp = $db->selectField( 'revision', 'rev_timestamp', array( 'rev_page' => $row->rev_page, "rev_timestamp < " . $db->addQuotes( $row->rev_timestamp ) ), - __FUNCTION__, + __METHOD__, array( 'ORDER BY' => 'rev_timestamp DESC' ) ); # If there is one, let the highest rev ID win if( $lastTimestamp ) { $previousID = $db->selectField( 'revision', 'rev_id', array( 'rev_page' => $row->rev_page, 'rev_timestamp' => $lastTimestamp ), - __FUNCTION__, + __METHOD__, array( 'ORDER BY' => 'rev_id DESC' ) ); } } @@ -80,16 +94,16 @@ class PopulateParentId extends Maintenance { $db->update( 'revision', array( 'rev_parent_id' => $previousID ), array( 'rev_id' => $row->rev_id ), - __FUNCTION__ ); + __METHOD__ ); $count++; } - $blockStart += self::BATCH_SIZE - 1; - $blockEnd += self::BATCH_SIZE - 1; + $blockStart += $this->mBatchSize - 1; + $blockEnd += $this->mBatchSize - 1; wfWaitForSlaves( 5 ); } $logged = $db->insert( 'updatelog', array( 'ul_key' => 'populate rev_parent_id' ), - __FUNCTION__, + __METHOD__, 'IGNORE' ); if( $logged ) { $this->output( "rev_parent_id population complete ... {$count} rows [{$changed} changed]\n" );