PHP Class eZ\Publish\Core\Persistence\Doctrine\ConnectionHandler

Inheritance: implements eZ\Publish\Core\Persistence\Database\DatabaseHandler

Afficher le fichier Open project: ezsystems/ezpublish-kernel Class Usage Examples

Protected Properties

Свойство	Type	Description
$connection	Doctrine\DBAL\Connection

Méthodes publiques

Méthode	Description
__construct ( Doctrine\DBAL\Connection $connection )
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.
createConnectionFromDSN ( string \| array $dsn ) : Doctrine\DBAL\Connection
createDeleteQuery ( ) : eZ\Publish\Core\Persistence\Database\DeleteQuery	Create a Delete Query object.
createFromConnection ( Doctrine\DBAL\Connection $connection ) : ConnectionHandler	Create a Connection Handler from given Doctrine $connection.
createFromDSN ( string \| array $dsn ) : ConnectionHandler	Create a Connection Handler with corresponding Doctrine connection from DSN.
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 ( ) : Doctrine\DBAL\Connection
getName ( ) : string
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.
parseDSN ( string $dsn ) : array	Returns the Data Source Name as a structure containing the various parts of the DSN.
prepare ( $query )
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

Method Details

__construct() public méthode

public __construct ( Doctrine\DBAL\Connection $connection )
$connection	Doctrine\DBAL\Connection

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 ( )

createConnectionFromDSN() public static méthode

public static createConnectionFromDSN ( string \| array $dsn ) : Doctrine\DBAL\Connection
$dsn	string \| array
Résultat	Doctrine\DBAL\Connection

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

createFromConnection() public static méthode

Create a Connection Handler from given Doctrine $connection.

public static createFromConnection ( Doctrine\DBAL\Connection $connection ) : ConnectionHandler
$connection	Doctrine\DBAL\Connection
Résultat	ConnectionHandler

createFromDSN() public static méthode

Create a Connection Handler with corresponding Doctrine connection from DSN.

public static createFromDSN ( string \| array $dsn ) : ConnectionHandler
$dsn	string \| array
Résultat	ConnectionHandler

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

public getConnection ( ) : Doctrine\DBAL\Connection
Résultat	Doctrine\DBAL\Connection

getName() public méthode

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

parseDSN() public static méthode

Additional keys can be added by appending a URI query string to the end of the DSN. The format of the supplied DSN is in its fullest form:


 driver://user:password@protocol+host/database?option=8&another=true

Most variations are allowed:


 driver://user:password@protocol+host:110//usr/db_file.db?mode=0644
 driver://user:password@host/dbname
 driver://user:password@host
 driver://user@host
 driver://host/dbname
 driver://host
 driver

This function is 'borrowed' from PEAR /DB.php .

public static parseDSN ( string $dsn ) : array
$dsn	string	Data Source Name to be parsed
Résultat	array	an associative array with the following keys: + driver: Database backend used in PHP (mysql, odbc etc.) + host: Host specification (hostname[:port]) + dbname: Database to use on the DBMS server + username: User name for login + password: Password for login

prepare() public méthode

public prepare ( $query )

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

public useSequences ( ) : boolean
Résultat	boolean

Property Details

$connection protected_oe property

protected Connection,Doctrine\DBAL $connection
Résultat	Doctrine\DBAL\Connection