Wikimedia\Rdbms\MWMySQLPlatform Class Reference

Inherits Wikimedia\Rdbms\Platform\MySQLPlatform.

Collaboration diagram for Wikimedia\Rdbms\MWMySQLPlatform:

Public Member Functions
	getFloatDeclarationSQL (array $column)
Public Member Functions inherited from Wikimedia\Rdbms\Platform\MySQLPlatform
	buildExcludedValue ( $column)
	Build a reference to a column value from the conflicting proposed upsert() row.
	buildIntegerCast ( $field)
	buildStringCast ( $field)
	deleteJoinSqlText ( $delTable, $joinTable, $delVar, $joinVar, $conds)
	ignoreIndexClause ( $index)
	isTransactableQuery (Query $sql)
	Determine whether a SQL statement is sensitive to isolation level.
	lockIsFreeSQLText ( $lockName)
	lockSQLText ( $lockName, $timeout)
	makeLockName ( $lockName)
	unlockSQLText ( $lockName)
	useIndexClause ( $index)
Public Member Functions inherited from Wikimedia\Rdbms\Platform\SQLPlatform
	__construct (DbQuoter $quoter, ?LoggerInterface $logger=null, ?DatabaseDomain $currentDomain=null, $errorLogger=null)
	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.
	assertValidUpsertSetArray (array $set, array $uniqueKey, array $rows)
	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. Parameters string[] $stringList Raw SQL expression list; caller is responsible for escaping Returns string
	buildGreatest ( $fields, $values)
	Build a GREATEST function statement comparing columns/values.Integer and float values in $values will not be quotedIf $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
	buildGroupConcatField ( $delim, $tables, $field, $conds='', $join_conds=[])
	Build a GROUP_CONCAT or equivalent statement for a query.
	buildLeast ( $fields, $values)
	Build a LEAST function statement comparing columns/values.Integer and float values in $values will not be quotedIf $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
	buildLike ( $param,... $params)
	LIKE statement wrapper.
	buildSelectSubquery ( $tables, $vars, $conds='', $fname=__METHOD__, $options=[], $join_conds=[])
	Equivalent to IDatabase::selectSQLText() except wraps the result in Subquery.
	buildSubstring ( $input, $startPosition, $length=null)
	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.
	deleteSqlText ( $table, $conds)
	dispatchingInsertSqlText ( $table, $rows, $options)
	dropTableSqlText ( $table)
	encodeExpiry ( $expiry)
	Encode an expiry time into the DBMS dependent format.
	escapeLikeInternal ( $s, $escapeChar='`')
	extractSingleFieldFromList ( $var)
	extractTableNameComponents (string $name)
	Extract the dot-separated components of a table name, preserving identifier quotation.
	factorConds ( $condsArray)
	Given an array of condition arrays representing an OR list of AND lists, for example:
	fieldNameWithAlias ( $name, $alias=false)
	Get an aliased field name e.g.
	getCurrentDomain ()
	getDatabaseAndTableIdentifier (string $table)
	Get the database identifer and prefixed table name identifier for a table.
	getInfinity ()
	Find out when 'infinity' is.
	getQueryVerb ( $sql)
	getTableAliases ()
	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.
	indexName ( $index)
	Allows for index remapping in queries where this is not consistent across DBMS.
	insertNonConflictingSqlText ( $table, array $rows)
	insertSelectNativeSqlText ( $destTable, $srcTable, array $varMap, $conds, $fname, array $insertOptions, array $selectOptions, $selectJoinConds)
	insertSqlText ( $table, array $rows)
	isFlagInOptions ( $option, array $options)
	isQuotedIdentifier ( $name)
	Returns if the given identifier looks quoted or not according to the database convention for quoting identifiers.
	limitResult ( $sql, $limit, $offset=false)
	Construct a LIMIT query with optional offset.
	makeInsertLists (array $rows, $aliasPrefix='', array $typeByColumn=[])
	Make SQL lists of columns, row tuples, and column aliases for INSERT/VALUES expressions.
	makeKeyCollisionCondition (array $rows, array $uniqueKey)
	Build an SQL condition to find rows with matching key values to those in $rows.
	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.
	normalizeConditions ( $conds, $fname)
	normalizeOptions ( $options)
	normalizeUpsertParams ( $uniqueKeys, &$rows)
	Validate and normalize parameters to upsert() or replace()
	qualifiedTableComponents ( $name)
	Get the table components needed for a query given the currently selected database/schema.
	releaseSavepointSqlText ( $identifier)
	replaceVars ( $ins)
	Database-independent variable replacement.
	rollbackSqlText ()
	rollbackToSavepointSqlText ( $identifier)
	savepointSqlText ( $identifier)
	selectSQLText ( $tables, $vars, $conds='', $fname=__METHOD__, $options=[], $join_conds=[])
	Take the same arguments as IDatabase::select() and return the SQL it would use.
	setCurrentDomain (DatabaseDomain $currentDomain)
	setIndexAliases (array $aliases)
	Convert certain index names to alternative names before querying the DB.
	setPrefix ( $prefix)
	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)
	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. Returns bool
	updateSqlText ( $table, $set, $conds, $options)
Public Member Functions inherited from Wikimedia\Rdbms\Platform\ISQLPlatform
	buildSubString ( $input, $startPosition, $length=null)
	Build a SUBSTRING function.

Additional Inherited Members
Public Attributes inherited from Wikimedia\Rdbms\Platform\ISQLPlatform
const	ALL_ROWS = '*'
	Unconditional update/delete of whole table.
const	CALLER_SUBQUERY = 'subquery'
	Special value for ->caller() / $fname parameter used when providing a caller is not expected, because we're formatting a subquery that won't be executed directly.
const	CALLER_UNKNOWN = 'unknown'
	Special value for ->caller() / $fname parameter used when a caller is not provided.
const	LIST_AND = 1
	Combine list with AND clauses.
const	LIST_COMMA = 0
	Combine list with comma delimiters.
const	LIST_NAMES = 3
	Treat as field name and do not apply value escaping.
const	LIST_OR = 4
	Combine list with OR clauses.
const	LIST_SET = 2
	Convert map into a SET clause.
const	QUERY_CHANGE_LOCKS = 512
	Query is a command for advisory locks.
const	QUERY_CHANGE_NONE = 32
	Query is a read-only Data Query Language query.
const	QUERY_CHANGE_ROWS = 128
	Query is a Data Manipulation Language command (INSERT, DELETE, LOCK, ...)
const	QUERY_CHANGE_SCHEMA = 256
	Query is a Data Definition Language command.
const	QUERY_CHANGE_TRX = 64
	Query is a Transaction Control Language command (BEGIN, USE, SET, ...)
const	QUERY_IGNORE_DBO_TRX = 8
	Ignore the current presence of any DBO_TRX flag.
const	QUERY_NO_RETRY = 16
	Do not try to retry the query if the connection was lost.
const	QUERY_NORMAL = 0
	Idiom for "no special flags".
const	QUERY_PSEUDO_PERMANENT = 2
	Track a TEMPORARY table CREATE as if it was for a permanent table (for testing)
const	QUERY_REPLICA_ROLE = 4
	Enforce that a query does not make effective writes.
const	QUERY_SILENCE_ERRORS = 1
	Ignore query errors and return false when they happen.
Protected Member Functions inherited from Wikimedia\Rdbms\Platform\MySQLPlatform
	getIdentifierQuoteChar ()
	Get the character used for identifier quoting.
	normalizeJoinType (string $joinType)
	Validate and normalize a join type.
Protected Member Functions inherited from Wikimedia\Rdbms\Platform\SQLPlatform
	assertBuildSubstringParams ( $startPosition, $length)
	Check type and bounds for parameters to self::buildSubstring()
	assertValidUpsertRowArray (array $rows, array $uniqueKey)
	buildSuperlative ( $sqlfunc, $fields, $values)
	Build a superlative function statement comparing columns/values.
	fieldNamesWithAlias ( $fields)
	Gets an array of aliased field names.
	getDefaultSchemaVars ()
	Get schema variables to use if none have been set via setSchemaVars().
	getSchemaVars ()
	Get schema variables.
	makeGroupByWithHaving ( $options)
	Returns an optional GROUP BY with an optional HAVING.
	makeInsertNonConflictingVerbAndOptions ()
	makeOrderBy ( $options)
	Returns an optional ORDER BY.
	makeSelectOptions (array $options)
	Returns an optional USE INDEX clause to go after the table, and a string to go at the end of the query.
	makeUpdateOptions ( $options)
	Make UPDATE options for the Database::update function.
	makeUpdateOptionsArray ( $options)
	Make UPDATE options array for Database::makeUpdateOptions.
	normalizeRowArray (array $rowOrRows)
	relationSchemaQualifier ()
	tableNamesWithIndexClauseOrJOIN ( $tables, $use_index=[], $ignore_index=[], $join_conds=[])
	Get the aliased table name clause for a FROM clause which might have a JOIN and/or USE INDEX or IGNORE INDEX clause.
	tableNameWithAlias ( $table, $alias=false)
	Get an aliased table name.
Protected Attributes inherited from Wikimedia\Rdbms\Platform\SQLPlatform
DatabaseDomain null	$currentDomain
callable	$errorLogger
	Error logging callback.
string[]	$indexAliases = []
	Current map of (index alias => index)
LoggerInterface	$logger
DbQuoter	$quoter
array null	$schemaVars
	Current variables use for schema element placeholders.
array[]	$tableAliases = []
	Current map of (table => (dbname, schema, prefix) map)

Detailed Description

Definition at line 7 of file MWMySQLPlatform.php.

Member Function Documentation

getFloatDeclarationSQL()

Wikimedia\Rdbms\MWMySQLPlatform::getFloatDeclarationSQL

(

array

$column

)

Definition at line 12 of file MWMySQLPlatform.php.

---

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

• includes/libs/rdbms/dbal/MWMySQLPlatform.php