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

Inheritance diagram for DatabaseInstaller:

[legend]

Collaboration diagram for DatabaseInstaller:

[legend]

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	$attribs	Optional.
string	$helpData	Optional.

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

Connect to the database using the administrative user/password currently defined in the session.

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

This will return a cached connection if one is available.

Returns: Status

Reimplemented in PostgresInstaller.

Definition at line 149 of file DatabaseInstaller.php.

References $status, DBO_TRX, and openConnection().

Referenced by MssqlInstaller\canCreateAccounts(), MysqlInstaller\canCreateAccounts(), createExtensionTables(), enableLB(), MysqlInstaller\getEngines(), needsUpgrade(), populateInterwikiTable(), Installer\populateSiteStats(), MssqlInstaller\preUpgrade(), MysqlInstaller\preUpgrade(), MssqlInstaller\setupDatabase(), MysqlInstaller\setupDatabase(), SqliteInstaller\setupDatabase(), setupSchemaVars(), MssqlInstaller\setupUser(), MysqlInstaller\setupUser(), OracleInstaller\setupUser(), stepApplySourceFile(), MssqlInstaller\submitConnectForm(), MysqlInstaller\submitConnectForm(), and OracleInstaller\submitConnectForm().

◆ 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 $params Parameters 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().

◆ getWebUserBox()

DatabaseInstaller::getWebUserBox ( $noCreateMsg = false )

Get a standard web-user fieldset.

Parameters

string | bool $noCreateMsg Message 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()

DatabaseInstaller::setVar	(	$name,
		$value
	)

Convenience alias for $this->parent->setVar()

Parameters

string	$name
mixed	$value

Definition at line 468 of file DatabaseInstaller.php.

References $name, and $value.

Referenced by MysqlInstaller\getSettingsForm(), MysqlInstaller\preUpgrade(), SqliteInstaller\setupDatabase(), MssqlInstaller\submitConnectForm(), PostgresInstaller\submitConnectForm(), SqliteInstaller\submitConnectForm(), MssqlInstaller\submitSettingsForm(), MysqlInstaller\submitSettingsForm(), PostgresInstaller\submitSettingsForm(), and submitWebUserBox().

◆ 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 ( )

Submit the form from getWebUserBox().

Returns: Status

Definition at line 669 of file DatabaseInstaller.php.

References getVar(), setVar(), and setVarsFromRequest().

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

Member Data Documentation

◆ $db

Database DatabaseInstaller::$db = null

The database connection.

Definition at line 46 of file DatabaseInstaller.php.

Referenced by getSqlFilePath(), MssqlInstaller\openConnection(), MysqlInstaller\openConnection(), OracleInstaller\openConnection(), PostgresInstaller\openConnectionToAnyDB(), PostgresInstaller\openConnectionWithParams(), and OracleInstaller\openSYSDBAConnection().

◆ $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:

includes/installer/DatabaseInstaller.php

Public Member Functions

Public Attributes

Static Protected Member Functions

Protected Attributes

Private Member Functions

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ checkExtension()

◆ checkPrerequisites()

◆ createExtensionTables()

◆ createTables()

◆ doUpgrade()

◆ enableLB()

◆ getCheckBox()

◆ getConnectForm()

◆ getConnection()

◆ getGlobalDefaults()

◆ getGlobalNames()

◆ getInstallUserBox()

◆ getInternalDefaults()

◆ getLocalSettings()

◆ getName()

◆ getPasswordBox()

◆ getRadioSet()

◆ getReadableName()

◆ getSchemaPath()

◆ getSchemaVars()

◆ getSettingsForm()

◆ getSqlFilePath()

◆ getTextBox()

◆ getUpdateKeysPath()

◆ getVar()

◆ getWebUserBox()

◆ insertUpdateKeys()

◆ isCompiled()

◆ needsUpgrade()

◆ openConnection()

◆ outputHandler()

◆ populateInterwikiTable()

◆ preInstall()

◆ preUpgrade()

◆ setupDatabase()

◆ setupSchemaVars()

◆ setVar()

◆ setVarsFromRequest()

◆ stepApplySourceFile()

◆ submitConnectForm()

◆ submitInstallUserBox()

◆ submitSettingsForm()

◆ submitWebUserBox()

Member Data Documentation

◆ $db

◆ $globalNames

◆ $internalDefaults

◆ $parent