MediaWiki REL1_30
DatabaseUpdater.php
Go to the documentation of this file.
1<?php
26
27require_once __DIR__ . '/../../maintenance/Maintenance.php';
28
36abstract class DatabaseUpdater {
42 protected $updates = [];
43
49 protected $updatesSkipped = [];
50
55 protected $extensionUpdates = [];
56
62 protected $db;
63
67 protected $maintenance;
68
69 protected $shared = false;
70
76 DeleteDefaultMessages::class,
77 PopulateRevisionLength::class,
78 PopulateRevisionSha1::class,
79 PopulateImageSha1::class,
80 FixExtLinksProtocolRelative::class,
81 PopulateFilearchiveSha1::class,
82 PopulateBacklinkNamespace::class,
83 FixDefaultJsonContentPages::class,
84 CleanupEmptyCategories::class,
85 AddRFCAndPMIDInterwiki::class,
86 PopulatePPSortKey::class,
87 PopulateIpChanges::class,
88 ];
89
95 protected $fileHandle = null;
96
102 protected $skipSchema = false;
103
107 protected $holdContentHandlerUseDB = true;
108
114 protected function __construct( Database &$db, $shared, Maintenance $maintenance = null ) {
115 $this->db = $db;
116 $this->db->setFlag( DBO_DDLMODE ); // For Oracle's handling of schema files
117 $this->shared = $shared;
118 if ( $maintenance ) {
119 $this->maintenance = $maintenance;
120 $this->fileHandle = $maintenance->fileHandle;
121 } else {
122 $this->maintenance = new FakeMaintenance;
123 }
124 $this->maintenance->setDB( $db );
125 $this->initOldGlobals();
126 $this->loadExtensions();
127 Hooks::run( 'LoadExtensionSchemaUpdates', [ $this ] );
128 }
129
134 private function initOldGlobals() {
135 global $wgExtNewTables, $wgExtNewFields, $wgExtPGNewFields,
136 $wgExtPGAlteredFields, $wgExtNewIndexes, $wgExtModifiedFields;
137
138 # For extensions only, should be populated via hooks
139 # $wgDBtype should be checked to specifiy the proper file
140 $wgExtNewTables = []; // table, dir
141 $wgExtNewFields = []; // table, column, dir
142 $wgExtPGNewFields = []; // table, column, column attributes; for PostgreSQL
143 $wgExtPGAlteredFields = []; // table, column, new type, conversion method; for PostgreSQL
144 $wgExtNewIndexes = []; // table, index, dir
145 $wgExtModifiedFields = []; // table, index, dir
146 }
147
152 private function loadExtensions() {
153 if ( !defined( 'MEDIAWIKI_INSTALL' ) ) {
154 return; // already loaded
155 }
157
158 $registry = ExtensionRegistry::getInstance();
159 $queue = $registry->getQueue();
160 // Don't accidentally load extensions in the future
161 $registry->clearQueue();
162
163 // This will automatically add "AutoloadClasses" to $wgAutoloadClasses
164 $data = $registry->readFromQueue( $queue );
165 $hooks = [ 'wgHooks' => [ 'LoadExtensionSchemaUpdates' => [] ] ];
166 if ( isset( $data['globals']['wgHooks']['LoadExtensionSchemaUpdates'] ) ) {
167 $hooks = $data['globals']['wgHooks']['LoadExtensionSchemaUpdates'];
168 }
169 if ( $vars && isset( $vars['wgHooks']['LoadExtensionSchemaUpdates'] ) ) {
170 $hooks = array_merge_recursive( $hooks, $vars['wgHooks']['LoadExtensionSchemaUpdates'] );
171 }
173 $wgHooks['LoadExtensionSchemaUpdates'] = $hooks;
174 if ( $vars && isset( $vars['wgAutoloadClasses'] ) ) {
175 $wgAutoloadClasses += $vars['wgAutoloadClasses'];
176 }
177 }
178
187 public static function newForDB( Database $db, $shared = false, $maintenance = null ) {
188 $type = $db->getType();
189 if ( in_array( $type, Installer::getDBTypes() ) ) {
190 $class = ucfirst( $type ) . 'Updater';
191
192 return new $class( $db, $shared, $maintenance );
193 } else {
194 throw new MWException( __METHOD__ . ' called for unsupported $wgDBtype' );
195 }
196 }
197
203 public function getDB() {
204 return $this->db;
205 }
206
212 public function output( $str ) {
213 if ( $this->maintenance->isQuiet() ) {
214 return;
215 }
216 global $wgCommandLineMode;
217 if ( !$wgCommandLineMode ) {
218 $str = htmlspecialchars( $str );
219 }
220 echo $str;
221 flush();
222 }
223
236 public function addExtensionUpdate( array $update ) {
237 $this->extensionUpdates[] = $update;
238 }
239
249 public function addExtensionTable( $tableName, $sqlPath ) {
250 $this->extensionUpdates[] = [ 'addTable', $tableName, $sqlPath, true ];
251 }
252
260 public function addExtensionIndex( $tableName, $indexName, $sqlPath ) {
261 $this->extensionUpdates[] = [ 'addIndex', $tableName, $indexName, $sqlPath, true ];
262 }
263
272 public function addExtensionField( $tableName, $columnName, $sqlPath ) {
273 $this->extensionUpdates[] = [ 'addField', $tableName, $columnName, $sqlPath, true ];
274 }
275
284 public function dropExtensionField( $tableName, $columnName, $sqlPath ) {
285 $this->extensionUpdates[] = [ 'dropField', $tableName, $columnName, $sqlPath, true ];
286 }
287
297 public function dropExtensionIndex( $tableName, $indexName, $sqlPath ) {
298 $this->extensionUpdates[] = [ 'dropIndex', $tableName, $indexName, $sqlPath, true ];
299 }
300
308 public function dropExtensionTable( $tableName, $sqlPath ) {
309 $this->extensionUpdates[] = [ 'dropTable', $tableName, $sqlPath, true ];
310 }
311
324 public function renameExtensionIndex( $tableName, $oldIndexName, $newIndexName,
325 $sqlPath, $skipBothIndexExistWarning = false
326 ) {
327 $this->extensionUpdates[] = [
328 'renameIndex',
329 $tableName,
330 $oldIndexName,
331 $newIndexName,
332 $skipBothIndexExistWarning,
333 $sqlPath,
334 true
335 ];
336 }
337
345 public function modifyExtensionField( $tableName, $fieldName, $sqlPath ) {
346 $this->extensionUpdates[] = [ 'modifyField', $tableName, $fieldName, $sqlPath, true ];
347 }
348
356 public function tableExists( $tableName ) {
357 return ( $this->db->tableExists( $tableName, __METHOD__ ) );
358 }
359
369 public function addPostDatabaseUpdateMaintenance( $class ) {
370 $this->postDatabaseUpdateMaintenance[] = $class;
371 }
372
378 protected function getExtensionUpdates() {
380 }
381
390
397 private function writeSchemaUpdateFile( array $schemaUpdate = [] ) {
399 $this->updatesSkipped = [];
400
401 foreach ( $updates as $funcList ) {
402 $func = $funcList[0];
403 $arg = $funcList[1];
404 $origParams = $funcList[2];
405 call_user_func_array( $func, $arg );
406 flush();
407 $this->updatesSkipped[] = $origParams;
408 }
409 }
410
421 public function getSchemaVars() {
422 return []; // DB-type specific
423 }
424
430 public function doUpdates( array $what = [ 'core', 'extensions', 'stats' ] ) {
431 $this->db->setSchemaVars( $this->getSchemaVars() );
432
433 $what = array_flip( $what );
434 $this->skipSchema = isset( $what['noschema'] ) || $this->fileHandle !== null;
435 if ( isset( $what['core'] ) ) {
436 $this->runUpdates( $this->getCoreUpdateList(), false );
437 }
438 if ( isset( $what['extensions'] ) ) {
439 $this->runUpdates( $this->getOldGlobalUpdates(), false );
440 $this->runUpdates( $this->getExtensionUpdates(), true );
441 }
442
443 if ( isset( $what['stats'] ) ) {
444 $this->checkStats();
445 }
446
447 if ( $this->fileHandle ) {
448 $this->skipSchema = false;
449 $this->writeSchemaUpdateFile();
450 }
451 }
452
459 private function runUpdates( array $updates, $passSelf ) {
460 $lbFactory = MediaWikiServices::getInstance()->getDBLoadBalancerFactory();
461
462 $updatesDone = [];
463 $updatesSkipped = [];
464 foreach ( $updates as $params ) {
465 $origParams = $params;
466 $func = array_shift( $params );
467 if ( !is_array( $func ) && method_exists( $this, $func ) ) {
468 $func = [ $this, $func ];
469 } elseif ( $passSelf ) {
470 array_unshift( $params, $this );
471 }
472 $ret = call_user_func_array( $func, $params );
473 flush();
474 if ( $ret !== false ) {
475 $updatesDone[] = $origParams;
476 $lbFactory->waitForReplication();
477 } else {
478 $updatesSkipped[] = [ $func, $params, $origParams ];
479 }
480 }
481 $this->updatesSkipped = array_merge( $this->updatesSkipped, $updatesSkipped );
482 $this->updates = array_merge( $this->updates, $updatesDone );
483 }
484
492 public function updateRowExists( $key ) {
493 $row = $this->db->selectRow(
494 'updatelog',
495 # T67813
496 '1 AS X',
497 [ 'ul_key' => $key ],
498 __METHOD__
499 );
500
501 return (bool)$row;
502 }
503
511 public function insertUpdateRow( $key, $val = null ) {
512 $this->db->clearFlag( DBO_DDLMODE );
513 $values = [ 'ul_key' => $key ];
514 if ( $val && $this->canUseNewUpdatelog() ) {
515 $values['ul_value'] = $val;
516 }
517 $this->db->insert( 'updatelog', $values, __METHOD__, 'IGNORE' );
518 $this->db->setFlag( DBO_DDLMODE );
519 }
520
529 protected function canUseNewUpdatelog() {
530 return $this->db->tableExists( 'updatelog', __METHOD__ ) &&
531 $this->db->fieldExists( 'updatelog', 'ul_value', __METHOD__ );
532 }
533
542 protected function doTable( $name ) {
544
545 // Don't bother to check $wgSharedTables if there isn't a shared database
546 // or the user actually also wants to do updates on the shared database.
547 if ( $wgSharedDB === null || $this->shared ) {
548 return true;
549 }
550
551 if ( in_array( $name, $wgSharedTables ) ) {
552 $this->output( "...skipping update to shared table $name.\n" );
553 return false;
554 } else {
555 return true;
556 }
557 }
558
567 protected function getOldGlobalUpdates() {
568 global $wgExtNewFields, $wgExtNewTables, $wgExtModifiedFields,
569 $wgExtNewIndexes;
570
571 $updates = [];
572
573 foreach ( $wgExtNewTables as $tableRecord ) {
574 $updates[] = [
575 'addTable', $tableRecord[0], $tableRecord[1], true
576 ];
577 }
578
579 foreach ( $wgExtNewFields as $fieldRecord ) {
580 $updates[] = [
581 'addField', $fieldRecord[0], $fieldRecord[1],
582 $fieldRecord[2], true
583 ];
584 }
585
586 foreach ( $wgExtNewIndexes as $fieldRecord ) {
587 $updates[] = [
588 'addIndex', $fieldRecord[0], $fieldRecord[1],
589 $fieldRecord[2], true
590 ];
591 }
592
593 foreach ( $wgExtModifiedFields as $fieldRecord ) {
594 $updates[] = [
595 'modifyField', $fieldRecord[0], $fieldRecord[1],
596 $fieldRecord[2], true
597 ];
598 }
599
600 return $updates;
601 }
602
611 abstract protected function getCoreUpdateList();
612
618 public function copyFile( $filename ) {
619 $this->db->sourceFile(
620 $filename,
621 null,
622 null,
623 __METHOD__,
624 [ $this, 'appendLine' ]
625 );
626 }
627
638 public function appendLine( $line ) {
639 $line = rtrim( $line ) . ";\n";
640 if ( fwrite( $this->fileHandle, $line ) === false ) {
641 throw new MWException( "trouble writing file" );
642 }
643
644 return false;
645 }
646
655 protected function applyPatch( $path, $isFullPath = false, $msg = null ) {
656 if ( $msg === null ) {
657 $msg = "Applying $path patch";
658 }
659 if ( $this->skipSchema ) {
660 $this->output( "...skipping schema change ($msg).\n" );
661
662 return false;
663 }
664
665 $this->output( "$msg ..." );
666
667 if ( !$isFullPath ) {
668 $path = $this->patchPath( $this->db, $path );
669 }
670 if ( $this->fileHandle !== null ) {
671 $this->copyFile( $path );
672 } else {
673 $this->db->sourceFile( $path );
674 }
675 $this->output( "done.\n" );
676
677 return true;
678 }
679
689 public function patchPath( IDatabase $db, $patch ) {
690 global $IP;
691
692 $dbType = $db->getType();
693 if ( file_exists( "$IP/maintenance/$dbType/archives/$patch" ) ) {
694 return "$IP/maintenance/$dbType/archives/$patch";
695 } else {
696 return "$IP/maintenance/archives/$patch";
697 }
698 }
699
708 protected function addTable( $name, $patch, $fullpath = false ) {
709 if ( !$this->doTable( $name ) ) {
710 return true;
711 }
712
713 if ( $this->db->tableExists( $name, __METHOD__ ) ) {
714 $this->output( "...$name table already exists.\n" );
715 } else {
716 return $this->applyPatch( $patch, $fullpath, "Creating $name table" );
717 }
718
719 return true;
720 }
721
731 protected function addField( $table, $field, $patch, $fullpath = false ) {
732 if ( !$this->doTable( $table ) ) {
733 return true;
734 }
735
736 if ( !$this->db->tableExists( $table, __METHOD__ ) ) {
737 $this->output( "...$table table does not exist, skipping new field patch.\n" );
738 } elseif ( $this->db->fieldExists( $table, $field, __METHOD__ ) ) {
739 $this->output( "...have $field field in $table table.\n" );
740 } else {
741 return $this->applyPatch( $patch, $fullpath, "Adding $field field to table $table" );
742 }
743
744 return true;
745 }
746
756 protected function addIndex( $table, $index, $patch, $fullpath = false ) {
757 if ( !$this->doTable( $table ) ) {
758 return true;
759 }
760
761 if ( !$this->db->tableExists( $table, __METHOD__ ) ) {
762 $this->output( "...skipping: '$table' table doesn't exist yet.\n" );
763 } elseif ( $this->db->indexExists( $table, $index, __METHOD__ ) ) {
764 $this->output( "...index $index already set on $table table.\n" );
765 } else {
766 return $this->applyPatch( $patch, $fullpath, "Adding index $index to table $table" );
767 }
768
769 return true;
770 }
771
781 protected function dropField( $table, $field, $patch, $fullpath = false ) {
782 if ( !$this->doTable( $table ) ) {
783 return true;
784 }
785
786 if ( $this->db->fieldExists( $table, $field, __METHOD__ ) ) {
787 return $this->applyPatch( $patch, $fullpath, "Table $table contains $field field. Dropping" );
788 } else {
789 $this->output( "...$table table does not contain $field field.\n" );
790 }
791
792 return true;
793 }
794
804 protected function dropIndex( $table, $index, $patch, $fullpath = false ) {
805 if ( !$this->doTable( $table ) ) {
806 return true;
807 }
808
809 if ( $this->db->indexExists( $table, $index, __METHOD__ ) ) {
810 return $this->applyPatch( $patch, $fullpath, "Dropping $index index from table $table" );
811 } else {
812 $this->output( "...$index key doesn't exist.\n" );
813 }
814
815 return true;
816 }
817
830 protected function renameIndex( $table, $oldIndex, $newIndex,
831 $skipBothIndexExistWarning, $patch, $fullpath = false
832 ) {
833 if ( !$this->doTable( $table ) ) {
834 return true;
835 }
836
837 // First requirement: the table must exist
838 if ( !$this->db->tableExists( $table, __METHOD__ ) ) {
839 $this->output( "...skipping: '$table' table doesn't exist yet.\n" );
840
841 return true;
842 }
843
844 // Second requirement: the new index must be missing
845 if ( $this->db->indexExists( $table, $newIndex, __METHOD__ ) ) {
846 $this->output( "...index $newIndex already set on $table table.\n" );
847 if ( !$skipBothIndexExistWarning &&
848 $this->db->indexExists( $table, $oldIndex, __METHOD__ )
849 ) {
850 $this->output( "...WARNING: $oldIndex still exists, despite it has " .
851 "been renamed into $newIndex (which also exists).\n" .
852 " $oldIndex should be manually removed if not needed anymore.\n" );
853 }
854
855 return true;
856 }
857
858 // Third requirement: the old index must exist
859 if ( !$this->db->indexExists( $table, $oldIndex, __METHOD__ ) ) {
860 $this->output( "...skipping: index $oldIndex doesn't exist.\n" );
861
862 return true;
863 }
864
865 // Requirements have been satisfied, patch can be applied
866 return $this->applyPatch(
867 $patch,
868 $fullpath,
869 "Renaming index $oldIndex into $newIndex to table $table"
870 );
871 }
872
884 public function dropTable( $table, $patch = false, $fullpath = false ) {
885 if ( !$this->doTable( $table ) ) {
886 return true;
887 }
888
889 if ( $this->db->tableExists( $table, __METHOD__ ) ) {
890 $msg = "Dropping table $table";
891
892 if ( $patch === false ) {
893 $this->output( "$msg ..." );
894 $this->db->dropTable( $table, __METHOD__ );
895 $this->output( "done.\n" );
896 } else {
897 return $this->applyPatch( $patch, $fullpath, $msg );
898 }
899 } else {
900 $this->output( "...$table doesn't exist.\n" );
901 }
902
903 return true;
904 }
905
915 public function modifyField( $table, $field, $patch, $fullpath = false ) {
916 if ( !$this->doTable( $table ) ) {
917 return true;
918 }
919
920 $updateKey = "$table-$field-$patch";
921 if ( !$this->db->tableExists( $table, __METHOD__ ) ) {
922 $this->output( "...$table table does not exist, skipping modify field patch.\n" );
923 } elseif ( !$this->db->fieldExists( $table, $field, __METHOD__ ) ) {
924 $this->output( "...$field field does not exist in $table table, " .
925 "skipping modify field patch.\n" );
926 } elseif ( $this->updateRowExists( $updateKey ) ) {
927 $this->output( "...$field in table $table already modified by patch $patch.\n" );
928 } else {
929 $apply = $this->applyPatch( $patch, $fullpath, "Modifying $field field of table $table" );
930 if ( $apply ) {
931 $this->insertUpdateRow( $updateKey );
932 }
933 return $apply;
934 }
935 return true;
936 }
937
947 public function modifyTable( $table, $patch, $fullpath = false ) {
948 if ( !$this->doTable( $table ) ) {
949 return true;
950 }
951
952 $updateKey = "$table-$patch";
953 if ( !$this->db->tableExists( $table, __METHOD__ ) ) {
954 $this->output( "...$table table does not exist, skipping modify table patch.\n" );
955 } elseif ( $this->updateRowExists( $updateKey ) ) {
956 $this->output( "...table $table already modified by patch $patch.\n" );
957 } else {
958 $apply = $this->applyPatch( $patch, $fullpath, "Modifying table $table" );
959 if ( $apply ) {
960 $this->insertUpdateRow( $updateKey );
961 }
962 return $apply;
963 }
964 return true;
965 }
966
972 public function setFileAccess() {
973 $repo = RepoGroup::singleton()->getLocalRepo();
974 $zonePath = $repo->getZonePath( 'temp' );
975 if ( $repo->getBackend()->directoryExists( [ 'dir' => $zonePath ] ) ) {
976 // If the directory was never made, then it will have the right ACLs when it is made
977 $status = $repo->getBackend()->secure( [
978 'dir' => $zonePath,
979 'noAccess' => true,
980 'noListing' => true
981 ] );
982 if ( $status->isOK() ) {
983 $this->output( "Set the local repo temp zone container to be private.\n" );
984 } else {
985 $this->output( "Failed to set the local repo temp zone container to be private.\n" );
986 }
987 }
988 }
989
993 public function purgeCache() {
995 # We can't guarantee that the user will be able to use TRUNCATE,
996 # but we know that DELETE is available to us
997 $this->output( "Purging caches..." );
998 $this->db->delete( 'objectcache', '*', __METHOD__ );
999 if ( $wgLocalisationCacheConf['manualRecache'] ) {
1000 $this->rebuildLocalisationCache();
1001 }
1002 $blobStore = new MessageBlobStore();
1003 $blobStore->clear();
1004 $this->db->delete( 'module_deps', '*', __METHOD__ );
1005 $this->output( "done.\n" );
1006 }
1007
1011 protected function checkStats() {
1012 $this->output( "...site_stats is populated..." );
1013 $row = $this->db->selectRow( 'site_stats', '*', [ 'ss_row_id' => 1 ], __METHOD__ );
1014 if ( $row === false ) {
1015 $this->output( "data is missing! rebuilding...\n" );
1016 } elseif ( isset( $row->site_stats ) && $row->ss_total_pages == -1 ) {
1017 $this->output( "missing ss_total_pages, rebuilding...\n" );
1018 } else {
1019 $this->output( "done.\n" );
1020
1021 return;
1022 }
1023 SiteStatsInit::doAllAndCommit( $this->db );
1024 }
1025
1026 # Common updater functions
1027
1031 protected function doActiveUsersInit() {
1032 $activeUsers = $this->db->selectField( 'site_stats', 'ss_active_users', false, __METHOD__ );
1033 if ( $activeUsers == -1 ) {
1034 $activeUsers = $this->db->selectField( 'recentchanges',
1035 'COUNT( DISTINCT rc_user_text )',
1036 [ 'rc_user != 0', 'rc_bot' => 0, "rc_log_type != 'newusers'" ], __METHOD__
1037 );
1038 $this->db->update( 'site_stats',
1039 [ 'ss_active_users' => intval( $activeUsers ) ],
1040 [ 'ss_row_id' => 1 ], __METHOD__, [ 'LIMIT' => 1 ]
1041 );
1042 }
1043 $this->output( "...ss_active_users user count set...\n" );
1044 }
1045
1049 protected function doLogUsertextPopulation() {
1050 if ( !$this->updateRowExists( 'populate log_usertext' ) ) {
1051 $this->output(
1052 "Populating log_user_text field, printing progress markers. For large\n" .
1053 "databases, you may want to hit Ctrl-C and do this manually with\n" .
1054 "maintenance/populateLogUsertext.php.\n"
1055 );
1056
1057 $task = $this->maintenance->runChild( 'PopulateLogUsertext' );
1058 $task->execute();
1059 $this->output( "done.\n" );
1060 }
1061 }
1062
1066 protected function doLogSearchPopulation() {
1067 if ( !$this->updateRowExists( 'populate log_search' ) ) {
1068 $this->output(
1069 "Populating log_search table, printing progress markers. For large\n" .
1070 "databases, you may want to hit Ctrl-C and do this manually with\n" .
1071 "maintenance/populateLogSearch.php.\n" );
1072
1073 $task = $this->maintenance->runChild( 'PopulateLogSearch' );
1074 $task->execute();
1075 $this->output( "done.\n" );
1076 }
1077 }
1078
1083 protected function doUpdateTranscacheField() {
1084 if ( $this->updateRowExists( 'convert transcache field' ) ) {
1085 $this->output( "...transcache tc_time already converted.\n" );
1086
1087 return true;
1088 }
1089
1090 return $this->applyPatch( 'patch-tc-timestamp.sql', false,
1091 "Converting tc_time from UNIX epoch to MediaWiki timestamp" );
1092 }
1093
1097 protected function doCollationUpdate() {
1098 global $wgCategoryCollation;
1099 if ( $this->db->fieldExists( 'categorylinks', 'cl_collation', __METHOD__ ) ) {
1100 if ( $this->db->selectField(
1101 'categorylinks',
1102 'COUNT(*)',
1103 'cl_collation != ' . $this->db->addQuotes( $wgCategoryCollation ),
1104 __METHOD__
1105 ) == 0
1106 ) {
1107 $this->output( "...collations up-to-date.\n" );
1108
1109 return;
1110 }
1111
1112 $this->output( "Updating category collations..." );
1113 $task = $this->maintenance->runChild( 'UpdateCollation' );
1114 $task->execute();
1115 $this->output( "...done.\n" );
1116 }
1117 }
1118
1122 protected function doMigrateUserOptions() {
1123 if ( $this->db->tableExists( 'user_properties' ) ) {
1124 $cl = $this->maintenance->runChild( 'ConvertUserOptions', 'convertUserOptions.php' );
1125 $cl->execute();
1126 $this->output( "done.\n" );
1127 }
1128 }
1129
1133 protected function doEnableProfiling() {
1134 global $wgProfiler;
1135
1136 if ( !$this->doTable( 'profiling' ) ) {
1137 return;
1138 }
1139
1140 $profileToDb = false;
1141 if ( isset( $wgProfiler['output'] ) ) {
1142 $out = $wgProfiler['output'];
1143 if ( $out === 'db' ) {
1144 $profileToDb = true;
1145 } elseif ( is_array( $out ) && in_array( 'db', $out ) ) {
1146 $profileToDb = true;
1147 }
1148 }
1149
1150 if ( $profileToDb && !$this->db->tableExists( 'profiling', __METHOD__ ) ) {
1151 $this->applyPatch( 'patch-profiling.sql', false, 'Add profiling table' );
1152 }
1153 }
1154
1158 protected function rebuildLocalisationCache() {
1162 $cl = $this->maintenance->runChild( 'RebuildLocalisationCache', 'rebuildLocalisationCache.php' );
1163 $this->output( "Rebuilding localisation cache...\n" );
1164 $cl->setForce();
1165 $cl->execute();
1166 $this->output( "done.\n" );
1167 }
1168
1173 protected function disableContentHandlerUseDB() {
1175
1176 if ( $wgContentHandlerUseDB ) {
1177 $this->output( "Turning off Content Handler DB fields for this part of upgrade.\n" );
1178 $this->holdContentHandlerUseDB = $wgContentHandlerUseDB;
1179 $wgContentHandlerUseDB = false;
1180 }
1181 }
1182
1186 protected function enableContentHandlerUseDB() {
1188
1189 if ( $this->holdContentHandlerUseDB ) {
1190 $this->output( "Content Handler DB fields should be usable now.\n" );
1191 $wgContentHandlerUseDB = $this->holdContentHandlerUseDB;
1192 }
1193 }
1194
1199 protected function migrateComments() {
1202 !$this->updateRowExists( 'MigrateComments' )
1203 ) {
1204 $this->output(
1205 "Migrating comments to the 'comments' table, printing progress markers. For large\n" .
1206 "databases, you may want to hit Ctrl-C and do this manually with\n" .
1207 "maintenance/migrateComments.php.\n"
1208 );
1209 $task = $this->maintenance->runChild( 'MigrateComments', 'migrateComments.php' );
1210 $task->execute();
1211 $this->output( "done.\n" );
1212 }
1213 }
1214
1215}
$wgSharedTables
$wgAutoloadClasses
Array mapping class names to filenames, for autoloading.
$wgCategoryCollation
Specify how category names should be sorted, when listed on a category page.
$wgSharedDB
Shared database for multiple wikis.
int $wgCommentTableSchemaMigrationStage
Comment table schema migration stage.
$wgContentHandlerUseDB
Set to false to disable use of the database fields introduced by the ContentHandler facility.
$wgLocalisationCacheConf
Localisation cache configuration.
$wgProfiler
global $wgCommandLineMode
Definition Setup.php:526
$line
Definition cdb.php:58
Class for handling database updates.
purgeCache()
Purge the objectcache table.
addExtensionTable( $tableName, $sqlPath)
Convenience wrapper for addExtensionUpdate() when adding a new table (which is the most common usage ...
getDB()
Get a database connection to run updates.
setFileAccess()
Set any .htaccess files or equivilent for storage repos.
loadExtensions()
Loads LocalSettings.php, if needed, and initialises everything needed for LoadExtensionSchemaUpdates ...
addIndex( $table, $index, $patch, $fullpath=false)
Add a new index to an existing table.
array $updates
Array of updates to perform on the database.
$holdContentHandlerUseDB
Hold the value of $wgContentHandlerUseDB during the upgrade.
disableContentHandlerUseDB()
Turns off content handler fields during parts of the upgrade where they aren't available.
bool $skipSchema
Flag specifying whether or not to skip schema (e.g.
addField( $table, $field, $patch, $fullpath=false)
Add a new field to an existing table.
addExtensionIndex( $tableName, $indexName, $sqlPath)
modifyTable( $table, $patch, $fullpath=false)
Modify an existing table, similar to modifyField.
doUpdates(array $what=[ 'core', 'extensions', 'stats'])
Do all the updates.
Maintenance $maintenance
updateRowExists( $key)
Helper function: check if the given key is present in the updatelog table.
runUpdates(array $updates, $passSelf)
Helper function for doUpdates()
getCoreUpdateList()
Get an array of updates to perform on the database.
enableContentHandlerUseDB()
Turns content handler fields back on.
output( $str)
Output some text.
doLogSearchPopulation()
Migrate log params to new table and index for searching.
doLogUsertextPopulation()
Populates the log_user_text field in the logging table.
getExtensionUpdates()
Get the list of extension-defined updates.
insertUpdateRow( $key, $val=null)
Helper function: Add a key to the updatelog table Obviously, only use this for updates that occur aft...
canUseNewUpdatelog()
Updatelog was changed in 1.17 to have a ul_value column so we can record more information about what ...
patchPath(IDatabase $db, $patch)
Get the full path of a patch file.
copyFile( $filename)
Append an SQL fragment to the open file handle.
tableExists( $tableName)
string[] $postDatabaseUpdateMaintenance
Scripts to run after database update Should be a subclass of LoggedUpdateMaintenance.
renameIndex( $table, $oldIndex, $newIndex, $skipBothIndexExistWarning, $patch, $fullpath=false)
Rename an index from an existing table.
writeSchemaUpdateFile(array $schemaUpdate=[])
rebuildLocalisationCache()
Rebuilds the localisation cache.
addExtensionField( $tableName, $columnName, $sqlPath)
__construct(Database &$db, $shared, Maintenance $maintenance=null)
dropExtensionTable( $tableName, $sqlPath)
addTable( $name, $patch, $fullpath=false)
Add a new table to the database.
modifyField( $table, $field, $patch, $fullpath=false)
Modify an existing field.
doActiveUsersInit()
Sets the number of active users in the site_stats table.
dropExtensionField( $tableName, $columnName, $sqlPath)
static newForDB(Database $db, $shared=false, $maintenance=null)
getOldGlobalUpdates()
Before 1.17, we used to handle updates via stuff like $wgExtNewTables/Fields/Indexes.
addPostDatabaseUpdateMaintenance( $class)
Add a maintenance script to be run after the database updates are complete.
dropField( $table, $field, $patch, $fullpath=false)
Drop a field from an existing table.
doCollationUpdate()
Update CategoryLinks collation.
renameExtensionIndex( $tableName, $oldIndexName, $newIndexName, $sqlPath, $skipBothIndexExistWarning=false)
Rename an index on an extension table.
addExtensionUpdate(array $update)
Add a new update coming from an extension.
array $updatesSkipped
Array of updates that were skipped.
Database $db
Handle to the database subclass.
resource $fileHandle
File handle for SQL output.
appendLine( $line)
Append a line to the open filehandle.
dropExtensionIndex( $tableName, $indexName, $sqlPath)
Drop an index from an extension table.
initOldGlobals()
Initialize all of the old globals.
doEnableProfiling()
Enable profiling table when it's turned on.
array $extensionUpdates
List of extension-provided database updates.
checkStats()
Check the site_stats table is not properly populated.
modifyExtensionField( $tableName, $fieldName, $sqlPath)
applyPatch( $path, $isFullPath=false, $msg=null)
Applies a SQL patch.
dropIndex( $table, $index, $patch, $fullpath=false)
Drop an index from an existing table.
doUpdateTranscacheField()
Updates the timestamps in the transcache table.
dropTable( $table, $patch=false, $fullpath=false)
If the specified table exists, drop it, or execute the patch if one is provided.
migrateComments()
Migrate comments to the new 'comment' table.
getSchemaVars()
Get appropriate schema variables in the current database connection.
doTable( $name)
Returns whether updates should be executed on the database table $name.
doMigrateUserOptions()
Migrates user options from the user table blob to user_properties.
Fake maintenance wrapper, mostly used for the web installer/updater.
static getExistingLocalSettings()
Determine if LocalSettings.php exists.
static getDBTypes()
Get a list of known DB types.
MediaWiki exception.
Abstract maintenance class for quickly writing and churning out maintenance scripts with minimal effo...
setDB(IDatabase $db)
Sets database object to be returned by getDB().
MediaWikiServices is the service locator for the application scope of MediaWiki.
This class generates message blobs for use by ResourceLoader modules.
static singleton()
Get a RepoGroup instance.
Definition RepoGroup.php:59
static doAllAndCommit( $database, array $options=[])
Do all updates and commit them.
Relational database abstraction object.
Definition Database.php:45
setFlag( $flag, $remember=self::REMEMBER_NOTHING)
Set a flag for this connection.
Definition Database.php:623
deferred txt A few of the database updates required by various functions here can be deferred until after the result page is displayed to the user For updating the view updating the linked to tables after a etc PHP does not yet have any way to tell the server to actually return and disconnect while still running these updates(as a Java servelet could)
design txt This is a brief overview of the new design More thorough and up to date information is available on the documentation wiki at etc Handles the details of getting and saving to the user table of the and dealing with sessions and cookies OutputPage Encapsulates the entire HTML page that will be sent in response to any server request It is used by calling its functions to add in any and then calling output() to send it all. It could be easily changed to send incrementally if that becomes useful
static configuration should be added through ResourceLoaderGetConfigVars instead & $vars
Definition hooks.txt:2198
null means default in associative array with keys and values unescaped Should be merged with default with a value of false meaning to suppress the attribute in associative array with keys and values unescaped noclasses just before the function returns a value If you return true
Definition hooks.txt:1976
null means default in associative array with keys and values unescaped Should be merged with default with a value of false meaning to suppress the attribute in associative array with keys and values unescaped noclasses & $ret
Definition hooks.txt:1975
this hook is for auditing only or null if authentication failed before getting that far or null if we can t even determine that probably a stub it is not rendered in wiki pages or galleries in category pages allow injecting custom HTML after the section Any uses of the hook need to handle escaping see BaseTemplate::getToolbox and BaseTemplate::makeListItem for details on the format of individual items inside of this array or by returning and letting standard HTTP rendering take place modifiable or by returning false and taking over the output $out
Definition hooks.txt:862
$wgHooks['ArticleShow'][]
Definition hooks.txt:108
Status::newGood()` to allow deletion, and then `return false` from the hook function. Ensure you consume the 'ChangeTagAfterDelete' hook to carry out custom deletion actions. $tag:name of the tag $user:user initiating the action & $status:Status object. See above. 'ChangeTagsListActive':Allows you to nominate which of the tags your extension uses are in active use. & $tags:list of all active tags. Append to this array. 'ChangeTagsAfterUpdateTags':Called after tags have been updated with the ChangeTags::updateTags function. Params:$addedTags:tags effectively added in the update $removedTags:tags effectively removed in the update $prevTags:tags that were present prior to the update $rc_id:recentchanges table id $rev_id:revision table id $log_id:logging table id $params:tag params $rc:RecentChange being tagged when the tagging accompanies the action or null $user:User who performed the tagging when the tagging is subsequent to the action or null 'ChangeTagsAllowedAdd':Called when checking if a user can add tags to a change. & $allowedTags:List of all the tags the user is allowed to add. Any tags the user wants to add( $addTags) that are not in this array will cause it to fail. You may add or remove tags to this array as required. $addTags:List of tags user intends to add. $user:User who is adding the tags. 'ChangeUserGroups':Called before user groups are changed. $performer:The User who will perform the change $user:The User whose groups will be changed & $add:The groups that will be added & $remove:The groups that will be removed 'Collation::factory':Called if $wgCategoryCollation is an unknown collation. $collationName:Name of the collation in question & $collationObject:Null. Replace with a subclass of the Collation class that implements the collation given in $collationName. 'ConfirmEmailComplete':Called after a user 's email has been confirmed successfully. $user:user(object) whose email is being confirmed 'ContentAlterParserOutput':Modify parser output for a given content object. Called by Content::getParserOutput after parsing has finished. Can be used for changes that depend on the result of the parsing but have to be done before LinksUpdate is called(such as adding tracking categories based on the rendered HTML). $content:The Content to render $title:Title of the page, as context $parserOutput:ParserOutput to manipulate 'ContentGetParserOutput':Customize parser output for a given content object, called by AbstractContent::getParserOutput. May be used to override the normal model-specific rendering of page content. $content:The Content to render $title:Title of the page, as context $revId:The revision ID, as context $options:ParserOptions for rendering. To avoid confusing the parser cache, the output can only depend on parameters provided to this hook function, not on global state. $generateHtml:boolean, indicating whether full HTML should be generated. If false, generation of HTML may be skipped, but other information should still be present in the ParserOutput object. & $output:ParserOutput, to manipulate or replace 'ContentHandlerDefaultModelFor':Called when the default content model is determined for a given title. May be used to assign a different model for that title. $title:the Title in question & $model:the model name. Use with CONTENT_MODEL_XXX constants. 'ContentHandlerForModelID':Called when a ContentHandler is requested for a given content model name, but no entry for that model exists in $wgContentHandlers. Note:if your extension implements additional models via this hook, please use GetContentModels hook to make them known to core. $modeName:the requested content model name & $handler:set this to a ContentHandler object, if desired. 'ContentModelCanBeUsedOn':Called to determine whether that content model can be used on a given page. This is especially useful to prevent some content models to be used in some special location. $contentModel:ID of the content model in question $title:the Title in question. & $ok:Output parameter, whether it is OK to use $contentModel on $title. Handler functions that modify $ok should generally return false to prevent further hooks from further modifying $ok. 'ContribsPager::getQueryInfo':Before the contributions query is about to run & $pager:Pager object for contributions & $queryInfo:The query for the contribs Pager 'ContribsPager::reallyDoQuery':Called before really executing the query for My Contributions & $data:an array of results of all contribs queries $pager:The ContribsPager object hooked into $offset:Index offset, inclusive $limit:Exact query limit $descending:Query direction, false for ascending, true for descending 'ContributionsLineEnding':Called before a contributions HTML line is finished $page:SpecialPage object for contributions & $ret:the HTML line $row:the DB row for this line & $classes:the classes to add to the surrounding< li > & $attribs:associative array of other HTML attributes for the< li > element. Currently only data attributes reserved to MediaWiki are allowed(see Sanitizer::isReservedDataAttribute). 'ContributionsToolLinks':Change tool links above Special:Contributions $id:User identifier $title:User page title & $tools:Array of tool links $specialPage:SpecialPage instance for context and services. Can be either SpecialContributions or DeletedContributionsPage. Extensions should type hint against a generic SpecialPage though. 'ConvertContent':Called by AbstractContent::convert when a conversion to another content model is requested. Handler functions that modify $result should generally return false to disable further attempts at conversion. $content:The Content object to be converted. $toModel:The ID of the content model to convert to. $lossy: boolean indicating whether lossy conversion is allowed. & $result:Output parameter, in case the handler function wants to provide a converted Content object. Note that $result->getContentModel() must return $toModel. 'CustomEditor':When invoking the page editor Return true to allow the normal editor to be used, or false if implementing a custom editor, e.g. for a special namespace, etc. $article:Article being edited $user:User performing the edit 'DatabaseOraclePostInit':Called after initialising an Oracle database $db:the DatabaseOracle object 'DeletedContribsPager::reallyDoQuery':Called before really executing the query for Special:DeletedContributions Similar to ContribsPager::reallyDoQuery & $data:an array of results of all contribs queries $pager:The DeletedContribsPager object hooked into $offset:Index offset, inclusive $limit:Exact query limit $descending:Query direction, false for ascending, true for descending 'DeletedContributionsLineEnding':Called before a DeletedContributions HTML line is finished. Similar to ContributionsLineEnding $page:SpecialPage object for DeletedContributions & $ret:the HTML line $row:the DB row for this line & $classes:the classes to add to the surrounding< li > & $attribs:associative array of other HTML attributes for the< li > element. Currently only data attributes reserved to MediaWiki are allowed(see Sanitizer::isReservedDataAttribute). 'DifferenceEngineAfterLoadNewText':called in DifferenceEngine::loadNewText() after the new revision 's content has been loaded into the class member variable $differenceEngine->mNewContent but before returning true from this function. $differenceEngine:DifferenceEngine object 'DifferenceEngineLoadTextAfterNewContentIsLoaded':called in DifferenceEngine::loadText() after the new revision 's content has been loaded into the class member variable $differenceEngine->mNewContent but before checking if the variable 's value is null. This hook can be used to inject content into said class member variable. $differenceEngine:DifferenceEngine object 'DifferenceEngineMarkPatrolledLink':Allows extensions to change the "mark as patrolled" link which is shown both on the diff header as well as on the bottom of a page, usually wrapped in a span element which has class="patrollink". $differenceEngine:DifferenceEngine object & $markAsPatrolledLink:The "mark as patrolled" link HTML(string) $rcid:Recent change ID(rc_id) for this change(int) 'DifferenceEngineMarkPatrolledRCID':Allows extensions to possibly change the rcid parameter. For example the rcid might be set to zero due to the user being the same as the performer of the change but an extension might still want to show it under certain conditions. & $rcid:rc_id(int) of the change or 0 $differenceEngine:DifferenceEngine object $change:RecentChange object $user:User object representing the current user 'DifferenceEngineNewHeader':Allows extensions to change the $newHeader variable, which contains information about the new revision, such as the revision 's author, whether the revision was marked as a minor edit or not, etc. $differenceEngine:DifferenceEngine object & $newHeader:The string containing the various #mw-diff-otitle[1-5] divs, which include things like revision author info, revision comment, RevisionDelete link and more $formattedRevisionTools:Array containing revision tools, some of which may have been injected with the DiffRevisionTools hook $nextlink:String containing the link to the next revision(if any) $status
Definition hooks.txt:1049
$IP
Definition update.php:3
const MIGRATION_WRITE_NEW
Definition Defines.php:295
Basic database interface for live and lazy-loaded relation database handles.
Definition IDatabase.php:40
getType()
Get the type of the DBMS, as it appears in $wgDBtype.
const DBO_DDLMODE
Definition defines.php:16
$params