Class DboOracle

Oracle layer for DBO.

Long description for class

Object

DataSource

DboSource

DboOracle

Package: cake\cake\libs\model\datasources\dbo
Copyright: Copyright 2005-2012, Cake Software Foundation, Inc. (http://cakefoundation.org)
License: License (http://www.opensource.org/licenses/mit-license.php)
Location: model/datasources/dbo/dbo_oracle.php

Properties summary

$__transactionStarted public

boolean

Transaction in progress flag
$_baseConfig public

array

Base configuration settings for MySQL driver
$_currentRow public

mixed

Current Row
$_error public

unknown_type

Last error issued by oci extension
$_limit public

integer

Query limit
$_map public

unknown_type

Enter description here...
$_numRows public

integer

Number of rows
$_offset public

integer

Query offset
$_results public

mixed

Query results
$_sequenceMap public

unknown_type

Table-sequence map
$_sequences public

array

Sequence names as introspected from the database
$alias public

string

Alias
$columns public

array

Column definitions
$config public

array

Configuration options
$connection public

mixed

Connection object

Inherited Properties

__bypass, __sqlOps, _commands, cacheMethods, description, fieldParameters, index, methodCache, tableParameters, virtualFieldSeparator __descriptions, _queriesCnt, _queriesLog, _queriesLogMax, _queriesTime, _queryCache, _result, _sources, _transactionStarted, affected, cacheSources, configKeyName, connected, endQuote, error, fullDebug, numRows, startQuote, took

Method Summary

_execute() public

Executes given SQL statement. This is an overloaded method.
_scrapeSQL() public

Scrape the incoming SQL to create the association map. This is an extremely experimental method that creates the association maps since Oracle will not tell us.
_setError() public

Keeps track of the most recent Oracle error
alterSchema() public

Generate a Oracle Alter Table syntax for the given Schema comparison
begin() public

Begin a transaction
column() public

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

Commit a transaction
connect() public

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

Enables, disables, and lists table constraints
createSequence() public

Creates a database sequence
createTrigger() public

Create trigger
describe() public

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

Disconnects from database.
dropSchema() public

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

Check whether the OCI8 extension is installed/loaded
fetchResult() public

Fetches the next row from the current result set
fetchRow() public

Fetch result row
getEncoding() public

Gets the current encoding language
index() public

Returns an array of the indexes in given table name.
lastAffected() public

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

Returns a formatted error message from previous database operation.
lastInsertId() public

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

Returns number of rows in previous resultset. If no previous resultset exists, this returns false.
limit() public

Modify a SQL query to limit (and offset) the result set
listSources() public

Returns an array of tables in the database. If there are no tables, an error is raised and the application exits.
name() public

This method should quote Oracle identifiers. Well it doesn't. It would break all scaffolding and all of Cake's default assumptions.
queryAssociation() public

Enter description here...
renderStatement() public

Renders a final SQL statement by putting together the component parts in the correct order
rollback() public

Rollback a transaction
sequenceExists() public

Checks to see if a named sequence exists
setEncoding() public

Sets the encoding language of the session
truncate() public

Deletes all the records in a table and drops all associated auto-increment sequences. Using DELETE instead of TRUNCATE because it causes locking problems.
value() public

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

Method Detail

_execute() public ¶

_execute( string $sql )

Executes given SQL statement. This is an overloaded method.

Parameters

string $sql: SQL statement

Returns

resource
Result resource identifier or null

_scrapeSQL() public ¶

_scrapeSQL( string $sql )

Scrape the incoming SQL to create the association map. This is an extremely experimental method that creates the association maps since Oracle will not tell us.

Parameters

string $sql

Returns

false
if sql is nor a SELECT

_setError() public ¶

_setError( $source = null , $clear = false )

Keeps track of the most recent Oracle error

alterSchema() public ¶

alterSchema( unknown_type $compare , $table = null )

Generate a Oracle Alter Table syntax for the given Schema comparison

Parameters

unknown_type $compare: $schema
$table optional null

Returns

unknown

Overrides

DboSource::alterSchema()

begin() public ¶

begin( unknown_type $model ,… )

Begin a transaction

Parameters

unknown_type $model ,…

Returns

boolean

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

Overrides

DboSource::begin()

column() public ¶

column( string $real )

Converts database-layer column types to basic types

Parameters

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

Returns

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

Overrides

DataSource::column()

commit() public ¶

commit( unknown_type $model ,… )

Commit a transaction

Parameters

unknown_type $model ,…

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

DboSource::commit()

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

constraint() public ¶

constraint( string $action , string $table )

Enables, disables, and lists table constraints

Note: This method could have been written using a subselect for each table, however the effort Oracle expends to run the constraint introspection is very high. Therefore, this method caches the result once and loops through the arrays to find what it needs. It reduced my query time by 50%. YMMV.

Parameters

string $action
string $table

Returns

mixed
boolean true or array of constraints

createSequence() public ¶

createSequence( string $sequence )

Creates a database sequence

Parameters

string $sequence

Returns

boolean

createTrigger() public ¶

createTrigger( string $table )

Create trigger

Parameters

string $table

Returns

mixed

describe() public ¶

describe( object $model )

Returns an array of the fields in given table name.

Parameters

object $model: of a model to inspect

Returns

array
Fields in table. Keys are name and type

Overrides

DataSource::describe()

disconnect() public ¶

disconnect( )

Disconnects from database.

Returns

boolean
True if the database could be disconnected, else false

dropSchema() public ¶

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

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

Parameters

object $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 whether the OCI8 extension is installed/loaded

Returns

boolean

Overrides

DataSource::enabled()

fetchResult() public ¶

fetchResult( )

Fetches the next row from the current result set

Returns

unknown

fetchRow() public ¶

fetchRow( )

Fetch result row

Returns

array

Overrides

DboSource::fetchRow()

getEncoding() public ¶

getEncoding( )

Gets the current encoding language

Returns

string
language constant

index() public ¶

index( string $model )

Returns an array of the indexes in given table name.

Parameters

string $model: Name of model to inspect

Returns

array
Fields in table. Keys are column and unique

Overrides

DboSource::index()

lastAffected() public ¶

lastAffected( )

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

Returns

integer
Number of affected rows

Overrides

DataSource::lastAffected()

lastError() public ¶

lastError( )

Returns a formatted error message from previous database operation.

Returns

string
Error message with error number

lastInsertId() public ¶

lastInsertId( string $source )

Returns the ID generated from the previous INSERT operation.

Parameters

string $source

Returns

integer

Overrides

DataSource::lastInsertId()

lastNumRows() public ¶

lastNumRows( )

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

Returns

integer
Number of rows in resultset

Overrides

DataSource::lastNumRows()

limit() public ¶

limit( integer $limit = -1 , integer $offset = 0 )

Modify a SQL query to limit (and offset) the result set

Parameters

integer $limit optional -1: Maximum number of rows to return
integer $offset optional 0: Row to begin returning

Returns

modified
SQL Query

Overrides

DboSource::limit()

listSources() public ¶

listSources( )

Returns an array of tables in the database. If there are no tables, an error is raised and the application exits.

Returns

array
tablenames in the database

Overrides

DataSource::listSources()

name() public ¶

name( unknown_type $name )

This method should quote Oracle identifiers. Well it doesn't. It would break all scaffolding and all of Cake's default assumptions.

Parameters

unknown_type $name: $var

Returns

unknown

Overrides

DboSource::name()

queryAssociation() public ¶

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

Enter description here...

Parameters

Model $model
unknown_type $linkModel
string $type: Association type
unknown_type $association
unknown_type $assocData
unknown_type $queryData
unknown_type $external
unknown_type $resultSet
integer $recursive: Number of levels of association
array $stack

Overrides

DboSource::queryAssociation()

renderStatement() public ¶

renderStatement( string $type , array $data )

Renders a final SQL statement by putting together the component parts in the correct order

Parameters

string $type
array $data

Returns

string

Overrides

DboSource::renderStatement()

rollback() public ¶

rollback( unknown_type $model ,… )

Rollback a transaction

Parameters

unknown_type $model ,…

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

DboSource::rollback()

sequenceExists() public ¶

sequenceExists( string $sequence )

Checks to see if a named sequence exists

Parameters

string $sequence

Returns

boolean

setEncoding() public ¶

setEncoding( string $lang )

Sets the encoding language of the session

Parameters

string $lang: language constant

Returns

boolean

truncate() public ¶

truncate( mixed $table , integer $reset = 0 )

Deletes all the records in a table and drops all associated auto-increment sequences. Using DELETE instead of TRUNCATE because it causes locking problems.

Parameters

mixed $table: A string or model class representing the table to be truncated
integer $reset optional 0: If -1, sequences are dropped, if 0 (default), sequences are reset, and if 1, sequences are not modified

Returns

boolean
SQL TRUNCATE TABLE statement, false if not applicable.

Overrides

DboSource::truncate()

value() public ¶

value( string $data , string $column = null , boolean $safe = false )

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
boolean $safe optional false: $read Value to be used in READ or WRITE context

Returns

string
Quoted and escaped

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.

Returns

void.

Overrides

DataSource::__construct()

__filterResults() public ¶

__filterResults( array $results , object $model , array $filtered = array() )

Passes association results thru afterFind filters of corresponding model

Parameters

array $results: Reference of resultset to be filtered
object $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

__mergeAssociation() public ¶

__mergeAssociation( unknown_type $data , unknown_type $merge , unknown_type $association , unknown_type $type , boolean $selfJoin = false )

Enter description here...

Parameters

unknown_type $data
unknown_type $merge
unknown_type $association
unknown_type $type
boolean $selfJoin optional false

__mergeConditions() public ¶

__mergeConditions( $query , $assoc )

Merges a mixed set of string/array conditions

Returns

array

__mergeHasMany() public ¶

__mergeHasMany( array $resultSet , array $merge , string $association , object $model , object $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
object $model: Model being merged onto
object $linkModel: Model being merged

__parseKey() public ¶

__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

__quoteFields() public ¶

__quoteFields( string $conditions )

Quotes Model.fields

Parameters

string $conditions

Returns

string
or false if no match

__quoteMatchedField() public ¶

__quoteMatchedField( string $match )

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

Parameters

string $match: string

Returns

string
quoted strig

__scrubQueryData() public ¶

__scrubQueryData( array $data )

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

Parameters

array $data

Returns

array

_buildFieldParameters() public ¶

_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.

_constructVirtualFields() public ¶

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

Converts model virtual fields into sql expressions to be fetched later

Parameters

Model $model
string $alias: Alias tablename
mixed $fields: virtual fields to be used on query

Returns

array

_getJoins() public ¶

_getJoins( object $model )

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

Parameters

object $model

Returns

array

_matchRecords() public ¶

_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

_prepareUpdateFields() public ¶

_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 preparted

boolean() public ¶

boolean( mixed $data )

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

Parameters

mixed $data: Value to be translated

Returns

mixed
Converted boolean value

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

buildIndex() public ¶

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

Format indexes for create table

Parameters

array $indexes
string $table optional null

Returns

array

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 , object $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
object $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 keyname 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.

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 simple hashing algorithm it can infrequently 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

create() public ¶

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

The "C" in CRUD

Creates new records in the database.

Parameters

Model $model: Model object that the record is for.
array $fields optional null: An array of field names to insert. If null, $model->data will be used to generate field names.
array $values optional null: An array of values with keys matching the fields. If null, $model->data will be used to generate values.

Returns

boolean
Success

Overrides

DataSource::create()

createSchema() public ¶

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

Generate a database-native schema for the given Schema object

Parameters

object $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( object $model , mixed $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

object $model
mixed $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 existance 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()

execute() public ¶

execute( string $sql , array $options = 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

stats - Collect meta data stats for this query. Stats include time take, rows affected, any errors, and number of rows returned. Defaults to true.
log - Whether or not the query should be logged to the memory log.

Parameters

string $sql
array $options optional array()

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

Parameters

string $expression

Returns

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

fetchAll() public ¶

fetchAll( string $sql , boolean $cache = true , $modelName = null )

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

Parameters

string $sql: SQL statement
boolean $cache optional true: Enables returning/storing cached query results
$modelName optional null

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

fetchVirtualField() public ¶

fetchVirtualField( array $result )

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

Parameters

array $result: $resut 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.

fields() public ¶

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

Generates the fields list of an SQL query.

Parameters

Model $model
string $alias optional null: Alias tablename
mixed $fields optional array()
boolean $quote optional true: If false, returns fields array unquoted

Returns

array

flushMethodCache() public ¶

flushMethodCache( )

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

fullTableName() public ¶

fullTableName( mixed $model , boolean $quote = true )

Gets full table name including prefix

Parameters

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

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

getConstraint() public ¶

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

Returns a conditions array for the constraint between two models

Parameters

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

Returns

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

getLog() public ¶

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

Get the query log as an array.

Parameters

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

Returns

array
Array of queries run as an array

group() public ¶

group( string $group , $model = null )

Create a GROUP BY SQL clause

Parameters

string $group: Group By Condition
$model optional null

Returns

mixed
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

Parameters

string $identifier

Returns

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

insertMulti() public ¶

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

Inserts multiple values into a table

Parameters

string $table
string $fields
array $values

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

length() public ¶

length( string $real )

Gets the length of a database-native column description, or null if no length

Parameters

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

Returns

mixed
An integer or string representing the length of the column

logQuery() public ¶

logQuery( string $sql )

Log given SQL query.

Parameters

string $sql: SQL statement

Todo:

Add hook to log errors instead of returning false

order() public ¶

order( string $keys , string $direction = 'ASC' , object $model = null )

Returns an ORDER BY clause as a string.

Parameters

string $keys: $key Field reference, as a key (i.e. Post.title)
string $direction optional 'ASC': Direction (ASC or DESC)
object $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.

rawQuery() public ¶

rawQuery( string $sql )

Executes given SQL statement.

Parameters

string $sql: SQL statement

Returns

boolean

read() public ¶

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

The "R" in CRUD

Reads record(s) from the database.

Parameters

Model $model: A Model object that the query is for.
array $queryData optional array(): An array of queryData information containing keys similar to Model::find()
integer $recursive optional null: Number of levels of association

Returns

mixed
boolean false on error/failure. An array of results on success.

Overrides

DataSource::read()

readTableParameters() public ¶

readTableParameters( array $name , string $table ,… )

Read additional table parameters

Parameters

array $name: $parameters
string $table ,…

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( unknown_type $model , unknown_type $key , unknown_type $assoc = null )

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

Parameters

unknown_type $model
unknown_type $key
unknown_type $assoc optional null

Returns

string

Overrides

DataSource::resolveKey()

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.

showQuery() public ¶

showQuery( string $sql )

Output information about an SQL query. The SQL statement, number of rows in resultset, and execution time in microseconds. If the query fails, an error is output instead.

Parameters

string $sql: Query to show information on.

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. For databases that do not support aliases in UPDATE queries.

Parameters

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

Returns

boolean
Success

Overrides

DataSource::update()

Methods inherited from DataSource

__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

Returns

mixed

__destruct() public ¶

__destruct( )

Closes the current datasource.

insertQueryData() public ¶

insertQueryData( string $query , array $data , string $association , unknown_type $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
unknown_type $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.

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

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

sources() public ¶

sources( boolean $reset = false )

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

Parameters

boolean $reset optional false: Whether or not the source list should be reset.

Returns

array
Array of sources available in this datasource

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. 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() public ¶

_stop( $status = 0 )

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

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

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 )

Convience 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_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. 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.

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

`$__transactionStarted` ¶

public boolean

Transaction in progress flag

false

`$_baseConfig` ¶

public array

Base configuration settings for MySQL driver

array(
    'persistent' => true,
    'host' => 'localhost',
    'login' => 'system',
    'password' => '',
    'database' => 'cake',
    'nls_sort' => '',
    'nls_sort' => ''
)

-1

array()

`$_sequences` ¶

public array

Sequence names as introspected from the database

array()

`$alias` ¶

public string

Alias

''

`$columns` ¶

public array

Column definitions

array(
    'primary_key' => array('name' => ''),
    'string' => array('name' => 'varchar2', 'limit' => '255'),
    'text' => array('name' => 'varchar2'),
    'integer' => array('name' => 'number'),
    'float' => array('name' => 'float'),
    'datetime' => array('name' => 'date', 'format' => 'Y-m-d H:i:s'),
    'timestamp' => array('name' => 'date', 'format' => 'Y-m-d H:i:s'),
    'time' => array('name' => 'date', 'format' => 'Y-m-d H:i:s'),
    'date' => array('name' => 'date', 'format' => 'Y-m-d H:i:s'),
    'binary' => array('name' => 'bytea'),
    'boolean' => array('name' => 'boolean'),
    'number' => array('name' => 'number'),
    'inet' => array('name' => 'inet'))

`$config` ¶

public array

Configuration options

array()

`$connection` ¶

public mixed

Connection object

Classes

Functions

Class DboOracle

Properties summary

Inherited Properties

Method Summary

_execute() public

_scrapeSQL() public

_setError() public

alterSchema() public

begin() public

column() public

commit() public

connect() public

constraint() public

createSequence() public

createTrigger() public

describe() public

disconnect() public

dropSchema() public

enabled() public

fetchResult() public

fetchRow() public

getEncoding() public

index() public

lastAffected() public

lastError() public

lastInsertId() public

lastNumRows() public

limit() public

listSources() public

name() public

queryAssociation() public

renderStatement() public

rollback() public

sequenceExists() public

setEncoding() public

truncate() public

value() public

Method Detail

_execute() public ¶

Parameters

Returns

_scrapeSQL() public ¶

Parameters

Returns

_setError() public ¶

alterSchema() public ¶

Parameters

Returns

Overrides

begin() public ¶

Parameters

Returns

Overrides

column() public ¶

Parameters

Returns

Overrides

commit() public ¶

Parameters

Returns

Overrides

connect() public ¶

Returns

constraint() public ¶

Parameters

Returns

createSequence() public ¶

Parameters

Returns

createTrigger() public ¶

Parameters

Returns

describe() public ¶

Parameters

Returns

Overrides

disconnect() public ¶

Returns