MediaWiki REL1_28
DatabaseInstaller Class Reference

Base class for DBMS-specific installation helper classes. More...

Inheritance diagram for DatabaseInstaller:
Collaboration diagram for DatabaseInstaller:

Public Member Functions

 __construct ( $parent)
 Construct and initialise parent.
 
 checkPrerequisites ()
 Checks for installation prerequisites other than those checked by isCompiled()
 
 createExtensionTables ()
 Create the tables for each extension the user enabled.
 
 createTables ()
 Create database tables from scratch.
 
 doUpgrade ()
 Perform database upgrades.
 
 enableLB ()
 Set up LBFactory so that wfGetDB() etc.
 
 getCheckBox ( $var, $label, $attribs=[], $helpData="")
 Get a labelled checkbox to configure a local boolean variable.
 
 getConnectForm ()
 Get HTML for a web form that configures this database.
 
 getConnection ()
 Connect to the database using the administrative user/password currently defined in the session.
 
 getGlobalDefaults ()
 Get a name=>value map of MW configuration globals for the default values.
 
 getGlobalNames ()
 Get an array of MW configuration globals that will be configured by this class.
 
 getInstallUserBox ()
 Get a standard install-user fieldset.
 
 getInternalDefaults ()
 Get a name=>value map of internal variables used during installation.
 
 getLocalSettings ()
 Get the DBMS-specific options for LocalSettings.php generation.
 
 getName ()
 Return the internal name, e.g.
 
 getPasswordBox ( $var, $label, $attribs=[], $helpData="")
 Get a labelled password box to configure a local variable.
 
 getRadioSet ( $params)
 Get a set of labelled radio buttons.
 
 getReadableName ()
 Get the internationalised name for this DBMS.
 
 getSchemaPath ( $db)
 Return a path to the DBMS-specific schema file, otherwise default to tables.sql.
 
 getSchemaVars ()
 Override this to provide DBMS-specific schema variables, to be substituted into tables.sql and other schema files.
 
 getSettingsForm ()
 Get HTML for a web form that retrieves settings used for installation.
 
 getTextBox ( $var, $label, $attribs=[], $helpData="")
 Get a labelled text box to configure a local variable.
 
 getUpdateKeysPath ( $db)
 Return a path to the DBMS-specific update key file, otherwise default to update-keys.sql.
 
 getVar ( $var, $default=null)
 Get a variable, taking local defaults into account.
 
 getWebUserBox ( $noCreateMsg=false)
 Get a standard web-user fieldset.
 
 insertUpdateKeys ()
 Insert update keys into table to prevent running unneded updates.
 
 isCompiled ()
 
 needsUpgrade ()
 Determine whether an existing installation of MediaWiki is present in the configured administrative connection.
 
 openConnection ()
 Open a connection to the database using the administrative user/password currently defined in the session, without any caching.
 
 outputHandler ( $string)
 
 populateInterwikiTable ()
 Common function for databases that don't understand the MySQLish syntax of interwiki.sql.
 
 preInstall ()
 Allow DB installers a chance to make last-minute changes before installation occurs.
 
 preUpgrade ()
 Allow DB installers a chance to make checks before upgrade.
 
 setupDatabase ()
 Create the database and return a Status object indicating success or failure.
 
 setupSchemaVars ()
 Set appropriate schema variables in the current database connection.
 
 setVar ( $name, $value)
 Convenience alias for $this->parent->setVar()
 
 setVarsFromRequest ( $varNames)
 Convenience function to set variables based on form data.
 
 submitConnectForm ()
 Set variables based on the request array, assuming it was submitted via the form returned by getConnectForm().
 
 submitInstallUserBox ()
 Submit a standard install user fieldset.
 
 submitSettingsForm ()
 Set variables based on the request array, assuming it was submitted via the form return by getSettingsForm().
 
 submitWebUserBox ()
 Submit the form from getWebUserBox().
 

Public Attributes

Database $db = null
 The database connection.
 
WebInstaller $parent
 The Installer object.
 

Static Protected Member Functions

static checkExtension ( $name)
 Convenience function.
 

Protected Attributes

array $globalNames = []
 Array of MW configuration globals this class uses.
 
array $internalDefaults = []
 Internal variables for installation.
 

Private Member Functions

 getSqlFilePath ( $db, $filename)
 Return a path to the DBMS-specific SQL file if it exists, otherwise default SQL file.
 
 stepApplySourceFile ( $sourceFileMethod, $stepName, $archiveTableMustNotExist=false)
 Apply a SQL source file to the database as part of running an installation step.
 

Detailed Description

Base class for DBMS-specific installation helper classes.

Since
1.17

Definition at line 30 of file DatabaseInstaller.php.

Constructor & Destructor Documentation

◆ __construct()

DatabaseInstaller::__construct (   $parent)

Construct and initialise parent.

This is typically only called from Installer::getDBInstaller()

Parameters
WebInstaller$parent

Definition at line 398 of file DatabaseInstaller.php.

References $parent.

Member Function Documentation

◆ checkExtension()

static DatabaseInstaller::checkExtension (   $name)
staticprotected

Convenience function.

Check if a named extension is present.

Parameters
string$name
Returns
bool

Definition at line 409 of file DatabaseInstaller.php.

References $name.

Referenced by MssqlInstaller\isCompiled(), MysqlInstaller\isCompiled(), OracleInstaller\isCompiled(), PostgresInstaller\isCompiled(), and SqliteInstaller\isCompiled().

◆ checkPrerequisites()

DatabaseInstaller::checkPrerequisites ( )

Checks for installation prerequisites other than those checked by isCompiled()

Since
1.19
Returns
Status

Reimplemented in SqliteInstaller.

Definition at line 77 of file DatabaseInstaller.php.

◆ createExtensionTables()

DatabaseInstaller::createExtensionTables ( )

Create the tables for each extension the user enabled.

Returns
Status

Definition at line 275 of file DatabaseInstaller.php.

References $status, getConnection(), and DatabaseUpdater\newForDB().

◆ createTables()

DatabaseInstaller::createTables ( )

Create database tables from scratch.

Returns
Status

Reimplemented in MssqlInstaller, OracleInstaller, PostgresInstaller, and SqliteInstaller.

Definition at line 217 of file DatabaseInstaller.php.

References stepApplySourceFile().

◆ doUpgrade()

DatabaseInstaller::doUpgrade ( )

Perform database upgrades.

Returns
bool

Definition at line 347 of file DatabaseInstaller.php.

References $e, $ret, enableLB(), DatabaseUpdater\newForDB(), and setupSchemaVars().

◆ enableLB()

DatabaseInstaller::enableLB ( )

Set up LBFactory so that wfGetDB() etc.

works. We set up a special LBFactory instance which returns the current installer connection.

Definition at line 326 of file DatabaseInstaller.php.

References $services, $status, getConnection(), LBFactorySingle\newFromConnection(), and use.

Referenced by PostgresInstaller\createTables(), doUpgrade(), and stepApplySourceFile().

◆ getCheckBox()

DatabaseInstaller::getCheckBox (   $var,
  $label,
  $attribs = [],
  $helpData = "" 
)

Get a labelled checkbox to configure a local boolean variable.

Parameters
string$var
string$label
array$attribsOptional.
string$helpDataOptional.
Returns
string

Definition at line 534 of file DatabaseInstaller.php.

References $attribs, $name, $value, getName(), and getVar().

Referenced by MssqlInstaller\getSettingsForm(), and getWebUserBox().

◆ getConnectForm()

DatabaseInstaller::getConnectForm ( )
abstract

Get HTML for a web form that configures this database.

Configuration at this time should be the minimum needed to connect and test whether install or upgrade is required.

If this is called, $this->parent can be assumed to be a WebInstaller.

Reimplemented in MssqlInstaller, MysqlInstaller, OracleInstaller, PostgresInstaller, and SqliteInstaller.

◆ getConnection()

DatabaseInstaller::getConnection ( )

◆ getGlobalDefaults()

DatabaseInstaller::getGlobalDefaults ( )

Get a name=>value map of MW configuration globals for the default values.

Returns
array

Reimplemented in MssqlInstaller, PostgresInstaller, and SqliteInstaller.

Definition at line 427 of file DatabaseInstaller.php.

References $GLOBALS, as, and getGlobalNames().

Referenced by getVar().

◆ getGlobalNames()

DatabaseInstaller::getGlobalNames ( )

Get an array of MW configuration globals that will be configured by this class.

Returns
array

Definition at line 389 of file DatabaseInstaller.php.

References $globalNames.

Referenced by getGlobalDefaults().

◆ getInstallUserBox()

DatabaseInstaller::getInstallUserBox ( )

Get a standard install-user fieldset.

Returns
string

Definition at line 607 of file DatabaseInstaller.php.

References getPasswordBox(), getTextBox(), text, and wfMessage().

Referenced by MysqlInstaller\getConnectForm(), OracleInstaller\getConnectForm(), and PostgresInstaller\getConnectForm().

◆ getInternalDefaults()

DatabaseInstaller::getInternalDefaults ( )

Get a name=>value map of internal variables used during installation.

Returns
array

Definition at line 441 of file DatabaseInstaller.php.

References $internalDefaults.

Referenced by getVar().

◆ getLocalSettings()

DatabaseInstaller::getLocalSettings ( )
abstract

Get the DBMS-specific options for LocalSettings.php generation.

Returns
string

Reimplemented in MssqlInstaller, MysqlInstaller, OracleInstaller, PostgresInstaller, and SqliteInstaller.

◆ getName()

DatabaseInstaller::getName ( )
abstract

Return the internal name, e.g.

'mysql', or 'sqlite'.

Reimplemented in MssqlInstaller, MysqlInstaller, OracleInstaller, PostgresInstaller, and SqliteInstaller.

Referenced by getCheckBox(), getPasswordBox(), getRadioSet(), getReadableName(), getTextBox(), and setVarsFromRequest().

◆ getPasswordBox()

DatabaseInstaller::getPasswordBox (   $var,
  $label,
  $attribs = [],
  $helpData = "" 
)

Get a labelled password box to configure a local variable.

Implements password hiding.

Parameters
string$var
string$label
array$attribs
string$helpData
Returns
string

Definition at line 508 of file DatabaseInstaller.php.

References $attribs, $name, $value, getName(), and getVar().

Referenced by MssqlInstaller\getConnectForm(), getInstallUserBox(), MssqlInstaller\getSettingsForm(), and getWebUserBox().

◆ getRadioSet()

DatabaseInstaller::getRadioSet (   $params)

Get a set of labelled radio buttons.

Parameters
array$paramsParameters are: var: The variable to be configured (required) label: The message name for the label (required) itemLabelPrefix: The message name prefix for the item labels (required) values: List of allowed values (required) itemAttribs Array of attribute arrays, outer key is the value name (optional)
Returns
string

Definition at line 560 of file DatabaseInstaller.php.

References $params, getName(), and getVar().

Referenced by MssqlInstaller\getConnectForm(), MssqlInstaller\getSettingsForm(), and MysqlInstaller\getSettingsForm().

◆ getReadableName()

DatabaseInstaller::getReadableName ( )

Get the internationalised name for this DBMS.

Returns
string

Definition at line 417 of file DatabaseInstaller.php.

References getName(), and wfMessage().

◆ getSchemaPath()

DatabaseInstaller::getSchemaPath (   $db)

Return a path to the DBMS-specific schema file, otherwise default to tables.sql.

Parameters
IDatabase$db
Returns
string

Definition at line 256 of file DatabaseInstaller.php.

References getSqlFilePath().

Referenced by PostgresInstaller\createTables().

◆ getSchemaVars()

DatabaseInstaller::getSchemaVars ( )

Override this to provide DBMS-specific schema variables, to be substituted into tables.sql and other schema files.

Returns
array

Reimplemented in MssqlInstaller, MysqlInstaller, and OracleInstaller.

Definition at line 299 of file DatabaseInstaller.php.

Referenced by setupSchemaVars().

◆ getSettingsForm()

DatabaseInstaller::getSettingsForm ( )

Get HTML for a web form that retrieves settings used for installation.

$this->parent can be assumed to be a WebInstaller. If the DB type has no settings beyond those already configured with getConnectForm(), this should return false.

Returns
bool

Reimplemented in MssqlInstaller, MysqlInstaller, and PostgresInstaller.

Definition at line 108 of file DatabaseInstaller.php.

◆ getSqlFilePath()

DatabaseInstaller::getSqlFilePath (   $db,
  $filename 
)
private

Return a path to the DBMS-specific SQL file if it exists, otherwise default SQL file.

Parameters
IDatabase$db
string$filename
Returns
string

Definition at line 238 of file DatabaseInstaller.php.

References $db, $IP, IDatabase\getType(), and global.

Referenced by getSchemaPath(), and getUpdateKeysPath().

◆ getTextBox()

DatabaseInstaller::getTextBox (   $var,
  $label,
  $attribs = [],
  $helpData = "" 
)

Get a labelled text box to configure a local variable.

Parameters
string$var
string$label
array$attribs
string$helpData
Returns
string

Definition at line 481 of file DatabaseInstaller.php.

References $attribs, $name, $value, getName(), and getVar().

Referenced by MssqlInstaller\getConnectForm(), MysqlInstaller\getConnectForm(), OracleInstaller\getConnectForm(), PostgresInstaller\getConnectForm(), SqliteInstaller\getConnectForm(), getInstallUserBox(), MssqlInstaller\getSettingsForm(), and getWebUserBox().

◆ getUpdateKeysPath()

DatabaseInstaller::getUpdateKeysPath (   $db)

Return a path to the DBMS-specific update key file, otherwise default to update-keys.sql.

Parameters
IDatabase$db
Returns
string

Definition at line 267 of file DatabaseInstaller.php.

References getSqlFilePath().

◆ getVar()

DatabaseInstaller::getVar (   $var,
  $default = null 
)

Get a variable, taking local defaults into account.

Parameters
string$var
mixed | null$default
Returns
mixed

Definition at line 451 of file DatabaseInstaller.php.

References getGlobalDefaults(), and getInternalDefaults().

Referenced by MssqlInstaller\canCreateAccounts(), MysqlInstaller\canCreateAccounts(), PostgresInstaller\canCreateObjectsForWebUser(), MssqlInstaller\createTables(), OracleInstaller\createTables(), PostgresInstaller\createTables(), getCheckBox(), MssqlInstaller\getConnectForm(), OracleInstaller\getConnectForm(), PostgresInstaller\getInstallUserPermissions(), MssqlInstaller\getLocalSettings(), MysqlInstaller\getLocalSettings(), OracleInstaller\getLocalSettings(), PostgresInstaller\getLocalSettings(), SqliteInstaller\getLocalSettings(), getPasswordBox(), getRadioSet(), MssqlInstaller\getSchemaVars(), MysqlInstaller\getSchemaVars(), OracleInstaller\getSchemaVars(), MssqlInstaller\getSettingsForm(), MysqlInstaller\getSettingsForm(), MysqlInstaller\getTableOptions(), getTextBox(), getWebUserBox(), OracleInstaller\needsUpgrade(), SqliteInstaller\needsUpgrade(), MssqlInstaller\openConnection(), MysqlInstaller\openConnection(), OracleInstaller\openConnection(), SqliteInstaller\openConnection(), PostgresInstaller\openConnectionToAnyDB(), PostgresInstaller\openConnectionWithParams(), PostgresInstaller\openPgConnection(), OracleInstaller\openSYSDBAConnection(), populateInterwikiTable(), PostgresInstaller\preInstall(), MssqlInstaller\preUpgrade(), MysqlInstaller\preUpgrade(), PostgresInstaller\preUpgrade(), MssqlInstaller\setupDatabase(), MysqlInstaller\setupDatabase(), PostgresInstaller\setupDatabase(), SqliteInstaller\setupDatabase(), PostgresInstaller\setupPLpgSQL(), PostgresInstaller\setupSchema(), MssqlInstaller\setupUser(), MysqlInstaller\setupUser(), OracleInstaller\setupUser(), PostgresInstaller\setupUser(), stepApplySourceFile(), OracleInstaller\submitConnectForm(), PostgresInstaller\submitConnectForm(), SqliteInstaller\submitConnectForm(), OracleInstaller\submitInstallUserBox(), MssqlInstaller\submitSettingsForm(), MysqlInstaller\submitSettingsForm(), PostgresInstaller\submitSettingsForm(), and submitWebUserBox().

◆ getWebUserBox()

DatabaseInstaller::getWebUserBox (   $noCreateMsg = false)

Get a standard web-user fieldset.

Parameters
string | bool$noCreateMsgMessage to display instead of the creation checkbox. Set this to false to show a creation checkbox (default).
Returns
string

Definition at line 642 of file DatabaseInstaller.php.

References $s, getCheckBox(), getPasswordBox(), getTextBox(), getVar(), plain, text, and wfMessage().

Referenced by OracleInstaller\getConnectForm(), MysqlInstaller\getSettingsForm(), and PostgresInstaller\getSettingsForm().

◆ insertUpdateKeys()

DatabaseInstaller::insertUpdateKeys ( )

Insert update keys into table to prevent running unneded updates.

Returns
Status

Definition at line 226 of file DatabaseInstaller.php.

References stepApplySourceFile().

◆ isCompiled()

DatabaseInstaller::isCompiled ( )
abstract
Returns
bool Returns true if the client library is compiled in.

Reimplemented in MssqlInstaller, MysqlInstaller, OracleInstaller, PostgresInstaller, and SqliteInstaller.

◆ needsUpgrade()

DatabaseInstaller::needsUpgrade ( )

Determine whether an existing installation of MediaWiki is present in the configured administrative connection.

Returns true if there is such a wiki, false if the database doesn't exist.

Traditionally, this is done by testing for the existence of either the revision table or the cur table.

Returns
bool

Reimplemented in OracleInstaller, and SqliteInstaller.

Definition at line 588 of file DatabaseInstaller.php.

References $status, and getConnection().

◆ openConnection()

DatabaseInstaller::openConnection ( )
abstract

Open a connection to the database using the administrative user/password currently defined in the session, without any caching.

Returns a status object. On success, the status object will contain a Database object in its value member.

Returns
Status

Reimplemented in MssqlInstaller, MysqlInstaller, OracleInstaller, PostgresInstaller, and SqliteInstaller.

Referenced by getConnection().

◆ outputHandler()

DatabaseInstaller::outputHandler (   $string)

Definition at line 728 of file DatabaseInstaller.php.

◆ populateInterwikiTable()

DatabaseInstaller::populateInterwikiTable ( )

Common function for databases that don't understand the MySQLish syntax of interwiki.sql.

Returns
Status

Definition at line 691 of file DatabaseInstaller.php.

References $IP, $status, as, file, getConnection(), getVar(), and global.

◆ preInstall()

DatabaseInstaller::preInstall ( )

Allow DB installers a chance to make last-minute changes before installation occurs.

This happens before setupDatabase() or createTables() is called, but long after the constructor. Helpful for things like modifying setup steps :)

Reimplemented in MssqlInstaller, MysqlInstaller, OracleInstaller, and PostgresInstaller.

Definition at line 376 of file DatabaseInstaller.php.

◆ preUpgrade()

DatabaseInstaller::preUpgrade ( )

Allow DB installers a chance to make checks before upgrade.

Reimplemented in MssqlInstaller, MysqlInstaller, and PostgresInstaller.

Definition at line 382 of file DatabaseInstaller.php.

◆ setupDatabase()

DatabaseInstaller::setupDatabase ( )
abstract

Create the database and return a Status object indicating success or failure.

Returns
Status

Reimplemented in MssqlInstaller, MysqlInstaller, OracleInstaller, PostgresInstaller, and SqliteInstaller.

◆ setupSchemaVars()

DatabaseInstaller::setupSchemaVars ( )

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

Definition at line 309 of file DatabaseInstaller.php.

References $status, getConnection(), and getSchemaVars().

Referenced by OracleInstaller\createTables(), doUpgrade(), MssqlInstaller\setupDatabase(), MysqlInstaller\setupDatabase(), SqliteInstaller\setupDatabase(), MssqlInstaller\setupUser(), MysqlInstaller\setupUser(), and OracleInstaller\setupUser().

◆ setVar()

◆ setVarsFromRequest()

DatabaseInstaller::setVarsFromRequest (   $varNames)

Convenience function to set variables based on form data.

Assumes that variables containing "password" in the name are (potentially fake) passwords.

Parameters
array$varNames
Returns
array

Definition at line 574 of file DatabaseInstaller.php.

References getName().

Referenced by MssqlInstaller\submitConnectForm(), MysqlInstaller\submitConnectForm(), OracleInstaller\submitConnectForm(), PostgresInstaller\submitConnectForm(), SqliteInstaller\submitConnectForm(), submitInstallUserBox(), MssqlInstaller\submitSettingsForm(), MysqlInstaller\submitSettingsForm(), and submitWebUserBox().

◆ stepApplySourceFile()

DatabaseInstaller::stepApplySourceFile (   $sourceFileMethod,
  $stepName,
  $archiveTableMustNotExist = false 
)
private

Apply a SQL source file to the database as part of running an installation step.

Parameters
string$sourceFileMethod
string$stepName
bool$archiveTableMustNotExist
Returns
Status

Definition at line 173 of file DatabaseInstaller.php.

References $status, DBO_DDLMODE, enableLB(), getConnection(), and getVar().

Referenced by createTables(), and insertUpdateKeys().

◆ submitConnectForm()

DatabaseInstaller::submitConnectForm ( )
abstract

Set variables based on the request array, assuming it was submitted via the form returned by getConnectForm().

Validate the connection settings by attempting to connect with them.

If this is called, $this->parent can be assumed to be a WebInstaller.

Returns
Status

Reimplemented in MssqlInstaller, MysqlInstaller, OracleInstaller, PostgresInstaller, and SqliteInstaller.

◆ submitInstallUserBox()

DatabaseInstaller::submitInstallUserBox ( )

Submit a standard install user fieldset.

Returns
Status

Reimplemented in OracleInstaller.

Definition at line 629 of file DatabaseInstaller.php.

References setVarsFromRequest().

Referenced by MysqlInstaller\submitConnectForm(), and PostgresInstaller\submitConnectForm().

◆ submitSettingsForm()

DatabaseInstaller::submitSettingsForm ( )

Set variables based on the request array, assuming it was submitted via the form return by getSettingsForm().

Returns
Status

Reimplemented in MssqlInstaller, MysqlInstaller, and PostgresInstaller.

Definition at line 118 of file DatabaseInstaller.php.

◆ submitWebUserBox()

DatabaseInstaller::submitWebUserBox ( )

Member Data Documentation

◆ $db

◆ $globalNames

array DatabaseInstaller::$globalNames = []
protected

Array of MW configuration globals this class uses.

Definition at line 60 of file DatabaseInstaller.php.

Referenced by getGlobalNames().

◆ $internalDefaults

array DatabaseInstaller::$internalDefaults = []
protected

Internal variables for installation.

Definition at line 53 of file DatabaseInstaller.php.

Referenced by getInternalDefaults().

◆ $parent

WebInstaller DatabaseInstaller::$parent

The Installer object.

Todo:
Naming this parent is confusing, 'installer' would be clearer.

Definition at line 39 of file DatabaseInstaller.php.

Referenced by __construct().


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