Class Sqlserver

Dbo driver for SQLServer

A Dbo driver for SQLServer 2008 and higher. Requires the sqlsrv and pdo_sqlsrv extensions to be enabled.

Object

DataSource

DboSource

Sqlserver

Package: Cake\Model\Datasource\Database
Copyright: Copyright 2005-2012, Cake Software Foundation, Inc. (http://cakefoundation.org)
License: License (http://www.opensource.org/licenses/mit-license.php)
Location: Cake/Model/Datasource/Database/Sqlserver.php

Constants summary

string

ROW_COUNTER ¶

'_cake_page_rownum_'

Properties summary

$_baseConfig protected

array

Base configuration settings for MS SQL driver
$_fieldMappings protected

array

Creates a map between field aliases and numeric indexes. Workaround for the SQL Server driver's 30-character column name limitation.
$_lastAffected protected

mixed

Storing the last affected value
$columns public

array

MS SQL column definition
$description public

string

Driver description
$endQuote public

string

Ending quote character for quoted identifiers
$startQuote public

string

Starting quote character for quoted identifiers

Inherited Properties

_connection, _methodCacheChange, _queriesCnt, _queriesLog, _queriesLogMax, _queriesTime, _queryCache, _queryDefaults, _result, _sqlOps, _transactionNesting, affected, alias, cacheMethods, configKeyName, fieldParameters, fullDebug, index, methodCache, numRows, tableParameters, took, useNestedTransactions, virtualFieldSeparator _descriptions, _sources, _transactionStarted, cacheSources, config, connected

Method Summary

_execute() protected

Executes given SQL statement.
_getPrimaryKey() protected

Makes sure it will return the primary key
buildColumn() public

Generate a database-native column schema string
buildIndex() public

Format indexes for create table
column() public

Converts database-layer column types to basic types
connect() public

Connects to the database using options in the given configuration array.
create() public

Generates and executes an SQL INSERT statement for given model, fields, and values. Removes Identity (primary key) column from update data before returning to parent, if value is empty.
describe() public

Returns an array of the fields in given table name.
dropSchema() public

Generate a "drop table" statement for the given Schema object
enabled() public

Check that PDO SQL Server is installed/loaded
fetchResult() public

Fetches the next row from the current result set. Eats the magic ROW_COUNTER variable.
fields() public

Generates the fields list of an SQL query.
getSchemaName() public

Gets the schema name
insertMulti() public

Inserts multiple values into a table
lastAffected() public

Returns number of affected rows in previous database operation. If no previous operation exists, this returns false.
length() public

Handle SQLServer specific length properties. SQLServer handles text types as nvarchar/varchar with a length of -1.
limit() public

Returns a limit statement in the correct format for the particular database.
listSources() public

Returns an array of sources (tables) in the database.
read() public

Returns an array of all result rows for a given SQL query. Returns false if no rows matched.
renderStatement() public

Builds final SQL statement
resultSet() public

Builds a map of the columns contained in a result
update() public

Generates and executes an SQL UPDATE statement for given model, fields, and values. Removes Identity (primary key) column from update data before returning to parent.
value() public

Returns a quoted and escaped string of $data for use in an SQL statement.

Method Detail

_execute() protected ¶

_execute( string $sql , array $params = array() , array $prepareOptions = array() )

Executes given SQL statement.

Parameters

string $sql: SQL statement
array $params optional array(): list of params to be bound to query (supported only in select)
array $prepareOptions optional array(): Options to be used in the prepare statement

Returns

mixed

PDOStatement if query executes with no problem, true as the result of a successful, false on error query returning no rows, such as a CREATE statement, false otherwise

Throws

PDOException

Overrides

DboSource::_execute()

_getPrimaryKey() protected ¶

_getPrimaryKey( Model|string $model )

Makes sure it will return the primary key

Parameters

Model|string $model: Model instance of table name

Returns

string

buildColumn() public ¶

buildColumn( array $column )

Generate a database-native column schema string

Parameters

array $column: An array structured like the following: array('name'=>'value', 'type'=>'value'[, options]), where options can be 'default', 'length', or 'key'.

Returns

string

Overrides

DboSource::buildColumn()

buildIndex() public ¶

buildIndex( array $indexes , string $table = null )

Format indexes for create table

Parameters

array $indexes
string $table optional null

Returns

string

Overrides

DboSource::buildIndex()

column() public ¶

column( mixed $real )

Converts database-layer column types to basic types

Parameters

mixed $real: Either the string value of the fields type. or the Result object from Sqlserver::describe()

Returns

string
Abstract column type (i.e. "string")

Overrides

DataSource::column()

connect() public ¶

connect( )

Connects to the database using options in the given configuration array.

Returns

boolean
True if the database could be connected, else false

Throws

MissingConnectionException

create() public ¶

create( Model $model , array $fields = null , array $values = null )

Generates and executes an SQL INSERT statement for given model, fields, and values. Removes Identity (primary key) column from update data before returning to parent, if value is empty.

Parameters

Model $model
array $fields optional null
array $values optional null

Returns

array

Overrides

DboSource::create()

describe() public ¶

describe( Model|string $model )

Returns an array of the fields in given table name.

Parameters

Model|string $model: Model object to describe, or a string table name.

Returns

array
Fields in table. Keys are name and type

Throws

CakeException

Overrides

DataSource::describe()

dropSchema() public ¶

dropSchema( CakeSchema $schema , string $table = null )

Generate a "drop table" statement for the given Schema object

Parameters

CakeSchema $schema: An instance of a subclass of CakeSchema
string $table optional null: Optional. If specified only the table name given will be generated. Otherwise, all tables defined in the schema are generated.

Returns

string

Overrides

DboSource::dropSchema()

enabled() public ¶

enabled( )

Check that PDO SQL Server is installed/loaded

Returns

boolean

Overrides

DataSource::enabled()

fetchResult() public ¶

fetchResult( )

Fetches the next row from the current result set. Eats the magic ROW_COUNTER variable.

Returns

mixed

Overrides

DboSource::fetchResult()

fields() public ¶

fields( Model $model , string $alias = null , array $fields = array() , boolean $quote = true )

Generates the fields list of an SQL query.

Parameters

Model $model
string $alias optional null: Alias table name
array $fields optional array()
boolean $quote optional true

Returns

array

Overrides

DboSource::fields()

getSchemaName() public ¶

getSchemaName( )

Gets the schema name

Returns

string
The schema name

Overrides

DataSource::getSchemaName()

insertMulti() public ¶

insertMulti( string $table , string $fields , array $values )

Inserts multiple values into a table

Parameters

string $table
string $fields
array $values

Overrides

DboSource::insertMulti()

lastAffected() public ¶

lastAffected( mixed $source = null )

Returns number of affected rows in previous database operation. If no previous operation exists, this returns false.

Parameters

mixed $source optional null

Returns

integer
Number of affected rows

Overrides

DboSource::lastAffected()

length() public ¶

length( mixed $length )

Handle SQLServer specific length properties. SQLServer handles text types as nvarchar/varchar with a length of -1.

Parameters

mixed $length: Either the length as a string, or a Column descriptor object.

Returns

mixed
null|integer with length of column.

Overrides

DboSource::length()

limit() public ¶

limit( integer $limit , integer $offset = null )

Returns a limit statement in the correct format for the particular database.

Parameters

integer $limit: Limit of results returned
integer $offset optional null: Offset from which to start results

Returns

string
SQL limit/offset statement

Overrides

DboSource::limit()

listSources() public ¶

listSources( mixed $data = null )

Returns an array of sources (tables) in the database.

Parameters

mixed $data optional null

Returns

array
Array of table names in the database

Overrides

DataSource::listSources()

read() public ¶

read( Model $model , array $queryData = array() , integer $recursive = null )

Returns an array of all result rows for a given SQL query. Returns false if no rows matched.

Parameters

Model $model
array $queryData optional array()
integer $recursive optional null

Returns

array
Array of resultset rows, or false if no rows matched

Overrides

DboSource::read()

renderStatement() public ¶

renderStatement( string $type , array $data )

Builds final SQL statement

Parameters

string $type: Query type
array $data: Query data

Returns

string

Overrides

DboSource::renderStatement()

resultSet() public ¶

resultSet( PDOStatement $results )

Builds a map of the columns contained in a result

Parameters

PDOStatement $results

update() public ¶

update( Model $model , array $fields = array() , array $values = null , mixed $conditions = null )

Generates and executes an SQL UPDATE statement for given model, fields, and values. Removes Identity (primary key) column from update data before returning to parent.

Parameters

Model $model
array $fields optional array()
array $values optional null
mixed $conditions optional null

Returns

array

Overrides

DboSource::update()

value() public ¶

value( string $data , string $column = null )

Returns a quoted and escaped string of $data for use in an SQL statement.

Parameters

string $data: String to be prepared for use in an SQL statement
string $column optional null: The column into which this data will be inserted

Returns

string
Quoted and escaped data

Overrides

DboSource::value()

Methods inherited from DboSource

__construct() public ¶

__construct( array $config = null , boolean $autoConnect = true )

Constructor

Parameters

array $config optional null: Array of configuration information for the Datasource.
boolean $autoConnect optional true: Whether or not the datasource should automatically connect.

Throws

MissingConnectionException
when a connection cannot be made.

Overrides

DataSource::__construct()

__destruct() public ¶

__destruct( )

Used for storing in cache the results of the in-memory methodCache

Overrides

DataSource::__destruct()

_beginNested() protected ¶

_beginNested( )

Begin a nested transaction

Returns

boolean

_buildFieldParameters() protected ¶

_buildFieldParameters( string $columnString , array $columnData , string $position )

Build the field parameters, in a position

Parameters

string $columnString: The partially built column string
array $columnData: The array of column data.
string $position: The position type to use. 'beforeDefault' or 'afterDefault' are common

Returns

string
a built column with the field parameters added.

_commitNested() protected ¶

_commitNested( )

Commit a nested transaction

Returns

boolean

_constructVirtualFields() protected ¶

_constructVirtualFields( Model $model , string $alias , array $fields )

Converts model virtual fields into sql expressions to be fetched later

Parameters

Model $model
string $alias: Alias table name
array $fields: virtual fields to be used on query

Returns

array

_filterResults() protected ¶

_filterResults( array $results , Model $model , array $filtered = array() )

Passes association results thru afterFind filters of corresponding model

Parameters

array $results: Reference of resultset to be filtered
Model $model: Instance of model to operate against
array $filtered optional array(): List of classes already filtered, to be skipped

Returns

array
Array of results that have been filtered through $model->afterFind

_getJoins() protected ¶

_getJoins( Model $model )

Returns an array of SQL JOIN fragments from a model's associations

Parameters

Model $model

Returns

array

_matchRecords() protected ¶

_matchRecords( Model $model , mixed $conditions = null )

Gets a list of record IDs for the given conditions. Used for multi-record updates and deletes in databases that do not support aliases in UPDATE/DELETE queries.

Parameters

Model $model
mixed $conditions optional null

Returns

array
List of record IDs

_mergeAssociation() protected ¶

_mergeAssociation( array $data , array $merge , string $association , string $type , boolean $selfJoin = false )

Merge association of merge into data

Parameters

array $data
array $merge
string $association
string $type
boolean $selfJoin optional false

_mergeConditions() protected ¶

_mergeConditions( mixed $query , mixed $assoc )

Merges a mixed set of string/array conditions

Parameters

mixed $query
mixed $assoc

Returns

array

_mergeHasMany() protected ¶

_mergeHasMany( array $resultSet , array $merge , string $association , Model $model , Model $linkModel )

mergeHasMany - Merge the results of hasMany relations.

Parameters

array $resultSet: Data to merge into
array $merge: Data to merge
string $association: Name of Model being Merged
Model $model: Model being merged onto
Model $linkModel: Model being merged

_parseKey() protected ¶

_parseKey( Model $model , string $key , mixed $value )

Extracts a Model.field identifier and an SQL condition operator from a string, formats and inserts values, and composes them into an SQL snippet.

Parameters

Model $model: Model object initiating the query
string $key: An SQL key snippet containing a field and optional SQL operator
mixed $value: The value(s) to be inserted in the string

Returns

string

_prepareUpdateFields() protected ¶

_prepareUpdateFields( Model $model , array $fields , boolean $quoteValues = true , boolean $alias = false )

Quotes and prepares fields and values for an SQL UPDATE statement

Parameters

Model $model
array $fields
boolean $quoteValues optional true: If values should be quoted, or treated as SQL snippets
boolean $alias optional false: Include the model alias in the field name

Returns

array
Fields and values, quoted and prepared

_quoteFields() protected ¶

_quoteFields( string $conditions )

Quotes Model.fields

Parameters

string $conditions

Returns

string
or false if no match

_quoteMatchedField() protected ¶

_quoteMatchedField( string $match )

Auxiliary function to quote matches Model.fields from a preg_replace_callback call

Parameters

string $match: matched string

Returns

string
quoted string

_rollbackNested() protected ¶

_rollbackNested( )

Rollback a nested transaction

Returns

boolean

_scrubQueryData() protected ¶

_scrubQueryData( array $data )

Private helper method to remove query metadata in given data array.

Parameters

array $data

Returns

array

_writeQueryCache() protected ¶

_writeQueryCache( string $sql , mixed $data , array $params = array() )

Writes a new key for the in memory sql query cache

Parameters

string $sql: SQL query
mixed $data: result of $sql query
array $params optional array(): query params bound as values

alterSchema() public ¶

alterSchema( mixed $compare , string $table = null )

Generate a alter syntax from CakeSchema::compare()

Parameters

mixed $compare
string $table optional null

Returns

boolean

begin() public ¶

begin( )

Begin a transaction

Returns

boolean

True on success, false on fail (i.e. if the database/model does not support transactions, or a transaction has not started).

Overrides

DataSource::begin()

boolean() public ¶

boolean( mixed $data , boolean $quote = false )

Translates between PHP boolean values and Database (faked) boolean values

Parameters

mixed $data: Value to be translated
boolean $quote optional false

Returns

string|boolean
Converted boolean value

buildJoinStatement() public ¶

buildJoinStatement( array $join )

Builds and generates a JOIN statement from an array. Handles final clean-up before conversion.

Parameters

array $join: An array defining a JOIN statement in a query

Returns

string
An SQL JOIN statement to be used in a query

See

DboSource::renderJoinStatement()
DboSource::buildStatement()

buildStatement() public ¶

buildStatement( array $query , Model $model )

Builds and generates an SQL statement from an array. Handles final clean-up before conversion.

Parameters

array $query: An array defining an SQL query
Model $model: The model object which initiated the query

Returns

string
An executable SQL statement

See

DboSource::renderStatement()

buildTableParameters() public ¶

buildTableParameters( array $parameters , string $table = null )

Format parameters for create table

Parameters

array $parameters
string $table optional null

Returns

array

cacheMethod() public ¶

cacheMethod( string $method , string $key , mixed $value = null )

Cache a value into the methodCaches. Will respect the value of DboSource::$cacheMethods. Will retrieve a value from the cache if $value is null.

If caching is disabled and a write is attempted, the $value will be returned. A read will either return the value or null.

Parameters

string $method: Name of the method being cached.
string $key: The key name for the cache operation.
mixed $value optional null: The value to cache into memory.

Returns

mixed
Either null on failure, or the value if its set.

calculate() public ¶

calculate( Model $model , string $func , array $params = array() )

Returns an SQL calculation, i.e. COUNT() or MAX()

Parameters

Model $model
string $func: Lowercase name of SQL function, i.e. 'count' or 'max'
array $params optional array(): Function parameters (any values must be quoted manually)

Returns

string
An SQL calculation function

close() public ¶

close( )

Disconnects database, kills the connection and says the connection is closed.

Overrides

DataSource::close()

commit() public ¶

commit( )

Commit a transaction

Returns

boolean

True on success, false on fail (i.e. if the database/model does not support transactions, or a transaction has not started).

Overrides

DataSource::commit()

conditionKeysToString() public ¶

conditionKeysToString( array $conditions , boolean $quoteValues = true , Model $model = null )

Creates a WHERE clause by parsing given conditions array. Used by DboSource::conditions().

Parameters

array $conditions: Array or string of conditions
boolean $quoteValues optional true: If true, values should be quoted
Model $model optional null: A reference to the Model instance making the query

Returns

string
SQL fragment

conditions() public ¶

conditions( mixed $conditions , boolean $quoteValues = true , boolean $where = true , Model $model = null )

Creates a WHERE clause by parsing given conditions data. If an array or string conditions are provided those conditions will be parsed and quoted. If a boolean is given it will be integer cast as condition. Null will return 1 = 1.

Results of this method are stored in a memory cache. This improves performance, but because the method uses a hashing algorithm it can have collisions. Setting DboSource::$cacheMethods to false will disable the memory cache.

Parameters

mixed $conditions: Array or string of conditions, or any value.
boolean $quoteValues optional true: If true, values should be quoted
boolean $where optional true: If true, "WHERE " will be prepended to the return value
Model $model optional null: A reference to the Model instance making the query

Returns

string
SQL fragment

createSchema() public ¶

createSchema( Model $schema , string $tableName = null )

Generate a database-native schema for the given Schema object

Parameters

Model $schema: An instance of a subclass of CakeSchema
string $tableName optional null: Optional. If specified only the table name given will be generated. Otherwise, all tables defined in the schema are generated.

Returns

string

defaultConditions() public ¶

defaultConditions( Model $model , string|array|boolean $conditions , boolean $useAlias = true )

Creates a default set of conditions from the model if $conditions is null/empty. If conditions are supplied then they will be returned. If a model doesn't exist and no conditions were provided either null or false will be returned based on what was input.

Parameters

Model $model
string|array|boolean $conditions: Array of conditions, conditions string, null or false. If an array of conditions, or string conditions those conditions will be returned. With other values the model's existence will be checked. If the model doesn't exist a null or false will be returned depending on the input value.
boolean $useAlias optional true: Use model aliases rather than table names when generating conditions

Returns

mixed
Either null, false, $conditions or an array of default conditions to use.

See

DboSource::update()
DboSource::conditions()

delete() public ¶

delete( Model $model , mixed $conditions = null )

Generates and executes an SQL DELETE statement. For databases that do not support aliases in UPDATE queries.

Parameters

Model $model
mixed $conditions optional null

Returns

boolean
Success

Overrides

DataSource::delete()

disconnect() public ¶

disconnect( )

Disconnects from database.

Returns

boolean
True if the database could be disconnected, else false

execute() public ¶

execute( string $sql , array $options = array() , array $params = array() )

Queries the database with given SQL statement, and obtains some metadata about the result (rows affected, timing, any errors, number of rows in resultset). The query is also logged. If Configure::read('debug') is set, the log is shown all the time, else it is only shown on errors.

Options

log - Whether or not the query should be logged to the memory log.

Parameters

string $sql: SQL statement
array $options optional array()
array $params optional array(): values to be bound to the query

Returns

mixed
Resource or object representing the result set, or false on failure

expression() public ¶

expression( string $expression )

Returns an object to represent a database expression in a query. Expression objects are not sanitized or escaped.

Parameters

string $expression: An arbitrary SQL expression to be inserted into a query.

Returns

stdClass
An object representing a database expression to be used in a query

fetchAll() public ¶

fetchAll( string $sql , array $params = array() , array $options = array() )

Returns an array of all result rows for a given SQL query. Returns false if no rows matched.

Options

cache - Returns the cached version of the query, if exists and stores the result in cache. This is a non-persistent cache, and only lasts for a single request. This option defaults to true. If you are directly calling this method, you can disable caching by setting $options to false

Parameters

string $sql: SQL statement
array $params optional array(): parameters to be bound as values for the SQL statement
array $options optional array(): additional options for the query.

Returns

array
Array of resultset rows, or false if no rows matched

fetchAssociated() public ¶

fetchAssociated( Model $model , string $query , array $ids )

A more efficient way to fetch associations. Woohoo!

Parameters

Model $model: Primary model object
string $query: Association query
array $ids: Array of IDs of associated records

Returns

array
Association results

fetchRow() public ¶

fetchRow( string $sql = null )

Returns a row from current resultset as an array

Parameters

string $sql optional null: Some SQL to be executed.

Returns

array
The fetched row as an array

fetchVirtualField() public ¶

fetchVirtualField( array $result )

Modifies $result array to place virtual fields in model entry where they belongs to

Parameters

array $result: Reference to the fetched row

field() public ¶

field( string $name , string $sql )

Returns a single field of the first of query results for a given SQL query, or false if empty.

Parameters

string $name: Name of the field
string $sql: SQL query

Returns

mixed
Value of field read.

flushMethodCache() public ¶

flushMethodCache( )

Empties the method caches. These caches are used by DboSource::name() and DboSource::conditions()

fullTableName() public ¶

fullTableName( Model|string $model , boolean $quote = true , boolean $schema = true )

Gets full table name including prefix

Parameters

Model|string $model: Either a Model object or a string table name.
boolean $quote optional true: Whether you want the table name quoted.
boolean $schema optional true: Whether you want the schema name included.

Returns

string
Full quoted table name

generateAssociationQuery() public ¶

generateAssociationQuery( Model $model , Model $linkModel , string $type , string $association , array $assocData , array $queryData , boolean $external , array $resultSet )

Generates an array representing a query or part of a query from a single model or two associated models

Parameters

Model $model
Model $linkModel
string $type
string $association
array $assocData
array $queryData
boolean $external
array $resultSet

Returns

mixed

getConnection() public ¶

getConnection( )

Get the underlying connection object.

Returns

PDO

getConstraint() public ¶

getConstraint( string $type , Model $model , string $linkModel , string $alias , array $assoc , string $alias2 = null )

Returns a conditions array for the constraint between two models

Parameters

string $type: Association type
Model $model: Model object
string $linkModel
string $alias
array $assoc
string $alias2 optional null

Returns

array
Conditions array defining the constraint between $model and $association

getLog() public ¶

getLog( boolean $sorted = false , boolean $clear = true )

Get the query log as an array.

Parameters

boolean $sorted optional false: Get the queries sorted by time taken, defaults to false.
boolean $clear optional true: If True the existing log will cleared.

Returns

array
Array of queries run as an array

getQueryCache() public ¶

getQueryCache( string $sql , array $params = array() )

Returns the result for a sql query if it is already cached

Parameters

string $sql: SQL query
array $params optional array(): query params bound as values

Returns

mixed
results for query if it is cached, false otherwise

getVersion() public ¶

getVersion( )

Gets the version string of the database server

Returns

string
The database version

group() public ¶

group( string $group , Model $model = null )

Create a GROUP BY SQL clause

Parameters

string $group: Group By Condition
Model $model optional null

Returns

string
string condition or null

hasAny() public ¶

hasAny( Model $Model , string $sql )

Checks if the specified table contains any record matching specified SQL

Parameters

Model $Model: Model to search
string $sql: SQL WHERE clause (condition only, not the "WHERE" part)

Returns

boolean
True if the table has a matching record, else false

hasResult() public ¶

hasResult( )

Checks if the result is valid

Returns

boolean
True if the result is valid else false

identifier() public ¶

identifier( string $identifier )

Returns an object to represent a database identifier in a query. Expression objects are not sanitized or escaped.

Parameters

string $identifier: A SQL expression to be used as an identifier

Returns

stdClass
An object representing a database identifier to be used in a query

index() public ¶

index( string $model )

Returns an array of the indexes in given datasource name.

Parameters

string $model: Name of model to inspect

Returns

array
Fields in table. Keys are column and unique

introspectType() public ¶

introspectType( string $value )

Guesses the data type of an array

Parameters

string $value

isConnected() public ¶

isConnected( )

Checks if the source is connected to the database.

Returns

boolean
True if the database is connected, else false

lastError() public ¶

lastError( PDOStatement $query = null )

Returns a formatted error message from previous database operation.

Parameters

PDOStatement $query optional null: the query to extract the error from if any

Returns

string
Error message with error number

lastInsertId() public ¶

lastInsertId( mixed $source = null )

Returns the ID generated from the previous INSERT operation.

Parameters

mixed $source optional null

Returns

mixed

Overrides

DataSource::lastInsertId()

lastNumRows() public ¶

lastNumRows( mixed $source = null )

Returns number of rows in previous resultset. If no previous resultset exists, this returns false.

Parameters

mixed $source optional null: Not used

Returns

integer
Number of rows in resultset

Overrides

DataSource::lastNumRows()

logQuery() public ¶

logQuery( string $sql , array $params = array() )

Log given SQL query.

Parameters

string $sql: SQL statement
array $params optional array(): Values binded to the query (prepared statements)

name() public ¶

name( mixed $data )

Returns a quoted name of $data for use in an SQL statement. Strips fields out of SQL functions before quoting.

Parameters

mixed $data: Either a string with a column to quote. An array of columns to quote or an object from DboSource::expression() or DboSource::identifier()

Returns

string
SQL field

nestedTransactionSupported() public ¶

nestedTransactionSupported( )

Check if the server support nested transactions

Returns

boolean

order() public ¶

order( array|string $keys , string $direction = 'ASC' , Model $model = null )

Returns an ORDER BY clause as a string.

Parameters

array|string $keys: Field reference, as a key (i.e. Post.title)
string $direction optional 'ASC': Direction (ASC or DESC)
Model $model optional null: model reference (used to look for virtual field)

Returns

string
ORDER BY clause

query() public ¶

query( )

DataSource Query abstraction

Returns

resource
Result resource identifier.

queryAssociation() public ¶

queryAssociation( Model $model , Model $linkModel , string $type , string $association , array $assocData , array $queryData , boolean $external , array $resultSet , integer $recursive , array $stack )

Queries associations. Used to fetch results on recursive models.

Parameters

Model $model: Primary Model object
Model $linkModel: Linked model that
string $type: Association type, one of the model association types ie. hasMany
string $association
array $assocData
array $queryData
boolean $external: Whether or not the association query is on an external datasource.
array $resultSet: Existing results
integer $recursive: Number of levels of association
array $stack

Returns

mixed

Throws

CakeException
when results cannot be created.

rawQuery() public ¶

rawQuery( string $sql , array $params = array() )

Executes given SQL statement.

Parameters

string $sql: SQL statement
array $params optional array(): Additional options for the query.

Returns

boolean

readTableParameters() public ¶

readTableParameters( string $name )

Read additional table parameters

Parameters

string $name

Returns

array

reconnect() public ¶

reconnect( array $config = array() )

Reconnects to database server with optional new settings

Parameters

array $config optional array(): An array defining the new configuration settings

Returns

boolean
True on success, false on failure

renderJoinStatement() public ¶

renderJoinStatement( array $data )

Renders a final SQL JOIN statement

Parameters

array $data

Returns

string

resolveKey() public ¶

resolveKey( Model $model , string $key , string $assoc = null )

Returns a key formatted like a string Model.fieldname(i.e. Post.title, or Country.name)

Parameters

Model $model
string $key
string $assoc optional null

Returns

string

Overrides

DataSource::resolveKey()

rollback() public ¶

rollback( )

Rollback a transaction

Returns

boolean

True on success, false on fail (i.e. if the database/model does not support transactions, or a transaction has not started).

Overrides

DataSource::rollback()

showLog() public ¶

showLog( boolean $sorted = false )

Outputs the contents of the queries log. If in a non-CLI environment the sql_log element will be rendered and output. If in a CLI environment, a plain text log is generated.

Parameters

boolean $sorted optional false: Get the queries sorted by time taken, defaults to false.

truncate() public ¶

truncate( Model|string $table )

Deletes all the records in a table and resets the count of the auto-incrementing primary key, where applicable.

Parameters

Model|string $table: A string or model class representing the table to be truncated

Returns

boolean
SQL TRUNCATE TABLE statement, false if not applicable.

Methods inherited from DataSource

_cacheDescription() protected ¶

_cacheDescription( string $object , mixed $data = null )

Cache the DataSource description

Parameters

string $object: The name of the object (model) to cache
mixed $data optional null: The description of the model, usually a string or array

Returns

mixed

insertQueryData() public ¶

insertQueryData( string $query , array $data , string $association , array $assocData , Model $model , Model $linkModel , array $stack )

Replaces {$__cakeID__$} and {$__cakeForeignKey__$} placeholders in query data.

Parameters

string $query: Query string needing replacements done.
array $data: Array of data with values that will be inserted in placeholders.
string $association: Name of association model being replaced
array $assocData
Model $model: Instance of the model to replace $cakeID$
Model $linkModel: Instance of model to replace $cakeForeignKey$
array $stack

Returns

string
String of query data with placeholders replaced.

setConfig() public ¶

setConfig( array $config = array() )

Sets the configuration for the DataSource. Merges the $config information with the _baseConfig and the existing $config property.

Parameters

array $config optional array(): The configuration array

Methods inherited from Object

_mergeVars() protected ¶

_mergeVars( array $properties , string $class , boolean $normalize = true )

Merges this objects $property with the property in $class' definition. This classes value for the property will be merged on top of $class'

This provides some of the DRY magic CakePHP provides. If you want to shut it off, redefine this method as an empty function.

Parameters

array $properties: The name of the properties to merge.
string $class: The class to merge the property with.
boolean $normalize optional true: Set to true to run the properties through Hash::normalize() before merging.

_set() protected ¶

_set( array $properties = array() )

Allows setting of multiple properties of the object in a single line of code. Will only set properties that are part of a class declaration.

Parameters

array $properties optional array(): An associative array containing properties and corresponding values.

_stop() protected ¶

_stop( integer|string $status = 0 )

Stop execution of the current script. Wraps exit() making testing easier.

Parameters

integer|string $status optional 0: see http://php.net/exit for values

dispatchMethod() public ¶

dispatchMethod( string $method , array $params = array() )

Calls a method on this object with the given parameters. Provides an OO wrapper for call_user_func_array

Parameters

string $method: Name of the method to call
array $params optional array(): Parameter list to use when calling $method

Returns

mixed
Returns the result of the method call

log() public ¶

log( string $msg , integer $type = LOG_ERR )

Convenience method to write a message to CakeLog. See CakeLog::write() for more information on writing to logs.

Parameters

string $msg: Log message
integer $type optional LOG_ERR: Error type constant. Defined in app/Config/core.php.

Returns

boolean
Success of log write

requestAction() public ¶

requestAction( string|array $url , array $extra = array() )

Calls a controller's method from any location. Can be used to connect controllers together or tie plugins into a main application. requestAction can be used to return rendered views or fetch the return value from controller actions.

Under the hood this method uses Router::reverse() to convert the $url parameter into a string URL. You should use URL formats that are compatible with Router::reverse()

Passing POST and GET data

POST and GET data can be simulated in requestAction. Use $extra['url'] for GET data. The $extra['data'] parameter allows POST data simulation.

Parameters

string|array $url: String or array-based url. Unlike other url arrays in CakePHP, this url will not automatically handle passed and named arguments in the $url parameter.
array $extra optional array(): if array includes the key "return" it sets the AutoRender to true. Can also be used to submit GET/POST data, and named/passed arguments.

Returns

mixed

Boolean true or false on success/failure, or contents of rendered action if 'return' is set in $extra.

toString() public ¶

toString( )

Object-to-string conversion. Each class can override this method as necessary.

Returns

string
The name of this class

Properties detail

`$_baseConfig` ¶

protected array

Base configuration settings for MS SQL driver

array(
    'persistent' => true,
    'host' => 'localhost\SQLEXPRESS',
    'login' => '',
    'password' => '',
    'database' => 'cake',
    'schema' => '',
)

`$_fieldMappings` ¶

protected array

Creates a map between field aliases and numeric indexes. Workaround for the SQL Server driver's 30-character column name limitation.

array()

`$_lastAffected` ¶

protected mixed

Storing the last affected value

false

`$columns` ¶

public array

MS SQL column definition

array(
    'primary_key' => array('name' => 'IDENTITY (1, 1) NOT NULL'),
    'string'    => array('name' => 'nvarchar', 'limit' => '255'),
    'text'      => array('name' => 'nvarchar', 'limit' => 'MAX'),
    'integer'   => array('name' => 'int', 'formatter' => 'intval'),
    'float'     => array('name' => 'numeric', 'formatter' => 'floatval'),
    'datetime'  => array('name' => 'datetime', 'format' => 'Y-m-d H:i:s', 'formatter' => 'date'),
    'timestamp' => array('name' => 'timestamp', 'format' => 'Y-m-d H:i:s', 'formatter' => 'date'),
    'time'      => array('name' => 'datetime', 'format' => 'H:i:s', 'formatter' => 'date'),
    'date'      => array('name' => 'datetime', 'format' => 'Y-m-d', 'formatter' => 'date'),
    'binary'    => array('name' => 'varbinary'),
    'boolean'   => array('name' => 'bit')
)

`$description` ¶

public string

Driver description

"SQL Server DBO Driver"

`$endQuote` ¶

public string

Ending quote character for quoted identifiers

"]"

`$startQuote` ¶

public string

Starting quote character for quoted identifiers

"["

Packages

Classes

Class Sqlserver

Constants summary

Properties summary

Inherited Properties

Method Summary

_execute() protected

_getPrimaryKey() protected

buildColumn() public

buildIndex() public

column() public

connect() public

create() public

describe() public

dropSchema() public

enabled() public

fetchResult() public

fields() public

getSchemaName() public

insertMulti() public

lastAffected() public

length() public

limit() public

listSources() public

read() public

renderStatement() public

resultSet() public

update() public

value() public

Method Detail

_execute() protected ¶

Parameters

Returns

Throws

Overrides

_getPrimaryKey() protected ¶

Parameters

Returns

buildColumn() public ¶

Parameters

Returns

Overrides

buildIndex() public ¶

Parameters

Returns

Overrides

column() public ¶

Parameters

Returns

Overrides

connect() public ¶

Returns

Throws

create() public ¶

Parameters

Returns

Overrides

describe() public ¶

Parameters

Returns

Throws

Overrides

dropSchema() public ¶

Parameters

Returns

Overrides

enabled() public ¶

Returns

Overrides

fetchResult() public ¶

Returns

Overrides

fields() public ¶

Parameters

Returns

Overrides

getSchemaName() public ¶

Returns

Overrides