PHP Interface eZ\Publish\Core\Persistence\Database\DatabaseHandler

Inheritance: extends eZ\Publish\Core\Persistence\Legacy\EzcDbHandler
Show file Open project: ezsystems/ezpublish-kernel Interface Usage Examples

Public Methods

Method Description
alias ( $name, $alias ) : string Custom alias method.
aliasedColumn ( eZ\Publish\Core\Persistence\Database\SelectQuery $query, string $columnName, string | null $tableName = null ) : string Creates an alias for $tableName, $columnName in $query.
beginTransaction ( ) Begin a transaction.
commit ( ) Commit a transaction.
createDeleteQuery ( ) : eZ\Publish\Core\Persistence\Database\DeleteQuery Create a Delete Query object.
createInsertQuery ( ) : eZ\Publish\Core\Persistence\Database\InsertQuery Create Insert Query object.
createSelectQuery ( ) : eZ\Publish\Core\Persistence\Database\SelectQuery Create Select Query object.
createUpdateQuery ( ) : eZ\Publish\Core\Persistence\Database\UpdateQuery Create update Query object.
exec ( string $query ) Execute a query against the database.
getAutoIncrementValue ( string $table, string $column ) : mixed Get auto increment value.
getConnection ( ) : mixed Returns underlying connection (e.g. Doctrine connection object).
getName ( ) : string Name of the database technology.
getSequenceName ( string $table, string $column ) : string Returns the name of the affected sequence.
lastInsertId ( string $sequenceName = null ) : string Retrieve the last auto incremet or sequence id.
prepare ( $query ) : object Prepare and return a statement.
quoteColumn ( string $columnName, string $tableName = null ) : string Returns a qualified identifier for $columnName in $tableName.
quoteIdentifier ( string $identifier ) : string Custom quote identifier method.
quoteTable ( string $tableName ) : string Returns a qualified identifier for $tableName.
rollBack ( ) Rollback a transaction.
useSequences ( ) : boolean Check for sequence based driver or not.

Method Details

alias() public method

Ignores some properties of identifier quoting, but since we use somehow sane table and column names, ourselves, this is fine. This is an optimization and works around the ezcDB implementation.
public alias ( $name, $alias ) : string
return string

aliasedColumn() public method

Creates an alias for $tableName, $columnName in $query.
public aliasedColumn ( eZ\Publish\Core\Persistence\Database\SelectQuery $query, string $columnName, string | null $tableName = null ) : string
$query eZ\Publish\Core\Persistence\Database\SelectQuery
$columnName string
$tableName string | null
return string

beginTransaction() public method

Begin a transaction.
public beginTransaction ( )

commit() public method

Commit a transaction.
public commit ( )

createDeleteQuery() public method

Create a Delete Query object.
public createDeleteQuery ( ) : eZ\Publish\Core\Persistence\Database\DeleteQuery
return eZ\Publish\Core\Persistence\Database\DeleteQuery

createInsertQuery() public method

Create Insert Query object.
public createInsertQuery ( ) : eZ\Publish\Core\Persistence\Database\InsertQuery
return eZ\Publish\Core\Persistence\Database\InsertQuery

createSelectQuery() public method

Create Select Query object.
public createSelectQuery ( ) : eZ\Publish\Core\Persistence\Database\SelectQuery
return eZ\Publish\Core\Persistence\Database\SelectQuery

createUpdateQuery() public method

Create update Query object.
public createUpdateQuery ( ) : eZ\Publish\Core\Persistence\Database\UpdateQuery
return eZ\Publish\Core\Persistence\Database\UpdateQuery

exec() public method

Execute a query against the database.
public exec ( string $query )
$query string

getAutoIncrementValue() public method

Returns the value used for autoincrement tables. Usually this will just be null. In case for sequence based RDBMS this method can return a proper value for the given column.
public getAutoIncrementValue ( string $table, string $column ) : mixed
$table string
$column string
return mixed

getConnection() public method

Returns underlying connection (e.g. Doctrine connection object).
public getConnection ( ) : mixed
return mixed

getName() public method

Name of the database technology.
public getName ( ) : string
return string

getSequenceName() public method

Returns the name of the affected sequence.
public getSequenceName ( string $table, string $column ) : string
$table string
$column string
return string

lastInsertId() public method

Retrieve the last auto incremet or sequence id.
public lastInsertId ( string $sequenceName = null ) : string
$sequenceName string
return string

prepare() public method

Statements are ducktyped, but need to work like PDOStatement.
public prepare ( $query ) : object
return object

quoteColumn() public method

Returns a qualified identifier for $columnName in $tableName.
public quoteColumn ( string $columnName, string $tableName = null ) : string
$columnName string
$tableName string
return string

quoteIdentifier() public method

Ignores some properties of identifier quoting, but since we use somehow sane table and column names, ourselves, this is fine. This is an optimization and works around the ezcDB implementation.
public quoteIdentifier ( string $identifier ) : string
$identifier string
return string

quoteTable() public method

Returns a qualified identifier for $tableName.
public quoteTable ( string $tableName ) : string
$tableName string
return string

rollBack() public method

Rollback a transaction.
public rollBack ( )

useSequences() public method

Check for sequence based driver or not.
public useSequences ( ) : boolean
return boolean