Class Mysql
Class Mysql
- Cake\Database\Driver implements Cake\Database\DriverInterface
-
Cake\Database\Driver\Mysql
uses
Cake\Database\Dialect\MysqlDialectTrait
Properties summary
-
$_baseConfigprotectedarrayBase configuration settings for MySQL driver -
$_supportsNativeJsonprotectedbooleanWhether or not the server supports native JSON -
$_versionprotectedstringThe server version
Inherited Properties
-
_autoQuoting,_config,_connection_endQuote,_schemaDialect,_startQuote
Method Summary
-
connect() public
Establishes a connection to the database server -
enabled() public
Returns whether php is able to use this driver for connecting to database -
prepare() public
Prepares a sql statement to be executed -
schema() public
Returns the schema name that's being used. -
supportsDynamicConstraints() public
Returns whether the driver supports adding or dropping constraints to already created tables.
-
supportsNativeJson() public
Returns true if the server supports native JSON columns
Method Detail
connect() public ¶
connect( )
Establishes a connection to the database server
Returns
true on success
enabled() public ¶
enabled( )
Returns whether php is able to use this driver for connecting to database
Returns
true if it is valid to use this driver
prepare() public ¶
prepare( string|Cake\Database\Query $query )
Prepares a sql statement to be executed
Parameters
-
string|
Cake\Database\Query$query - The query to prepare.
Returns
Overrides
supportsDynamicConstraints() public ¶
supportsDynamicConstraints( )
Returns whether the driver supports adding or dropping constraints to already created tables.
Returns
true if driver supports dynamic constraints.
supportsNativeJson() public ¶
supportsNativeJson( )
Returns true if the server supports native JSON columns
Returns
Methods inherited from Cake\Database\Driver
__construct() public ¶
__construct( array $config = [] )
Constructor
Parameters
- array $config optional []
- The configuration for the driver.
Throws
__debugInfo() public ¶
__debugInfo( )
Returns an array that can be used to describe the internal state of this object.
Returns
_connect() protected ¶
_connect( string $dsn , array $config )
Establishes a connection to the database server
Parameters
- string $dsn
- A Driver-specific PDO-DSN
- array $config
- configuration to be used for creating connection
Returns
true on success
autoQuoting() public deprecated ¶
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
Deprecated
Parameters
- boolean|null $enable optional null
- Whether to enable auto quoting
Returns
beginTransaction() public ¶
beginTransaction( )
Starts a transaction.
Returns
True on success, false otherwise.
Implementation of
commitTransaction() public ¶
commitTransaction( )
Commits a transaction.
Returns
True on success, false otherwise.
Implementation of
compileQuery() 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
containing 2 entries. The first entity is the transformed query and the second one the compiled SQL.
Implementation of
connection() public deprecated ¶
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.
Deprecated
Parameters
- mixed $connection optional null
- The PDO connection instance.
Returns
Connection object used internally.
disableAutoQuoting() public ¶
disableAutoQuoting( )
Disable auto quoting of identifiers in queries.
Returns
$this
disableForeignKeySQL() abstract public ¶
disableForeignKeySQL( )
Get the SQL for disabling foreign keys.
Returns
Implementation of
enableAutoQuoting() public ¶
enableAutoQuoting( boolean $enable = true )
Sets whether or not this driver should automatically quote identifiers in queries.
Parameters
- boolean $enable optional true
- Whether to enable auto quoting
Returns
$this
Implementation of
enableForeignKeySQL() abstract public ¶
enableForeignKeySQL( )
Get the SQL for enabling foreign keys.
Returns
Implementation of
getConnection() public ¶
getConnection( )
Get the internal PDO connection instance.
Returns
Implementation of
isAutoQuotingEnabled() public ¶
isAutoQuotingEnabled( )
Returns whether or not this driver should automatically quote identifiers in queries.
Returns
Implementation of
isConnected() public ¶
isConnected( )
Checks whether or not the driver is connected.
Returns
Implementation of
lastInsertId() 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
Implementation of
newCompiler() public ¶
newCompiler( )
Returns an instance of a QueryCompiler.
Returns
Implementation of
queryTranslator() 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
Implementation of
quote() 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
Implementation of
quoteIdentifier() 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
Implementation of
releaseSavePointSQL() abstract public ¶
releaseSavePointSQL( string $name )
Get the SQL for releasing a save point.
Parameters
- string $name
- The table name.
Returns
Implementation of
rollbackSavePointSQL() abstract public ¶
rollbackSavePointSQL( string $name )
Get the SQL for rollingback a save point.
Parameters
- string $name
- The table name.
Returns
Implementation of
rollbackTransaction() public ¶
rollbackTransaction( )
Rollbacks a transaction.
Returns
True on success, false otherwise.
Implementation of
savePointSQL() abstract public ¶
savePointSQL( string $name )
Get the SQL for creating a save point.
Parameters
- string $name
- The table name.
Returns
Implementation of
schemaDialect() abstract public ¶
schemaDialect( )
Get the schema dialect.
Returns
Implementation of
schemaValue() public ¶
schemaValue( mixed $value )
Escapes values for use in schema definitions.
Parameters
- mixed $value
- The value to escape.
Returns
String for use in schema definitions.
Implementation of
setConnection() public ¶
setConnection( PDO $connection )
Set the internal PDO connection instance.
Parameters
- PDO $connection
- PDO instance.
Returns
$this
Implementation of
supportsQuoting() public ¶
supportsQuoting( )
Checks if the driver supports quoting, as PDO_ODBC does not support it.
Returns
Implementation of
supportsSavePoints() public ¶
supportsSavePoints( )
Returns whether this driver supports save points for nested transactions.
Returns
True if save points are supported, false otherwise.
Implementation of
Methods used from Cake\Database\Dialect\MysqlDialectTrait
schemaDialect() public ¶
schemaDialect( )
Get the schema dialect.
Used by Cake\Database\Schema package to reflect schema and generate schema.
Returns
Properties detail
$_baseConfig ¶
Base configuration settings for MySQL driver
[
'persistent' => true,
'host' => 'localhost',
'username' => 'root',
'password' => '',
'database' => 'cake',
'port' => '3306',
'flags' => [],
'encoding' => 'utf8mb4',
'timezone' => null,
'init' => [],
]