3 * Fix instances of pre-existing JSON pages
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
24 use MediaWiki\Revision\RevisionRecord
;
26 require_once __DIR__
. '/Maintenance.php';
30 * fixDefaultJsonContentPages.php
32 * It is automatically run by update.php
34 class FixDefaultJsonContentPages
extends LoggedUpdateMaintenance
{
35 public function __construct() {
36 parent
::__construct();
37 $this->addDescription(
38 'Fix instances of JSON pages prior to them being the ContentHandler default' );
39 $this->setBatchSize( 100 );
42 protected function getUpdateKey() {
46 protected function doDBUpdates() {
47 if ( !$this->getConfig()->get( 'ContentHandlerUseDB' ) ) {
48 $this->output( "\$wgContentHandlerUseDB is not enabled, nothing to do.\n" );
52 $dbr = $this->getDB( DB_REPLICA
);
54 NS_MEDIAWIKI
=> $dbr->buildLike( $dbr->anyString(), '.json' ),
55 NS_USER
=> $dbr->buildLike( $dbr->anyString(), '/', $dbr->anyString(), '.json' ),
57 foreach ( $namespaces as $ns => $like ) {
62 [ 'page_id', 'page_title', 'page_namespace', 'page_content_model' ],
64 'page_namespace' => $ns,
65 'page_title ' . $like,
66 'page_id > ' . $dbr->addQuotes( $lastPage )
69 [ 'ORDER BY' => 'page_id', 'LIMIT' => $this->getBatchSize() ]
71 foreach ( $rows as $row ) {
72 $this->handleRow( $row );
74 } while ( $rows->numRows() >= $this->getBatchSize() );
80 protected function handleRow( stdClass
$row ) {
81 $title = Title
::makeTitle( $row->page_namespace
, $row->page_title
);
82 $this->output( "Processing {$title} ({$row->page_id})...\n" );
83 $rev = Revision
::newFromTitle( $title );
84 $content = $rev->getContent( RevisionRecord
::RAW
);
85 $dbw = $this->getDB( DB_MASTER
);
86 if ( $content instanceof JsonContent
) {
87 if ( $content->isValid() ) {
88 // Yay, actually JSON. We need to just change the
89 // page_content_model because revision will automatically
90 // use the default, which is *now* JSON.
91 $this->output( "Setting page_content_model to json..." );
94 [ 'page_content_model' => CONTENT_MODEL_JSON
],
95 [ 'page_id' => $row->page_id
],
98 $this->output( "done.\n" );
101 // Not JSON...force it to wikitext. We need to update the
102 // revision table so that these revisions are always processed
103 // as wikitext in the future. page_content_model is already
104 // set to "wikitext".
105 $this->output( "Setting rev_content_model to wikitext..." );
106 // Grab all the ids for batching
107 $ids = $dbw->selectFieldValues(
110 [ 'rev_page' => $row->page_id
],
113 foreach ( array_chunk( $ids, 50 ) as $chunk ) {
116 [ 'rev_content_model' => CONTENT_MODEL_WIKITEXT
],
117 [ 'rev_page' => $row->page_id
, 'rev_id' => $chunk ]
121 $this->output( "done.\n" );
124 $this->output( "not a JSON page? Skipping\n" );
129 $maintClass = FixDefaultJsonContentPages
::class;
130 require_once RUN_MAINTENANCE_IF_MAIN
;