diff options
| author | Bartosz Dziewoński <dziewonski@fastmail.fm> | 2024-05-17 18:54:28 +0200 |
|---|---|---|
| committer | Bartosz Dziewoński <dziewonski@fastmail.fm> | 2024-05-29 19:48:23 +0000 |
| commit | babf311ea14879115e0081da0602cf9de0c3838b (patch) | |
| tree | 6a5451db0dd292fbe2824326750de71e8241f4db /maintenance/initEditCount.php | |
| parent | a9adc61d353c46502d1cfee044775a9c221239e3 (diff) | |
| download | mediawikicore-babf311ea14879115e0081da0602cf9de0c3838b.tar.gz mediawikicore-babf311ea14879115e0081da0602cf9de0c3838b.zip | |
Use RawSQLValue/RawSQLExpression for some subqueries
Change-Id: Ie7dbd639c51abe21851ed3edfcd74fa3dfc192c2
Diffstat (limited to 'maintenance/initEditCount.php')
| -rw-r--r-- | maintenance/initEditCount.php | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/maintenance/initEditCount.php b/maintenance/initEditCount.php index cd7beb0358a6..b9e4c7b20543 100644 --- a/maintenance/initEditCount.php +++ b/maintenance/initEditCount.php @@ -25,6 +25,7 @@ require_once __DIR__ . '/Maintenance.php'; use MediaWiki\WikiMap\WikiMap; +use Wikimedia\Rdbms\RawSQLValue; class InitEditCount extends Maintenance { public function __construct() { @@ -97,7 +98,6 @@ class InitEditCount extends Maintenance { } else { $this->output( "Using single-query mode...\n" ); - $user = $dbw->tableName( 'user' ); $subquery = $dbw->newSelectQueryBuilder() ->select( 'COUNT(*)' ) ->from( 'revision' ) @@ -105,7 +105,11 @@ class InitEditCount extends Maintenance { ->where( 'user_id = actor_rev_user.actor_user' ) ->caller( __METHOD__ )->getSQL(); - $dbw->query( "UPDATE $user SET user_editcount=($subquery)", __METHOD__ ); + $dbw->newUpdateQueryBuilder() + ->table( 'user' ) + ->set( [ 'user_editcount' => new RawSQLValue( "($subquery)" ) ] ) + ->caller( __METHOD__ ) + ->execute(); } $this->output( "Done!\n" ); |