maintenance/cleanupPreferences.php

   1 <?php
   2 /**
   3  * Clean up user preferences from the database.
   4  *
   5  * This program is free software; you can redistribute it and/or modify
   6  * it under the terms of the GNU General Public License as published by
   7  * the Free Software Foundation; either version 2 of the License, or
   8  * (at your option) any later version.
   9  *
  10  * This program is distributed in the hope that it will be useful,
  11  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  12  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  13  * GNU General Public License for more details.
  14  *
  15  * You should have received a copy of the GNU General Public License along
  16  * with this program; if not, write to the Free Software Foundation, Inc.,
  17  * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
  18  * http://www.gnu.org/copyleft/gpl.html
  19  *
  20  * @file
  21  * @author TyA <tya.wiki@gmail.com>
  22  * @author Chad <chad@wikimedia.org>
  23  * @see https://phabricator.wikimedia.org/T32976
  24  * @ingroup Maintenance
  25  */
  26
  27 require_once __DIR__ . '/Maintenance.php';
  28
  29 /**
  30  * Maintenance script that removes bogus preferences from the database.
  31  *
  32  * @ingroup Maintenance
  33  */
  34 class CleanupPreferences extends Maintenance {
  35         public function __construct() {
  36                 parent::__construct();
  37                 $this->mDescription = 'Clean up hidden preferences, removed preferences, and normalizes values';
  38                 $this->setBatchSize( 50 );
  39                 $this->addOption( 'dry-run', 'Print debug info instead of actually deleting' );
  40                 $this->addOption( 'hidden', 'Drop hidden preferences ($wgHiddenPrefs)' );
  41                 $this->addOption( 'unknown',
  42                         'Drop unknown preferences (not in $wgDefaultUserOptions or a gadget or userjs)' );
  43                 // TODO: actually implement this
  44                 // $this->addOption( 'bogus', 'Drop preferences that have invalid/unaccepted values' );
  45         }
  46
  47         /**
  48          * We will do this in three passes
  49          *   1) The easiest is to drop the hidden preferences from the database. We
  50          *      don't actually want them
  51          *   2) Drop preference keys that we don't know about. They could've been
  52          *      removed from core, provided by a now-disabled extension, or the result
  53          *      of a bug. We don't want them.
  54          *   3) TODO: Normalize accepted preference values. This is the biggest part of the work.
  55          *      For each preference we know about, iterate over it and if it's got a
  56          *      limited set of accepted values (so it's not text, basically), make sure
  57          *      all values are in that range. Drop ones that aren't.
  58          */
  59         public function execute() {
  60                 global $wgHiddenPrefs, $wgDefaultUserOptions;
  61
  62                 $dbw = $this->getDB( DB_MASTER );
  63                 $didWork = false;
  64                 $hidden = $this->hasOption( 'hidden' );
  65                 $unknown = $this->hasOption( 'unknown' );
  66                 $bogus = $this->hasOption( 'bogus' );
  67
  68                 if ( !$hidden && !$unknown && !$bogus ) {
  69                         $this->output( "Did not select one of --hidden, --unknown or --bogus, exiting\n" );
  70                         return;
  71                 }
  72
  73                 // Remove hidden prefs. Iterate over them to avoid the IN on a large table
  74                 if ( $hidden ) {
  75                         if ( !$wgHiddenPrefs ) {
  76                                 $this->output( "No hidden preferences, skipping\n" );
  77                         }
  78                         foreach ( $wgHiddenPrefs as $hiddenPref ) {
  79                                 $this->deleteByWhere(
  80                                         $dbw,
  81                                         'Dropping hidden preferences',
  82                                         [ 'up_property' => $hiddenPref ]
  83                                 );
  84                         }
  85                 }
  86
  87                 // Remove unknown preferences. Special-case gadget- and userjs- as we can't
  88                 // control those names.
  89                 if ( $unknown ) {
  90                         $this->deleteByWhere(
  91                                 $dbw,
  92                                 'Dropping unknown preferences',
  93                                 [
  94                                         'up_property NOT' . $dbw->buildLike( 'gadget-', $dbw->anyString() ),
  95                                         'up_property NOT' . $dbw->buildLike( 'userjs-', $dbw->anyString() ),
  96                                         'up_property NOT IN (' . $dbw->makeList( array_keys( $wgDefaultUserOptions ) ) . ')',
  97                                 ]
  98                         );
  99                 }
 100
 101                 // Something something phase 3
 102                 if ( $bogus ) {
 103                 }
 104         }
 105
 106         /**
 107          *
 108          */
 109         private function deleteByWhere( $dbw, $startMessage, $where ) {
 110                 $this->output( $startMessage . "...\n" );
 111                 $total = 0;
 112                 while ( true ) {
 113                         $res = $dbw->select(
 114                                 'user_properties',
 115                                 '*', // The table lacks a primary key, so select the whole row
 116                                 $where,
 117                                 __METHOD__,
 118                                 [ 'LIMIT' => $this->mBatchSize ]
 119                         );
 120
 121                         $numRows = $res->numRows();
 122                         $total += $numRows;
 123                         if ( $res->numRows() <= 0 ) {
 124                                 // All done!
 125                                 $this->output( "DONE! (handled $total entries)\n" );
 126                                 break;
 127                         }
 128
 129                         // Progress or something
 130                         $this->output( "..doing $numRows entries\n" );
 131
 132                         // Delete our batch, then wait
 133                         foreach ( $res as $row ) {
 134                                 if ( $this->hasOption( 'dry-run' ) ) {
 135                                         $this->output(
 136                                                 "    DRY RUN, would drop: " .
 137                                                 "[up_user] => '{$row->up_user}' " .
 138                                                 "[up_property] => '{$row->up_property}' " .
 139                                                 "[up_value] => '{$row->up_value}'\n"
 140                                         );
 141                                         continue;
 142                                 }
 143                                 $this->beginTransaction( $dbw, __METHOD__ );
 144                                 $dbw->delete(
 145                                         'user_properties',
 146                                         [
 147                                                 'up_user'     => $row->up_user,
 148                                                 'up_property' => $row->up_property,
 149                                                 'up_value'    => $row->up_value,
 150                                         ],
 151                                         __METHOD__
 152                                 );
 153                                 $this->commitTransaction( $dbw, __METHOD__ );
 154                         }
 155                 }
 156         }
 157 }
 158
 159 $maintClass = 'CleanupPreferences'; // Tells it to run the class
 160 require_once RUN_MAINTENANCE_IF_MAIN;