X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2FpopulateParentId.php;h=99c2b2301429baeb815df090a9e4988d2dcb22b9;hb=dac20d0ffab5a850563d3fb02331a927e42a2bd9;hp=beb8cc8a3618b0bc6317a5b68ff7dfaa1a802cad;hpb=4b069cd1b88877fbb253af8780e358d96ba2587c;p=lhc%2Fweb%2Fwiklou.git diff --git a/maintenance/populateParentId.php b/maintenance/populateParentId.php index beb8cc8a36..99c2b23014 100644 --- a/maintenance/populateParentId.php +++ b/maintenance/populateParentId.php @@ -46,6 +46,7 @@ class PopulateParentId extends LoggedUpdateMaintenance { } protected function doDBUpdates() { + $batchSize = $this->getBatchSize(); $db = $this->getDB( DB_MASTER ); if ( !$db->tableExists( 'revision' ) ) { $this->error( "revision table does not exist" ); @@ -62,15 +63,15 @@ class PopulateParentId extends LoggedUpdateMaintenance { } # Do remaining chunk $blockStart = intval( $start ); - $blockEnd = intval( $start ) + $this->mBatchSize - 1; + $blockEnd = intval( $start ) + $batchSize - 1; $count = 0; $changed = 0; while ( $blockStart <= $end ) { $this->output( "...doing rev_id from $blockStart to $blockEnd\n" ); $cond = "rev_id BETWEEN $blockStart AND $blockEnd"; $res = $db->select( 'revision', - array( 'rev_id', 'rev_page', 'rev_timestamp', 'rev_parent_id' ), - array( $cond, 'rev_parent_id' => null ), __METHOD__ ); + [ 'rev_id', 'rev_page', 'rev_timestamp', 'rev_parent_id' ], + [ $cond, 'rev_parent_id' => null ], __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 @@ -80,29 +81,29 @@ class PopulateParentId extends LoggedUpdateMaintenance { # with a smaller rev ID. The highest ID "wins". This avoids loops # as timestamp can only decrease and never loops with IDs (from parent to parent) $previousID = $db->selectField( 'revision', 'rev_id', - array( 'rev_page' => $row->rev_page, 'rev_timestamp' => $row->rev_timestamp, - "rev_id < " . intval( $row->rev_id ) ), + [ 'rev_page' => $row->rev_page, 'rev_timestamp' => $row->rev_timestamp, + "rev_id < " . intval( $row->rev_id ) ], __METHOD__, - array( 'ORDER BY' => 'rev_id DESC' ) ); + [ 'ORDER BY' => 'rev_id DESC' ] ); # If there are none, check 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 ) - ), + ], __METHOD__, - array( 'ORDER BY' => 'rev_timestamp DESC' ) + [ '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 ), + [ 'rev_page' => $row->rev_page, 'rev_timestamp' => $lastTimestamp ], __METHOD__, - array( 'ORDER BY' => 'rev_id DESC' ) ); + [ 'ORDER BY' => 'rev_id DESC' ] ); } } $previousID = intval( $previousID ); @@ -111,13 +112,13 @@ class PopulateParentId extends LoggedUpdateMaintenance { } # Update the row... $db->update( 'revision', - array( 'rev_parent_id' => $previousID ), - array( 'rev_id' => $row->rev_id ), + [ 'rev_parent_id' => $previousID ], + [ 'rev_id' => $row->rev_id ], __METHOD__ ); $count++; } - $blockStart += $this->mBatchSize; - $blockEnd += $this->mBatchSize; + $blockStart += $batchSize; + $blockEnd += $batchSize; wfWaitForSlaves(); } $this->output( "rev_parent_id population complete ... {$count} rows [{$changed} changed]\n" );