DatabaseUpdater Class Reference

Class for handling database updates. More...

Inheritance diagram for DatabaseUpdater:

Collaboration diagram for DatabaseUpdater:

Public Member Functions
	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)
	addExtensionUpdate (array $update)
	Add a new update coming from an extension.
	addPostDatabaseUpdateMaintenance ( $class)
	Add a maintenance script to be run after the database updates are complete.
	appendLine ( $line)
	Append a line to the open filehandle.
	copyFile ( $filename)
	Append an SQL fragment to the open file handle.
	doUpdates (array $what=[ 'core', 'extensions', 'stats'])
	Do all the updates.
	dropExtensionField ( $tableName, $columnName, $sqlPath)
	dropExtensionIndex ( $tableName, $indexName, $sqlPath)
	Drop an index from an extension table.
	dropExtensionTable ( $tableName, $sqlPath)
	dropTable ( $table, $patch=false, $fullpath=false)
	If the specified table exists, drop it, or execute the patch if one is provided.
	getDB ()
	Get a database connection to run updates.
	getPostDatabaseUpdateMaintenance ()
	getSchemaVars ()
	Get appropriate schema variables in the current database connection.
	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!
	modifyExtensionField ( $tableName, $fieldName, $sqlPath)
	modifyExtensionTable ( $tableName, $sqlPath)
	modifyField ( $table, $field, $patch, $fullpath=false)
	Modify an existing field.
	modifyTable ( $table, $patch, $fullpath=false)
	Modify an existing table, similar to modifyField.
	output ( $str)
	Output some text.
	patchPath (IDatabase $db, $patch)
	Get the full path of a patch file.
	purgeCache ()
	Purge various database caches.
	renameExtensionIndex ( $tableName, $oldIndexName, $newIndexName, $sqlPath, $skipBothIndexExistWarning=false)
	Rename an index on an extension table.
	runMaintenance ( $class, $script)
	Run a maintenance script.
	setFileAccess ()
	Set any .htaccess files or equivilent for storage repos.
	tableExists ( $tableName)
	updateRowExists ( $key)
	Helper function: check if the given key is present in the updatelog table.

Static Public Member Functions
static	newForDB (IMaintainableDatabase $db, $shared=false, Maintenance $maintenance=null)

Public Attributes
const	REPLICATION_WAIT_TIMEOUT = 300

Protected Member Functions
	__construct (IMaintainableDatabase &$db, $shared, Maintenance $maintenance=null)
	addField ( $table, $field, $patch, $fullpath=false)
	Add a new field to an existing table.
	addIndex ( $table, $index, $patch, $fullpath=false)
	Add a new index to an existing table.
	addIndexIfNoneExist ( $table, $indexes, $patch, $fullpath=false)
	Add a new index to an existing table if none of the given indexes exist.
	addTable ( $name, $patch, $fullpath=false)
	Add a new table to the database.
	applyPatch ( $path, $isFullPath=false, $msg=null)
	Applies a SQL patch.
	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).
	checkStats ()
	Check the site_stats table is not properly populated.
	disableContentHandlerUseDB ()
	Turns off content handler fields during parts of the upgrade where they aren't available.
	doActiveUsersInit ()
	Sets the number of active users in the site_stats table.
	doCollationUpdate ()
	Update CategoryLinks collation.
	doEnableProfiling ()
	Enable profiling table when it's turned on.
	doLogSearchPopulation ()
	Migrate log params to new table and index for searching.
	doLogUsertextPopulation ()
	Populates the log_user_text field in the logging table.
	doMigrateUserOptions ()
	Migrates user options from the user table blob to user_properties.
	doTable ( $name)
	Returns whether updates should be executed on the database table $name.
	dropField ( $table, $field, $patch, $fullpath=false)
	Drop a field from an existing table.
	dropIndex ( $table, $index, $patch, $fullpath=false)
	Drop an index from an existing table.
	enableContentHandlerUseDB ()
	Turns content handler fields back on.
	getCoreUpdateList ()
	Get an array of updates to perform on the database.
	getExtensionUpdates ()
	Get the list of extension-defined updates.
	getOldGlobalUpdates ()
	Before 1.17, we used to handle updates via stuff like $wgExtNewTables/Fields/Indexes.
	ifNoActorTable ( $func,... $params)
	Only run a function if the actor table does not exist.
	migrateActors ()
	Migrate actors to the new 'actor' table.
	migrateArchiveText ()
	Migrate ar_text to modern storage.
	migrateComments ()
	Migrate comments to the new 'comment' table.
	migrateImageCommentTemp ()
	Merge image_comment_temp into the image table.
	populateArchiveRevId ()
	Populate ar_rev_id, then make it not nullable.
	populateContentTables ()
	Populates the MCR content tables.
	populateExternallinksIndex60 ()
	Populates the externallinks.el_index_60 field.
	rebuildLocalisationCache ()
	Rebuilds the localisation cache.
	renameIndex ( $table, $oldIndex, $newIndex, $skipBothIndexExistWarning, $patch, $fullpath=false)
	Rename an index from an existing table.

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

Private Member Functions
	initOldGlobals ()
	Initialize all of the old globals.
	loadExtensions ()
	Loads LocalSettings.php, if needed, and initialises everything needed for LoadExtensionSchemaUpdates hook.
	runUpdates (array $updates, $passSelf)
	Helper function for doUpdates()
	writeSchemaUpdateFile (array $schemaUpdate=[])

Detailed Description

Class for handling database updates.

Roughly based off of updaters.inc, with a few improvements :)

Since

1.17

Definition at line 36 of file DatabaseUpdater.php.

Constructor & Destructor Documentation

__construct()

DatabaseUpdater::__construct ( IMaintainableDatabase & $db, $shared, Maintenance $maintenance = null )

protected

Parameters

IMaintainableDatabase	&$db	To perform updates on
bool	$shared	Whether to perform updates on shared tables
Maintenance | null	$maintenance	Maintenance object which created us

Definition at line 117 of file DatabaseUpdater.php.

References $maintenance, $shared, DBO_DDLMODE, initOldGlobals(), loadExtensions(), Maintenance\setDB(), and Wikimedia\Rdbms\IDatabase\setFlag().

Member Function Documentation

addExtensionField()

DatabaseUpdater::addExtensionField	(		$tableName,
			$columnName,
			$sqlPath )

Since

1.19

Parameters

string	$tableName
string	$columnName
string	$sqlPath

Definition at line 281 of file DatabaseUpdater.php.

References true.

addExtensionIndex()

DatabaseUpdater::addExtensionIndex	(		$tableName,
			$indexName,
			$sqlPath )

Since

1.19

Parameters

string	$tableName
string	$indexName
string	$sqlPath

Definition at line 269 of file DatabaseUpdater.php.

References true.

addExtensionTable()

DatabaseUpdater::addExtensionTable	(		$tableName,
			$sqlPath )

Convenience wrapper for addExtensionUpdate() when adding a new table (which is the most common usage of updaters in an extension)

Since

1.18

Parameters

string	$tableName	Name of table to create
string	$sqlPath	Full path to the schema file

Definition at line 258 of file DatabaseUpdater.php.

References true.

addExtensionUpdate()

DatabaseUpdater::addExtensionUpdate

(

array

$update

)

Add a new update coming from an extension.

This should be called by extensions while executing the LoadExtensionSchemaUpdates hook.

Since

1.17

Parameters

array

$update

The update to run. Format is [ $callback, $params... ] $callback is the method to call; either a DatabaseUpdater method name or a callable. Must be serializable (ie. no anonymous functions allowed). The rest of the parameters (if any) will be passed to the callback. The first parameter passed to the callback is always this object.

Definition at line 245 of file DatabaseUpdater.php.

addField()

DatabaseUpdater::addField ( $table, $field, $patch, $fullpath = false )

protected

Add a new field to an existing table.

Parameters

string	$table	Name of the table to modify
string	$field	Name of the new field
string	$patch	Path to the patch file
bool	$fullpath	Whether to treat $patch path as a relative or not

Returns

bool False if this was skipped because schema changes are skipped

Definition at line 749 of file DatabaseUpdater.php.

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

addIndex()

DatabaseUpdater::addIndex ( $table, $index, $patch, $fullpath = false )

protected

Add a new index to an existing table.

Parameters

string	$table	Name of the table to modify
string	$index	Name of the new index
string	$patch	Path to the patch file
bool	$fullpath	Whether to treat $patch path as a relative or not

Returns

bool False if this was skipped because schema changes are skipped

Definition at line 774 of file DatabaseUpdater.php.

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

addIndexIfNoneExist()

DatabaseUpdater::addIndexIfNoneExist ( $table, $indexes, $patch, $fullpath = false )

protected

Add a new index to an existing table if none of the given indexes exist.

Parameters

string	$table	Name of the table to modify
string[]	$indexes	Name of the indexes to check. $indexes[0] should be the one actually being added.
string	$patch	Path to the patch file
bool	$fullpath	Whether to treat $patch path as a relative or not

Returns

bool False if this was skipped because schema changes are skipped

Definition at line 800 of file DatabaseUpdater.php.

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

addPostDatabaseUpdateMaintenance()

DatabaseUpdater::addPostDatabaseUpdateMaintenance

(

$class

)

Add a maintenance script to be run after the database updates are complete.

Script should subclass LoggedUpdateMaintenance

Since

1.19

Parameters

string

$class

Name of a Maintenance subclass

Definition at line 388 of file DatabaseUpdater.php.

addTable()

DatabaseUpdater::addTable ( $name, $patch, $fullpath = false )

protected

Add a new table to the database.

Parameters

string	$name	Name of the new table
string	$patch	Path to the patch file
bool	$fullpath	Whether to treat $patch path as a relative or not

Returns

bool False if this was skipped because schema changes are skipped

Definition at line 726 of file DatabaseUpdater.php.

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

appendLine()

DatabaseUpdater::appendLine

(

$line

)

Append a line to the open filehandle.

The line is assumed to be a complete SQL statement.

This is used as a callback for sourceLine().

Parameters

string

$line

Text to append to the file

Returns

bool False to skip actually executing the file

Exceptions

MWException

Definition at line 656 of file DatabaseUpdater.php.

References $line.

applyPatch()

DatabaseUpdater::applyPatch ( $path, $isFullPath = false, $msg = null )

protected

Applies a SQL patch.

Parameters

string	$path	Path to the patch file
bool	$isFullPath	Whether to treat $path as a relative or not
string | null	$msg	Description of the patch

Returns

bool False if patch is skipped.

Definition at line 673 of file DatabaseUpdater.php.

References $path, copyFile(), output(), and patchPath().

Referenced by addField(), addIndex(), addIndexIfNoneExist(), PostgresUpdater\addInterwikiType(), PostgresUpdater\addPgExtIndex(), addTable(), MysqlUpdater\checkBin(), PostgresUpdater\checkIwlPrefix(), PostgresUpdater\checkPageDeletedTrigger(), PostgresUpdater\checkRevUserFkey(), PostgresUpdater\convertArchive2(), MysqlUpdater\doBacklinkingIndicesUpdate(), MysqlUpdater\doCategorylinksIndicesUpdate(), MysqlUpdater\doClFieldsUpdate(), doEnableProfiling(), MysqlUpdater\doExtendCommentLengths(), MysqlUpdater\doFilearchiveIndicesUpdate(), MysqlUpdater\doFixAncientImagelinks(), MysqlUpdater\doIndexUpdate(), MysqlUpdater\doInterwikiUpdate(), MysqlUpdater\doIwlinksIndexNonUnique(), MysqlUpdater\doLangLinksLengthUpdate(), MysqlUpdater\doMaybeProfilingMemoryUpdate(), MysqlUpdater\doNonUniquePlTlIl(), MysqlUpdater\doPagelinksUpdate(), MysqlUpdater\doRestrictionsUpdate(), MysqlUpdater\doRevisionPageRevIndexNonUnique(), MysqlUpdater\doTemplatelinksUpdate(), MysqlUpdater\doUnsignedSyncronisation(), MysqlUpdater\doUpdateMimeMinorField(), MysqlUpdater\doUserGroupsUpdate(), MysqlUpdater\doUserNewTalkTimestampNotNull(), MysqlUpdater\doUserUniqueUpdate(), MysqlUpdater\doWatchlistNull(), dropField(), dropIndex(), dropTable(), migrateArchiveText(), modifyField(), modifyTable(), populateArchiveRevId(), PostgresUpdater\rebuildTextSearch(), renameIndex(), PostgresUpdater\renameTable(), SqliteUpdater\sqliteInitialIndexes(), SqliteUpdater\sqliteSetupSearchindex(), and PostgresUpdater\tsearchFixes().

canUseNewUpdatelog()

DatabaseUpdater::canUseNewUpdatelog ( )

protected

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).

Pre-1.17 wikis won't have this column, and really old wikis might not even have updatelog at all

Returns

bool

Definition at line 547 of file DatabaseUpdater.php.

Referenced by insertUpdateRow().

checkStats()

DatabaseUpdater::checkStats ( )

protected

Check the site_stats table is not properly populated.

Definition at line 1097 of file DatabaseUpdater.php.

References SiteStatsInit\doAllAndCommit(), and output().

Referenced by doUpdates().

copyFile()

DatabaseUpdater::copyFile

(

$filename

)

Append an SQL fragment to the open file handle.

Parameters

string

$filename

File name to open

Definition at line 636 of file DatabaseUpdater.php.

Referenced by applyPatch().

disableContentHandlerUseDB()

DatabaseUpdater::disableContentHandlerUseDB ( )

protected

Turns off content handler fields during parts of the upgrade where they aren't available.

Definition at line 1247 of file DatabaseUpdater.php.

References $wgContentHandlerUseDB, and output().

doActiveUsersInit()

DatabaseUpdater::doActiveUsersInit ( )

protected

Sets the number of active users in the site_stats table.

Definition at line 1117 of file DatabaseUpdater.php.

References output().

doCollationUpdate()

DatabaseUpdater::doCollationUpdate ( )

protected

Update CategoryLinks collation.

Definition at line 1168 of file DatabaseUpdater.php.

References $wgCategoryCollation, and output().

doEnableProfiling()

DatabaseUpdater::doEnableProfiling ( )

protected

Enable profiling table when it's turned on.

Definition at line 1204 of file DatabaseUpdater.php.

References $wgProfiler, applyPatch(), and doTable().

doLogSearchPopulation()

DatabaseUpdater::doLogSearchPopulation ( )

protected

Migrate log params to new table and index for searching.

Definition at line 1152 of file DatabaseUpdater.php.

References output(), and updateRowExists().

doLogUsertextPopulation()

DatabaseUpdater::doLogUsertextPopulation ( )

protected

Populates the log_user_text field in the logging table.

Definition at line 1135 of file DatabaseUpdater.php.

References output(), and updateRowExists().

doMigrateUserOptions()

DatabaseUpdater::doMigrateUserOptions ( )

protected

Migrates user options from the user table blob to user_properties.

Definition at line 1193 of file DatabaseUpdater.php.

References output().

doTable()

DatabaseUpdater::doTable ( $name )

protected

Returns whether updates should be executed on the database table $name.

Updates will be prevented if the table is a shared table and it is not specified to run updates on shared tables.

Parameters

string

$name

Table name

Returns

bool

Definition at line 560 of file DatabaseUpdater.php.

References $wgSharedDB, $wgSharedTables, and output().

Referenced by addField(), addIndex(), addIndexIfNoneExist(), addTable(), MysqlUpdater\checkBin(), doEnableProfiling(), MysqlUpdater\doInterwikiUpdate(), MysqlUpdater\doMaybeProfilingMemoryUpdate(), MysqlUpdater\doRevisionPageRevIndexNonUnique(), MysqlUpdater\doUnsignedSyncronisation(), MysqlUpdater\doUserGroupsUpdate(), MysqlUpdater\doUserNewTalkTimestampNotNull(), MysqlUpdater\doUserUniqueUpdate(), dropField(), dropIndex(), dropTable(), MysqlUpdater\indexHasField(), modifyField(), modifyTable(), and renameIndex().

doUpdates()

DatabaseUpdater::doUpdates

(

array

$what = [ 'core', 'extensions', 'stats' ]

)

Do all the updates.

Parameters

array

$what

What updates to perform

Definition at line 448 of file DatabaseUpdater.php.

References checkStats(), getCoreUpdateList(), getExtensionUpdates(), getOldGlobalUpdates(), getSchemaVars(), runUpdates(), and writeSchemaUpdateFile().

dropExtensionField()

DatabaseUpdater::dropExtensionField	(		$tableName,
			$columnName,
			$sqlPath )

Since

1.20

Parameters

string	$tableName
string	$columnName
string	$sqlPath

Definition at line 293 of file DatabaseUpdater.php.

References true.

dropExtensionIndex()

DatabaseUpdater::dropExtensionIndex	(		$tableName,
			$indexName,
			$sqlPath )

Drop an index from an extension table.

Since

1.21

Parameters

string	$tableName	The table name
string	$indexName	The index name
string	$sqlPath	The path to the SQL change path

Definition at line 306 of file DatabaseUpdater.php.

References true.

dropExtensionTable()

DatabaseUpdater::dropExtensionTable	(		$tableName,
			$sqlPath )

Since

1.20

Parameters

string	$tableName
string	$sqlPath

Definition at line 317 of file DatabaseUpdater.php.

References true.

dropField()

DatabaseUpdater::dropField ( $table, $field, $patch, $fullpath = false )

protected

Drop a field from an existing table.

Parameters

string	$table	Name of the table to modify
string	$field	Name of the old field
string	$patch	Path to the patch file
bool	$fullpath	Whether to treat $patch path as a relative or not

Returns

bool False if this was skipped because schema changes are skipped

Definition at line 832 of file DatabaseUpdater.php.

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

dropIndex()

DatabaseUpdater::dropIndex ( $table, $index, $patch, $fullpath = false )

protected

Drop an index from an existing table.

Parameters

string	$table	Name of the table to modify
string	$index	Name of the index
string	$patch	Path to the patch file
bool	$fullpath	Whether to treat $patch path as a relative or not

Returns

bool False if this was skipped because schema changes are skipped

Definition at line 855 of file DatabaseUpdater.php.

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

dropTable()

DatabaseUpdater::dropTable	(		$table,
			$patch = false,
			$fullpath = false )

If the specified table exists, drop it, or execute the patch if one is provided.

Public

Since

1.20

Parameters

string	$table	Table to drop.
string | bool	$patch	String of patch file that will drop the table. Default: false.
bool	$fullpath	Whether $patch is a full path. Default: false.

Returns

bool False if this was skipped because schema changes are skipped

Definition at line 935 of file DatabaseUpdater.php.

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

Referenced by migrateImageCommentTemp().

enableContentHandlerUseDB()

DatabaseUpdater::enableContentHandlerUseDB ( )

protected

Turns content handler fields back on.

Definition at line 1260 of file DatabaseUpdater.php.

References $wgContentHandlerUseDB, and output().

getCoreUpdateList()

DatabaseUpdater::getCoreUpdateList ( )

abstractprotected

Get an array of updates to perform on the database.

Should return a multi-dimensional array. The main key is the MediaWiki version (1.12, 1.13...) with the values being arrays of updates, identical to how updaters.inc did it (for now)

Returns

array[]

Reimplemented in MysqlUpdater, PostgresUpdater, and SqliteUpdater.

Referenced by doUpdates().

getDB()

DatabaseUpdater::getDB

(

)

Get a database connection to run updates.

Returns

IMaintainableDatabase

Definition at line 211 of file DatabaseUpdater.php.

getExtensionUpdates()

DatabaseUpdater::getExtensionUpdates ( )

protected

Get the list of extension-defined updates.

Returns

array

Definition at line 397 of file DatabaseUpdater.php.

Referenced by doUpdates().

getOldGlobalUpdates()

DatabaseUpdater::getOldGlobalUpdates ( )

protected

Before 1.17, we used to handle updates via stuff like $wgExtNewTables/Fields/Indexes.

This is nasty :) We refactored a lot of this in 1.17 but we want to remain back-compatible for a while. So load up these old global-based things into our update list.

Returns

array

Reimplemented in PostgresUpdater.

Definition at line 585 of file DatabaseUpdater.php.

References true.

Referenced by doUpdates().

getPostDatabaseUpdateMaintenance()

DatabaseUpdater::getPostDatabaseUpdateMaintenance

(

)

Since

1.17

Returns

string[]

Definition at line 406 of file DatabaseUpdater.php.

getSchemaVars()

DatabaseUpdater::getSchemaVars

(

)

Get appropriate schema variables in the current database connection.

This should be called after any request data has been imported, but before any write operations to the database. The result should be passed to the DB setSchemaVars() method.

Returns

array

Since

1.28

Reimplemented in MysqlUpdater.

Definition at line 439 of file DatabaseUpdater.php.

Referenced by doUpdates().

ifNoActorTable()

DatabaseUpdater::ifNoActorTable ( $func, $params )

protected

Only run a function if the actor table does not exist.

The transition to the actor table is dropping several indexes (and a few fields) that old upgrades want to add. This function is used to prevent those from running to re-add things when the actor table exists, while still allowing them to run if this really is an upgrade from an old MW version.

Since

1.34

Parameters

string | array | static	$func	Normally this is the string naming the method on $this to call. It may also be an array callable. If passed $this, it's assumed to be a call from runUpdates() with $passSelf = true: $params[0] is assumed to be the real $func and $this is prepended to the rest of $params.
	mixed	...$params Parameters for $func

Returns

mixed Whatever $func returns, or null when skipped.

Definition at line 1419 of file DatabaseUpdater.php.

References tableExists().

initOldGlobals()

DatabaseUpdater::initOldGlobals ( )

private

Initialize all of the old globals.

One day this should all become something much nicer

Definition at line 141 of file DatabaseUpdater.php.

Referenced by __construct().

insertUpdateRow()

DatabaseUpdater::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!

Parameters

string	$key	Name of key to insert
string | null	$val	[optional] Value to insert along with the key

Definition at line 529 of file DatabaseUpdater.php.

References canUseNewUpdatelog(), and DBO_DDLMODE.

Referenced by modifyField(), modifyTable(), and populateContentTables().

loadExtensions()

DatabaseUpdater::loadExtensions ( )

private

Loads LocalSettings.php, if needed, and initialises everything needed for LoadExtensionSchemaUpdates hook.

Definition at line 159 of file DatabaseUpdater.php.

References $queue, $wgAutoloadClasses, $wgHooks, and Installer\getExistingLocalSettings().

Referenced by __construct().

migrateActors()

DatabaseUpdater::migrateActors ( )

protected

Migrate actors to the new 'actor' table.

Since

1.31

Definition at line 1310 of file DatabaseUpdater.php.

References output(), and updateRowExists().

migrateArchiveText()

DatabaseUpdater::migrateArchiveText ( )

protected

Migrate ar_text to modern storage.

Since

1.31

Definition at line 1327 of file DatabaseUpdater.php.

References applyPatch(), and output().

migrateComments()

DatabaseUpdater::migrateComments ( )

protected

Migrate comments to the new 'comment' table.

Since

1.30

Definition at line 1273 of file DatabaseUpdater.php.

References output(), and updateRowExists().

migrateImageCommentTemp()

DatabaseUpdater::migrateImageCommentTemp ( )

protected

Merge image_comment_temp into the image table.

Since

1.32

Definition at line 1290 of file DatabaseUpdater.php.

References dropTable(), output(), and tableExists().

modifyExtensionField()

DatabaseUpdater::modifyExtensionField	(		$tableName,
			$fieldName,
			$sqlPath )

Since

1.21

Parameters

string	$tableName	The table name
string	$fieldName	The field to be modified
string	$sqlPath	The path to the SQL patch

Definition at line 354 of file DatabaseUpdater.php.

References true.

modifyExtensionTable()

DatabaseUpdater::modifyExtensionTable	(		$tableName,
			$sqlPath )

Since

1.31

Parameters

string	$tableName	The table name
string	$sqlPath	The path to the SQL patch

Definition at line 364 of file DatabaseUpdater.php.

References true.

modifyField()

DatabaseUpdater::modifyField	(		$table,
			$field,
			$patch,
			$fullpath = false )

Modify an existing field.

Parameters

string	$table	Name of the table to which the field belongs
string	$field	Name of the field to modify
string	$patch	Path to the patch file
bool	$fullpath	Whether to treat $patch path as a relative or not

Returns

bool False if this was skipped because schema changes are skipped

Definition at line 966 of file DatabaseUpdater.php.

References applyPatch(), doTable(), insertUpdateRow(), output(), and updateRowExists().

modifyTable()

DatabaseUpdater::modifyTable	(		$table,
			$patch,
			$fullpath = false )

Modify an existing table, similar to modifyField.

Intended for changes that touch more than one column on a table.

Parameters

string	$table	Name of the table to modify
string	$patch	Name of the patch file to apply
string | bool	$fullpath	Whether to treat $patch path as relative or not, defaults to false

Returns

bool False if this was skipped because of schema changes being skipped

Definition at line 998 of file DatabaseUpdater.php.

References applyPatch(), doTable(), insertUpdateRow(), output(), and updateRowExists().

newForDB()

static DatabaseUpdater::newForDB ( IMaintainableDatabase $db, $shared = false, Maintenance $maintenance = null )

static

Parameters

IMaintainableDatabase	$db
bool	$shared
Maintenance | null	$maintenance

Exceptions

MWException

Returns

DatabaseUpdater

Definition at line 191 of file DatabaseUpdater.php.

References $maintenance, $shared, $type, Installer\getDBTypes(), and Wikimedia\Rdbms\IDatabase\getType().

output()

DatabaseUpdater::output

(

$str

)

Output some text.

If we're running from web, escape the text first.

Parameters

string	$str	Text to output
-taint	$str	escapes_html

Definition at line 221 of file DatabaseUpdater.php.

References $wgCommandLineMode.

Referenced by addField(), addIndex(), addIndexIfNoneExist(), PostgresUpdater\addPgEnumValue(), PostgresUpdater\addPgExtIndex(), PostgresUpdater\addPgField(), PostgresUpdater\addPgIndex(), PostgresUpdater\addSequence(), addTable(), applyPatch(), PostgresUpdater\changeField(), PostgresUpdater\changeFieldPurgeTable(), PostgresUpdater\changeFkeyDeferrable(), PostgresUpdater\changeNullableField(), MysqlUpdater\checkBin(), PostgresUpdater\checkIndex(), PostgresUpdater\checkOiDeleted(), PostgresUpdater\checkOiNameConstraint(), PostgresUpdater\checkPageDeletedTrigger(), PostgresUpdater\checkRevUserFkey(), checkStats(), PostgresUpdater\convertArchive2(), disableContentHandlerUseDB(), doActiveUsersInit(), MysqlUpdater\doCategoryPopulation(), MysqlUpdater\doClFieldsUpdate(), doCollationUpdate(), MysqlUpdater\doExtendCommentLengths(), MysqlUpdater\doFixAncientImagelinks(), MysqlUpdater\doIndexUpdate(), MysqlUpdater\doInterwikiUpdate(), MysqlUpdater\doIwlinksIndexNonUnique(), MysqlUpdater\doLangLinksLengthUpdate(), doLogSearchPopulation(), doLogUsertextPopulation(), MysqlUpdater\doMaybeProfilingMemoryUpdate(), doMigrateUserOptions(), MysqlUpdater\doNamespaceSize(), MysqlUpdater\doNonUniquePlTlIl(), MysqlUpdater\doPagelinksUpdate(), MysqlUpdater\doPageRandomUpdate(), MysqlUpdater\doPopulateParentId(), MysqlUpdater\doRestrictionsUpdate(), MysqlUpdater\doRevisionPageRevIndexNonUnique(), MysqlUpdater\doSchemaRestructuring(), doTable(), MysqlUpdater\doTemplatelinksUpdate(), MysqlUpdater\doUnsignedSyncronisation(), MysqlUpdater\doUpdateMimeMinorField(), MysqlUpdater\doUserGroupsUpdate(), MysqlUpdater\doUserNewTalkTimestampNotNull(), MysqlUpdater\doUserUniqueUpdate(), MysqlUpdater\doWatchlistNull(), MysqlUpdater\doWatchlistUpdate(), PostgresUpdater\dropDefault(), dropField(), PostgresUpdater\dropFkey(), dropIndex(), PostgresUpdater\dropPgField(), PostgresUpdater\dropPgIndex(), PostgresUpdater\dropSequence(), dropTable(), enableContentHandlerUseDB(), MysqlUpdater\indexHasField(), migrateActors(), migrateArchiveText(), migrateComments(), migrateImageCommentTemp(), modifyField(), modifyTable(), populateArchiveRevId(), populateContentTables(), populateExternallinksIndex60(), purgeCache(), rebuildLocalisationCache(), PostgresUpdater\rebuildTextSearch(), PostgresUpdater\renameIndex(), renameIndex(), PostgresUpdater\renameSequence(), PostgresUpdater\renameTable(), runMaintenance(), PostgresUpdater\setDefault(), setFileAccess(), PostgresUpdater\setSequenceOwner(), SqliteUpdater\sqliteInitialIndexes(), and SqliteUpdater\sqliteSetupSearchindex().

patchPath()

DatabaseUpdater::patchPath	(	IDatabase	$db,
			$patch )

Get the full path of a patch file.

Originally based on archive() from updaters.inc. Keep in mind this always returns a patch, as it fails back to MySQL if no DB-specific patch can be found

Parameters

IDatabase	$db
string	$patch	The name of the patch, like patch-something.sql

Returns

string Full path to patch file

Definition at line 707 of file DatabaseUpdater.php.

References $IP, and Wikimedia\Rdbms\IDatabase\getType().

Referenced by applyPatch().

populateArchiveRevId()

DatabaseUpdater::populateArchiveRevId ( )

protected

Populate ar_rev_id, then make it not nullable.

Since

1.31

Definition at line 1344 of file DatabaseUpdater.php.

References applyPatch(), and output().

populateContentTables()

DatabaseUpdater::populateContentTables ( )

protected

Populates the MCR content tables.

Since

1.32

Definition at line 1381 of file DatabaseUpdater.php.

References $wgMultiContentRevisionSchemaMigrationStage, insertUpdateRow(), output(), SCHEMA_COMPAT_WRITE_NEW, and updateRowExists().

populateExternallinksIndex60()

DatabaseUpdater::populateExternallinksIndex60 ( )

protected

Populates the externallinks.el_index_60 field.

Since

1.32

Definition at line 1363 of file DatabaseUpdater.php.

References output(), and updateRowExists().

purgeCache()

DatabaseUpdater::purgeCache

(

)

Purge various database caches.

Definition at line 1069 of file DatabaseUpdater.php.

References $wgLocalisationCacheConf, output(), and rebuildLocalisationCache().

rebuildLocalisationCache()

DatabaseUpdater::rebuildLocalisationCache ( )

protected

Rebuilds the localisation cache.

Definition at line 1229 of file DatabaseUpdater.php.

References output().

Referenced by purgeCache().

renameExtensionIndex()

DatabaseUpdater::renameExtensionIndex	(		$tableName,
			$oldIndexName,
			$newIndexName,
			$sqlPath,
			$skipBothIndexExistWarning = false )

Rename an index on an extension table.

Since

1.21

Parameters

string	$tableName	The table name
string	$oldIndexName	The old index name
string	$newIndexName	The new index name
string	$sqlPath	The path to the SQL change path
bool	$skipBothIndexExistWarning	Whether to warn if both the old and the new indexes exist. [facultative; by default, false]

Definition at line 333 of file DatabaseUpdater.php.

References true.

renameIndex()

DatabaseUpdater::renameIndex ( $table, $oldIndex, $newIndex, $skipBothIndexExistWarning, $patch, $fullpath = false )

protected

Rename an index from an existing table.

Parameters

string	$table	Name of the table to modify
string	$oldIndex	Old name of the index
string	$newIndex	New name of the index
bool	$skipBothIndexExistWarning	Whether to warn if both the old and the new indexes exist.
string	$patch	Path to the patch file
bool	$fullpath	Whether to treat $patch path as a relative or not

Returns

bool False if this was skipped because schema changes are skipped

Reimplemented in PostgresUpdater.

Definition at line 881 of file DatabaseUpdater.php.

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

runMaintenance()

DatabaseUpdater::runMaintenance	(		$class,
			$script )

Run a maintenance script.

This should only be used when the maintenance script must run before later updates. If later updates don't depend on the script, add it to DatabaseUpdater::$postDatabaseUpdateMaintenance instead.

The script's execute() method must return true to indicate successful completion, and must return false (or throw an exception) to indicate unsuccessful completion.

Since

1.32

Parameters

string	$class	Maintenance subclass
string	$script	Script path and filename, usually "maintenance/fooBar.php"

Definition at line 1033 of file DatabaseUpdater.php.

References output().

runUpdates()

DatabaseUpdater::runUpdates ( array $updates, $passSelf )

private

Helper function for doUpdates()

Parameters

array	$updates	Array of updates to run
bool	$passSelf	Whether to pass this object we calling external functions

Definition at line 477 of file DatabaseUpdater.php.

Referenced by doUpdates().

setFileAccess()

DatabaseUpdater::setFileAccess

(

)

Set any .htaccess files or equivilent for storage repos.

Some zones (e.g. "temp") used to be public and may have been initialized as such

Definition at line 1048 of file DatabaseUpdater.php.

References output().

tableExists()

DatabaseUpdater::tableExists

(

$tableName

)

Since

1.20

Parameters

string

$tableName

Returns

bool

Definition at line 375 of file DatabaseUpdater.php.

Referenced by ifNoActorTable(), and migrateImageCommentTemp().

updateRowExists()

DatabaseUpdater::updateRowExists

(

$key

)

Helper function: check if the given key is present in the updatelog table.

Obviously, only use this for updates that occur after the updatelog table was created!

Parameters

string

$key

Name of the key to check for

Returns

bool

Definition at line 510 of file DatabaseUpdater.php.

Referenced by MysqlUpdater\doCategoryPopulation(), MysqlUpdater\doClFieldsUpdate(), doLogSearchPopulation(), doLogUsertextPopulation(), MysqlUpdater\doPopulateParentId(), MysqlUpdater\doUpdateMimeMinorField(), migrateActors(), migrateComments(), modifyField(), modifyTable(), populateContentTables(), populateExternallinksIndex60(), PostgresUpdater\rebuildTextSearch(), SqliteUpdater\sqliteInitialIndexes(), and SqliteUpdater\sqliteSetupSearchindex().

writeSchemaUpdateFile()

DatabaseUpdater::writeSchemaUpdateFile ( array $schemaUpdate = [] )

private

Since

1.21

Writes the schema updates desired to a file for the DB Admin to run.

Parameters

array

$schemaUpdate

Definition at line 416 of file DatabaseUpdater.php.

References $args.

Referenced by doUpdates().

Member Data Documentation

$db

IMaintainableDatabase DatabaseUpdater::$db

protected

Handle to the database subclass.

Definition at line 64 of file DatabaseUpdater.php.

$extensionUpdates

array DatabaseUpdater::$extensionUpdates = []

protected

List of extension-provided database updates.

Definition at line 57 of file DatabaseUpdater.php.

$fileHandle

resource DatabaseUpdater::$fileHandle = null

protected

File handle for SQL output.

Definition at line 98 of file DatabaseUpdater.php.

$holdContentHandlerUseDB

DatabaseUpdater::$holdContentHandlerUseDB = true

protected

Hold the value of $wgContentHandlerUseDB during the upgrade.

Definition at line 110 of file DatabaseUpdater.php.

$maintenance

Maintenance DatabaseUpdater::$maintenance

protected

Definition at line 69 of file DatabaseUpdater.php.

$postDatabaseUpdateMaintenance

string [] DatabaseUpdater::$postDatabaseUpdateMaintenance

protected

Initial value:

= [
        DeleteDefaultMessages::class,
        PopulateRevisionLength::class,
        PopulateRevisionSha1::class,
        PopulateImageSha1::class,
        FixExtLinksProtocolRelative::class,
        PopulateFilearchiveSha1::class,
        PopulateBacklinkNamespace::class,
        FixDefaultJsonContentPages::class,
        CleanupEmptyCategories::class,
        AddRFCandPMIDInterwiki::class,
        PopulatePPSortKey::class,
        PopulateIpChanges::class,
        RefreshExternallinksIndex::class,
    ]

Scripts to run after database update Should be a subclass of LoggedUpdateMaintenance.

Definition at line 77 of file DatabaseUpdater.php.

$shared

DatabaseUpdater::$shared = false

protected

Definition at line 71 of file DatabaseUpdater.php.

Referenced by __construct(), and newForDB().

$skipSchema

bool DatabaseUpdater::$skipSchema = false

protected

Flag specifying whether or not to skip schema (e.g.

SQL-only) updates.

Definition at line 105 of file DatabaseUpdater.php.

$updates

array DatabaseUpdater::$updates = []

protected

Array of updates to perform on the database.

Definition at line 44 of file DatabaseUpdater.php.

Referenced by PostgresUpdater\getOldGlobalUpdates().

$updatesSkipped

array DatabaseUpdater::$updatesSkipped = []

protected

Array of updates that were skipped.

Definition at line 51 of file DatabaseUpdater.php.

REPLICATION_WAIT_TIMEOUT

const DatabaseUpdater::REPLICATION_WAIT_TIMEOUT = 300

Definition at line 37 of file DatabaseUpdater.php.

Referenced by MysqlUpdater\doTemplatelinksUpdate().

---

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

• includes/installer/DatabaseUpdater.php