TYPO3 CMS  TYPO3_6-2
Public Member Functions | Protected Member Functions | Protected Attributes | List of all members
TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend Class Reference
Inheritance diagram for TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend:
TYPO3\CMS\Extbase\Persistence\Generic\Storage\BackendInterface TYPO3\CMS\Core\SingletonInterface Tx_Extbase_Persistence_Storage_Typo3DbBackend

Public Member Functions

 __construct ()
 
 initializeObject ()
 
 addRow ($tableName, array $fieldValues, $isRelation=FALSE)
 
 updateRow ($tableName, array $fieldValues, $isRelation=FALSE)
 
 updateRelationTableRow ($tableName, array $fieldValues)
 
 removeRow ($tableName, array $where, $isRelation=FALSE)
 
 getMaxValueFromTable ($tableName, array $where, $columnName)
 
 getRowByIdentifier ($tableName, array $where)
 
 getObjectDataByQuery (QueryInterface $query)
 
 getObjectCountByQuery (QueryInterface $query)
 
 getUidOfAlreadyPersistedValueObject (\TYPO3\CMS\Extbase\DomainObject\AbstractValueObject $object)
 
- Public Member Functions inherited from TYPO3\CMS\Extbase\Persistence\Generic\Storage\BackendInterface
 getObjectCountByQuery (\TYPO3\CMS\Extbase\Persistence\QueryInterface $query)
 
 getObjectDataByQuery (\TYPO3\CMS\Extbase\Persistence\QueryInterface $query)
 

Protected Member Functions

 resolveWhereStatement (array $where, $tableName='foo')
 
 createQueryCommandParametersFromStatementParts (array $statementParts)
 
 getRowsByStatementParts (QueryInterface $query)
 
 getRowsFromDatabase (array $statementParts)
 
 getRowsFromPreparedDatabase (array $statementParts, array $parameters)
 
 getObjectDataByRawQuery (Statement $statement)
 
 getStatementParts ($query, $resolveParameterPlaceholders=TRUE)
 
 resolveParameterPlaceholders (array $statementParts, array $parameters)
 
 getPlainValue ($input)
 
 replacePlaceholders (&$sqlString, array $parameters, $tableName='foo')
 
 addVisibilityConstraintStatement (\TYPO3\CMS\Extbase\Persistence\Generic\QuerySettingsInterface $querySettings, $tableName, array &$sql)
 
 getFrontendConstraintStatement ($tableName, $ignoreEnableFields, array $enableFieldsToBeIgnored=array(), $includeDeleted)
 
 getBackendConstraintStatement ($tableName, $ignoreEnableFields, $includeDeleted)
 
 doLanguageAndWorkspaceOverlay (\TYPO3\CMS\Extbase\Persistence\Generic\Qom\SourceInterface $source, array $rows, \TYPO3\CMS\Extbase\Persistence\Generic\QuerySettingsInterface $querySettings, $workspaceUid=NULL)
 
 getPageRepository ()
 
 checkSqlErrors ($sql='')
 
 clearPageCache ($tableName, $uid)
 
 getQueryCacheEntry ($entryIdentifier)
 
 setQueryCacheEntry ($entryIdentifier, $variable)
 

Protected Attributes

 $databaseHandle
 
 $dataMapper
 
 $pageRepository
 
 $pageTSConfigCache = array()
 
 $configurationManager
 
 $cacheService
 
 $cacheManager
 
 $tableColumnCache
 
 $queryCache
 
 $environmentService
 
 $queryParser
 
 $queryRuntimeCache = array()
 

Detailed Description

A Storage backend

Definition at line 24 of file Typo3DbBackend.php.

Constructor & Destructor Documentation

◆ __construct()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::__construct ( )

Constructor. takes the database handle from $GLOBALS['TYPO3_DB']

Definition at line 103 of file Typo3DbBackend.php.

References $GLOBALS.

Member Function Documentation

◆ addRow()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::addRow (   $tableName,
array  $fieldValues,
  $isRelation = FALSE 
)

Adds a row to the storage

Parameters
string$tableNameThe database table name
array$fieldValuesThe row to be inserted
bool$isRelationTRUE if we are currently inserting into a relation table, FALSE by default
Returns
integer The uid of the inserted row

Implements TYPO3\CMS\Extbase\Persistence\Generic\Storage\BackendInterface.

Definition at line 125 of file Typo3DbBackend.php.

References $uid, TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\checkSqlErrors(), and TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\clearPageCache().

◆ addVisibilityConstraintStatement()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::addVisibilityConstraintStatement ( \TYPO3\CMS\Extbase\Persistence\Generic\QuerySettingsInterface  $querySettings,
  $tableName,
array &  $sql 
)
protected

Adds enableFields and deletedClause to the query if necessary

Parameters
\TYPO3\CMS\Extbase\Persistence\Generic\QuerySettingsInterface$querySettings
string$tableNameThe database table name
array&$sqlThe query parts
Returns
void
Todo:
remove after getUidOfAlreadyPersistedValueObject is adjusted, this was moved to queryParser

Definition at line 678 of file Typo3DbBackend.php.

References $GLOBALS, TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getBackendConstraintStatement(), and TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getFrontendConstraintStatement().

Referenced by TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getUidOfAlreadyPersistedValueObject().

◆ checkSqlErrors()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::checkSqlErrors (   $sql = '')
protected

Checks if there are SQL errors in the last query, and if yes, throw an exception.

Returns
void
Parameters
string$sqlThe SQL statement
Exceptions

Definition at line 858 of file Typo3DbBackend.php.

References $sql.

Referenced by TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\addRow(), TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getMaxValueFromTable(), TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getObjectCountByQuery(), TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getObjectDataByRawQuery(), TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getRowByIdentifier(), TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getRowsFromDatabase(), TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getUidOfAlreadyPersistedValueObject(), TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\removeRow(), TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\updateRelationTableRow(), and TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\updateRow().

◆ clearPageCache()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::clearPageCache (   $tableName,
  $uid 
)
protected

Clear the TYPO3 page cache for the given record. If the record lies on a page, then we clear the cache of this page. If the record has no PID column, we clear the cache of the current page as best-effort.

Much of this functionality is taken from t3lib_tcemain::clear_cache() which unfortunately only works with logged-in BE user.

Parameters
string$tableNameTable name of the record
integer$uidUID of the record
Returns
void

Definition at line 877 of file Typo3DbBackend.php.

References $GLOBALS, $result, $uid, TYPO3\CMS\Backend\Utility\BackendUtility\getPagesTSconfig(), and TYPO3\CMS\Core\Utility\GeneralUtility\trimExplode().

Referenced by TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\addRow(), TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\removeRow(), and TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\updateRow().

◆ createQueryCommandParametersFromStatementParts()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::createQueryCommandParametersFromStatementParts ( array  $statementParts)
protected

Creates the parameters for the query methods of the database methods in the TYPO3 core, from an array that came from a parsed query.

Parameters
array$statementParts
Returns
array

Definition at line 311 of file Typo3DbBackend.php.

Referenced by TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getObjectCountByQuery(), TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getRowsFromDatabase(), and TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getRowsFromPreparedDatabase().

◆ doLanguageAndWorkspaceOverlay()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::doLanguageAndWorkspaceOverlay ( \TYPO3\CMS\Extbase\Persistence\Generic\Qom\SourceInterface  $source,
array  $rows,
\TYPO3\CMS\Extbase\Persistence\Generic\QuerySettingsInterface  $querySettings,
  $workspaceUid = NULL 
)
protected

Performs workspace and language overlay on the given row array. The language and workspace id is automatically detected (depending on FE or BE context). You can also explicitly set the language/workspace id.

Parameters
\TYPO3\CMS\Extbase\Persistence\Generic\Qom\SourceInterface$sourceThe source (selector od join)
array$rows
\TYPO3\CMS\Extbase\Persistence\Generic\QuerySettingsInterface$querySettingsThe TYPO3 CMS specific query settings
null | integer$workspaceUid
Returns
array

Definition at line 755 of file Typo3DbBackend.php.

References $GLOBALS, TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\$pageRepository, and TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getPageRepository().

Referenced by TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getObjectDataByQuery().

◆ getBackendConstraintStatement()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::getBackendConstraintStatement (   $tableName,
  $ignoreEnableFields,
  $includeDeleted 
)
protected

Returns constraint statement for backend context

Parameters
string$tableName
bool$ignoreEnableFieldsA flag indicating whether the enable fields should be ignored
bool$includeDeletedA flag indicating whether deleted records should be included
Returns
string
Todo:
remove after getUidOfAlreadyPersistedValueObject is adjusted, this was moved to queryParser

Definition at line 734 of file Typo3DbBackend.php.

References TYPO3\CMS\Backend\Utility\BackendUtility\BEenableFields(), and TYPO3\CMS\Backend\Utility\BackendUtility\deleteClause().

Referenced by TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\addVisibilityConstraintStatement().

◆ getFrontendConstraintStatement()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::getFrontendConstraintStatement (   $tableName,
  $ignoreEnableFields,
array  $enableFieldsToBeIgnored = array(),
  $includeDeleted 
)
protected

Returns constraint statement for frontend context

Parameters
string$tableName
bool$ignoreEnableFieldsA flag indicating whether the enable fields should be ignored
array$enableFieldsToBeIgnoredIf $ignoreEnableFields is true, this array specifies enable fields to be ignored. If it is NULL or an empty array (default) all enable fields are ignored.
bool$includeDeletedA flag indicating whether deleted records should be included
Returns
string
Exceptions

Definition at line 708 of file Typo3DbBackend.php.

References TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getPageRepository().

Referenced by TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\addVisibilityConstraintStatement().

◆ getMaxValueFromTable()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::getMaxValueFromTable (   $tableName,
array  $where,
  $columnName 
)

Fetches maximal value for given table column from database.

Parameters
string$tableNameThe database table name
array$whereAn array of where array('fieldname' => value).
string$columnNamecolumn name to get the max value from
Returns
mixed the max value

Implements TYPO3\CMS\Extbase\Persistence\Generic\Storage\BackendInterface.

Definition at line 236 of file Typo3DbBackend.php.

References $result, TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\checkSqlErrors(), and TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\resolveWhereStatement().

◆ getObjectCountByQuery()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::getObjectCountByQuery ( QueryInterface  $query)

Returns the number of tuples matching the query.

Parameters
QueryInterface$query
Exceptions
Exception

Definition at line 436 of file Typo3DbBackend.php.

References TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\checkSqlErrors(), TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\createQueryCommandParametersFromStatementParts(), TYPO3\CMS\Extbase\Persistence\QueryInterface\getConstraint(), and TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getStatementParts().

◆ getObjectDataByQuery()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::getObjectDataByQuery ( QueryInterface  $query)

Returns the object data matching the $query.

Parameters
QueryInterface$query
Returns
array

Definition at line 292 of file Typo3DbBackend.php.

References TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\doLanguageAndWorkspaceOverlay(), TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getObjectDataByRawQuery(), TYPO3\CMS\Extbase\Persistence\QueryInterface\getQuerySettings(), TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getRowsByStatementParts(), TYPO3\CMS\Extbase\Persistence\QueryInterface\getSource(), and TYPO3\CMS\Extbase\Persistence\QueryInterface\getStatement().

◆ getObjectDataByRawQuery()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::getObjectDataByRawQuery ( Statement  $statement)
protected

Returns the object data using a custom statement

Parameters
Statement$statement
Returns
array
Deprecated:
since 6.2, this block will be removed in two versions the deprecation log is in Qom

Definition at line 396 of file Typo3DbBackend.php.

References $parameters, $result, TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\checkSqlErrors(), TYPO3\CMS\Extbase\Persistence\Generic\Qom\Statement\getBoundVariables(), TYPO3\CMS\Extbase\Persistence\Generic\Qom\Statement\getStatement(), and TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\replacePlaceholders().

Referenced by TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getObjectDataByQuery().

◆ getPageRepository()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::getPageRepository ( )
protected
Returns

Definition at line 839 of file Typo3DbBackend.php.

References $GLOBALS, TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\$pageRepository, and TYPO3\CMS\Core\Utility\GeneralUtility\makeInstance().

Referenced by TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\doLanguageAndWorkspaceOverlay(), and TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getFrontendConstraintStatement().

◆ getPlainValue()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::getPlainValue (   $input)
protected

Returns a plain value, i.e. objects are flattened out if possible.

Parameters
mixed$input
Exceptions

Definition at line 605 of file Typo3DbBackend.php.

Referenced by TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getUidOfAlreadyPersistedValueObject().

◆ getQueryCacheEntry()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::getQueryCacheEntry (   $entryIdentifier)
protected

Finds and returns a variable value from the query cache.

Parameters
string$entryIdentifierIdentifier of the cache entry to fetch
Returns
mixed The value

Definition at line 925 of file Typo3DbBackend.php.

Referenced by TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getStatementParts().

◆ getRowByIdentifier()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::getRowByIdentifier (   $tableName,
array  $where 
)

Fetches row data from the database

Parameters
string$tableName
array$whereAn array of where array('fieldname' => value).
Returns
array|bool

Definition at line 257 of file Typo3DbBackend.php.

References TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\checkSqlErrors(), and TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\resolveWhereStatement().

◆ getRowsByStatementParts()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::getRowsByStatementParts ( QueryInterface  $query)
protected

Determines whether to use prepared statement or not and returns the rows from the corresponding method

Parameters
QueryInterface$query
Returns
array

Definition at line 332 of file Typo3DbBackend.php.

References $parameters, TYPO3\CMS\Extbase\Persistence\QueryInterface\getQuerySettings(), TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getRowsFromDatabase(), TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getRowsFromPreparedDatabase(), and TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getStatementParts().

Referenced by TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getObjectDataByQuery().

◆ getRowsFromDatabase()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::getRowsFromDatabase ( array  $statementParts)
protected

Fetches the rows directly from the database, not using prepared statement

Parameters
array$statementParts
Returns
array the result

Definition at line 350 of file Typo3DbBackend.php.

References TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\checkSqlErrors(), and TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\createQueryCommandParametersFromStatementParts().

Referenced by TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getRowsByStatementParts().

◆ getRowsFromPreparedDatabase()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::getRowsFromPreparedDatabase ( array  $statementParts,
array  $parameters 
)
protected

Fetches the rows from the database, using prepared statement

Parameters
array$statementParts
array$parameters
Returns
array the result

Definition at line 372 of file Typo3DbBackend.php.

References TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\createQueryCommandParametersFromStatementParts().

Referenced by TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getRowsByStatementParts().

◆ getStatementParts()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::getStatementParts (   $query,
  $resolveParameterPlaceholders = TRUE 
)
protected

Looks for the query in cache or builds it up otherwise

Parameters
QueryInterface$query
bool$resolveParameterPlaceholderswhether to resolve the parameters or leave the placeholders
Returns
array
Exceptions

The queryParser will preparse the query to get the query's hash and parameters. If the hash is found in the cache and useQueryCaching is enabled, extbase will then take the string representation from cache and build a prepared query with the parameters found.

Otherwise extbase will parse the complete query, build the string representation and run a usual query.

Definition at line 475 of file Typo3DbBackend.php.

References $parameters, TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getQueryCacheEntry(), TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\resolveParameterPlaceholders(), and TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\setQueryCacheEntry().

Referenced by TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getObjectCountByQuery(), and TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getRowsByStatementParts().

◆ getUidOfAlreadyPersistedValueObject()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::getUidOfAlreadyPersistedValueObject ( \TYPO3\CMS\Extbase\DomainObject\AbstractValueObject  $object)

Checks if a Value Object equal to the given Object exists in the data base

Parameters
\TYPO3\CMS\Extbase\DomainObject\AbstractValueObject$objectThe Value Object
Returns
mixed The matching uid if an object was found, else FALSE
Todo:
this is the last monster in this persistence series. refactor!

Implements TYPO3\CMS\Extbase\Persistence\Generic\Storage\BackendInterface.

Definition at line 560 of file Typo3DbBackend.php.

References $parameters, $sql, TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\addVisibilityConstraintStatement(), TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\checkSqlErrors(), TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getPlainValue(), and TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\replacePlaceholders().

◆ initializeObject()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::initializeObject ( )

Lifecycle method

Returns
void

Definition at line 112 of file Typo3DbBackend.php.

◆ removeRow()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::removeRow (   $tableName,
array  $where,
  $isRelation = FALSE 
)

Deletes a row in the storage

Parameters
string$tableNameThe database table name
array$whereAn array of where array('fieldname' => value).
bool$isRelationTRUE if we are currently manipulating a relation table, FALSE by default
Returns
bool

Implements TYPO3\CMS\Extbase\Persistence\Generic\Storage\BackendInterface.

Definition at line 214 of file Typo3DbBackend.php.

References TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\checkSqlErrors(), TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\clearPageCache(), and TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\resolveWhereStatement().

◆ replacePlaceholders()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::replacePlaceholders ( &  $sqlString,
array  $parameters,
  $tableName = 'foo' 
)
protected

Replace query placeholders in a query part by the given parameters.

Parameters
string&$sqlStringThe query part with placeholders
array$parametersThe parameters
string$tableName
Exceptions

Definition at line 643 of file Typo3DbBackend.php.

Referenced by TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getObjectDataByRawQuery(), and TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getUidOfAlreadyPersistedValueObject().

◆ resolveParameterPlaceholders()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::resolveParameterPlaceholders ( array  $statementParts,
array  $parameters 
)
protected

Replaces the parameters in the queryStructure with given values

Parameters
array$statementParts
array$parameters
Returns
array

Definition at line 521 of file Typo3DbBackend.php.

Referenced by TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getStatementParts().

◆ resolveWhereStatement()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::resolveWhereStatement ( array  $where,
  $tableName = 'foo' 
)
protected

Converts an array to an AND concatenated where statement

Parameters
array$wherearray('fieldName' => 'fieldValue')
string$tableNametable to use for escaping config
Returns
string

Definition at line 276 of file Typo3DbBackend.php.

Referenced by TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getMaxValueFromTable(), TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getRowByIdentifier(), TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\removeRow(), and TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\updateRelationTableRow().

◆ setQueryCacheEntry()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::setQueryCacheEntry (   $entryIdentifier,
  $variable 
)
protected

Saves the value of a PHP variable in the query cache.

Parameters
string$entryIdentifierAn identifier used for this cache entry
mixed$variableThe query to cache
Returns
void

Definition at line 939 of file Typo3DbBackend.php.

Referenced by TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getStatementParts().

◆ updateRelationTableRow()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::updateRelationTableRow (   $tableName,
array  $fieldValues 
)

Updates a relation row in the storage.

Parameters
string$tableNameThe database relation table name
array$fieldValuesThe row to be updated
Exceptions

Implements TYPO3\CMS\Extbase\Persistence\Generic\Storage\BackendInterface.

Definition at line 175 of file Typo3DbBackend.php.

References TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\checkSqlErrors(), and TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\resolveWhereStatement().

◆ updateRow()

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::updateRow (   $tableName,
array  $fieldValues,
  $isRelation = FALSE 
)

Updates a row in the storage

Parameters
string$tableNameThe database table name
array$fieldValuesThe row to be updated
bool$isRelationTRUE if we are currently inserting into a relation table, FALSE by default
Exceptions

Implements TYPO3\CMS\Extbase\Persistence\Generic\Storage\BackendInterface.

Definition at line 149 of file Typo3DbBackend.php.

References $uid, TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\checkSqlErrors(), and TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\clearPageCache().

Member Data Documentation

◆ $cacheManager

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::$cacheManager
protected

Definition at line 69 of file Typo3DbBackend.php.

◆ $cacheService

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::$cacheService
protected

Definition at line 63 of file Typo3DbBackend.php.

◆ $configurationManager

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::$configurationManager
protected

Definition at line 57 of file Typo3DbBackend.php.

◆ $databaseHandle

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::$databaseHandle
protected

Definition at line 31 of file Typo3DbBackend.php.

◆ $dataMapper

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::$dataMapper
protected

Definition at line 37 of file Typo3DbBackend.php.

◆ $environmentService

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::$environmentService
protected

Definition at line 85 of file Typo3DbBackend.php.

◆ $pageRepository

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::$pageRepository
protected

Definition at line 44 of file Typo3DbBackend.php.

Referenced by TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\doLanguageAndWorkspaceOverlay(), and TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend\getPageRepository().

◆ $pageTSConfigCache

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::$pageTSConfigCache = array()
protected

Definition at line 51 of file Typo3DbBackend.php.

◆ $queryCache

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::$queryCache
protected

Definition at line 79 of file Typo3DbBackend.php.

◆ $queryParser

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::$queryParser
protected

Definition at line 91 of file Typo3DbBackend.php.

◆ $queryRuntimeCache

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::$queryRuntimeCache = array()
protected

Definition at line 98 of file Typo3DbBackend.php.

◆ $tableColumnCache

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend::$tableColumnCache
protected

Definition at line 74 of file Typo3DbBackend.php.