On this page
Class Driver
Represents a database diver containing all specificities for a database engine including its SQL dialect
Direct Subclasses
- Cake\Database\Driver\Mysql
- Cake\Database\Driver\Postgres
- Cake\Database\Driver\Sqlite
- Cake\Database\Driver\Sqlserver
Properties summary
-
$_autoQuoting
protectedboolean
Indicates whether or not the driver is doing automatic identifier quoting for all queries
-
$_baseConfig
protectedarray
Base configuration that is merged into the user supplied configuration data.
-
$_config
protectedarray
Method Summary
-
__construct() publicConstructor
-
__debugInfo() public
Returns an array that can be used to describe the internal state of this object.
-
__destruct() publicDestructor
-
autoQuoting() public
Returns whether or not this driver should automatically quote identifiers in queries
- Starts a transaction
- Commits a transaction
-
compileQuery() public
Transforms the passed query to this Driver's dialect and returns an instance of the transformed query and the full compiled SQL string
- Establishes a connection to the database server
-
Returns correct connection resource or object that is internally used If first argument is passed,
- Get the SQL for disabling foreign keys
- Disconnects from database server
- Get the SQL for enabling foreign keys
- Returns whether php is able to use this driver for connecting to database
-
isConnected() publicCheck whether or not the driver is connected.
-
lastInsertId() publicReturns last id generated for a table or sequence in database
-
newCompiler() publicReturns an instance of a QueryCompiler
- Prepares a sql statement to be executed
-
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.
- Returns a value in a safe representation to be used in a query string
-
Quotes a database identifier (a column name, table name, etc..) to be used safely in queries without the risk of using reserved words
- Get the SQL for releasing a save point.
- Get the SQL for rollingback a save point.
- Rollsback a transaction
- Get the SQL for creating a save point.
- Get the schema dialect.
-
schemaValue() publicEscapes values for use in schema definitions.
-
Returns whether the driver supports adding or dropping constraints to already created tables.
-
supportsQuoting() publicChecks if the driver supports quoting
-
supportsSavePoints() publicReturns whether this driver supports save points for nested transactions
Method Detail
__construct()source public
__construct( array $config [] )
Constructor
Parameters
-
array
$config
optional [] - The configuration for the driver.
Throws
InvalidArgumentException__debugInfo()source public
__debugInfo( )
Returns an array that can be used to describe the internal state of this object.
Returns
arrayautoQuoting()source public
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
Parameters
-
boolean|null
$enable
optional null - whether to enable auto quoting
Returns
booleanbeginTransaction()source abstract public
beginTransaction( )
Starts a transaction
Returns
booleantrue on success, false otherwise
commitTransaction()source abstract public
commitTransaction( )
Commits a transaction
Returns
booleantrue on success, false otherwise
compileQuery()source public
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
Parameters
Cake\Database\Query
$query
- The query to compile.
-
Cake\Database\ValueBinder
$generator
- The value binder to use.
Returns
arraycontaining 2 entries. The first entity is the transformed query and the second one the compiled SQL
connect()source abstract public
connect( )
Establishes a connection to the database server
Returns
booleantrue con success
connection()source abstract public
connection( null|PDO $connection null )
Returns correct connection resource or object that is internally used If first argument is passed,
Parameters
-
null|PDO
$connection
optional null - The connection object
disableForeignKeySQL()source abstract public
disableForeignKeySQL( )
Get the SQL for disabling foreign keys
Returns
stringenableForeignKeySQL()source abstract public
enableForeignKeySQL( )
Get the SQL for enabling foreign keys
Returns
stringenabled()source abstract public
enabled( )
Returns whether php is able to use this driver for connecting to database
Returns
booleantrue if it is valid to use this driver
isConnected()source public
isConnected( )
Check whether or not the driver is connected.
Returns
booleanlastInsertId()source public
lastInsertId( string|null $table null , string|null $column null )
Returns last id generated for a table or sequence in database
Parameters
-
string|null
$table
optional null - table name or sequence to get last insert value from
-
string|null
$column
optional null - the name of the column representing the primary key
Returns
string|integernewCompiler()source public
newCompiler( )
Returns an instance of a QueryCompiler
Returns
Cake\Database\QueryCompilerprepare()source abstract public
prepare( string|Cake\Database\Query $query )
Prepares a sql statement to be executed
Parameters
-
string|
Cake\Database\Query
$query
- The query to convert into a statement.
Returns
Cake\Database\StatementInterface
queryTranslator()source abstract public
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.
Parameters
-
string
$type
-
the type of query to be transformed (select, insert, update, delete)
Returns
callablequote()source abstract public
quote( mixed $value , string $type )
Returns a value in a safe representation to be used in a query string
Parameters
-
mixed
$value
- The value to quote.
-
string
$type
- Type to be used for determining kind of quoting to perform
Returns
stringquoteIdentifier()source abstract public
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
Parameters
-
string
$identifier
- The identifier expression to quote.
Returns
stringreleaseSavePointSQL()source abstract public
releaseSavePointSQL( string $name )
Get the SQL for releasing a save point.
Parameters
-
string
$name
- The table name
Returns
stringrollbackSavePointSQL()source abstract public
rollbackSavePointSQL( string $name )
Get the SQL for rollingback a save point.
Parameters
-
string
$name
- The table name
Returns
stringrollbackTransaction()source abstract public
rollbackTransaction( )
Rollsback a transaction
Returns
booleantrue on success, false otherwise
savePointSQL()source abstract public
savePointSQL( string $name )
Get the SQL for creating a save point.
Parameters
-
string
$name
- The table name
Returns
stringschemaDialect()source abstract public
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.
Returns
Cake\Database\Schema\BaseSchema
schemaValue()source public
schemaValue( mixed $value )
Escapes values for use in schema definitions.
Parameters
-
mixed
$value
- The value to escape.
Returns
stringString for use in schema definitions.
supportsDynamicConstraints()source abstract public
supportsDynamicConstraints( )
Returns whether the driver supports adding or dropping constraints to already created tables.
Returns
booleantrue if driver supports dynamic constraints
supportsQuoting()source public
supportsQuoting( )
Checks if the driver supports quoting
Returns
booleansupportsSavePoints()source public
supportsSavePoints( )
Returns whether this driver supports save points for nested transactions
Returns
booleantrue if save points are supported, false otherwise
Properties detail
$_autoQuotingsource
protected boolean
Indicates whether or not the driver is doing automatic identifier quoting for all queries
false
$_baseConfigsource
protected array
Base configuration that is merged into the user supplied configuration data.
[]
© 2005–2016 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.
http://api.cakephp.org/3.2/class-Cake.Database.Driver.html