X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2FconvertUserOptions.php;h=501f045607130a6805b53bf5e04ae3f1acd7245d;hb=86d7bd86fa08db2dbf3651a656d8238a34703c4f;hp=c245a1e6bdd94e6540027680a109d360e35b1112;hpb=920c06e42c307fcaea47d9b65e09303aded2d1c9;p=lhc%2Fweb%2Fwiklou.git diff --git a/maintenance/convertUserOptions.php b/maintenance/convertUserOptions.php index c245a1e6bd..501f045607 100644 --- a/maintenance/convertUserOptions.php +++ b/maintenance/convertUserOptions.php @@ -23,6 +23,9 @@ require_once __DIR__ . '/Maintenance.php'; +use Wikimedia\Rdbms\ResultWrapper; +use Wikimedia\Rdbms\IDatabase; + /** * Maintenance script to convert user options to the new `user_properties` table. * @@ -50,16 +53,16 @@ class ConvertUserOptions extends Maintenance { } while ( $id !== null ) { $res = $dbw->select( 'user', - array( 'user_id', 'user_options' ), - array( + [ 'user_id', 'user_options' ], + [ 'user_id > ' . $dbw->addQuotes( $id ), "user_options != " . $dbw->addQuotes( '' ), - ), + ], __METHOD__, - array( + [ 'ORDER BY' => 'user_id', - 'LIMIT' => $this->mBatchSize, - ) + 'LIMIT' => $this->getBatchSize(), + ] ); $id = $this->convertOptionBatch( $res, $dbw ); @@ -74,16 +77,16 @@ class ConvertUserOptions extends Maintenance { /** * @param ResultWrapper $res - * @param DatabaseBase $dbw + * @param IDatabase $dbw * @return null|int */ function convertOptionBatch( $res, $dbw ) { $id = null; foreach ( $res as $row ) { $this->mConversionCount++; - $insertRows = array(); + $insertRows = []; foreach ( explode( "\n", $row->user_options ) as $s ) { - $m = array(); + $m = []; if ( !preg_match( "/^(.[^=]*)=(.*)$/", $s, $m ) ) { continue; } @@ -92,22 +95,22 @@ class ConvertUserOptions extends Maintenance { // here (as in User) to avoid adding many unnecessary rows. $defaultOption = User::getDefaultOption( $m[1] ); if ( is_null( $defaultOption ) || $m[2] != $defaultOption ) { - $insertRows[] = array( + $insertRows[] = [ 'up_user' => $row->user_id, 'up_property' => $m[1], 'up_value' => $m[2], - ); + ]; } } if ( count( $insertRows ) ) { - $dbw->insert( 'user_properties', $insertRows, __METHOD__, array( 'IGNORE' ) ); + $dbw->insert( 'user_properties', $insertRows, __METHOD__, [ 'IGNORE' ] ); } $dbw->update( 'user', - array( 'user_options' => '' ), - array( 'user_id' => $row->user_id ), + [ 'user_options' => '' ], + [ 'user_id' => $row->user_id ], __METHOD__ ); $id = $row->user_id;