PDOConnector
class PDOConnector extends DBConnector implements TransactionManager (View source)
PDO driver database connector
Traits
Provides extensions to this object to integrate it with standard config API methods.
Properties
| static private array | $write_operations | List of operations to treat as write Implicitly includes all ddl_operations |
from DBConnector |
| static private array | $ddl_operations | List of operations to treat as DDL |
from DBConnector |
| static private bool | $emulate_prepare | Should ATTR_EMULATE_PREPARES flag be used to emulate prepared statements? |
|
| static private bool | $legacy_types | Should we return everything as a string in order to allow transaction savepoints? This preserves the behaviour of <= 4.3, including some bugs. |
|
| static private string | $ssl_cipher_default | Default strong SSL cipher to be used |
Methods
Get a configuration accessor for this class. Short hand for Config::inst()->get($this->class, .....).
Gets the uninherited value for the given config option
Determine if this SQL statement is a destructive operation (write or ddl)
Determine if this SQL statement is a write operation (alters content but not structure)
Link this connector to the database given the specified parameters Will throw an exception rather than return a success state.
Query for the version of the currently connected database
Given a value escape this for use in a query for the current database connector. Note that this does not quote the value.
Given a value escape and quote this appropriately for the current database connector.
Executes the following query with the specified error level.
Execute the given SQL parameterised query with the specified arguments
Select a database by name
Retrieves the name of the currently selected database
De-selects the currently selected database
Retrieves the last error generated from the database connection
Determines the last ID generated from the specified table.
Determines the number of affected rows from the last SQL query
Determines if we are connected to a server AND have a valid database selected.
Flush all prepared statements
Retrieve a prepared statement for a given SQL string, or return an already prepared version if one exists for the given query
Is PDO running in emulated mode
Return the driver for this connector E.g. 'mysql', 'sqlsrv', 'pgsql'
Executes a query that doesn't return a resultset
Determines the PDO::PARAM_* type for a given PHP type string
Start a prepared transaction
Complete a transaction
Roll-back a transaction
Return the depth of the transaction For unnested transactions returns 1 while in a transaction, 0 otherwise
Create a new savepoint
Return true if savepoints are supported by this transaction manager.
Details
static Config_ForClass
config()
Get a configuration accessor for this class. Short hand for Config::inst()->get($this->class, .....).
mixed
stat(string $name)
deprecated
deprecated
Get inherited config value
mixed
uninherited(string $name)
Gets the uninherited value for the given config option
$this
set_stat(string $name, mixed $value)
deprecated
deprecated
Update the config value for a given property
bool
isQueryMutable(string $sql)
Determine if this SQL statement is a destructive operation (write or ddl)
bool
isQueryDDL(string $sql)
Determine if this SQL statement is a DDL operation
bool
isQueryWrite(string $sql)
Determine if this SQL statement is a write operation (alters content but not structure)
connect(array $parameters, bool $selectDB = false)
Link this connector to the database given the specified parameters Will throw an exception rather than return a success state.
The connector should not select the database once connected until explicitly called by selectDatabase()
string
getVersion()
Query for the version of the currently connected database
string
escapeString(string $value)
Given a value escape this for use in a query for the current database connector. Note that this does not quote the value.
string
quoteString(string $value)
Given a value escape and quote this appropriately for the current database connector.
query(string $sql, int $errorLevel = E_USER_ERROR)
Executes the following query with the specified error level.
Implementations of this function should respect previewWrite and benchmarkQuery
Query
preparedQuery(string $sql, array $parameters, int $errorLevel = E_USER_ERROR)
Execute the given SQL parameterised query with the specified arguments
bool
selectDatabase(string $name)
Select a database by name
string
getSelectedDatabase()
Retrieves the name of the currently selected database
unloadDatabase()
De-selects the currently selected database
string
getLastError()
Retrieves the last error generated from the database connection
int
getGeneratedID(string $table)
Determines the last ID generated from the specified table.
Note that some connectors may not be able to return $table specific responses, and this parameter may be ignored.
int
affectedRows()
Determines the number of affected rows from the last SQL query
bool
isActive()
Determines if we are connected to a server AND have a valid database selected.
flushStatements()
Flush all prepared statements
PDOStatementHandle|false
getOrPrepareStatement(string $sql)
Retrieve a prepared statement for a given SQL string, or return an already prepared version if one exists for the given query
static bool
is_emulate_prepare()
Is PDO running in emulated mode
string
getDriver()
Return the driver for this connector E.g. 'mysql', 'sqlsrv', 'pgsql'
int
exec(string $sql, int $errorLevel = E_USER_ERROR)
Executes a query that doesn't return a resultset
int
getPDOParamType(string $phpType)
Determines the PDO::PARAM_* type for a given PHP type string
bindParameters(PDOStatement $statement, array $parameters)
Bind all parameters to a PDOStatement
bool
transactionStart(string|bool $transactionMode = false, string|bool $sessionCharacteristics = false)
Start a prepared transaction
bool
transactionEnd()
Complete a transaction
bool
transactionRollback(string $savepoint = null)
Roll-back a transaction
int
transactionDepth()
Return the depth of the transaction For unnested transactions returns 1 while in a transaction, 0 otherwise
transactionSavepoint(string $savepoint = null)
Create a new savepoint
bool
supportsSavepoints()
Return true if savepoints are supported by this transaction manager.
Savepoints aren't supported by all database connectors (notably PDO doesn't support them) and should be used with caution.