From babf311ea14879115e0081da0602cf9de0c3838b Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Bartosz=20Dziewo=C5=84ski?= Date: Fri, 17 May 2024 18:54:28 +0200 Subject: Use RawSQLValue/RawSQLExpression for some subqueries Change-Id: Ie7dbd639c51abe21851ed3edfcd74fa3dfc192c2 --- maintenance/initEditCount.php | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) (limited to 'maintenance/initEditCount.php') 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" ); -- cgit v1.2.3