$_connection
$_connection : \PDO|null
Instance of PDO.
SQLServer driver.
connect() : boolean
Establishes a connection to the database server.
Please note that the PDO::ATTR_PERSISTENT attribute is not supported by the SQL Server PHP PDO drivers. As a result you cannot use the persistent config option when connecting to a SQL Server (for more information see: https://github.com/Microsoft/msphpsql/issues/65).
if an unsupported setting is in the driver config
true on success
connection(mixed $connection = null) : mixed
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.
| mixed | $connection | The PDO connection instance. |
Connection object used internally.
prepare(string|\Cake\Database\Query $query) : \Cake\Database\StatementInterface
Prepares a sql statement to be executed
| string|\Cake\Database\Query | $query | The query to prepare. |
queryTranslator(string $type) : callable
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.
| string | $type | The type of query to be transformed (select, insert, update, delete). |
schemaDialect() : \Cake\Database\Schema\BaseSchema
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.
lastInsertId(string|null $table = null, string|null $column = null) : string|integer
Returns last id generated for a table or sequence in database.
| string|null | $table | table name or sequence to get last insert value from. |
| string|null | $column | the name of the column representing the primary key. |
autoQuoting(boolean|null $enable = null) : boolean
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
| boolean|null | $enable | Whether to enable auto quoting |
compileQuery(\Cake\Database\Query $query, \Cake\Database\ValueBinder $generator) : array
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 | The query to compile. |
| \Cake\Database\ValueBinder | $generator | The value binder to use. |
containing 2 entries. The first entity is the transformed query and the second one the compiled SQL.
newCompiler() : \Cake\Database\QueryCompiler
Returns an instance of a QueryCompiler.