diff options
author | Pierre Schmitz <pierre@archlinux.de> | 2006-10-11 18:12:39 +0000 |
---|---|---|
committer | Pierre Schmitz <pierre@archlinux.de> | 2006-10-11 18:12:39 +0000 |
commit | 183851b06bd6c52f3cae5375f433da720d410447 (patch) | |
tree | a477257decbf3360127f6739c2f9d0ec57a03d39 /maintenance/storage/resolveStubs.php |
MediaWiki 1.7.1 wiederhergestellt
Diffstat (limited to 'maintenance/storage/resolveStubs.php')
-rw-r--r-- | maintenance/storage/resolveStubs.php | 100 |
1 files changed, 100 insertions, 0 deletions
diff --git a/maintenance/storage/resolveStubs.php b/maintenance/storage/resolveStubs.php new file mode 100644 index 00000000..e93d5c97 --- /dev/null +++ b/maintenance/storage/resolveStubs.php @@ -0,0 +1,100 @@ +<?php + +define( 'REPORTING_INTERVAL', 100 ); + +if ( !defined( 'MEDIAWIKI' ) ) { + $optionsWithArgs = array( 'm' ); + + require_once( '../commandLine.inc' ); + require_once( 'includes/ExternalStoreDB.php' ); + + resolveStubs(); +} + +/** + * Convert history stubs that point to an external row to direct + * external pointers + */ +function resolveStubs() { + $fname = 'resolveStubs'; + + $dbr =& wfGetDB( DB_SLAVE ); + $dbw =& wfGetDB( DB_MASTER ); + $maxID = $dbr->selectField( 'text', 'MAX(old_id)', false, $fname ); + $blockSize = 10000; + $numBlocks = intval( $maxID / $blockSize ) + 1; + + for ( $b = 0; $b < $numBlocks; $b++ ) { + wfWaitForSlaves( 5 ); + + printf( "%5.2f%%\n", $b / $numBlocks * 100 ); + $start = intval($maxID / $numBlocks) * $b + 1; + $end = intval($maxID / $numBlocks) * ($b + 1); + $stubs = array(); + $flagsArray = array(); + + + $res = $dbr->select( 'text', array( 'old_id', 'old_text', 'old_flags' ), + "old_id>=$start AND old_id<=$end " . + # Using a more restrictive flag set for now, until I do some more analysis -- TS + #"AND old_flags LIKE '%object%' AND old_flags NOT LIKE '%external%' ". + + "AND old_flags='object' " . + "AND old_text LIKE 'O:15:\"historyblobstub\"%'", $fname ); + while ( $row = $dbr->fetchObject( $res ) ) { + resolveStub( $row->old_id, $row->old_text, $row->old_flags ); + } + $dbr->freeResult( $res ); + + + } + print "100%\n"; +} + +/** + * Resolve a history stub + */ +function resolveStub( $id, $stubText, $flags ) { + $fname = 'resolveStub'; + + $stub = unserialize( $stubText ); + $flags = explode( ',', $flags ); + + $dbr =& wfGetDB( DB_SLAVE ); + $dbw =& wfGetDB( DB_MASTER ); + + if ( strtolower( get_class( $stub ) ) !== 'historyblobstub' ) { + print "Error found object of class " . get_class( $stub ) . ", expecting historyblobstub\n"; + return; + } + + # Get the (maybe) external row + $externalRow = $dbr->selectRow( 'text', array( 'old_text' ), + array( 'old_id' => $stub->mOldId, "old_flags LIKE '%external%'" ), + $fname + ); + + if ( !$externalRow ) { + # Object wasn't external + return; + } + + # Preserve the legacy encoding flag, but switch from object to external + if ( in_array( 'utf-8', $flags ) ) { + $newFlags = 'external,utf-8'; + } else { + $newFlags = 'external'; + } + + # Update the row + $dbw->update( 'text', + array( /* SET */ + 'old_flags' => $newFlags, + 'old_text' => $externalRow->old_text . '/' . $stub->mHash + ), + array( /* WHERE */ + 'old_id' => $id + ), $fname + ); +} +?> |