MediaWiki  1.27.2
PostgresUpdater Class Reference

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

Inheritance diagram for PostgresUpdater:
Collaboration diagram for PostgresUpdater:

Public Member Functions

 addPgExtIndex ($table, $index, $type)
 
 addPgIndex ($table, $index, $type)
 
 describeIndex ($idx)
 
 fkeyDeltype ($fkey)
 
 ruleDef ($table, $rule)
 
- 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 ()
 
 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...
 
 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

 addInterwikiType ()
 
 addPgField ($table, $field, $type)
 
 addSequence ($table, $pkey, $ns)
 
 changeField ($table, $field, $newtype, $default)
 
 changeFieldPurgeTable ($table, $field, $newtype, $default)
 
 changeFkeyDeferrable ($table, $field, $clause)
 
 changeNullableField ($table, $field, $null)
 
 checkIndex ($index, $should_be, $good_def)
 
 checkIwlPrefix ()
 
 checkOiDeleted ()
 
 checkOiNameConstraint ()
 
 checkPageDeletedTrigger ()
 
 checkRevUserFkey ()
 
 convertArchive2 ()
 
 describeTable ($table)
 
 dropFkey ($table, $field)
 
 dropIndex ($table, $index, $patch= '', $fullpath=false)
 
 getCoreUpdateList ()
 
 getOldGlobalUpdates ()
 
 rebuildTextSearch ()
 
 renameIndex ($table, $old, $new, $skipBothIndexExistWarning=false, $a=false, $b=false)
 
 renameSequence ($old, $new)
 
 renameTable ($old, $new, $patch=false)
 
 setDefault ($table, $field, $default)
 
 tsearchFixes ()
 
- Protected Member Functions inherited from DatabaseUpdater
 __construct (DatabaseBase &$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=[])
 

Protected Attributes

DatabasePostgres $db
 
- Protected Attributes inherited from DatabaseUpdater
DatabaseBase $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...
 

Additional Inherited Members

- Static Public Member Functions inherited from DatabaseUpdater
static newForDB (&$db, $shared=false, $maintenance=null)
 
- Static Protected Attributes inherited from DatabaseUpdater
static $updateCounter = 0
 

Detailed Description

Class for handling updates to Postgres databases.

Since
1.17

Definition at line 30 of file PostgresUpdater.php.

Member Function Documentation

PostgresUpdater::addInterwikiType ( )
protected

Definition at line 948 of file PostgresUpdater.php.

References DatabaseUpdater\applyPatch().

PostgresUpdater::addPgExtIndex (   $table,
  $index,
  $type 
)
PostgresUpdater::addPgField (   $table,
  $field,
  $type 
)
protected

Definition at line 668 of file PostgresUpdater.php.

References DatabaseUpdater\output().

PostgresUpdater::addPgIndex (   $table,
  $index,
  $type 
)

Definition at line 768 of file PostgresUpdater.php.

References DatabaseUpdater\output().

PostgresUpdater::addSequence (   $table,
  $pkey,
  $ns 
)
protected

Definition at line 600 of file PostgresUpdater.php.

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

PostgresUpdater::changeField (   $table,
  $field,
  $newtype,
  $default 
)
protected

Definition at line 680 of file PostgresUpdater.php.

References $res, and DatabaseUpdater\output().

PostgresUpdater::changeFieldPurgeTable (   $table,
  $field,
  $newtype,
  $default 
)
protected

Definition at line 705 of file PostgresUpdater.php.

References $res, and DatabaseUpdater\output().

PostgresUpdater::changeFkeyDeferrable (   $table,
  $field,
  $clause 
)
protected

Definition at line 808 of file PostgresUpdater.php.

References $command, and DatabaseUpdater\output().

PostgresUpdater::changeNullableField (   $table,
  $field,
  $null 
)
protected

Definition at line 743 of file PostgresUpdater.php.

References DatabaseUpdater\output().

PostgresUpdater::checkIndex (   $index,
  $should_be,
  $good_def 
)
protected

Definition at line 908 of file PostgresUpdater.php.

References DatabaseUpdater\output().

PostgresUpdater::checkIwlPrefix ( )
protected

Definition at line 938 of file PostgresUpdater.php.

References DatabaseUpdater\applyPatch().

PostgresUpdater::checkOiDeleted ( )
protected

Definition at line 856 of file PostgresUpdater.php.

References DatabaseUpdater\output().

PostgresUpdater::checkOiNameConstraint ( )
protected

Definition at line 868 of file PostgresUpdater.php.

References DatabaseUpdater\output().

PostgresUpdater::checkPageDeletedTrigger ( )
protected

Definition at line 889 of file PostgresUpdater.php.

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

PostgresUpdater::checkRevUserFkey ( )
protected
PostgresUpdater::convertArchive2 ( )
protected

Definition at line 836 of file PostgresUpdater.php.

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

PostgresUpdater::describeIndex (   $idx)

Definition at line 503 of file PostgresUpdater.php.

References $query, $res, as, and FROM.

PostgresUpdater::describeTable (   $table)
protected

Definition at line 478 of file PostgresUpdater.php.

References $res, as, and FROM.

PostgresUpdater::dropFkey (   $table,
  $field 
)
protected

Definition at line 790 of file PostgresUpdater.php.

References $command, and DatabaseUpdater\output().

PostgresUpdater::dropIndex (   $table,
  $index,
  $patch = '',
  $fullpath = false 
)
protected

Definition at line 901 of file PostgresUpdater.php.

References DatabaseUpdater\output().

PostgresUpdater::fkeyDeltype (   $fkey)

Definition at line 554 of file PostgresUpdater.php.

References FROM.

Referenced by checkRevUserFkey().

PostgresUpdater::getCoreUpdateList ( )
protected
Todo:
FIXME: Postgres should use sequential updates like Mysql, Sqlite and everybody else. It never got refactored like it should've.
Returns
array

Definition at line 42 of file PostgresUpdater.php.

PostgresUpdater::getOldGlobalUpdates ( )
protected

Definition at line 439 of file PostgresUpdater.php.

References DatabaseUpdater\$updates, as, global, and true.

PostgresUpdater::rebuildTextSearch ( )
protected
PostgresUpdater::renameIndex (   $table,
  $old,
  $new,
  $skipBothIndexExistWarning = false,
  $a = false,
  $b = false 
)
protected

Definition at line 634 of file PostgresUpdater.php.

References DatabaseUpdater\output().

PostgresUpdater::renameSequence (   $old,
  $new 
)
protected

Definition at line 610 of file PostgresUpdater.php.

References DatabaseUpdater\output().

PostgresUpdater::renameTable (   $old,
  $new,
  $patch = false 
)
protected

Definition at line 622 of file PostgresUpdater.php.

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

PostgresUpdater::ruleDef (   $table,
  $rule 
)

Definition at line 576 of file PostgresUpdater.php.

References definition, and FROM.

PostgresUpdater::setDefault (   $table,
  $field,
  $default 
)
protected

Definition at line 734 of file PostgresUpdater.php.

References DatabaseUpdater\output().

Referenced by addSequence().

PostgresUpdater::tsearchFixes ( )
protected

Definition at line 952 of file PostgresUpdater.php.

References DatabaseUpdater\applyPatch().

Member Data Documentation

DatabasePostgres PostgresUpdater::$db
protected

Definition at line 35 of file PostgresUpdater.php.


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