TYPO3
7.6
|
Public Member Functions | |
__construct (DatabaseConnection $databaseConnection) | |
compileSQL ($components) | |
compileFieldList ($selectFields, $compileComments=true, $functionMapping=true) | |
compileWhereClause ($clauseArray, $functionMapping=true) | |
compileFromTables ($tablesArray) | |
Protected Member Functions | |
compileSELECT ($components) | |
compileUPDATE ($components) | |
compileINSERT ($components) | |
compileDELETE ($components) | |
compileCREATETABLE ($components) | |
compileALTERTABLE ($components) | |
compileTRUNCATETABLE (array $components) | |
compileAddslashes ($str) | |
compileJoinIdentifier ($identifierParts) | |
compileCaseStatement (array $components, $functionMapping=true) | |
Protected Attributes | |
$databaseConnection | |
Abstract base class for SQL compilers
Definition at line 22 of file AbstractCompiler.php.
__construct | ( | DatabaseConnection | $databaseConnection | ) |
\TYPO3\CMS\Dbal\Database\DatabaseConnection | $databaseConnection |
Definition at line 32 of file AbstractCompiler.php.
References AbstractCompiler\$databaseConnection.
|
abstractprotected |
Add slashes function used for compiling queries This method overrides the method from because the input string is already properly escaped.
string | $str | Input string |
Referenced by AbstractCompiler\compileFromTables(), and AbstractCompiler\compileUPDATE().
|
abstractprotected |
Compiles an ALTER TABLE statement from components array
array | Array of SQL query components |
Referenced by AbstractCompiler\compileSQL().
|
protected |
Compiles a CASE ... WHEN flow-control construct based on input array (made with ->parseCaseStatement())
array | $components | Array of case components, (made with ->parseCaseStatement()) |
bool | $functionMapping | Whether function mapping should take place |
Definition at line 303 of file AbstractCompiler.php.
References AbstractCompiler\compileWhereClause(), and elseif.
Referenced by Mysql\compileFieldList(), and Adodb\compileFieldList().
|
abstractprotected |
Compiles a CREATE TABLE statement from components array
array | $components | Array of SQL query components |
Referenced by AbstractCompiler\compileSQL().
|
protected |
Compiles an DELETE statement from components array
array | $components | Array of SQL query components |
Definition at line 143 of file AbstractCompiler.php.
References AbstractCompiler\compileWhereClause().
Referenced by AbstractCompiler\compileSQL().
|
abstract |
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.
array | $selectFields | Array of select fields, (made with ->parseFieldList()) |
bool | $compileComments | Whether comments should be compiled |
bool | $functionMapping | Whether function mapping should take place |
Referenced by AbstractCompiler\compileSELECT().
compileFromTables | ( | $tablesArray | ) |
Compiles a "FROM [output] WHERE..:" table list based on input array (made with ->parseFromTables())
array | $tablesArray | Array of table names, (made with ->parseFromTables()) |
Definition at line 253 of file AbstractCompiler.php.
References AbstractCompiler\compileAddslashes(), and AbstractCompiler\compileJoinIdentifier().
Referenced by AbstractCompiler\compileSELECT().
|
abstractprotected |
Compiles an INSERT statement from components array
array | $components | Array of SQL query components |
Referenced by AbstractCompiler\compileSQL().
|
protected |
Compile a "JOIN table ON [output] = ..." identifier
array | $identifierParts | Array of identifier parts |
Definition at line 234 of file AbstractCompiler.php.
Referenced by AbstractCompiler\compileFromTables().
|
protected |
Compiles a SELECT statement from components array
array | $components | Array of SQL query components |
Definition at line 86 of file AbstractCompiler.php.
References AbstractCompiler\compileFieldList(), AbstractCompiler\compileFromTables(), and AbstractCompiler\compileWhereClause().
Referenced by AbstractCompiler\compileSQL(), Mysql\compileWhereClause(), and Adodb\compileWhereClause().
compileSQL | ( | $components | ) |
Compiles an SQL query from components
array | $components | Array of SQL query components |
Definition at line 44 of file AbstractCompiler.php.
References AbstractCompiler\compileALTERTABLE(), AbstractCompiler\compileCREATETABLE(), AbstractCompiler\compileDELETE(), AbstractCompiler\compileINSERT(), AbstractCompiler\compileSELECT(), AbstractCompiler\compileTRUNCATETABLE(), and AbstractCompiler\compileUPDATE().
|
protected |
Compiles a TRUNCATE TABLE statement from components array
array | $components | Array of SQL query components |
Definition at line 178 of file AbstractCompiler.php.
Referenced by AbstractCompiler\compileSQL().
|
protected |
Compiles an UPDATE statement from components array
array | $components | Array of SQL query components |
Definition at line 111 of file AbstractCompiler.php.
References AbstractCompiler\compileAddslashes(), and AbstractCompiler\compileWhereClause().
Referenced by AbstractCompiler\compileSQL().
|
abstract |
Implodes an array of WHERE clause configuration into a WHERE clause.
DBAL-specific: The only(!) handled "calc" operators supported by parseWhereClause() are:
array | $clauseArray | |
bool | $functionMapping |
Referenced by AbstractCompiler\compileCaseStatement(), AbstractCompiler\compileDELETE(), AbstractCompiler\compileSELECT(), and AbstractCompiler\compileUPDATE().
|
protected |
Definition at line 27 of file AbstractCompiler.php.
Referenced by AbstractCompiler\__construct().