Référence de la classe SqlsrvChangeItem

Graphe d'héritage de SqlsrvChangeItem:

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)

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 SQL Server 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

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

fixInteger()

fixInteger (   $type1,   $type2  )

private

Fix up integer. Fixes problem with MySQL integer descriptions. If you change a column to "integer unsigned" it shows as "int(10) unsigned" in the check query.

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

---

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

• SqlsrvChangeItem.php