TYPO3\CMS\Dbal\Database\SqlCompilers\Mysql Class Reference

Inheritance diagram for TYPO3\CMS\Dbal\Database\SqlCompilers\Mysql:

Public Member Functions
	compileFieldList ($selectFields, $compileComments=true, $functionMapping=true)
	compileFieldCfg ($fieldCfg)
	compileWhereClause ($clauseArray, $functionMapping=true)
Public Member Functions inherited from TYPO3\CMS\Dbal\Database\SqlCompilers\AbstractCompiler
	__construct (DatabaseConnection $databaseConnection)
	compileSQL ($components)
	compileFieldList ($selectFields, $compileComments=true, $functionMapping=true)
	compileWhereClause ($clauseArray, $functionMapping=true)
	compileFromTables ($tablesArray)

Protected Member Functions
	compileINSERT ($components)
	compileCREATETABLE ($components)
	compileALTERTABLE ($components)
	compileAddslashes ($str)
Protected Member Functions inherited from TYPO3\CMS\Dbal\Database\SqlCompilers\AbstractCompiler
	compileSELECT ($components)
	compileUPDATE ($components)
	compileINSERT ($components)
	compileDELETE ($components)
	compileCREATETABLE ($components)
	compileALTERTABLE ($components)
	compileTRUNCATETABLE (array $components)
	compileAddslashes ($str)
	compileJoinIdentifier ($identifierParts)
	compileCaseStatement (array $components, $functionMapping=true)

Additional Inherited Members
Protected Attributes inherited from TYPO3\CMS\Dbal\Database\SqlCompilers\AbstractCompiler
	$databaseConnection

Detailed Description

SQL Compiler for native MySQL connections

Definition at line 22 of file Mysql.php.

Member Function Documentation

compileAddslashes()

TYPO3\CMS\Dbal\Database\SqlCompilers\Mysql::compileAddslashes (   $str )

protected

Add slashes function used for compiling queries This method overrides the method from because the input string is already properly escaped.

Parameters

string

$str

Input string

Returns

string Output string

Definition at line 188 of file Mysql.php.

Referenced by TYPO3\CMS\Dbal\Database\SqlCompilers\Mysql\compileFieldCfg(), TYPO3\CMS\Dbal\Database\SqlCompilers\Mysql\compileINSERT(), and TYPO3\CMS\Dbal\Database\SqlCompilers\Mysql\compileWhereClause().

compileALTERTABLE()

TYPO3\CMS\Dbal\Database\SqlCompilers\Mysql::compileALTERTABLE (   $components )

protected

Compiles an ALTER TABLE statement from components array

Parameters

array

$components

Array of SQL query components

Returns

string SQL ALTER TABLE query

See also

parseALTERTABLE()

Definition at line 100 of file Mysql.php.

References TYPO3\CMS\Dbal\Database\SqlCompilers\Mysql\compileFieldCfg(), and TYPO3\CMS\Dbal\Database\SqlParser\normalizeKeyword().

compileCREATETABLE()

TYPO3\CMS\Dbal\Database\SqlCompilers\Mysql::compileCREATETABLE (   $components )

protected

Compiles a CREATE TABLE statement from components array

Parameters

array

$components

Array of SQL query components

Returns

string SQL CREATE TABLE query

See also

parseCREATETABLE()

Definition at line 65 of file Mysql.php.

References TYPO3\CMS\Dbal\Database\SqlCompilers\Mysql\compileFieldCfg().

compileFieldCfg()

TYPO3\CMS\Dbal\Database\SqlCompilers\Mysql::compileFieldCfg

(

$fieldCfg

)

Compile field definition

Parameters

array

$fieldCfg

Field definition parts

Returns

string Field definition string

Definition at line 202 of file Mysql.php.

References TYPO3\CMS\Dbal\Database\SqlCompilers\Mysql\compileAddslashes().

Referenced by TYPO3\CMS\Dbal\Database\SqlCompilers\Mysql\compileALTERTABLE(), and TYPO3\CMS\Dbal\Database\SqlCompilers\Mysql\compileCREATETABLE().

compileFieldList()

TYPO3\CMS\Dbal\Database\SqlCompilers\Mysql::compileFieldList	(		$selectFields,
			$compileComments = true,
			$functionMapping = true
	)

Compiles a "SELECT [output] FROM..:" field list based on input array (made with ->parseFieldList()) Can also compile field lists for ORDER BY and GROUP BY.

Parameters

array	$selectFields	Array of select fields, (made with ->parseFieldList())
bool	$compileComments	Whether comments should be compiled
bool	$functionMapping

Returns

string Select field string

See also

parseFieldList()

Definition at line 141 of file Mysql.php.

References TYPO3\CMS\Dbal\Database\SqlCompilers\AbstractCompiler\compileCaseStatement().

compileINSERT()

TYPO3\CMS\Dbal\Database\SqlCompilers\Mysql::compileINSERT (   $components )

protected

Compiles an INSERT statement from components array

Parameters

array

$components

Array of SQL query components

Returns

string SQL INSERT query

See also

parseINSERT()

Definition at line 31 of file Mysql.php.

References TYPO3\CMS\Dbal\Database\SqlCompilers\Mysql\compileAddslashes().

compileWhereClause()

TYPO3\CMS\Dbal\Database\SqlCompilers\Mysql::compileWhereClause	(		$clauseArray,
			$functionMapping = true
	)

Implodes an array of WHERE clause configuration into a WHERE clause.

Parameters

array	$clauseArray	WHERE clause configuration
bool	$functionMapping

Returns

string WHERE clause as string.

See also

explodeWhereClause()

Definition at line 232 of file Mysql.php.

References TYPO3\CMS\Dbal\Database\SqlCompilers\Mysql\compileAddslashes(), TYPO3\CMS\Dbal\Database\SqlCompilers\AbstractCompiler\compileSELECT(), and TYPO3\CMS\Dbal\Database\SqlParser\normalizeKeyword().