MediaWiki  1.28.0
MysqlUpdater Class Reference

Mysql update list and mysql-specific update functions. More...

Inheritance diagram for MysqlUpdater:
Collaboration diagram for MysqlUpdater:

Public Member Functions

 doSchemaRestructuring ()
 
 doWatchlistUpdate ()
 Check if we need to add talk page rows to the watchlist. More...
 
 getSchemaVars ()
 
- Public Member Functions inherited from DatabaseUpdater
 addExtensionField ($tableName, $columnName, $sqlPath)
 
 addExtensionIndex ($tableName, $indexName, $sqlPath)
 
 addExtensionTable ($tableName, $sqlPath)
 Convenience wrapper for addExtensionUpdate() when adding a new table (which is the most common usage of updaters in an extension) More...
 
 addExtensionUpdate (array $update)
 Add a new update coming from an extension. More...
 
 addPostDatabaseUpdateMaintenance ($class)
 Add a maintenance script to be run after the database updates are complete. More...
 
 appendLine ($line)
 Append a line to the open filehandle. More...
 
 copyFile ($filename)
 Append an SQL fragment to the open file handle. More...
 
 doUpdates ($what=[ 'core', 'extensions', 'stats'])
 Do all the updates. More...
 
 dropExtensionField ($tableName, $columnName, $sqlPath)
 
 dropExtensionIndex ($tableName, $indexName, $sqlPath)
 Drop an index from an extension table. More...
 
 dropExtensionTable ($tableName, $sqlPath)
 
 dropTable ($table, $patch=false, $fullpath=false)
 If the specified table exists, drop it, or execute the patch if one is provided. More...
 
 getDB ()
 Get a database connection to run updates. More...
 
 getPostDatabaseUpdateMaintenance ()
 
 getSchemaVars ()
 Get appropriate schema variables in the current database connection. More...
 
 insertUpdateRow ($key, $val=null)
 Helper function: Add a key to the updatelog table Obviously, only use this for updates that occur after the updatelog table was created! More...
 
 modifyExtensionField ($tableName, $fieldName, $sqlPath)
 
 modifyField ($table, $field, $patch, $fullpath=false)
 Modify an existing field. More...
 
 output ($str)
 Output some text. More...
 
 patchPath (IDatabase $db, $patch)
 Get the full path of a patch file. More...
 
 purgeCache ()
 Purge the objectcache table. More...
 
 renameExtensionIndex ($tableName, $oldIndexName, $newIndexName, $sqlPath, $skipBothIndexExistWarning=false)
 Rename an index on an extension table. More...
 
 setFileAccess ()
 Set any .htaccess files or equivilent for storage repos. More...
 
 tableExists ($tableName)
 
 updateRowExists ($key)
 Helper function: check if the given key is present in the updatelog table. More...
 

Protected Member Functions

 checkBin ($table, $field, $patchFile)
 1.4 betas were missing the 'binary' marker from logging.log_title, which causes a collation mismatch error on joins in MySQL 4.1. More...
 
 doBacklinkingIndicesUpdate ()
 
 doCategorylinksIndicesUpdate ()
 
 doCategoryPopulation ()
 
 doClFieldsUpdate ()
 
 doFilearchiveIndicesUpdate ()
 
 doFixAncientImagelinks ()
 
 doIndexUpdate ()
 Check that proper indexes are in place. More...
 
 doInterwikiUpdate ()
 Check that interwiki table exists; if it doesn't source it. More...
 
 doIwlinksIndexNonUnique ()
 
 doLangLinksLengthUpdate ()
 
 doMaybeProfilingMemoryUpdate ()
 
 doNamespaceSize ()
 
 doNonUniquePlTlIl ()
 
 doOldLinksUpdate ()
 
 doPagelinksUpdate ()
 
 doPageRandomUpdate ()
 Set page_random field to a random value where it is equals to 0. More...
 
 doPopulateParentId ()
 
 doRestrictionsUpdate ()
 Adding page_restrictions table, obsoleting page.page_restrictions. More...
 
 doRevisionPageRevIndexNonUnique ()
 
 doTemplatelinksUpdate ()
 
 doUpdateMimeMinorField ()
 
 doUserGroupsUpdate ()
 
 doUserNewTalkTimestampNotNull ()
 
 doUserNewTalkUseridUnsigned ()
 
 doUserUniqueUpdate ()
 
 doWatchlistNull ()
 Make sure wl_notificationtimestamp can be NULL, and update old broken items. More...
 
 getCoreUpdateList ()
 
 indexHasField ($table, $index, $field)
 Check whether an index contain a field. More...
 
- Protected Member Functions inherited from DatabaseUpdater
 __construct (Database &$db, $shared, Maintenance $maintenance=null)
 Constructor. More...
 
 addField ($table, $field, $patch, $fullpath=false)
 Add a new field to an existing table. More...
 
 addIndex ($table, $index, $patch, $fullpath=false)
 Add a new index to an existing table. More...
 
 addTable ($name, $patch, $fullpath=false)
 Add a new table to the database. More...
 
 applyPatch ($path, $isFullPath=false, $msg=null)
 Applies a SQL patch. More...
 
 canUseNewUpdatelog ()
 Updatelog was changed in 1.17 to have a ul_value column so we can record more information about what kind of updates we've done (that's what this class does). More...
 
 checkStats ()
 Check the site_stats table is not properly populated. More...
 
 disableContentHandlerUseDB ()
 Turns off content handler fields during parts of the upgrade where they aren't available. More...
 
 doActiveUsersInit ()
 Sets the number of active users in the site_stats table. More...
 
 doCollationUpdate ()
 Update CategoryLinks collation. More...
 
 doEnableProfiling ()
 Enable profiling table when it's turned on. More...
 
 doLogSearchPopulation ()
 Migrate log params to new table and index for searching. More...
 
 doLogUsertextPopulation ()
 Populates the log_user_text field in the logging table. More...
 
 doMigrateUserOptions ()
 Migrates user options from the user table blob to user_properties. More...
 
 doTable ($name)
 Returns whether updates should be executed on the database table $name. More...
 
 doUpdateTranscacheField ()
 Updates the timestamps in the transcache table. More...
 
 dropField ($table, $field, $patch, $fullpath=false)
 Drop a field from an existing table. More...
 
 dropIndex ($table, $index, $patch, $fullpath=false)
 Drop an index from an existing table. More...
 
 enableContentHandlerUseDB ()
 Turns content handler fields back on. More...
 
 getCoreUpdateList ()
 Get an array of updates to perform on the database. More...
 
 getExtensionUpdates ()
 Get the list of extension-defined updates. More...
 
 getOldGlobalUpdates ()
 Before 1.17, we used to handle updates via stuff like $wgExtNewTables/Fields/Indexes. More...
 
 rebuildLocalisationCache ()
 Rebuilds the localisation cache. More...
 
 renameIndex ($table, $oldIndex, $newIndex, $skipBothIndexExistWarning, $patch, $fullpath=false)
 Rename an index from an existing table. More...
 
 setAppliedUpdates ($version, $updates=[])
 

Additional Inherited Members

- Static Public Member Functions inherited from DatabaseUpdater
static newForDB (Database $db, $shared=false, $maintenance=null)
 
- Protected Attributes inherited from DatabaseUpdater
Database $db
 Handle to the database subclass. More...
 
array $extensionUpdates = []
 List of extension-provided database updates. More...
 
resource $fileHandle = null
 File handle for SQL output. More...
 
 $holdContentHandlerUseDB = true
 Hold the value of $wgContentHandlerUseDB during the upgrade. More...
 
string[] $postDatabaseUpdateMaintenance
 Scripts to run after database update Should be a subclass of LoggedUpdateMaintenance. More...
 
 $shared = false
 
bool $skipSchema = false
 Flag specifying whether or not to skip schema (e.g. More...
 
array $updates = []
 Array of updates to perform on the database. More...
 
array $updatesSkipped = []
 Array of updates that were skipped. More...
 
- Static Protected Attributes inherited from DatabaseUpdater
static $updateCounter = 0
 

Detailed Description

Mysql update list and mysql-specific update functions.

Since
1.17

Definition at line 30 of file MysqlUpdater.php.

Member Function Documentation

MysqlUpdater::checkBin (   $table,
  $field,
  $patchFile 
)
protected

1.4 betas were missing the 'binary' marker from logging.log_title, which causes a collation mismatch error on joins in MySQL 4.1.

Parameters
string$tableTable name
string$fieldField name to check
string$patchFilePath to the patch to correct the field
Returns
bool

Definition at line 306 of file MysqlUpdater.php.

References DatabaseUpdater\applyPatch(), DatabaseUpdater\doTable(), and DatabaseUpdater\output().

MysqlUpdater::doBacklinkingIndicesUpdate ( )
protected

Definition at line 877 of file MysqlUpdater.php.

References DatabaseUpdater\applyPatch(), and indexHasField().

MysqlUpdater::doCategorylinksIndicesUpdate ( )
protected

Definition at line 915 of file MysqlUpdater.php.

References DatabaseUpdater\applyPatch(), and indexHasField().

MysqlUpdater::doCategoryPopulation ( )
protected
MysqlUpdater::doClFieldsUpdate ( )
protected
MysqlUpdater::doFilearchiveIndicesUpdate ( )
protected

Definition at line 971 of file MysqlUpdater.php.

References DatabaseUpdater\applyPatch().

MysqlUpdater::doFixAncientImagelinks ( )
protected

Definition at line 394 of file MysqlUpdater.php.

References DatabaseUpdater\applyPatch(), and DatabaseUpdater\output().

MysqlUpdater::doIndexUpdate ( )
protected

Check that proper indexes are in place.

Definition at line 375 of file MysqlUpdater.php.

References DatabaseUpdater\applyPatch(), and DatabaseUpdater\output().

MysqlUpdater::doInterwikiUpdate ( )
protected

Check that interwiki table exists; if it doesn't source it.

Definition at line 351 of file MysqlUpdater.php.

References $IP, DatabaseUpdater\applyPatch(), DatabaseUpdater\doTable(), global, and DatabaseUpdater\output().

MysqlUpdater::doIwlinksIndexNonUnique ( )
protected

Definition at line 1067 of file MysqlUpdater.php.

References DatabaseUpdater\applyPatch(), and DatabaseUpdater\output().

MysqlUpdater::doLangLinksLengthUpdate ( )
protected

Definition at line 1029 of file MysqlUpdater.php.

References $res, DatabaseUpdater\applyPatch(), and DatabaseUpdater\output().

MysqlUpdater::doMaybeProfilingMemoryUpdate ( )
protected
MysqlUpdater::doNamespaceSize ( )
protected

Definition at line 646 of file MysqlUpdater.php.

References $tables, as, and DatabaseUpdater\output().

MysqlUpdater::doNonUniquePlTlIl ( )
protected

Definition at line 980 of file MysqlUpdater.php.

References DatabaseUpdater\applyPatch(), and DatabaseUpdater\output().

MysqlUpdater::doOldLinksUpdate ( )
protected

Definition at line 389 of file MysqlUpdater.php.

MysqlUpdater::doPagelinksUpdate ( )
protected
MysqlUpdater::doPageRandomUpdate ( )
protected

Set page_random field to a random value where it is equals to 0.

See also
bug 3946

Definition at line 821 of file MysqlUpdater.php.

References $page, and DatabaseUpdater\output().

MysqlUpdater::doPopulateParentId ( )
protected
MysqlUpdater::doRestrictionsUpdate ( )
protected

Adding page_restrictions table, obsoleting page.page_restrictions.

Migrating old restrictions to new table – Andrew Garrett, January 2007.

Definition at line 891 of file MysqlUpdater.php.

References DatabaseUpdater\applyPatch(), and DatabaseUpdater\output().

MysqlUpdater::doRevisionPageRevIndexNonUnique ( )
protected
MysqlUpdater::doSchemaRestructuring ( )
MysqlUpdater::doTemplatelinksUpdate ( )
protected
MysqlUpdater::doUpdateMimeMinorField ( )
protected
MysqlUpdater::doUserGroupsUpdate ( )
protected
MysqlUpdater::doUserNewTalkTimestampNotNull ( )
protected
MysqlUpdater::doUserNewTalkUseridUnsigned ( )
protected
MysqlUpdater::doUserUniqueUpdate ( )
protected
MysqlUpdater::doWatchlistNull ( )
protected

Make sure wl_notificationtimestamp can be NULL, and update old broken items.

Definition at line 798 of file MysqlUpdater.php.

References DatabaseUpdater\applyPatch(), and DatabaseUpdater\output().

MysqlUpdater::doWatchlistUpdate ( )

Check if we need to add talk page rows to the watchlist.

Definition at line 416 of file MysqlUpdater.php.

References DatabaseUpdater\output().

MysqlUpdater::getCoreUpdateList ( )
protected

Definition at line 31 of file MysqlUpdater.php.

MysqlUpdater::getSchemaVars ( )

Definition at line 1129 of file MysqlUpdater.php.

References $vars, $wgDBTableOptions, and global.

MysqlUpdater::indexHasField (   $table,
  $index,
  $field 
)
protected

Check whether an index contain a field.

Parameters
string$tableTable name
string$indexIndex name to check
string$fieldField that should be in the index
Returns
bool

Definition at line 328 of file MysqlUpdater.php.

References as, DatabaseUpdater\doTable(), and DatabaseUpdater\output().

Referenced by doBacklinkingIndicesUpdate(), and doCategorylinksIndicesUpdate().


The documentation for this class was generated from the following file: