Represents a database diver containing all specificities for a database engine including its SQL dialect
$_autoQuoting protected booleanIndicates whether or not the driver is doing automatic identifier quoting for all queries
$_baseConfig protected arrayBase configuration that is merged into the user supplied configuration data.
$_config protected arrayReturns 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,
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.
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
commitTransaction( )
Commits a transaction
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
connect( )
Establishes a connection to the database server
connection( null|PDO $connection null )
Returns correct connection resource or object that is internally used If first argument is passed,
$connection optional null Cake\Database\ConnectiondisableForeignKeySQL( )
Get the SQL for disabling foreign keys
enableAutoQuoting( boolean $enable true )
Sets whether or not this driver should automatically quote identifiers in queries.
$enable optional true enableForeignKeySQL( )
Get the SQL for enabling foreign keys
enabled( )
Returns whether php is able to use this driver for connecting to database
isAutoQuotingEnabled( )
Returns whether or not this driver should automatically quote identifiers in queries
isConnected( )
Check whether or not the driver is connected.
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 newCompiler( )
Returns an instance of a QueryCompiler
prepare( string|Cake\Database\Query $query )
Prepares a sql statement to be executed
Cake\Database\Query $query Cake\Database\StatementInterfacequeryTranslator( 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)
quote( mixed $value , string $type )
Returns a value in a safe representation to be used in a query string
$value $type 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 releaseSavePointSQL( string $name )
Get the SQL for releasing a save point.
$name rollbackSavePointSQL( string $name )
Get the SQL for rollingback a save point.
$name rollbackTransaction( )
Rollsback a transaction
savePointSQL( string $name )
Get the SQL for creating a save point.
$name schemaDialect( )
Get the schema dialect.
Used by Cake\Database\Schema package to reflect schema and generate schema.
If all the tables that use this Driver specify their own schemas, then this may return null.
Cake\Database\Schema\BaseSchemaschemaValue( mixed $value )
Escapes values for use in schema definitions.
$value supportsDynamicConstraints( )
Returns whether the driver supports adding or dropping constraints to already created tables.
supportsQuoting( )
Checks if the driver supports quoting
supportsSavePoints( )
Returns whether this driver supports save points for nested transactions
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–2017 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.4/class-Cake.Database.Driver.html