3 * This program is free software; you can redistribute it and/or modify
4 * it under the terms of the GNU General Public License as published by
5 * the Free Software Foundation; either version 2 of the License, or
6 * (at your option) any later version.
8 * This program is distributed in the hope that it will be useful,
9 * but WITHOUT ANY WARRANTY; without even the implied warranty of
10 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
11 * GNU General Public License for more details.
13 * You should have received a copy of the GNU General Public License along
14 * with this program; if not, write to the Free Software Foundation, Inc.,
15 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
16 * http://www.gnu.org/copyleft/gpl.html
19 * @ingroup Maintenance
22 use Wikimedia\Rdbms\IDatabase
;
24 require_once __DIR__
. '/Maintenance.php';
27 * Maintenance script to purge the module_deps database cache table for ResourceLoader.
29 * @ingroup Maintenance
31 class PurgeModuleDeps
extends Maintenance
{
32 public function __construct() {
33 parent
::__construct();
34 $this->addDescription(
35 'Remove all cache entries for ResourceLoader modules from the database' );
36 $this->setBatchSize( 500 );
39 public function execute() {
40 $this->output( "Cleaning up module_deps table...\n" );
42 $dbw = $this->getDB( DB_MASTER
);
43 $res = $dbw->select( 'module_deps', [ 'md_module', 'md_skin' ], [], __METHOD__
);
44 $rows = iterator_to_array( $res, false );
46 $modDeps = $dbw->tableName( 'module_deps' );
48 foreach ( array_chunk( $rows, $this->getBatchSize() ) as $chunk ) {
49 // WHERE ( mod=A AND skin=A ) OR ( mod=A AND skin=B) ..
50 $conds = array_map( function ( stdClass
$row ) use ( $dbw ) {
51 return $dbw->makeList( (array)$row, IDatabase
::LIST_AND
);
53 $conds = $dbw->makeList( $conds, IDatabase
::LIST_OR
);
55 $this->beginTransaction( $dbw, __METHOD__
);
56 $dbw->query( "DELETE FROM $modDeps WHERE $conds", __METHOD__
);
57 $numRows = $dbw->affectedRows();
58 $this->output( "Batch $i: $numRows rows\n" );
59 $this->commitTransaction( $dbw, __METHOD__
);
64 $this->output( "Done\n" );
68 $maintClass = PurgeModuleDeps
::class;
69 require_once RUN_MAINTENANCE_IF_MAIN
;