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

Public Attributes

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

Static Protected Member Functions

static checkExtension ( $name)
 Convenience function. More...
 

Protected Attributes

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

Private Member Functions

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

Detailed Description

Base class for DBMS-specific installation helper classes.

Since
1.17

Definition at line 33 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 400 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 411 of file DatabaseInstaller.php.

References $name.

Referenced by SqliteInstaller\isCompiled(), OracleInstaller\isCompiled(), PostgresInstaller\isCompiled(), MysqlInstaller\isCompiled(), and MssqlInstaller\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 80 of file DatabaseInstaller.php.

References StatusValue\newGood().

◆ createExtensionTables()

DatabaseInstaller::createExtensionTables ( )

Create the tables for each extension the user enabled.

Returns
Status

Definition at line 278 of file DatabaseInstaller.php.

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

◆ createTables()

DatabaseInstaller::createTables ( )

Create database tables from scratch.

Returns
Status

Reimplemented in MssqlInstaller, PostgresInstaller, SqliteInstaller, and OracleInstaller.

Definition at line 220 of file DatabaseInstaller.php.

References stepApplySourceFile().

◆ doUpgrade()

DatabaseInstaller::doUpgrade ( )

Perform database upgrades.

Returns
bool

Definition at line 349 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 329 of file DatabaseInstaller.php.

References $services, $status, getConnection(), 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 536 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 SqliteInstaller, MssqlInstaller, MysqlInstaller, PostgresInstaller, and OracleInstaller.

◆ 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 429 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 391 of file DatabaseInstaller.php.

References $globalNames.

Referenced by getGlobalDefaults().

◆ getInstallUserBox()

DatabaseInstaller::getInstallUserBox ( )

◆ getInternalDefaults()

DatabaseInstaller::getInternalDefaults ( )

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

Returns
array

Definition at line 443 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, PostgresInstaller, SqliteInstaller, and OracleInstaller.

◆ getName()

DatabaseInstaller::getName ( )
abstract

Return the internal name, e.g.

'mysql', or 'sqlite'.

Reimplemented in MssqlInstaller, MysqlInstaller, PostgresInstaller, OracleInstaller, 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 510 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 562 of file DatabaseInstaller.php.

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

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

◆ getReadableName()

DatabaseInstaller::getReadableName ( )

Get the internationalised name for this DBMS.

Returns
string

Definition at line 419 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 259 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 302 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 111 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 241 of file DatabaseInstaller.php.

References $db, $IP, Wikimedia\Rdbms\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 483 of file DatabaseInstaller.php.

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

Referenced by OracleInstaller\getConnectForm(), PostgresInstaller\getConnectForm(), MysqlInstaller\getConnectForm(), MssqlInstaller\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 270 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 453 of file DatabaseInstaller.php.

References getGlobalDefaults(), and getInternalDefaults().

Referenced by MssqlInstaller\canCreateAccounts(), MysqlInstaller\canCreateAccounts(), PostgresInstaller\canCreateObjectsForWebUser(), OracleInstaller\createTables(), PostgresInstaller\createTables(), MssqlInstaller\createTables(), getCheckBox(), OracleInstaller\getConnectForm(), MssqlInstaller\getConnectForm(), PostgresInstaller\getInstallUserPermissions(), OracleInstaller\getLocalSettings(), SqliteInstaller\getLocalSettings(), PostgresInstaller\getLocalSettings(), MysqlInstaller\getLocalSettings(), MssqlInstaller\getLocalSettings(), getPasswordBox(), getRadioSet(), OracleInstaller\getSchemaVars(), MysqlInstaller\getSchemaVars(), MssqlInstaller\getSchemaVars(), MysqlInstaller\getSettingsForm(), MssqlInstaller\getSettingsForm(), MysqlInstaller\getTableOptions(), getTextBox(), getWebUserBox(), SqliteInstaller\needsUpgrade(), OracleInstaller\needsUpgrade(), MysqlInstaller\openConnection(), OracleInstaller\openConnection(), SqliteInstaller\openConnection(), MssqlInstaller\openConnection(), PostgresInstaller\openConnectionToAnyDB(), PostgresInstaller\openConnectionWithParams(), PostgresInstaller\openPgConnection(), OracleInstaller\openSYSDBAConnection(), populateInterwikiTable(), PostgresInstaller\preInstall(), MysqlInstaller\preUpgrade(), MssqlInstaller\preUpgrade(), PostgresInstaller\preUpgrade(), SqliteInstaller\setupDatabase(), PostgresInstaller\setupDatabase(), MssqlInstaller\setupDatabase(), MysqlInstaller\setupDatabase(), PostgresInstaller\setupPLpgSQL(), PostgresInstaller\setupSchema(), OracleInstaller\setupUser(), MysqlInstaller\setupUser(), MssqlInstaller\setupUser(), PostgresInstaller\setupUser(), stepApplySourceFile(), PostgresInstaller\submitConnectForm(), OracleInstaller\submitConnectForm(), SqliteInstaller\submitConnectForm(), OracleInstaller\submitInstallUserBox(), PostgresInstaller\submitSettingsForm(), MssqlInstaller\submitSettingsForm(), MysqlInstaller\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 644 of file DatabaseInstaller.php.

References $s, Html\closeElement(), Html\element(), getCheckBox(), getPasswordBox(), getTextBox(), getVar(), Html\openElement(), plain, text, and wfMessage().

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

◆ insertUpdateKeys()

DatabaseInstaller::insertUpdateKeys ( )

Insert update keys into table to prevent running unneded updates.

Returns
Status

Definition at line 229 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, PostgresInstaller, OracleInstaller, 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 590 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, SqliteInstaller, OracleInstaller, MysqlInstaller, and PostgresInstaller.

Referenced by getConnection().

◆ outputHandler()

DatabaseInstaller::outputHandler (   $string)

Definition at line 730 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 693 of file DatabaseInstaller.php.

References $IP, $status, as, file, getConnection(), getVar(), global, StatusValue\newFatal(), and StatusValue\newGood().

◆ 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 MysqlInstaller, MssqlInstaller, PostgresInstaller, and OracleInstaller.

Definition at line 378 of file DatabaseInstaller.php.

◆ preUpgrade()

DatabaseInstaller::preUpgrade ( )

Allow DB installers a chance to make checks before upgrade.

Reimplemented in PostgresInstaller, MssqlInstaller, and MysqlInstaller.

Definition at line 384 of file DatabaseInstaller.php.

◆ setupDatabase()

DatabaseInstaller::setupDatabase ( )
abstract

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

Returns
Status

Reimplemented in MysqlInstaller, MssqlInstaller, PostgresInstaller, OracleInstaller, 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 312 of file DatabaseInstaller.php.

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

Referenced by OracleInstaller\createTables(), doUpgrade(), SqliteInstaller\setupDatabase(), MssqlInstaller\setupDatabase(), MysqlInstaller\setupDatabase(), OracleInstaller\setupUser(), MysqlInstaller\setupUser(), and MssqlInstaller\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 576 of file DatabaseInstaller.php.

References getName().

Referenced by PostgresInstaller\submitConnectForm(), OracleInstaller\submitConnectForm(), MysqlInstaller\submitConnectForm(), SqliteInstaller\submitConnectForm(), MssqlInstaller\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 176 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, SqliteInstaller, MysqlInstaller, OracleInstaller, and PostgresInstaller.

◆ submitInstallUserBox()

DatabaseInstaller::submitInstallUserBox ( )

Submit a standard install user fieldset.

Returns
Status

Reimplemented in OracleInstaller.

Definition at line 631 of file DatabaseInstaller.php.

References StatusValue\newGood(), and setVarsFromRequest().

Referenced by PostgresInstaller\submitConnectForm(), and MysqlInstaller\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 MysqlInstaller, MssqlInstaller, and PostgresInstaller.

Definition at line 121 of file DatabaseInstaller.php.

References StatusValue\newGood().

◆ submitWebUserBox()

Member Data Documentation

◆ $db

◆ $globalNames

array DatabaseInstaller::$globalNames = []
protected

Array of MW configuration globals this class uses.

Definition at line 63 of file DatabaseInstaller.php.

Referenced by getGlobalNames().

◆ $internalDefaults

array DatabaseInstaller::$internalDefaults = []
protected

Internal variables for installation.

Definition at line 56 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 42 of file DatabaseInstaller.php.

Referenced by __construct().


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