Class DboSource

Properties summary

• $__bypass public
  boolean
  Bypass automatic adding of joined fields/associations.
• $__sqlOps public
  array
  The set of valid SQL operations usable in a WHERE statement
• $_commands public
  array
  Index of basic SQL commands
• $alias public
  string
  Database keyword used to assign aliases to identifiers.
• $description public
  unknown_type
  Description string for this Database Data Source.
• $fieldCache public
  array
  Caches fields quoted in DboSource::name()
• $index public
  array
  index definition, standard cake, primary, index, unique

Inherited Properties

• __descriptions, _baseConfig, _queriesCnt, _queriesLog, _queriesLogMax, _queriesTime, _queryCache, _result, _sources, _transactionStarted, affected, cacheSources, config, configKeyName, connected, connection, endQuote, error, fullDebug, numRows, startQuote, took _log

Method Summary

• __construct() public

  Constructor

• __filterResults() public

  Private method. Passes association results thru afterFind filters of corresponding model

• __mergeAssociation() public

  Enter description here...

• __mergeConditions() public

  Merges a mixed set of string/array conditions

• __mergeHasMany() public

  mergeHasMany - Merge the results of hasMany relations.

• __parseKey() public

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

• __quoteFields() public

  Quotes Model.fields

• __scrubQueryData() public

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

• _getJoins() public

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

• _matchRecords() public

  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.

• _prepareUpdateFields() public

  Quotes and prepares fields and values for an SQL UPDATE statement

• alterSchema() public

  Generate a alter syntax from CakeSchema::compare()

• begin() public

  Begin a transaction

• boolean() public

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

• buildColumn() public

  Generate a database-native column schema string

• buildIndex() public

  Format indexes for create table

• buildJoinStatement() public

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

• buildStatement() public

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

• calculate() public

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

• close() public

  Disconnects database, kills the connection and says the connection is closed, and if DEBUG is turned on, the log for this object is shown.

• commit() public

  Commit a transaction

• conditionKeysToString() public

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

• conditions() public

  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.

• create() public

  The "C" in CRUD

• createSchema() public

  Generate a database-native schema for the given Schema object

• defaultConditions() public

  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.

• delete() public

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

• dropSchema() public

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

• execute() public

  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 DEBUG is set, the log is shown all the time, else it is only shown on errors.

• expression() public

  Returns an object to represent a database expression in a query

• fetchAll() public

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

• fetchAssociated() public

  A more efficient way to fetch associations. Woohoo!

• fetchRow() public

  Returns a row from current resultset as an array

• field() public

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

• fields() public

  Generates the fields list of an SQL query.

• fullTableName() public

  Gets full table name including prefix

• generateAssociationQuery() public

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

• getConstraint() public

  Returns a conditions array for the constraint between two models

• group() public

  Create a GROUP BY SQL clause

• hasAny() public

  Checks if the specified table contains any record matching specified SQL

• hasResult() public

  Checks if the result is valid

• identifier() public

  Returns an object to represent a database identifier in a query

• index() public

  Returns an array of the indexes in given datasource name.

• insertMulti() public

  Inserts multiple values into a table

• introspectType() public

  Guesses the data type of an array

• isConnected() public

  Checks if it's connected to the database

• length() public

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

• limit() public

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

• logQuery() public

  Log given SQL query.

• name() public

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

• order() public

  Returns an ORDER BY clause as a string.

• query() public

  DataSource Query abstraction

• queryAssociation() public

  Enter description here...

• rawQuery() public

  Executes given SQL statement.

• read() public

  The "R" in CRUD

• reconnect() public

  Reconnects to database server with optional new settings

• renderJoinStatement() public

  Renders a final SQL JOIN statement

• renderStatement() public

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

• resolveKey() public

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

• rollback() public

  Rollback a transaction

• showLog() public

  Outputs the contents of the queries log.

• showQuery() public

  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.

• truncate() public

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

• update() public

  Generates and executes an SQL UPDATE statement for given model, fields, and values. For databases that do not support aliases in UPDATE queries.

• value() public

  Prepares a value, or an array of values for database queries by quoting and escaping them.

Method Detail

Methods inherited from DataSource

Methods inherited from Object

Properties detail

false

array('like', 'ilike', 'or', 'not', 'in', 'between', 'regexp', 'similar to')

array(
    'begin' => 'BEGIN',
    'commit' => 'COMMIT',
    'rollback' => 'ROLLBACK'
)

'AS '

"Database Data Source"

array()

array('PRI' => 'primary', 'MUL' => 'index', 'UNI' => 'unique')