Référence de la classe MysqlChangeItem

Graphe d'héritage de MysqlChangeItem:

Fonctions membres protégées
	buildCheckQuery ()
Fonctions membres protégées hérités de ChangeItem
	buildCheckQuery ()

Fonctions membres privées
	fixInteger ($type1, $type2)
	fixQuote ($string)
	fixUtf8mb4TypeChecks ($type)
	checkNull ($changesArray)
	checkDefault ($changesArray, $type)

Membres hérités additionnels
Fonctions membres publiques hérités de ChangeItem
	__construct ($db, $file, $query)
	check ()
	fix ()
Fonctions membres publiques statiques hérités de ChangeItem
static	getInstance ($db, $file, $query)
Champs de données hérités de ChangeItem
	$file = null
	$updateQuery = null
	$checkQuery = null
	$checkQueryExpected = 1
	$db = null
	$queryType = null
	$msgElements = array()
	$checkStatus = 0
	$rerunStatus = 0

Description détaillée

Checks the database schema against one MySQL DDL query to see if it has been run.

Depuis

2.5

Documentation des fonctions membres

buildCheckQuery()

buildCheckQuery ( )

protected

Checks a DDL query to see if it is a known type If yes, build a check query to see if the DDL has been run on the database. If successful, the $msgElements, $queryType, $checkStatus and $checkQuery fields are populated. The $msgElements contains the text to create the user message. The $checkQuery contains the SQL query to check whether the schema change has been run against the current database. The $queryType contains the type of DDL query that was run (for example, CREATE_TABLE, ADD_COLUMN, CHANGE_COLUMN_TYPE, ADD_INDEX). The $checkStatus field is set to zero if the query is created

If not successful, $checkQuery is empty and , and $checkStatus is -1. For example, this will happen if the current line is a non-DDL statement.

Renvoie

void

Depuis

2.5

When we made the UTF8MB4 conversion then text becomes medium text - so loosen the checks to these two types otherwise (for example) the profile fields profile_value check fails - see https://github.com/joomla/joomla-cms/issues/9258

When we made the UTF8MB4 conversion then text becomes medium text - so loosen the checks to these two types otherwise (for example) the profile fields profile_value check fails - see https://github.com/joomla/joomla-cms/issues/9258

Références $result, $type, ChangeItem\$updateQuery, elseif, et null.

checkDefault()

checkDefault (   $changesArray,   $type  )

private

Create query clause for column changes/modifications for DEFAULT attribute

Paramètres

array	$changesArray	The array of words after COLUMN name
string	$type	The type of the COLUMN

Renvoie

string The query clause for DEFAULT check in the check query

Depuis

3.8.6

Références $type.

checkNull()

checkNull (   $changesArray )

private

Create query clause for column changes/modifications for NULL attribute

Paramètres

array

$changesArray

The array of words after COLUMN name

Renvoie

string The query clause for NULL check in the check query

Depuis

3.8.6

fixInteger()

fixInteger (   $type1,   $type2  )

private

Fix up integer. Fixes problem with MySQL integer descriptions. On MySQL 8 display length is not shown anymore. This means we have to match e.g. both "int(10) unsigned" and "int unsigned", or both "int(11)" and "int" and so on. The same applies to the other integer data types "tinyint", "smallint", "mediumint" and "bigint".

Paramètres

string	$type1	the column type
string	$type2	the column attributes

Renvoie

string The original or changed column type.

Depuis

2.5

Références $result.

fixQuote()

fixQuote (   $string )

private

Fixes up a string for inclusion in a query. Replaces name quote character with normal quote for literal. Drops trailing semicolon. Injects the database prefix.

Paramètres

string

$string

The input string to be cleaned up.

Renvoie

string The modified string.

Depuis

2.5

fixUtf8mb4TypeChecks()

fixUtf8mb4TypeChecks (   $type )

private

Make check query for column changes/modifications tolerant for automatic type changes of text columns, e.g. from TEXT to MEDIUMTEXT, after conversion from utf8 to utf8mb4, and fix integer columns without display length for MySQL 8 (see also function "fixInteger" above).

Paramètres

string

$type

The column type found in the update query

Renvoie

string The condition for type check in the check query

Depuis

3.5

Références $type.

---

La documentation de cette classe a été générée à partir du fichier suivant :

• MysqlChangeItem.php