Interface for database driver.
Transforms the passed query to this Driver's dialect and returns an instance of the transformed query and the full compiled SQL string.
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.
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.
disableForeignKeySQL( )
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.
getConnection( )
Returns correct connection resource or object that is internally used.
isAutoQuotingEnabled( )
Returns whether or not this driver should automatically quote identifiers in queries.
isConnected( )
Checks 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\StatementInterface
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).
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( )
Rollbacks 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\BaseSchema
schemaValue( mixed $value )
Escapes values for use in schema definitions.
$value
setConnection( object $connection )
Set the internal connection object.
$connection
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.
© 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.DriverInterface.html