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

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

Méthodes publiques

Méthode 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 méthode

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
Résultat string

aliasedColumn() public méthode

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
Résultat string

beginTransaction() public méthode

Begin a transaction.
public beginTransaction ( )

commit() public méthode

Commit a transaction.
public commit ( )

createDeleteQuery() public méthode

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

createInsertQuery() public méthode

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

createSelectQuery() public méthode

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

createUpdateQuery() public méthode

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

exec() public méthode

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

getAutoIncrementValue() public méthode

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
Résultat mixed

getConnection() public méthode

Returns underlying connection (e.g. Doctrine connection object).
public getConnection ( ) : mixed
Résultat mixed

getName() public méthode

Name of the database technology.
public getName ( ) : string
Résultat string

getSequenceName() public méthode

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

lastInsertId() public méthode

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

prepare() public méthode

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

quoteColumn() public méthode

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

quoteIdentifier() public méthode

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
Résultat string

quoteTable() public méthode

Returns a qualified identifier for $tableName.
public quoteTable ( string $tableName ) : string
$tableName string
Résultat string

rollBack() public méthode

Rollback a transaction.
public rollBack ( )

useSequences() public méthode

Check for sequence based driver or not.
public useSequences ( ) : boolean
Résultat boolean