Class DataSource

DataSource base class

Long description for file

Object

DataSource

Direct Subclasses

DboSource

Indirect Subclasses

Package: cake\cake\libs\model\datasources
Copyright: Copyright 2005-2012, Cake Software Foundation, Inc. (http://cakefoundation.org)
License: The MIT License
Location: model/datasources/datasource.php

Properties summary

$__descriptions public

array

Holds references to descriptions loaded by the DataSource
$_baseConfig public

array

The default configuration of a specific DataSource
$_queriesCnt public

integer

Queries count.
$_queriesLog public

unknown_type

Log of queries executed by this DataSource
$_queriesLogMax public

integer

Maximum number of items in query log, to prevent query log taking over too much memory on large amounts of queries -- I we've had problems at

6000 queries on one system.
$_queriesTime public

unknown_type

Total duration of all queries.
$_queryCache public

array

Caches serialzed results of executed queries
$_result public

array

Enter description here...
$_sources public

array

Holds a list of sources (tables) contained in the DataSource
$_transactionStarted public

boolean

Whether or not this DataSource is in the middle of a transaction
$affected public

string

String to hold how many rows were affected by the last SQL operation.
$cacheSources public

boolean

Whether or not source data like available tables and schema descriptions should be cached
$config public

array

The DataSource configuration
$configKeyName public

string

The DataSource configuration key name
$connected public

boolean

Are we connected to the DataSource?
$connection public

array

A reference to the physical connection of this DataSource
$endQuote public

string

The ending character that this DataSource uses for quoted identifiers.
$error public

unknown_type

Error description of last query
$fullDebug public

boolean

Print full query debug info?
$numRows public

integer

Number of rows in current resultset
$startQuote public

string

The starting character that this DataSource uses for quoted identifiers.
$took public

integer

Time the last query took

Inherited Properties

_log

Method Summary

__cacheDescription() public

Cache the DataSource description
__construct() public

Constructor.
__destruct() public

Closes the current datasource.
begin() public

Begin a transaction
column() public

Converts column types to basic types
commit() public

Commit a transaction
create() public

Used to create new records. The "C" CRUD.
delete() public

Delete a record(s) in the datasource.
describe() public

Returns a Model description (metadata) or null if none found.
enabled() public

Check whether the conditions for the Datasource being available are satisfied. Often used from connect() to check for support before establishing a connection.
insertQueryData() public

Enter description here...
isInterfaceSupported() public

Returns true if the DataSource supports the given interface (method)
lastAffected() public

Returns the ID generated from the previous INSERT operation.
lastInsertId() public

Returns the ID generated from the previous INSERT operation.
lastNumRows() public

Returns the ID generated from the previous INSERT operation.
listSources() public

Caches/returns cached results for child instances
read() public

Used to read records from the Datasource. The "R" in CRUD
resolveKey() public

To-be-overridden in subclasses.
rollback() public

Rollback a transaction
setConfig() public

Sets the configuration for the DataSource
sources() public

Convenience method for DboSource::listSources(). Returns source names in lowercase.
update() public

Update a record(s) in the datasource.

Method Detail

__cacheDescription() public ¶

__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

__construct() public ¶

__construct( $config = array() )

Constructor.

Overrides

Object::__construct()

__destruct() public ¶

__destruct( )

Closes the current datasource.

begin() public ¶

begin( $model )

Begin a transaction

Returns

boolean
Returns true if a transaction is not in progress

column() public ¶

column( string $real )

Converts column types to basic types

Parameters

string $real: Real column type (i.e. "varchar(255)")

Returns

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

commit() public ¶

commit( $model )

Commit a transaction

Returns

boolean
Returns true if a transaction is in progress

create() public ¶

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

Used to create new records. The "C" CRUD.

To-be-overridden in subclasses.

Parameters

Model $model: The Model to be created.
array $fields optional null: An Array of fields to be saved.
array $values optional null: An Array of values to save.

Returns

boolean
success

delete() public ¶

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

Delete a record(s) in the datasource.

To-be-overridden in subclasses.

Parameters

Model $model: The model class having record(s) deleted
mixed $id optional null: Primary key of the model

describe() public ¶

describe( Model $model )

Returns a Model description (metadata) or null if none found.

Parameters

Model $model

Returns

mixed

enabled() public ¶

enabled( )

Check whether the conditions for the Datasource being available are satisfied. Often used from connect() to check for support before establishing a connection.

Returns

boolean
Whether or not the Datasources conditions for use are met.

insertQueryData() public ¶

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

Enter description here...

Parameters

unknown_type $query
unknown_type $data
unknown_type $association
unknown_type $assocData
Model $model
Model $linkModel
array $stack

Returns

unknown

isInterfaceSupported() public ¶

isInterfaceSupported( string $interface )

Returns true if the DataSource supports the given interface (method)

Parameters

string $interface: The name of the interface (method)

Returns

boolean
True on success

lastAffected() public ¶

lastAffected( unknown_type $source = null )

Returns the ID generated from the previous INSERT operation.

Parameters

unknown_type $source optional null

Returns

lastInsertId() public ¶

lastInsertId( unknown_type $source = null )

Returns the ID generated from the previous INSERT operation.

Parameters

unknown_type $source optional null

Returns

lastNumRows() public ¶

lastNumRows( unknown_type $source = null )

Returns the ID generated from the previous INSERT operation.

Parameters

unknown_type $source optional null

Returns

listSources() public ¶

listSources( $data = null )

Caches/returns cached results for child instances

Returns

array

read() public ¶

read( Model $model , array $queryData = array() )

Used to read records from the Datasource. The "R" in CRUD

To-be-overridden in subclasses.

Parameters

Model $model: The model being read.
array $queryData optional array(): An array of query data used to find the data you want

Returns

mixed

resolveKey() public ¶

resolveKey( unknown_type $model , unknown_type $key )

To-be-overridden in subclasses.

Parameters

unknown_type $model
unknown_type $key

Returns

unknown

rollback() public ¶

rollback( $model )

Rollback a transaction

Returns

boolean
Returns true if a transaction is in progress

setConfig() public ¶

setConfig( array $config = array() )

Sets the configuration for the DataSource

Parameters

array $config optional array(): The configuration array

sources() public ¶

sources( $reset = false )

Convenience method for DboSource::listSources(). Returns source names in lowercase.

Returns

array

update() public ¶

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

Update a record(s) in the datasource.

To-be-overridden in subclasses.

Parameters

Model $model: Instance of the model class being updated
array $fields optional null: Array of fields to be updated
array $values optional null: Array of values to be update $fields to.

Returns

boolean
Success

Methods inherited from Object

Object() public ¶

Object( )

A hack to support __construct() on PHP 4 Hint: descendant classes have no PHP4 class_name() constructors, so this constructor gets called first and calls the top-layer __construct() which (if present) should call parent::__construct()

Returns

Object

__openPersistent() public ¶

__openPersistent( string $name , string $type = null )

Open the persistent class file for reading Used by Object::_persist()

Parameters

string $name: Name of persisted class
string $type optional null: Type of persistance (e.g: registry)

_persist() public ¶

_persist( string $name , string $return , $object , $type = null )

Checks for a persistent class file, if found file is opened and true returned If file is not found a file is created and false returned If used in other locations of the model you should choose a unique name for the persistent file There are many uses for this method, see manual for examples

Parameters

string $name: name of the class to persist
string $return: $object the object to persist
$object
$type optional null

Returns

boolean
Success

_savePersistent() public ¶

_savePersistent( string $name , object $object )

You should choose a unique name for the persistent file

There are many uses for this method, see manual for examples

Parameters

string $name: name used for object to cache
object $object: the object to persist

Returns

boolean
true on save, throws error if file can not be created

_set() public ¶

_set( array $properties = array() )

Allows setting of multiple properties of the object in a single line of code.

Parameters

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

_stop() public ¶

_stop( $status = 0 )

Stop execution of the current script

Parameters

$status optional 0: http://php.net/exit for values

cakeError() public ¶

cakeError( string $method , array $messages = array() )

Used to report user friendly errors. If there is a file app/error.php or app/app_error.php this file will be loaded error.php is the AppError class it should extend ErrorHandler class.

Parameters

string $method: Method to be called in the error class (AppError or ErrorHandler classes)
array $messages optional array(): Message that is to be displayed by the error class

Returns

error
message

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, and improves performance by using straight method calls in most cases.

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_ERROR )

API for logging events.

Parameters

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

Returns

boolean
Success of log write

requestAction() public ¶

requestAction( mixed $url , array $extra = array() )

Calls a controller's method from any location.

Parameters

mixed $url: String or array-based url.
array $extra optional array(): if array includes the key "return" it sets the AutoRender to true.

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

`$__descriptions` ¶

public array

Holds references to descriptions loaded by the DataSource

array()

`$_baseConfig` ¶

public array

The default configuration of a specific DataSource

array()

`$_queriesCnt` ¶

public integer

Queries count.

`$_queriesLog` ¶

public unknown_type

Log of queries executed by this DataSource

array()

`$_queriesLogMax` ¶

public integer

Maximum number of items in query log, to prevent query log taking over too much memory on large amounts of queries -- I we've had problems at

6000 queries on one system.

`$_queriesTime` ¶

public unknown_type

Total duration of all queries.

null

`$_queryCache` ¶

public array

Caches serialzed results of executed queries

array()

`$_result` ¶

public array

Enter description here...

null

`$_sources` ¶

public array

Holds a list of sources (tables) contained in the DataSource

null

`$_transactionStarted` ¶

public boolean

Whether or not this DataSource is in the middle of a transaction

false

`$affected` ¶

public string

String to hold how many rows were affected by the last SQL operation.

null

`$cacheSources` ¶

public boolean

Whether or not source data like available tables and schema descriptions should be cached

true

`$config` ¶

public array

The DataSource configuration

array()

`$configKeyName` ¶

public string

The DataSource configuration key name

null

`$connected` ¶

public boolean

Are we connected to the DataSource?

false

`$connection` ¶

public array

A reference to the physical connection of this DataSource

null

`$endQuote` ¶

public string

The ending character that this DataSource uses for quoted identifiers.

null

`$error` ¶

public unknown_type

Error description of last query

null

`$fullDebug` ¶

public boolean

Print full query debug info?

false

`$numRows` ¶

public integer

Number of rows in current resultset

null

`$startQuote` ¶

public string

The starting character that this DataSource uses for quoted identifiers.

null

`$took` ¶

public integer

Time the last query took

null

Classes

Functions

Class DataSource

Direct Subclasses

Indirect Subclasses

Properties summary

Inherited Properties

Method Summary

__cacheDescription() public

__construct() public

__destruct() public

begin() public

column() public

commit() public

create() public

delete() public

describe() public

enabled() public

insertQueryData() public

isInterfaceSupported() public

lastAffected() public

lastInsertId() public

lastNumRows() public

listSources() public

read() public

resolveKey() public

rollback() public

setConfig() public

sources() public

update() public

Method Detail

__cacheDescription() public ¶

Parameters

__construct() public ¶

Overrides

__destruct() public ¶

begin() public ¶

Returns

column() public ¶

Parameters

Returns

commit() public ¶

Returns

create() public ¶

Parameters

Returns

delete() public ¶

Parameters

describe() public ¶

Parameters

Returns

enabled() public ¶

Returns

insertQueryData() public ¶

Parameters

Returns

isInterfaceSupported() public ¶

Parameters

Returns

lastAffected() public ¶

Parameters

Returns

lastInsertId() public ¶

Parameters

Returns

lastNumRows() public ¶

Parameters

Returns

listSources() public ¶

Returns

read() public ¶

Parameters

Returns

resolveKey() public ¶

Parameters

Returns

rollback() public ¶

Returns

setConfig() public ¶

Parameters