SQLServer driver.
$_baseConfig
protected array
_autoQuoting
, _config
, _connection
_endQuote
, _startQuote
Returns whether the driver supports adding or dropping constraints to already created tables.
connect( )
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).
enabled( )
Returns whether PHP is able to use this driver for connecting to database
prepare( string|Cake\Database\Query $query )
Prepares a sql statement to be executed
Cake\Database\Query
$query
Cake\Database\StatementInterface
Cake\Database\Driver::prepare()
supportsDynamicConstraints( )
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.
_connect( string $dsn , array $config )
Establishes a connection to the database server
$dsn
$config
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.
Cake\Database\DriverInterface::beginTransaction()
commitTransaction( )
Commits a transaction.
Cake\Database\DriverInterface::commitTransaction()
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.
Cake\Database\DriverInterface::compileQuery()
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.
$connection
optional null disableForeignKeySQL( )
Get the SQL for disabling foreign keys.
Cake\Database\DriverInterface::disableForeignKeySQL()
disconnect( )
Disconnects from database server.
Cake\Database\DriverInterface::disconnect()
enableAutoQuoting( boolean $enable true )
Sets whether or not this driver should automatically quote identifiers in queries.
$enable
optional true Cake\Database\DriverInterface::enableAutoQuoting()
enableForeignKeySQL( )
Get the SQL for enabling foreign keys.
Cake\Database\DriverInterface::enableForeignKeySQL()
getConnection( )
Get the internal PDO connection instance.
Cake\Database\DriverInterface::getConnection()
isAutoQuotingEnabled( )
Returns whether or not this driver should automatically quote identifiers in queries.
Cake\Database\DriverInterface::isAutoQuotingEnabled()
isConnected( )
Checks whether or not the driver is connected.
Cake\Database\DriverInterface::isConnected()
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 Cake\Database\DriverInterface::lastInsertId()
newCompiler( )
Returns an instance of a QueryCompiler.
Cake\Database\DriverInterface::newCompiler()
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).
Cake\Database\DriverInterface::queryTranslator()
quote( mixed $value , string $type )
Returns a value in a safe representation to be used in a query string
$value
$type
Cake\Database\DriverInterface::quote()
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
Cake\Database\DriverInterface::quoteIdentifier()
releaseSavePointSQL( string $name )
Get the SQL for releasing a save point.
$name
Cake\Database\DriverInterface::releaseSavePointSQL()
rollbackSavePointSQL( string $name )
Get the SQL for rollingback a save point.
$name
Cake\Database\DriverInterface::rollbackSavePointSQL()
rollbackTransaction( )
Rollbacks a transaction.
Cake\Database\DriverInterface::rollbackTransaction()
savePointSQL( string $name )
Get the SQL for creating a save point.
$name
Cake\Database\DriverInterface::savePointSQL()
schema( )
Returns the schema name that's being used.
Cake\Database\DriverInterface::schema()
schemaDialect( )
Get the schema dialect.
Cake\Database\Schema\BaseSchema
Cake\Database\DriverInterface::schemaDialect()
schemaValue( mixed $value )
Escapes values for use in schema definitions.
$value
Cake\Database\DriverInterface::schemaValue()
setConnection( PDO $connection )
Set the internal PDO connection instance.
$connection
Cake\Database\DriverInterface::setConnection()
supportsQuoting( )
Checks if the driver supports quoting, as PDO_ODBC does not support it.
Cake\Database\DriverInterface::supportsQuoting()
supportsSavePoints( )
Returns whether this driver supports save points for nested transactions.
Cake\Database\DriverInterface::supportsSavePoints()
_expressionTranslators( )
Returns a dictionary of expressions to be transformed when compiling a Query to SQL. Array keys are method names to be called in this class
_pagingSubquery( Cake\Database\Query $original , integer $limit , integer $offset )
Generate a paging subquery for older versions of SQLserver.
Prior to SQLServer 2012 there was no equivalent to LIMIT OFFSET, so a subquery must be used.
$original
$limit
$offset
_selectQueryTranslator( Cake\Database\Query $query )
Modify the limit/offset to TSQL
$query
_transformDistinct( Cake\Database\Query $original )
Returns the passed query after rewriting the DISTINCT clause, so that drivers that do not support the "ON" part can provide the actual way it should be done
$original
_transformFunctionExpression( Cake\Database\Expression\FunctionExpression $expression )
Receives a FunctionExpression and changes it so that it conforms to this SQL dialect.
$expression
_version( )
disableForeignKeySQL( )
enableForeignKeySQL( )
releaseSavePointSQL( string $name )
Returns a SQL snippet for releasing a previously created save point
$name
rollbackSavePointSQL( string $name )
Returns a SQL snippet for rollbacking a previously created save point
$name
savePointSQL( string $name )
Returns a SQL snippet for creating a new transaction savepoint
$name
schemaDialect( )
Get the schema dialect.
Used by Cake\Schema package to reflect schema and generate schema.
protected array
Base configuration settings for Sqlserver driver
[ 'host' => 'localhost\SQLEXPRESS', 'username' => '', 'password' => '', 'database' => 'cake', 'port' => '', // PDO::SQLSRV_ENCODING_UTF8 'encoding' => 65001, 'flags' => [], 'init' => [], 'settings' => [], 'attributes' => [], 'app' => null, 'connectionPooling' => null, 'failoverPartner' => null, 'loginTimeout' => null, 'multiSubnetFailover' => null, ]
© 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.Driver.Sqlserver.html