Represents a database driver containing all specificities for a database engine including its SQL dialect.
$_autoQuoting
protected boolean
Indicates whether or not the driver is doing automatic identifier quoting for all queries
$_baseConfig
protected array
Base configuration that is merged into the user supplied configuration data.
$_config
protected array
$_connection
protected PDO|null
Returns an array that can be used to describe the internal state of this object.
Returns whether or not this driver should automatically quote identifiers in queries
Transforms the passed query to this Driver's dialect and returns an instance of the transformed query and the full compiled SQL string.
Returns correct connection resource or object that is internally used If first argument is passed, it will set internal connection object or result to the value passed.
Sets whether or not this driver should automatically quote identifiers in queries.
Returns whether or not this driver should automatically quote identifiers in queries.
Returns a callable function that will be used to transform a passed Query object. This function, in turn, will return an instance of a Query object that has been transformed to accommodate any specificities of the SQL dialect in use.
Quotes a database identifier (a column name, table name, etc..) to be used safely in queries without the risk of using reserved words.
Returns whether the driver supports adding or dropping constraints to already created tables.
__construct( array $config [] )
Constructor
$config
optional [] __debugInfo( )
Returns an array that can be used to describe the internal state of this object.
_connect( string $dsn , array $config )
Establishes a connection to the database server
$dsn
$config
autoQuoting( boolean|null $enable null )
Returns whether or not this driver should automatically quote identifiers in queries
If called with a boolean argument, it will toggle the auto quoting setting to the passed value
$enable
optional null beginTransaction( )
Starts a transaction.
Cake\Database\DriverInterface::beginTransaction()
commitTransaction( )
Commits a transaction.
Cake\Database\DriverInterface::commitTransaction()
compileQuery( Cake\Database\Query $query , Cake\Database\ValueBinder $generator )
Transforms the passed query to this Driver's dialect and returns an instance of the transformed query and the full compiled SQL string.
Cake\Database\Query
$query
$generator
containing 2 entries. The first entity is the transformed query and the second one the compiled SQL.
Cake\Database\DriverInterface::compileQuery()
connect( )
Establishes a connection to the database server.
Cake\Database\DriverInterface::connect()
connection( mixed $connection null )
Returns correct connection resource or object that is internally used If first argument is passed, it will set internal connection object or result to the value passed.
$connection
optional null disableForeignKeySQL( )
Get the SQL for disabling foreign keys.
Cake\Database\DriverInterface::disableForeignKeySQL()
disconnect( )
Disconnects from database server.
Cake\Database\DriverInterface::disconnect()
enableAutoQuoting( boolean $enable true )
Sets whether or not this driver should automatically quote identifiers in queries.
$enable
optional true Cake\Database\DriverInterface::enableAutoQuoting()
enableForeignKeySQL( )
Get the SQL for enabling foreign keys.
Cake\Database\DriverInterface::enableForeignKeySQL()
enabled( )
Returns whether php is able to use this driver for connecting to database.
Cake\Database\DriverInterface::enabled()
getConnection( )
Get the internal PDO connection instance.
Cake\Database\DriverInterface::getConnection()
isAutoQuotingEnabled( )
Returns whether or not this driver should automatically quote identifiers in queries.
Cake\Database\DriverInterface::isAutoQuotingEnabled()
isConnected( )
Checks whether or not the driver is connected.
Cake\Database\DriverInterface::isConnected()
lastInsertId( string|null $table null , string|null $column null )
Returns last id generated for a table or sequence in database.
$table
optional null $column
optional null Cake\Database\DriverInterface::lastInsertId()
newCompiler( )
Returns an instance of a QueryCompiler.
Cake\Database\DriverInterface::newCompiler()
prepare( string|Cake\Database\Query $query )
Prepares a sql statement to be executed.
Cake\Database\Query
$query
Cake\Database\StatementInterface
Cake\Database\DriverInterface::prepare()
queryTranslator( string $type )
Returns a callable function that will be used to transform a passed Query object. This function, in turn, will return an instance of a Query object that has been transformed to accommodate any specificities of the SQL dialect in use.
$type
The type of query to be transformed (select, insert, update, delete).
Cake\Database\DriverInterface::queryTranslator()
quote( mixed $value , string $type )
Returns a value in a safe representation to be used in a query string
$value
$type
Cake\Database\DriverInterface::quote()
quoteIdentifier( string $identifier )
Quotes a database identifier (a column name, table name, etc..) to be used safely in queries without the risk of using reserved words.
$identifier
Cake\Database\DriverInterface::quoteIdentifier()
releaseSavePointSQL( string $name )
Get the SQL for releasing a save point.
$name
Cake\Database\DriverInterface::releaseSavePointSQL()
rollbackSavePointSQL( string $name )
Get the SQL for rollingback a save point.
$name
Cake\Database\DriverInterface::rollbackSavePointSQL()
rollbackTransaction( )
Rollbacks a transaction.
Cake\Database\DriverInterface::rollbackTransaction()
savePointSQL( string $name )
Get the SQL for creating a save point.
$name
Cake\Database\DriverInterface::savePointSQL()
schema( )
Returns the schema name that's being used.
Cake\Database\DriverInterface::schema()
schemaDialect( )
Get the schema dialect.
Cake\Database\Schema\BaseSchema
Cake\Database\DriverInterface::schemaDialect()
schemaValue( mixed $value )
Escapes values for use in schema definitions.
$value
Cake\Database\DriverInterface::schemaValue()
setConnection( PDO $connection )
Set the internal PDO connection instance.
$connection
Cake\Database\DriverInterface::setConnection()
supportsDynamicConstraints( )
Returns whether the driver supports adding or dropping constraints to already created tables.
Cake\Database\DriverInterface::supportsDynamicConstraints()
supportsQuoting( )
Checks if the driver supports quoting, as PDO_ODBC does not support it.
Cake\Database\DriverInterface::supportsQuoting()
supportsSavePoints( )
Returns whether this driver supports save points for nested transactions.
Cake\Database\DriverInterface::supportsSavePoints()
protected boolean
Indicates whether or not the driver is doing automatic identifier quoting for all queries
false
protected array
Base configuration that is merged into the user supplied configuration data.
[]
© 2005–2018 The Cake Software Foundation, Inc.
Licensed under the MIT License.
CakePHP is a registered trademark of Cake Software Foundation, Inc.
We are not endorsed by or affiliated with CakePHP.
https://api.cakephp.org/3.6/class-Cake.Database.Driver.html