Interface for query language. More...

Inherited by Wikimedia\Rdbms\IReadableDatabase, and Wikimedia\Rdbms\Platform\SQLPlatform.

Public Member Functions
	addIdentifierQuotes ( $s)
	Escape a SQL identifier (e.g.

	anyChar ()
	Returns a token for `buildLike()` that denotes a '_' to be used in a LIKE query.

	anyString ()
	Returns a token for `buildLike()` that denotes a '' to be used in a LIKE query.

	bitAnd ( $fieldLeft, $fieldRight)

	bitNot ( $field)

	bitOr ( $fieldLeft, $fieldRight)

	buildComparison (string $op, array $conds)
	Build a condition comparing multiple values, for use with indexes that cover multiple fields, common when e.g.

	buildConcat ( $stringList)
	Build a concatenation list to feed into a SQL query.

	buildExcludedValue ( $column)
	Build a reference to a column value from the conflicting proposed upsert() row.

	buildGreatest ( $fields, $values)
	Build a GREATEST function statement comparing columns/values.

	buildGroupConcatField ( $delim, $table, $field, $conds='', $join_conds=[])
	Build a GROUP_CONCAT or equivalent statement for a query.

	buildIntegerCast ( $field)

	buildLeast ( $fields, $values)
	Build a LEAST function statement comparing columns/values.

	buildLike ( $param,... $params)
	LIKE statement wrapper.

	buildSelectSubquery ( $table, $vars, $conds='', $fname=__METHOD__, $options=[], $join_conds=[])
	Equivalent to IDatabase::selectSQLText() except wraps the result in Subquery.

	buildStringCast ( $field)

	buildSubString ( $input, $startPosition, $length=null)
	Build a SUBSTRING function.

	conditional ( $cond, $caseTrueExpression, $caseFalseExpression)
	Returns an SQL expression for a simple conditional.

	decodeExpiry ( $expiry, $format=TS_MW)
	Decode an expiry time into a DBMS independent format.

	encodeExpiry ( $expiry)
	Encode an expiry time into the DBMS dependent format.

	factorConds ( $condsArray)
	Given an array of condition arrays representing an OR list of AND lists, for example:

	getInfinity ()
	Find out when 'infinity' is.

	getTableAliases ()
	Return current table aliases.

	implicitOrderby ()
	Returns true if this database does an implicit order by when the column has an index For example: SELECT page_title FROM page LIMIT 1.

	limitResult ( $sql, $limit, $offset=false)
	Construct a LIMIT query with optional offset.

	makeList (array $a, $mode=self::LIST_COMMA)
	Makes an encoded list of strings from an array.

	makeWhereFrom2d ( $data, $baseKey, $subKey)
	Build a "OR" condition with pairs from a two-dimensional array.

	selectSQLText ( $table, $vars, $conds='', $fname=__METHOD__, $options=[], $join_conds=[])
	Take the same arguments as IDatabase::select() and return the SQL it would use.

	setIndexAliases (array $aliases)
	Convert certain index names to alternative names before querying the DB.

	setSchemaVars ( $vars)
	Set schema variables to be used when streaming commands from SQL files or stdin.

	setTableAliases (array $aliases)
	Make certain table names use their own database, schema, and table prefix when passed into SQL queries pre-escaped and without a qualified database name.

	strreplace ( $orig, $old, $new)
	Returns a SQL expression for simple string replacement (e.g.

	tableName (string $name, $format='quoted')
	Format a table name ready for use in constructing an SQL query.

	tableNames (... $tables)
	Fetch a number of table names into an associative array.

	tableNamesN (... $tables)
	Fetch a number of table names into a zero-indexed numerical array.

	timestamp ( $ts=0)
	Convert a timestamp in one of the formats accepted by `ConvertibleTimestamp` to the format used for inserting into timestamp fields in this DBMS.

	timestampOrNull ( $ts=null)
	Convert a timestamp in one of the formats accepted by ConvertibleTimestamp to the format used for inserting into timestamp fields in this DBMS.

	unionQueries ( $sqls, $all, $options=[])
	Construct a UNION query.

	unionSupportsOrderAndLimit ()
	Determine if the RDBMS supports ORDER BY and LIMIT for separate subqueries within UNION.

Public Attributes
const	QUERY_PSEUDO_PERMANENT = 2
	Track a TEMPORARY table CREATE as if it was for a permanent table (for testing)

Detailed Description

Interface for query language.

Note: This is for simple SQL operations, use query builder classes for building full queries.

Methods of this interface should be only used by rdbms library.

Since: 1.39

Definition at line 34 of file ISQLPlatform.php.

Member Function Documentation

◆ addIdentifierQuotes()

Wikimedia\Rdbms\Platform\ISQLPlatform::addIdentifierQuotes ( $s )

Escape a SQL identifier (e.g.

table, column, database) for use in a SQL query

Depending on the database this will either be backticks or "double quotes"

Parameters

string $s

Returns: string

Since: 1.33

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

Referenced by MediaWiki\Deferred\SiteStatsUpdate\doUpdate().

◆ anyChar()

Wikimedia\Rdbms\Platform\ISQLPlatform::anyChar ( )

Returns a token for buildLike() that denotes a '_' to be used in a LIKE query.

Returns: LikeMatch

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ anyString()

Wikimedia\Rdbms\Platform\ISQLPlatform::anyString ( )

Returns a token for buildLike() that denotes a '' to be used in a LIKE query.

Returns: LikeMatch

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

Referenced by MediaWiki\User\TempUser\Pattern\buildLike(), and DeleteLocalPasswords\processUsers().

◆ bitAnd()

Wikimedia\Rdbms\Platform\ISQLPlatform::bitAnd	(		$fieldLeft,
			$fieldRight )

Parameters

string \| int	$fieldLeft
string \| int	$fieldRight

Returns: string

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ bitNot()

Wikimedia\Rdbms\Platform\ISQLPlatform::bitNot ( $field )

Parameters

string | int $field

Returns: string

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ bitOr()

Wikimedia\Rdbms\Platform\ISQLPlatform::bitOr	(		$fieldLeft,
			$fieldRight )

Parameters

string \| int	$fieldLeft
string \| int	$fieldRight

Returns: string

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ buildComparison()

Wikimedia\Rdbms\Platform\ISQLPlatform::buildComparison	(	string	$op,
		array	$conds )

Build a condition comparing multiple values, for use with indexes that cover multiple fields, common when e.g.

paging through results or doing batch operations.

For example, you might be displaying a list of people ordered alphabetically by their last and first name, split across multiple pages. The first page of the results ended at Jane Doe. When building the query for the next page, you would use:

$queryBuilder->where( $db->buildComparison( '>', [ 'last' => 'Doe', 'first' => 'Jane' ] ) );

This will return people whose last name follows Doe, or whose last name is Doe and first name follows Jane.

Note that the order of keys in the associative array $conds is significant, and must match the order of fields used by the index.

When comparing a single value, prefer using the expression builder:

$db->expr( 'key', '<=', $val )

// equivalent to:
$db->buildComparison( '<=', [ 'key' => $val ] )
'key <= ' . $db->addQuotes( $val )

Parameters

string	$op	Comparison operator, one of '>', '>=', '<', '<='
	non-empty-array<string,mixed>	$conds Map of field names to their values to use in the comparison

Returns: string SQL code

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ buildConcat()

Wikimedia\Rdbms\Platform\ISQLPlatform::buildConcat ( $stringList )

Build a concatenation list to feed into a SQL query.

Parameters

string[] $stringList Raw SQL expression list; caller is responsible for escaping

Returns: string

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, Wikimedia\Rdbms\Platform\PostgresPlatform, Wikimedia\Rdbms\Platform\SqlitePlatform, and Wikimedia\Rdbms\Platform\SQLPlatform.

Referenced by DeleteLocalPasswords\processUsers().

◆ buildExcludedValue()

Wikimedia\Rdbms\Platform\ISQLPlatform::buildExcludedValue ( $column )

Build a reference to a column value from the conflicting proposed upsert() row.

The reference comes in the form of an alias, function, or parenthesized SQL expression. It can be used in upsert() SET expressions to handle the merging of column values between each conflicting pair of existing and proposed rows. Such proposed rows are said to have been "excluded" from insertion in favor of updating the existing row.

This is useful for multi-row upserts() since the proposed values cannot just be included as literals in the SET expressions.

See also: IDatabase::upsert()

Parameters

string $column Column name

Returns: string SQL expression returning a scalar

Since: 1.39

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, Wikimedia\Rdbms\Platform\MySQLPlatform, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ buildGreatest()

Wikimedia\Rdbms\Platform\ISQLPlatform::buildGreatest	(		$fields,
			$values )

Build a GREATEST function statement comparing columns/values.

Integer and float values in $values will not be quoted

If $fields is an array, then each value with a string key is treated as an expression (which must be manually quoted); such string keys do not appear in the SQL and are only descriptive aliases.

Parameters

string \| string[]	$fields	Name(s) of column(s) with values to compare
string \| int \| float \| string[] \| int[] \| float[]	$values	Values to compare

Returns: mixed

Since: 1.35 in IDatabase, moved to ISQLPlatform in 1.39

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, Wikimedia\Rdbms\Platform\SqlitePlatform, and Wikimedia\Rdbms\Platform\SQLPlatform.

Referenced by MediaWiki\Deferred\SiteStatsUpdate\doUpdate().

◆ buildGroupConcatField()

Wikimedia\Rdbms\Platform\ISQLPlatform::buildGroupConcatField	(	$delim,
		$table,
		$field,
		$conds = '',
		$join_conds = [] )

Build a GROUP_CONCAT or equivalent statement for a query.

This is useful for combining a field for several rows into a single string. NULL values will not appear in the output, duplicated values will appear, and the resulting delimiter-separated values have no defined sort order. Code using the results may need to use the PHP unique() or sort() methods.

Parameters

string	$delim	Glue to bind the results together
string \| array	$table	Table name
string	$field	Field name
string \| array	$conds	Conditions
string \| array	$join_conds	Join conditions

Returns: string SQL text

Since: 1.23

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, Wikimedia\Rdbms\Platform\PostgresPlatform, Wikimedia\Rdbms\Platform\SqlitePlatform, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ buildIntegerCast()

Wikimedia\Rdbms\Platform\ISQLPlatform::buildIntegerCast ( $field )

Parameters

string $field Field or column to cast

Returns: string

Since: 1.31 in IDatabase, moved to ISQLPlatform in 1.39

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, Wikimedia\Rdbms\Platform\MySQLPlatform, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ buildLeast()

Wikimedia\Rdbms\Platform\ISQLPlatform::buildLeast	(		$fields,
			$values )

Build a LEAST function statement comparing columns/values.

Integer and float values in $values will not be quoted

If $fields is an array, then each value with a string key is treated as an expression (which must be manually quoted); such string keys do not appear in the SQL and are only descriptive aliases.

Parameters

string \| string[]	$fields	Name(s) of column(s) with values to compare
string \| int \| float \| string[] \| int[] \| float[]	$values	Values to compare

Returns: mixed

Since: 1.35 in IDatabase, moved to ISQLPlatform in 1.39

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, Wikimedia\Rdbms\Platform\SqlitePlatform, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ buildLike()

Wikimedia\Rdbms\Platform\ISQLPlatform::buildLike	(		$param,
			$params )

LIKE statement wrapper.

This takes a variable-length argument list with parts of pattern to match containing either string literals that will be escaped or tokens returned by anyChar() or anyString(). Alternatively, the function could be provided with an array of the aforementioned parameters.

Example: $dbr->buildLike( 'My_page_title/', $dbr->anyString() ) returns a LIKE clause that searches for subpages of 'My page title'. Alternatively: $pattern = [ 'My_page_title/', $dbr->anyString() ]; $query .= $dbr->buildLike( $pattern );

Since: 1.16 in IDatabase, moved to ISQLPlatform in 1.39

Parameters

array[] \| string \| LikeMatch	$param
	string\|LikeMatch	...$params

Returns: string Fully built LIKE statement

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

Referenced by MediaWiki\User\TempUser\Pattern\buildLike(), and DeleteLocalPasswords\processUsers().

◆ buildSelectSubquery()

Wikimedia\Rdbms\Platform\ISQLPlatform::buildSelectSubquery	(	$table,
		$vars,
		$conds = '',
		$fname = __METHOD__,
		$options = [],
		$join_conds = [] )

Equivalent to IDatabase::selectSQLText() except wraps the result in Subquery.

See also: IDatabase::selectSQLText()

Parameters

string \| array	$table	Table name
string \| array	$vars	Field names
string \| array	$conds	Conditions
string	$fname	Caller function name
string \| array	$options	Query options
string \| array	$join_conds	Join conditions

Returns: Subquery

Since: 1.31

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ buildStringCast()

Wikimedia\Rdbms\Platform\ISQLPlatform::buildStringCast ( $field )

Parameters

string $field Field or column to cast

Returns: string

Since: 1.28 in IDatabase, moved to ISQLPlatform in 1.39

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, Wikimedia\Rdbms\Platform\MySQLPlatform, Wikimedia\Rdbms\Platform\PostgresPlatform, Wikimedia\Rdbms\Platform\SqlitePlatform, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ buildSubString()

Wikimedia\Rdbms\Platform\ISQLPlatform::buildSubString	(	$input,
		$startPosition,
		$length = null )

Build a SUBSTRING function.

Behavior for non-ASCII values is undefined.

Parameters

string	$input	Field name
int	$startPosition	Positive integer
int \| null	$length	Non-negative integer length or null for no limit

Exceptions

\InvalidArgumentException

Returns: string SQL text

Since: 1.31 in IDatabase, moved to ISQLPlatform in 1.39

Referenced by DeleteLocalPasswords\processUsers().

◆ conditional()

Wikimedia\Rdbms\Platform\ISQLPlatform::conditional	(	$cond,
		$caseTrueExpression,
		$caseFalseExpression )

Returns an SQL expression for a simple conditional.

This doesn't need to be overridden unless CASE isn't supported in the RDBMS.

Parameters

string \| array \| IExpression	$cond	SQL condition expression (yields a boolean)
string	$caseTrueExpression	SQL expression to return when the condition is true
string	$caseFalseExpression	SQL expression to return when the condition is false

Returns: string SQL fragment

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ decodeExpiry()

Wikimedia\Rdbms\Platform\ISQLPlatform::decodeExpiry	(		$expiry,
			$format = TS_MW )

Decode an expiry time into a DBMS independent format.

Parameters

string	$expiry	DB timestamp field value for expiry
int	$format	TS_* constant, defaults to TS_MW

Returns: string

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

Referenced by MediaWiki\Block\DatabaseBlockStore\newFromRow().

◆ encodeExpiry()

Wikimedia\Rdbms\Platform\ISQLPlatform::encodeExpiry ( $expiry )

Encode an expiry time into the DBMS dependent format.

Parameters

string $expiry Timestamp for expiry, or the 'infinity' string

Returns: string

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ factorConds()

Wikimedia\Rdbms\Platform\ISQLPlatform::factorConds ( $condsArray )

Given an array of condition arrays representing an OR list of AND lists, for example:

(A=1 AND B=2) OR (A=1 AND B=3)

produce an SQL expression in which the conditions are factored:

(A=1 AND (B=2 OR B=3))

We also use IN() to simplify further:

(A=1 AND (B IN (2,3))

More compactly, in boolean algebra notation, a sum of products, e.g. AB + AC is factored to produce A(B+C). Factoring proceeds recursively to reduce expressions with any number of variables, for example AEP + AEQ + AFP + AFQ = A(E(P+Q) + F(P+Q))

The algorithm is simple and will not necessarily find the shortest possible expression. For the best results, fields should be given in a consistent order, and the fields with values likely to be shared should be leftmost in the associative arrays.

Parameters

array $condsArray An array of associative arrays. The associative array keys represent field names, and the values represent the field values to compare against.

Returns: string SQL expression fragment

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

Referenced by MediaWiki\Deferred\LinksUpdate\LinksTable\doWrites().

◆ getInfinity()

Wikimedia\Rdbms\Platform\ISQLPlatform::getInfinity ( )

Find out when 'infinity' is.

Most DBMSes support this. This is a special keyword for timestamps in PostgreSQL, and works with CHAR(14) as well because "i" sorts after all numbers.

Returns: string

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ getTableAliases()

Wikimedia\Rdbms\Platform\ISQLPlatform::getTableAliases ( )

Return current table aliases.

Access: internal: only to be used inside rdbms library

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ implicitOrderby()

Wikimedia\Rdbms\Platform\ISQLPlatform::implicitOrderby ( )

Returns true if this database does an implicit order by when the column has an index For example: SELECT page_title FROM page LIMIT 1.

Returns: bool

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, Wikimedia\Rdbms\Platform\PostgresPlatform, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ limitResult()

Wikimedia\Rdbms\Platform\ISQLPlatform::limitResult	(	$sql,
		$limit,
		$offset = false )

Construct a LIMIT query with optional offset.

The SQL should be adjusted so that only the first $limit rows are returned. If $offset is provided as well, then the first $offset rows should be discarded, and the next $limit rows should be returned. If the result of the query is not ordered, then the rows to be returned are theoretically arbitrary.

$sql is expected to be a SELECT, if that makes a difference.

Parameters

string	$sql	SQL query we will append the limit too
int	$limit	The SQL limit
int \| false	$offset	The SQL offset (default false)

Returns: string

Since: 1.34 in IDatabase, moved to ISQLPlatform in 1.39

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, Wikimedia\Rdbms\Platform\PostgresPlatform, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ makeList()

Wikimedia\Rdbms\Platform\ISQLPlatform::makeList	(	array	$a,
			$mode = self::LIST_COMMA )

Makes an encoded list of strings from an array.

These can be used to make conjunctions or disjunctions on SQL condition strings derived from an array ({

See also: IDatabase::select} $conds documentation).

Example usage:

$sql = $db->makeList( [
    'rev_page' => $id,
    $db->makeList( [ 'rev_minor' => 1, 'rev_len < 500' ], $db::LIST_OR )
], $db::LIST_AND );

This would set $sql to "rev_page = '$id' AND (rev_minor = 1 OR rev_len < 500)"

Parameters

array	$a	Containing the data
int	$mode	IDatabase class constant: IDatabase::LIST_COMMA: Comma separated, no field names IDatabase::LIST_AND: ANDed WHERE clause (without the WHERE). IDatabase::LIST_OR: ORed WHERE clause (without the WHERE) IDatabase::LIST_SET: Comma separated with field names, like a SET clause IDatabase::LIST_NAMES: Comma separated field names

Exceptions

DBError If an error occurs, {

See also: IDatabase::query}

Returns: string

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

Referenced by Wikimedia\Rdbms\Replication\MysqlReplicationReporter\fetchSecondsSinceHeartbeat(), MediaWiki\User\ActorMigrationBase\getWhere(), and MediaWiki\Specials\SpecialWatchlist\registerFilters().

◆ makeWhereFrom2d()

Wikimedia\Rdbms\Platform\ISQLPlatform::makeWhereFrom2d	(	$data,
		$baseKey,
		$subKey )

Build a "OR" condition with pairs from a two-dimensional array.

The associative array should have integer keys relating to the $baseKey field. The nested array should have string keys for the $subKey field. The inner values are ignored, and are typically boolean true.

Example usage:

$data = [
    2 => [
        'Foo' => true,
        'Bar' => true,
    ],
    3 => [
        'Quux' => true,
    ],
];
// (page_namespace = 2 AND page_title IN ('Foo','Bar'))
// OR (page_namespace = 3 AND page_title = 'Quux')

Todo: This is effectively specific to MediaWiki's LinkBatch. Consider deprecating or generalising slightly.

Parameters

array	$data	Nested array, must be non-empty
string	$baseKey	Field name to match the base-level keys to (eg 'pl_namespace')
string	$subKey	Field name to match the sub-level keys to (eg 'pl_title')

Returns: string SQL fragment

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ selectSQLText()

Wikimedia\Rdbms\Platform\ISQLPlatform::selectSQLText	(	$table,
		$vars,
		$conds = '',
		$fname = __METHOD__,
		$options = [],
		$join_conds = [] )

Take the same arguments as IDatabase::select() and return the SQL it would use.

This can be useful for making UNION queries, where the SQL text of each query is needed. In general, however, callers outside of Database classes should just use select().

See also: IDatabase::select()

Parameters

string \| array	$table	Table name(s)
string \| array	$vars	Field names
string \| array	$conds	Conditions
string	$fname	Caller function name
string \| array	$options	Query options
string \| array	$join_conds	Join conditions

Returns: string SQL query string

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DatabaseMySQL, Wikimedia\Rdbms\DBConnRef, Wikimedia\Rdbms\Platform\PostgresPlatform, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ setIndexAliases()

Wikimedia\Rdbms\Platform\ISQLPlatform::setIndexAliases ( array $aliases )

Convert certain index names to alternative names before querying the DB.

Note that this applies to indexes regardless of the table they belong to.

This can be employed when an index was renamed X => Y in code, but the new Y-named indexes were not yet built on all DBs. After all the Y-named ones are added by the DBA, the aliases can be removed, and then the old X-named indexes dropped.

Parameters

string[] $aliases

Since: 1.31 in IDatabase, moved to ISQLPlatform in 1.39

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ setSchemaVars()

Wikimedia\Rdbms\Platform\ISQLPlatform::setSchemaVars ( $vars )

Set schema variables to be used when streaming commands from SQL files or stdin.

Variables appear as SQL comments and are substituted by their corresponding values

Parameters

array | null $vars Map of (variable => value) or null to use the defaults

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ setTableAliases()

Wikimedia\Rdbms\Platform\ISQLPlatform::setTableAliases ( array $aliases )

Make certain table names use their own database, schema, and table prefix when passed into SQL queries pre-escaped and without a qualified database name.

For example, "user" can be converted to "myschema.mydbname.user" for convenience. Appearances like user, somedb.user, somedb.someschema.user will used literally.

Calling this twice will completely clear any old table aliases. Also, note that callers are responsible for making sure the schemas and databases actually exist.

Parameters

array[] $aliases Map of (table => (dbname, schema, prefix) map)

Since: 1.28 in IDatabase, moved to ISQLPlatform in 1.39

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DatabaseSqlite, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ strreplace()

Wikimedia\Rdbms\Platform\ISQLPlatform::strreplace	(	$orig,
		$old,
		$new )

Returns a SQL expression for simple string replacement (e.g.

REPLACE() in mysql)

Parameters

string	$orig	Column to modify
string	$old	Column to seek
string	$new	Column to replace with

Returns: string

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ tableName()

Wikimedia\Rdbms\Platform\ISQLPlatform::tableName	(	string	$name,
			$format = 'quoted' )

Format a table name ready for use in constructing an SQL query.

This does two important things: it quotes the table names to clean them up, and it adds a table prefix if only given a table name with no quotes.

All functions of this object which require a table name call this function themselves. Pass the canonical name to such functions. This is only needed when calling query() directly.

Note: This function does not sanitize user input. It is not safe to use this function to escape user input.

Parameters

string	$name	Database table name
string	$format	One of: quoted - Automatically pass the table name through addIdentifierQuotes() so that it can be used in a query. raw - Do not add identifier quotes to the table name

Returns: string Full database name

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\Platform\SqlitePlatform, and Wikimedia\Rdbms\Platform\SQLPlatform.

Referenced by SqlBagOStuff\createTables().

◆ tableNames()

Wikimedia\Rdbms\Platform\ISQLPlatform::tableNames ( $tables )

Fetch a number of table names into an associative array.

Much like tableName(), this is only needed when calling query() directly. Prefer calling other methods, or using SelectQueryBuilder.

Theoretical example (which really does not require raw SQL):

[ 'user' => $user, 'watchlist' => $watchlist ] =
    $dbr->tableNames( 'user', 'watchlist' );
$sql = "SELECT wl_namespace, wl_title FROM $watchlist, $user
        WHERE wl_user=user_id AND wl_user=$nameWithQuotes";

Parameters

string ...$tables

Returns: array

Deprecated: since 1.39; if you must format table names, write several calls to tableName or use tableNamesN instead of calling this function.

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ tableNamesN()

Wikimedia\Rdbms\Platform\ISQLPlatform::tableNamesN ( $tables )

Fetch a number of table names into a zero-indexed numerical array.

Much like tableName(), this is only needed when calling query() directly. It is slightly more convenient than tableNames(), but you should still prefer calling other methods, or using SelectQueryBuilder.

Theoretical example (which really does not require raw SQL):

[ $user, $watchlist ] = $dbr->tableNamesN( 'user', 'watchlist' );
$sql = "SELECT wl_namespace,wl_title FROM $watchlist,$user
        WHERE wl_user=user_id AND wl_user=$nameWithQuotes";

Parameters

string ...$tables

Returns: array

Deprecated: Since 1.43; if you must format table names, write several calls to tableName.

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ timestamp()

Wikimedia\Rdbms\Platform\ISQLPlatform::timestamp ( $ts = 0 )

Convert a timestamp in one of the formats accepted by ConvertibleTimestamp to the format used for inserting into timestamp fields in this DBMS.

The result is unquoted, and needs to be passed through addQuotes() before it can be included in raw SQL.

Parameters

string | int $ts

Returns: string

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, Wikimedia\Rdbms\Platform\PostgresPlatform, and Wikimedia\Rdbms\Platform\SQLPlatform.

Referenced by MediaWiki\User\User\addToDatabase(), LocalFile\getHistory(), JobQueueDB\insertFields(), MediaWiki\Title\Title\invalidateCache(), PurgeJobUtils\invalidatePages(), MediaWiki\User\User\makeUpdateConditions(), MediaWiki\Block\DatabaseBlockStore\purgeExpiredBlocks(), MediaWiki\Title\Title\purgeExpiredRestrictions(), MediaWiki\SpecialPage\QueryPage\recache(), MediaWiki\User\User\saveSettings(), and MediaWiki\Revision\RevisionStore\userWasLastToEdit().

◆ timestampOrNull()

Wikimedia\Rdbms\Platform\ISQLPlatform::timestampOrNull ( $ts = null )

Convert a timestamp in one of the formats accepted by ConvertibleTimestamp to the format used for inserting into timestamp fields in this DBMS.

If NULL is input, it is passed through, allowing NULL values to be inserted into timestamp fields.

The result is unquoted, and needs to be passed through addQuotes() before it can be included in raw SQL.

Parameters

string | int | null $ts

Returns: string|null

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, and Wikimedia\Rdbms\Platform\SQLPlatform.

Referenced by MediaWiki\User\User\addToDatabase(), and MediaWiki\User\User\saveSettings().

◆ unionQueries()

Wikimedia\Rdbms\Platform\ISQLPlatform::unionQueries	(	$sqls,
		$all,
		$options = [] )

Construct a UNION query.

This is used for providing overload point for other DB abstractions not compatible with the MySQL syntax.

Access: internal: callers outside of rdbms library should use UnionQueryBuilder instead.

Parameters

array	$sqls	SQL statements to combine
bool	$all	Either `IDatabase::UNION_ALL` or `IDatabase::UNION_DISTINCT`
array	$options	Query options

Returns: string SQL fragment

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, Wikimedia\Rdbms\Platform\SqlitePlatform, and Wikimedia\Rdbms\Platform\SQLPlatform.

◆ unionSupportsOrderAndLimit()

Wikimedia\Rdbms\Platform\ISQLPlatform::unionSupportsOrderAndLimit ( )

Determine if the RDBMS supports ORDER BY and LIMIT for separate subqueries within UNION.

Returns: bool

Implemented in Wikimedia\Rdbms\Database, Wikimedia\Rdbms\DBConnRef, Wikimedia\Rdbms\Platform\SqlitePlatform, and Wikimedia\Rdbms\Platform\SQLPlatform.

Member Data Documentation

◆ QUERY_PSEUDO_PERMANENT

const Wikimedia\Rdbms\Platform\ISQLPlatform::QUERY_PSEUDO_PERMANENT = 2

Track a TEMPORARY table CREATE as if it was for a permanent table (for testing)

Definition at line 55 of file ISQLPlatform.php.

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

includes/libs/rdbms/platform/ISQLPlatform.php

Public Member Functions

Public Attributes

Detailed Description

Member Function Documentation

◆ addIdentifierQuotes()

◆ anyChar()

◆ anyString()

◆ bitAnd()

◆ bitNot()

◆ bitOr()

◆ buildComparison()

◆ buildConcat()

◆ buildExcludedValue()

◆ buildGreatest()

◆ buildGroupConcatField()

◆ buildIntegerCast()

◆ buildLeast()

◆ buildLike()

◆ buildSelectSubquery()

◆ buildStringCast()

◆ buildSubString()

◆ conditional()

◆ decodeExpiry()

◆ encodeExpiry()

◆ factorConds()

◆ getInfinity()

◆ getTableAliases()

◆ implicitOrderby()

◆ limitResult()

◆ makeList()

◆ makeWhereFrom2d()

◆ selectSQLText()

◆ setIndexAliases()

◆ setSchemaVars()

◆ setTableAliases()

◆ strreplace()

◆ tableName()

◆ tableNames()

◆ tableNamesN()

◆ timestamp()

◆ timestampOrNull()

◆ unionQueries()

◆ unionSupportsOrderAndLimit()

Member Data Documentation

◆ QUERY_PSEUDO_PERMANENT