3 * Remove cache entries for removed ResourceLoader modules from the database.
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.
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.
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
21 * @ingroup Maintenance
22 * @author Roan Kattouw
25 use MediaWiki\MediaWikiServices
;
26 use Wikimedia\Rdbms\IDatabase
;
28 require_once __DIR__
. '/Maintenance.php';
31 * Maintenance script to remove cache entries for removed ResourceLoader modules
34 * @ingroup Maintenance
36 class CleanupRemovedModules
extends Maintenance
{
38 public function __construct() {
39 parent
::__construct();
40 $this->addDescription(
41 'Remove cache entries for removed ResourceLoader modules from the database' );
42 $this->setBatchSize( 500 );
45 public function execute() {
46 $this->output( "Cleaning up module_deps table...\n" );
48 $dbw = $this->getDB( DB_MASTER
);
49 $rl = new ResourceLoader( MediaWikiServices
::getInstance()->getMainConfig() );
50 $moduleNames = $rl->getModuleNames();
51 $res = $dbw->select( 'module_deps',
52 [ 'md_module', 'md_skin' ],
53 $moduleNames ?
'md_module NOT IN (' . $dbw->makeList( $moduleNames ) . ')' : '1=1',
56 $rows = iterator_to_array( $res, false );
58 $modDeps = $dbw->tableName( 'module_deps' );
60 foreach ( array_chunk( $rows, $this->getBatchSize() ) as $chunk ) {
61 // WHERE ( mod=A AND skin=A ) OR ( mod=A AND skin=B) ..
62 $conds = array_map( function ( stdClass
$row ) use ( $dbw ) {
63 return $dbw->makeList( (array)$row, IDatabase
::LIST_AND
);
65 $conds = $dbw->makeList( $conds, IDatabase
::LIST_OR
);
67 $this->beginTransaction( $dbw, __METHOD__
);
68 $dbw->query( "DELETE FROM $modDeps WHERE $conds", __METHOD__
);
69 $numRows = $dbw->affectedRows();
70 $this->output( "Batch $i: $numRows rows\n" );
71 $this->commitTransaction( $dbw, __METHOD__
);
76 $this->output( "Done\n" );
80 $maintClass = CleanupRemovedModules
::class;
81 require_once RUN_MAINTENANCE_IF_MAIN
;