PHP Class Horde_Db_Adapter_Pdo_Sqlite, horde

Author: Mike Naberezny ([email protected])
Author: Derek DeVries ([email protected])
Author: Chuck Hagenbuch ([email protected])
Inheritance: extends Horde_Db_Adapter_Pdo_Abstract
Mostrar archivo Open project: horde/horde Class Usage Examples

Protected Properties

Property Type Description
$_schemaClass string
$_sqliteVersion integer SQLite version number

Public Methods

Method Description
adapterName ( ) : string
addLock ( &$sql, array $options = [] ) SELECT .
beginDbTransaction ( ) Begins the transaction (and turns off auto-committing).
commitDbTransaction ( ) Commits the transaction (and turns on auto-committing).
connect ( ) Connect to the db.
emptyInsertStatement ( $tableName )
execute ( string $sql, mixed $arg1 = null, string $arg2 = null ) Executes the SQL statement in the context of this connection.
rollbackDbTransaction ( ) Rolls back the transaction (and turns on auto-committing). Must be done if the transaction block raises an exception or returns false.
supportsAutoIncrement ( )
supportsCountDistinct ( ) : boolean Does this adapter support using DISTINCT within COUNT? This is +true+ for all adapters except sqlite.
supportsInterval ( ) : boolean Does this adapter support using INTERVAL statements? This is +true+ for all adapters except sqlite.
supportsMigrations ( ) : boolean

Protected Methods

Method Description
_buildDsnString ( $params )
_catchSchemaChanges ( $method, $args = [] ) *########################################################################## # Protected ##########################################################################
_parseConfig ( ) : array Parse configuration array into options for PDO constructor

Method Details

_buildDsnString() protected method

protected _buildDsnString ( $params )

_catchSchemaChanges() protected method

*########################################################################## # Protected ##########################################################################
protected _catchSchemaChanges ( $method, $args = [] )

_parseConfig() protected method

Parse configuration array into options for PDO constructor
protected _parseConfig ( ) : array
return array [dsn, username, password]

adapterName() public method

public adapterName ( ) : string
return string

addLock() public method

.. FOR UPDATE is redundant since the table is locked.
public addLock ( &$sql, array $options = [] )
$options array

beginDbTransaction() public method

Begins the transaction (and turns off auto-committing).
public beginDbTransaction ( )

commitDbTransaction() public method

Commits the transaction (and turns on auto-committing).
public commitDbTransaction ( )

connect() public method

Connect to the db.
public connect ( )

emptyInsertStatement() public method

public emptyInsertStatement ( $tableName )

execute() public method

Executes the SQL statement in the context of this connection.
public execute ( string $sql, mixed $arg1 = null, string $arg2 = null )
$sql string
$arg1 mixed Either an array of bound parameters or a query name.
$arg2 string If $arg1 contains bound parameters, the query name.

rollbackDbTransaction() public method

Rolls back the transaction (and turns on auto-committing). Must be done if the transaction block raises an exception or returns false.

supportsAutoIncrement() public method

supportsCountDistinct() public method

Does this adapter support using DISTINCT within COUNT? This is +true+ for all adapters except sqlite.
public supportsCountDistinct ( ) : boolean
return boolean

supportsInterval() public method

Does this adapter support using INTERVAL statements? This is +true+ for all adapters except sqlite.
public supportsInterval ( ) : boolean
return boolean

supportsMigrations() public method

public supportsMigrations ( ) : boolean
return boolean

Property Details

$_schemaClass protected_oe property

protected string $_schemaClass
return string

$_sqliteVersion protected_oe property

SQLite version number
protected int $_sqliteVersion
return integer