Class for handling updates to Postgres databases. More...

Inherits MediaWiki\Installer\DatabaseUpdater.

Collaboration diagram for MediaWiki\Installer\PostgresUpdater:

[legend]

Protected Member Functions
	addPgExtIndex ( $table, $index, $type)

	addPgField ( $table, $field, $type)

	addPgIndex ( $table, $index, $type, $unique=false)

	addSequence ( $table, $pkey, $ns)

	changeField ( $table, $field, $newtype, $default)

	changeFieldPurgeTable ( $table, $field, $newtype, $default)

	changeFkeyDeferrable ( $table, $field, $clause)

	changeNullableField ( $table, $field, $null, $update=false)

	changePrimaryKey ( $table, $shouldBe, $constraintName=null)

	checkIndex ( $index, $should_be, $good_def)

	describeIndex ( $idx)

	describeTable ( $table)

	dropConstraint ( $table, $field, $type, $conname=null)
	Drop generic constraint.

	dropDefault ( $table, $field)
	Drop a default value from a field.

	dropFkey ( $table, $field)

	dropPgField ( $table, $field)

	dropPgIndex ( $table, $index)

	dropSequence ( $table, $ns)

	fkeyDeltype ( $fkey)

	getCoreUpdateList ()

	renameIndex ( $table, $old, $new, $skipBothIndexExistWarning=false, $a=false, $b=false)
	Rename an index from an existing table.

	renameSequence ( $old, $new)

	renameTable ( $old, $new, $patch=false)

	ruleDef ( $table, $rule)

	setDefault ( $table, $field, $default)

	setSequenceOwner ( $table, $pkey, $seq)

Protected Member Functions inherited from MediaWiki\Installer\DatabaseUpdater
	__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.

	addTable ( $name, $patch, $fullpath=false)
	Add a new table to the database.

	appendLine ( $line)
	Append a line to the open file handle.

	applyPatch ( $path, $isFullPath=false, $msg=null)
	Applies a SQL patch.

	checkStats ()
	Check the site_stats table is not properly populated.

	copyFile ( $filename)
	Append an SQL fragment to the open file handle.

	doCollationUpdate ()
	Update CategoryLinks collation.

	doConvertDjvuMetadata ()

	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.

	dropTable ( $table, $patch=false, $fullpath=false)
	If the specified table exists, drop it, or execute the patch if one is provided.

	getExtensionUpdates ()
	Get the list of extension-defined updates.

	ifFieldExists ( $table, $field, $func,... $params)
	Only run a function if the named field exists.

	ifTableNotExists ( $table, $func,... $params)
	Only run a function if a table does not exist.

	migratePagelinks ()

	migrateTemplatelinks ()

	modifyField ( $table, $field, $patch, $fullpath=false)
	Modify an existing field.

	modifyTable ( $table, $patch, $fullpath=false)
	Modify an existing table, similar to modifyField.

	rebuildLocalisationCache ()
	Rebuilds the localisation cache.

	runMaintenance ( $class, $script)
	Run a maintenance script.

Protected Attributes
DatabasePostgres	$db

Protected Attributes inherited from MediaWiki\Installer\DatabaseUpdater
HookContainer null	$autoExtensionHookContainer

IMaintainableDatabase	$db
	Handle to the database subclass.

array	$extensionUpdates = []
	List of extension-provided database updates.

array	$extensionUpdatesWithVirtualDomains = []
	List of extension-provided database updates on virtual domain dbs.

resource null	$fileHandle = null
	File handle for SQL output.

Maintenance	$maintenance

string[]	$postDatabaseUpdateMaintenance
	Scripts to run after database update Should be a subclass of LoggedUpdateMaintenance.

	$shared = false

bool	$skipSchema = false
	Flag specifying whether to skip schema (e.g., SQL-only) updates.

array	$updates = []
	Array of updates to perform on the database.

array	$updatesSkipped = []
	Array of updates that were skipped.

Additional Inherited Members
Public Member Functions inherited from MediaWiki\Installer\DatabaseUpdater
	addExtensionField ( $tableName, $columnName, $sqlPath)
	Add a field to an existing extension table.

	addExtensionIndex ( $tableName, $indexName, $sqlPath)
	Add an index to an existing extension table.

	addExtensionTable ( $tableName, $sqlPath)
	Convenience wrapper for addExtensionUpdate() when adding a new table (which is the most common usage of updaters in an extension) Intended for use in LoadExtensionSchemaUpdates hook handlers.

	addExtensionUpdate (array $update)
	Add a new update coming from an extension.

	addExtensionUpdateOnVirtualDomain (array $update)
	Add a new update coming from an extension on virtual domain databases.

	addPostDatabaseUpdateMaintenance ( $class)
	Add a maintenance script to be run after the database updates are complete.

	doUpdates (array $what=[ 'core', 'extensions', 'stats'])
	Do all the updates.

	dropExtensionField ( $tableName, $columnName, $sqlPath)
	Drop a field from an extension table.

	dropExtensionIndex ( $tableName, $indexName, $sqlPath)
	Drop an index from an extension table Intended for use in LoadExtensionSchemaUpdates hook handlers.

	dropExtensionTable ( $tableName, $sqlPath=false)
	Drop an extension table.

	fieldExists ( $tableName, $fieldName)

	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.

	modifyExtensionField ( $tableName, $fieldName, $sqlPath)
	Modify an existing field in an extension table.

	modifyExtensionTable ( $tableName, $sqlPath)
	Modify an existing extension table.

	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 Intended for use in LoadExtensionSchemaUpdates hook handlers.

	setAutoExtensionHookContainer (HookContainer $hookContainer)
	Set the HookContainer to use for loading extension schema updates.

	setFileAccess ()
	Set any .htaccess files or equivalent for storage repos.

	tableExists ( $tableName)

	updateRowExists ( $key)
	Helper function: check if the given key is present in the updatelog table.

Static Public Member Functions inherited from MediaWiki\Installer\DatabaseUpdater
static	newForDB (IMaintainableDatabase $db, $shared=false, Maintenance $maintenance=null)

Public Attributes inherited from MediaWiki\Installer\DatabaseUpdater
const	REPLICATION_WAIT_TIMEOUT = 300

Detailed Description

Class for handling updates to Postgres databases.

Since: 1.17

Definition at line 40 of file PostgresUpdater.php.

Member Function Documentation

◆ addPgExtIndex()

MediaWiki\Installer\PostgresUpdater::addPgExtIndex	(	$table,
		$index,
		$type )

protected

Definition at line 837 of file PostgresUpdater.php.

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

◆ addPgField()

MediaWiki\Installer\PostgresUpdater::addPgField	(	$table,
		$field,
		$type )

protected

Definition at line 705 of file PostgresUpdater.php.

References MediaWiki\Installer\DatabaseUpdater\output().

◆ addPgIndex()

MediaWiki\Installer\PostgresUpdater::addPgIndex	(	$table,
		$index,
		$type,
		$unique = false )

protected

Definition at line 826 of file PostgresUpdater.php.

References MediaWiki\Installer\DatabaseUpdater\output().

◆ addSequence()

MediaWiki\Installer\PostgresUpdater::addSequence	(	$table,
		$pkey,
		$ns )

protected

Definition at line 607 of file PostgresUpdater.php.

References MediaWiki\Installer\DatabaseUpdater\output(), and MediaWiki\Installer\PostgresUpdater\setDefault().

◆ changeField()

MediaWiki\Installer\PostgresUpdater::changeField	(	$table,
		$field,
		$newtype,
		$default )

protected

Definition at line 716 of file PostgresUpdater.php.

References MediaWiki\Installer\DatabaseUpdater\output().

◆ changeFieldPurgeTable()

MediaWiki\Installer\PostgresUpdater::changeFieldPurgeTable	(	$table,
		$field,
		$newtype,
		$default )

protected

Definition at line 742 of file PostgresUpdater.php.

References MediaWiki\Installer\DatabaseUpdater\output().

◆ changeFkeyDeferrable()

MediaWiki\Installer\PostgresUpdater::changeFkeyDeferrable	(	$table,
		$field,
		$clause )

protected

Definition at line 864 of file PostgresUpdater.php.

References MediaWiki\Installer\PostgresUpdater\dropConstraint(), and MediaWiki\Installer\DatabaseUpdater\output().

◆ changeNullableField()

MediaWiki\Installer\PostgresUpdater::changeNullableField	(	$table,
		$field,
		$null,
		$update = false )

protected

Definition at line 797 of file PostgresUpdater.php.

References MediaWiki\Installer\DatabaseUpdater\output().

◆ changePrimaryKey()

MediaWiki\Installer\PostgresUpdater::changePrimaryKey	(	$table,
		$shouldBe,
		$constraintName = null )

protected

Definition at line 917 of file PostgresUpdater.php.

References MediaWiki\Installer\PostgresUpdater\dropConstraint(), and MediaWiki\Installer\DatabaseUpdater\output().

◆ checkIndex()

MediaWiki\Installer\PostgresUpdater::checkIndex	(	$index,
		$should_be,
		$good_def )

protected

Definition at line 899 of file PostgresUpdater.php.

References MediaWiki\Installer\DatabaseUpdater\output().

◆ describeIndex()

MediaWiki\Installer\PostgresUpdater::describeIndex ( $idx )

protected

Definition at line 511 of file PostgresUpdater.php.

◆ describeTable()

MediaWiki\Installer\PostgresUpdater::describeTable ( $table )

protected

Definition at line 482 of file PostgresUpdater.php.

◆ dropConstraint()

MediaWiki\Installer\PostgresUpdater::dropConstraint	(	$table,
		$field,
		$type,
		$conname = null )

protected

Drop generic constraint.

If the constraint was created with a custom name, then the name must be queried and supplied as $conname, otherwise standard system suffixes and format would be assumed.

Parameters

string	$table
string	$field
string	$type
string \| null	$conname

Returns: bool

Definition at line 959 of file PostgresUpdater.php.

Referenced by MediaWiki\Installer\PostgresUpdater\changeFkeyDeferrable(), MediaWiki\Installer\PostgresUpdater\changePrimaryKey(), and MediaWiki\Installer\PostgresUpdater\dropFkey().

◆ dropDefault()

MediaWiki\Installer\PostgresUpdater::dropDefault	(		$table,
			$field )

protected

Drop a default value from a field.

Since: 1.32

Parameters

string	$table
string	$field

Definition at line 788 of file PostgresUpdater.php.

References MediaWiki\Installer\DatabaseUpdater\output().

◆ dropFkey()

MediaWiki\Installer\PostgresUpdater::dropFkey	(		$table,
			$field )

protected

Definition at line 849 of file PostgresUpdater.php.

References MediaWiki\Installer\PostgresUpdater\dropConstraint(), and MediaWiki\Installer\DatabaseUpdater\output().

◆ dropPgField()

MediaWiki\Installer\PostgresUpdater::dropPgField	(		$table,
			$field )

protected

Definition at line 694 of file PostgresUpdater.php.

References MediaWiki\Installer\DatabaseUpdater\output().

◆ dropPgIndex()

MediaWiki\Installer\PostgresUpdater::dropPgIndex	(		$table,
			$index )

protected

Definition at line 892 of file PostgresUpdater.php.

References MediaWiki\Installer\DatabaseUpdater\output().

◆ dropSequence()

MediaWiki\Installer\PostgresUpdater::dropSequence	(		$table,
			$ns )

protected

Definition at line 620 of file PostgresUpdater.php.

References MediaWiki\Installer\DatabaseUpdater\output().

◆ fkeyDeltype()

MediaWiki\Installer\PostgresUpdater::fkeyDeltype ( $fkey )

protected

Definition at line 563 of file PostgresUpdater.php.

◆ getCoreUpdateList()

MediaWiki\Installer\PostgresUpdater::getCoreUpdateList ( )

protected

Returns: array

Reimplemented from MediaWiki\Installer\DatabaseUpdater.

Definition at line 50 of file PostgresUpdater.php.

◆ renameIndex()

MediaWiki\Installer\PostgresUpdater::renameIndex	(	$table,
		$oldIndex,
		$newIndex,
		$skipBothIndexExistWarning = false,
		$patch = false,
		$fullpath = false )

protected

Rename an index from an existing table.

Note: Code in a LoadExtensionSchemaUpdates handler should use renameExtensionIndex instead!

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 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 from MediaWiki\Installer\DatabaseUpdater.

Definition at line 659 of file PostgresUpdater.php.

References MediaWiki\Installer\DatabaseUpdater\output().

◆ renameSequence()

MediaWiki\Installer\PostgresUpdater::renameSequence	(		$old,
			$new )

protected

Definition at line 627 of file PostgresUpdater.php.

References MediaWiki\Installer\DatabaseUpdater\output().

◆ renameTable()

MediaWiki\Installer\PostgresUpdater::renameTable	(	$old,
		$new,
		$patch = false )

protected

Definition at line 647 of file PostgresUpdater.php.

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

◆ ruleDef()

MediaWiki\Installer\PostgresUpdater::ruleDef	(		$table,
			$rule )

protected

Definition at line 582 of file PostgresUpdater.php.

◆ setDefault()

MediaWiki\Installer\PostgresUpdater::setDefault	(	$table,
		$field,
		$default )

protected

Definition at line 772 of file PostgresUpdater.php.

References MediaWiki\Installer\DatabaseUpdater\output().

Referenced by MediaWiki\Installer\PostgresUpdater\addSequence().

◆ setSequenceOwner()

MediaWiki\Installer\PostgresUpdater::setSequenceOwner	(	$table,
		$pkey,
		$seq )

protected

Definition at line 639 of file PostgresUpdater.php.

References MediaWiki\Installer\DatabaseUpdater\output().

Member Data Documentation

◆ $db

DatabasePostgres MediaWiki\Installer\PostgresUpdater::$db

protected

Definition at line 45 of file PostgresUpdater.php.

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

includes/installer/PostgresUpdater.php

Protected Member Functions

Protected Attributes

Additional Inherited Members

Detailed Description

Member Function Documentation

◆ addPgExtIndex()

◆ addPgField()

◆ addPgIndex()

◆ addSequence()

◆ changeField()

◆ changeFieldPurgeTable()

◆ changeFkeyDeferrable()

◆ changeNullableField()

◆ changePrimaryKey()

◆ checkIndex()

◆ describeIndex()

◆ describeTable()

◆ dropConstraint()

◆ dropDefault()

◆ dropFkey()

◆ dropPgField()

◆ dropPgIndex()

◆ dropSequence()

◆ fkeyDeltype()

◆ getCoreUpdateList()

◆ renameIndex()

◆ renameSequence()

◆ renameTable()

◆ ruleDef()

◆ setDefault()

◆ setSequenceOwner()

Member Data Documentation

◆ $db