3 * Makes the required database updates for Special:ProtectedPages
4 * to show all protected pages, even ones before the page restrictions
5 * schema change. All remaining page_restriction column values are moved
8 * This program is free software; you can redistribute it and/or modify
9 * it under the terms of the GNU General Public License as published by
10 * the Free Software Foundation; either version 2 of the License, or
11 * (at your option) any later version.
13 * This program is distributed in the hope that it will be useful,
14 * but WITHOUT ANY WARRANTY; without even the implied warranty of
15 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
16 * GNU General Public License for more details.
18 * You should have received a copy of the GNU General Public License along
19 * with this program; if not, write to the Free Software Foundation, Inc.,
20 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
21 * http://www.gnu.org/copyleft/gpl.html
24 * @ingroup Maintenance
27 require_once __DIR__
. '/Maintenance.php';
30 * Maintenance script that makes the required database updates for
31 * Special:ProtectedPages to show all protected pages.
33 * @ingroup Maintenance
35 class PopulateLogUsertext
extends LoggedUpdateMaintenance
{
36 public function __construct() {
37 parent
::__construct();
38 $this->addDescription( 'Populates the log_user_text field' );
39 $this->setBatchSize( 100 );
42 protected function getUpdateKey() {
43 return 'populate log_usertext';
46 protected function updateSkippedMessage() {
47 return 'log_user_text column of logging table already populated.';
50 protected function doDBUpdates() {
51 $batchSize = $this->getBatchSize();
52 $db = $this->getDB( DB_MASTER
);
53 $start = $db->selectField( 'logging', 'MIN(log_id)', false, __METHOD__
);
55 $this->output( "Nothing to do.\n" );
59 $end = $db->selectField( 'logging', 'MAX(log_id)', false, __METHOD__
);
62 $end +
= $batchSize - 1;
64 $blockEnd = $start +
$batchSize - 1;
65 while ( $blockEnd <= $end ) {
66 $this->output( "...doing log_id from $blockStart to $blockEnd\n" );
67 $cond = "log_id BETWEEN " . (int)$blockStart . " AND " . (int)$blockEnd .
68 " AND log_user = user_id";
69 $res = $db->select( [ 'logging', 'user' ],
70 [ 'log_id', 'user_name' ], $cond, __METHOD__
);
72 $this->beginTransaction( $db, __METHOD__
);
73 foreach ( $res as $row ) {
74 $db->update( 'logging', [ 'log_user_text' => $row->user_name
],
75 [ 'log_id' => $row->log_id
], __METHOD__
);
77 $this->commitTransaction( $db, __METHOD__
);
78 $blockStart +
= $batchSize;
79 $blockEnd +
= $batchSize;
82 $this->output( "Done populating log_user_text field.\n" );
88 $maintClass = PopulateLogUsertext
::class;
89 require_once RUN_MAINTENANCE_IF_MAIN
;