/web/api/lib/Cake/Model/Datasource/DboSource.php
PHP | 3544 lines | 2226 code | 378 blank | 940 comment | 550 complexity | f00b6053077554321772de44305a869c MD5 | raw file
Possible License(s): GPL-2.0
Large files files are truncated, but you can click here to view the full file
- <?php
- /**
- * Dbo Source
- *
- * CakePHP(tm) : Rapid Development Framework (http://cakephp.org)
- * Copyright (c) Cake Software Foundation, Inc. (http://cakefoundation.org)
- *
- * Licensed under The MIT License
- * For full copyright and license information, please see the LICENSE.txt
- * Redistributions of files must retain the above copyright notice.
- *
- * @copyright Copyright (c) Cake Software Foundation, Inc. (http://cakefoundation.org)
- * @link http://cakephp.org CakePHP(tm) Project
- * @package Cake.Model.Datasource
- * @since CakePHP(tm) v 0.10.0.1076
- * @license http://www.opensource.org/licenses/mit-license.php MIT License
- */
- App::uses('DataSource', 'Model/Datasource');
- App::uses('String', 'Utility');
- App::uses('View', 'View');
- /**
- * DboSource
- *
- * Creates DBO-descendant objects from a given db connection configuration
- *
- * @package Cake.Model.Datasource
- */
- class DboSource extends DataSource {
- /**
- * Description string for this Database Data Source.
- *
- * @var string
- */
- public $description = "Database Data Source";
- /**
- * index definition, standard cake, primary, index, unique
- *
- * @var array
- */
- public $index = array('PRI' => 'primary', 'MUL' => 'index', 'UNI' => 'unique');
- /**
- * Database keyword used to assign aliases to identifiers.
- *
- * @var string
- */
- public $alias = 'AS ';
- /**
- * Caches result from query parsing operations. Cached results for both DboSource::name() and
- * DboSource::conditions() will be stored here. Method caching uses `md5()`. If you have
- * problems with collisions, set DboSource::$cacheMethods to false.
- *
- * @var array
- */
- public static $methodCache = array();
- /**
- * Whether or not to cache the results of DboSource::name() and DboSource::conditions()
- * into the memory cache. Set to false to disable the use of the memory cache.
- *
- * @var boolean
- */
- public $cacheMethods = true;
- /**
- * Flag to support nested transactions. If it is set to false, you will be able to use
- * the transaction methods (begin/commit/rollback), but just the global transaction will
- * be executed.
- *
- * @var boolean
- */
- public $useNestedTransactions = false;
- /**
- * Print full query debug info?
- *
- * @var boolean
- */
- public $fullDebug = false;
- /**
- * String to hold how many rows were affected by the last SQL operation.
- *
- * @var string
- */
- public $affected = null;
- /**
- * Number of rows in current resultset
- *
- * @var integer
- */
- public $numRows = null;
- /**
- * Time the last query took
- *
- * @var integer
- */
- public $took = null;
- /**
- * Result
- *
- * @var array
- */
- protected $_result = null;
- /**
- * Queries count.
- *
- * @var integer
- */
- protected $_queriesCnt = 0;
- /**
- * Total duration of all queries.
- *
- * @var integer
- */
- protected $_queriesTime = null;
- /**
- * Log of queries executed by this DataSource
- *
- * @var array
- */
- protected $_queriesLog = array();
- /**
- * Maximum number of items in query log
- *
- * This is to prevent query log taking over too much memory.
- *
- * @var integer Maximum number of queries in the queries log.
- */
- protected $_queriesLogMax = 200;
- /**
- * Caches serialized results of executed queries
- *
- * @var array Cache of results from executed sql queries.
- */
- protected $_queryCache = array();
- /**
- * A reference to the physical connection of this DataSource
- *
- * @var array
- */
- protected $_connection = null;
- /**
- * The DataSource configuration key name
- *
- * @var string
- */
- public $configKeyName = null;
- /**
- * The starting character that this DataSource uses for quoted identifiers.
- *
- * @var string
- */
- public $startQuote = null;
- /**
- * The ending character that this DataSource uses for quoted identifiers.
- *
- * @var string
- */
- public $endQuote = null;
- /**
- * The set of valid SQL operations usable in a WHERE statement
- *
- * @var array
- */
- protected $_sqlOps = array('like', 'ilike', 'or', 'not', 'in', 'between', 'regexp', 'similar to');
- /**
- * Indicates the level of nested transactions
- *
- * @var integer
- */
- protected $_transactionNesting = 0;
- /**
- * Default fields that are used by the DBO
- *
- * @var array
- */
- protected $_queryDefaults = array(
- 'conditions' => array(),
- 'fields' => null,
- 'table' => null,
- 'alias' => null,
- 'order' => null,
- 'limit' => null,
- 'joins' => array(),
- 'group' => null,
- 'offset' => null
- );
- /**
- * Separator string for virtualField composition
- *
- * @var string
- */
- public $virtualFieldSeparator = '__';
- /**
- * List of table engine specific parameters used on table creating
- *
- * @var array
- */
- public $tableParameters = array();
- /**
- * List of engine specific additional field parameters used on table creating
- *
- * @var array
- */
- public $fieldParameters = array();
- /**
- * Indicates whether there was a change on the cached results on the methods of this class
- * This will be used for storing in a more persistent cache
- *
- * @var boolean
- */
- protected $_methodCacheChange = false;
- /**
- * Constructor
- *
- * @param array $config Array of configuration information for the Datasource.
- * @param boolean $autoConnect Whether or not the datasource should automatically connect.
- * @throws MissingConnectionException when a connection cannot be made.
- */
- public function __construct($config = null, $autoConnect = true) {
- if (!isset($config['prefix'])) {
- $config['prefix'] = '';
- }
- parent::__construct($config);
- $this->fullDebug = Configure::read('debug') > 1;
- if (!$this->enabled()) {
- throw new MissingConnectionException(array(
- 'class' => get_class($this),
- 'message' => __d('cake_dev', 'Selected driver is not enabled'),
- 'enabled' => false
- ));
- }
- if ($autoConnect) {
- $this->connect();
- }
- }
- /**
- * Reconnects to database server with optional new settings
- *
- * @param array $config An array defining the new configuration settings
- * @return boolean True on success, false on failure
- */
- public function reconnect($config = array()) {
- $this->disconnect();
- $this->setConfig($config);
- $this->_sources = null;
- return $this->connect();
- }
- /**
- * Disconnects from database.
- *
- * @return boolean Always true
- */
- public function disconnect() {
- if ($this->_result instanceof PDOStatement) {
- $this->_result->closeCursor();
- }
- unset($this->_connection);
- $this->connected = false;
- return true;
- }
- /**
- * Get the underlying connection object.
- *
- * @return PDO
- */
- public function getConnection() {
- return $this->_connection;
- }
- /**
- * Gets the version string of the database server
- *
- * @return string The database version
- */
- public function getVersion() {
- return $this->_connection->getAttribute(PDO::ATTR_SERVER_VERSION);
- }
- /**
- * Returns a quoted and escaped string of $data for use in an SQL statement.
- *
- * @param string $data String to be prepared for use in an SQL statement
- * @param string $column The column datatype into which this data will be inserted.
- * @return string Quoted and escaped data
- */
- public function value($data, $column = null) {
- if (is_array($data) && !empty($data)) {
- return array_map(
- array(&$this, 'value'),
- $data, array_fill(0, count($data), $column)
- );
- } elseif (is_object($data) && isset($data->type, $data->value)) {
- if ($data->type === 'identifier') {
- return $this->name($data->value);
- } elseif ($data->type === 'expression') {
- return $data->value;
- }
- } elseif (in_array($data, array('{$__cakeID__$}', '{$__cakeForeignKey__$}'), true)) {
- return $data;
- }
- if ($data === null || (is_array($data) && empty($data))) {
- return 'NULL';
- }
- if (empty($column)) {
- $column = $this->introspectType($data);
- }
- switch ($column) {
- case 'binary':
- return $this->_connection->quote($data, PDO::PARAM_LOB);
- case 'boolean':
- return $this->_connection->quote($this->boolean($data, true), PDO::PARAM_BOOL);
- case 'string':
- case 'text':
- return $this->_connection->quote($data, PDO::PARAM_STR);
- default:
- if ($data === '') {
- return 'NULL';
- }
- if (is_float($data)) {
- return str_replace(',', '.', strval($data));
- }
- if ((is_int($data) || $data === '0') || (
- is_numeric($data) && strpos($data, ',') === false &&
- $data[0] != '0' && strpos($data, 'e') === false)
- ) {
- return $data;
- }
- return $this->_connection->quote($data);
- }
- }
- /**
- * Returns an object to represent a database identifier in a query. Expression objects
- * are not sanitized or escaped.
- *
- * @param string $identifier A SQL expression to be used as an identifier
- * @return stdClass An object representing a database identifier to be used in a query
- */
- public function identifier($identifier) {
- $obj = new stdClass();
- $obj->type = 'identifier';
- $obj->value = $identifier;
- return $obj;
- }
- /**
- * Returns an object to represent a database expression in a query. Expression objects
- * are not sanitized or escaped.
- *
- * @param string $expression An arbitrary SQL expression to be inserted into a query.
- * @return stdClass An object representing a database expression to be used in a query
- */
- public function expression($expression) {
- $obj = new stdClass();
- $obj->type = 'expression';
- $obj->value = $expression;
- return $obj;
- }
- /**
- * Executes given SQL statement.
- *
- * @param string $sql SQL statement
- * @param array $params Additional options for the query.
- * @return boolean
- */
- public function rawQuery($sql, $params = array()) {
- $this->took = $this->numRows = false;
- return $this->execute($sql, $params);
- }
- /**
- * 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.
- *
- * @param string $sql SQL statement
- * @param array $options
- * @param array $params values to be bound to the query
- * @return mixed Resource or object representing the result set, or false on failure
- */
- public function execute($sql, $options = array(), $params = array()) {
- $options += array('log' => $this->fullDebug);
- $t = microtime(true);
- $this->_result = $this->_execute($sql, $params);
- if ($options['log']) {
- $this->took = round((microtime(true) - $t) * 1000, 0);
- $this->numRows = $this->affected = $this->lastAffected();
- $this->logQuery($sql, $params);
- }
- return $this->_result;
- }
- /**
- * Executes given SQL statement.
- *
- * @param string $sql SQL statement
- * @param array $params list of params to be bound to query
- * @param array $prepareOptions Options to be used in the prepare statement
- * @return 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
- */
- protected function _execute($sql, $params = array(), $prepareOptions = array()) {
- $sql = trim($sql);
- if (preg_match('/^(?:CREATE|ALTER|DROP)\s+(?:TABLE|INDEX)/i', $sql)) {
- $statements = array_filter(explode(';', $sql));
- if (count($statements) > 1) {
- $result = array_map(array($this, '_execute'), $statements);
- return array_search(false, $result) === false;
- }
- }
- try {
- $query = $this->_connection->prepare($sql, $prepareOptions);
- $query->setFetchMode(PDO::FETCH_LAZY);
- if (!$query->execute($params)) {
- $this->_results = $query;
- $query->closeCursor();
- return false;
- }
- if (!$query->columnCount()) {
- $query->closeCursor();
- if (!$query->rowCount()) {
- return true;
- }
- }
- return $query;
- } catch (PDOException $e) {
- if (isset($query->queryString)) {
- $e->queryString = $query->queryString;
- } else {
- $e->queryString = $sql;
- }
- throw $e;
- }
- }
- /**
- * Returns a formatted error message from previous database operation.
- *
- * @param PDOStatement $query the query to extract the error from if any
- * @return string Error message with error number
- */
- public function lastError(PDOStatement $query = null) {
- if ($query) {
- $error = $query->errorInfo();
- } else {
- $error = $this->_connection->errorInfo();
- }
- if (empty($error[2])) {
- return null;
- }
- return $error[1] . ': ' . $error[2];
- }
- /**
- * Returns number of affected rows in previous database operation. If no previous operation exists,
- * this returns false.
- *
- * @param mixed $source
- * @return integer Number of affected rows
- */
- public function lastAffected($source = null) {
- if ($this->hasResult()) {
- return $this->_result->rowCount();
- }
- return 0;
- }
- /**
- * Returns number of rows in previous resultset. If no previous resultset exists,
- * this returns false.
- *
- * @param mixed $source Not used
- * @return integer Number of rows in resultset
- */
- public function lastNumRows($source = null) {
- return $this->lastAffected();
- }
- /**
- * DataSource Query abstraction
- *
- * @return resource Result resource identifier.
- */
- public function query() {
- $args = func_get_args();
- $fields = null;
- $order = null;
- $limit = null;
- $page = null;
- $recursive = null;
- if (count($args) === 1) {
- return $this->fetchAll($args[0]);
- } elseif (count($args) > 1 && (strpos($args[0], 'findBy') === 0 || strpos($args[0], 'findAllBy') === 0)) {
- $params = $args[1];
- if (substr($args[0], 0, 6) === 'findBy') {
- $all = false;
- $field = Inflector::underscore(substr($args[0], 6));
- } else {
- $all = true;
- $field = Inflector::underscore(substr($args[0], 9));
- }
- $or = (strpos($field, '_or_') !== false);
- if ($or) {
- $field = explode('_or_', $field);
- } else {
- $field = explode('_and_', $field);
- }
- $off = count($field) - 1;
- if (isset($params[1 + $off])) {
- $fields = $params[1 + $off];
- }
- if (isset($params[2 + $off])) {
- $order = $params[2 + $off];
- }
- if (!array_key_exists(0, $params)) {
- return false;
- }
- $c = 0;
- $conditions = array();
- foreach ($field as $f) {
- $conditions[$args[2]->alias . '.' . $f] = $params[$c++];
- }
- if ($or) {
- $conditions = array('OR' => $conditions);
- }
- if ($all) {
- if (isset($params[3 + $off])) {
- $limit = $params[3 + $off];
- }
- if (isset($params[4 + $off])) {
- $page = $params[4 + $off];
- }
- if (isset($params[5 + $off])) {
- $recursive = $params[5 + $off];
- }
- return $args[2]->find('all', compact('conditions', 'fields', 'order', 'limit', 'page', 'recursive'));
- }
- if (isset($params[3 + $off])) {
- $recursive = $params[3 + $off];
- }
- return $args[2]->find('first', compact('conditions', 'fields', 'order', 'recursive'));
- }
- if (isset($args[1]) && $args[1] === true) {
- return $this->fetchAll($args[0], true);
- } elseif (isset($args[1]) && !is_array($args[1])) {
- return $this->fetchAll($args[0], false);
- } elseif (isset($args[1]) && is_array($args[1])) {
- if (isset($args[2])) {
- $cache = $args[2];
- } else {
- $cache = true;
- }
- return $this->fetchAll($args[0], $args[1], array('cache' => $cache));
- }
- }
- /**
- * Returns a row from current resultset as an array
- *
- * @param string $sql Some SQL to be executed.
- * @return array The fetched row as an array
- */
- public function fetchRow($sql = null) {
- if (is_string($sql) && strlen($sql) > 5 && !$this->execute($sql)) {
- return null;
- }
- if ($this->hasResult()) {
- $this->resultSet($this->_result);
- $resultRow = $this->fetchResult();
- if (isset($resultRow[0])) {
- $this->fetchVirtualField($resultRow);
- }
- return $resultRow;
- }
- return null;
- }
- /**
- * 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`
- *
- * @param string $sql SQL statement
- * @param array|boolean $params Either parameters to be bound as values for the SQL statement,
- * or a boolean to control query caching.
- * @param array $options additional options for the query.
- * @return boolean|array Array of resultset rows, or false if no rows matched
- */
- public function fetchAll($sql, $params = array(), $options = array()) {
- if (is_string($options)) {
- $options = array('modelName' => $options);
- }
- if (is_bool($params)) {
- $options['cache'] = $params;
- $params = array();
- }
- $options += array('cache' => true);
- $cache = $options['cache'];
- if ($cache && ($cached = $this->getQueryCache($sql, $params)) !== false) {
- return $cached;
- }
- $result = $this->execute($sql, array(), $params);
- if ($result) {
- $out = array();
- if ($this->hasResult()) {
- $first = $this->fetchRow();
- if ($first) {
- $out[] = $first;
- }
- while ($item = $this->fetchResult()) {
- if (isset($item[0])) {
- $this->fetchVirtualField($item);
- }
- $out[] = $item;
- }
- }
- if (!is_bool($result) && $cache) {
- $this->_writeQueryCache($sql, $out, $params);
- }
- if (empty($out) && is_bool($this->_result)) {
- return $this->_result;
- }
- return $out;
- }
- return false;
- }
- /**
- * Fetches the next row from the current result set
- *
- * @return boolean
- */
- public function fetchResult() {
- return false;
- }
- /**
- * Modifies $result array to place virtual fields in model entry where they belongs to
- *
- * @param array $result Reference to the fetched row
- * @return void
- */
- public function fetchVirtualField(&$result) {
- if (isset($result[0]) && is_array($result[0])) {
- foreach ($result[0] as $field => $value) {
- if (strpos($field, $this->virtualFieldSeparator) === false) {
- continue;
- }
- list($alias, $virtual) = explode($this->virtualFieldSeparator, $field);
- if (!ClassRegistry::isKeySet($alias)) {
- return;
- }
- $Model = ClassRegistry::getObject($alias);
- if ($Model->isVirtualField($virtual)) {
- $result[$alias][$virtual] = $value;
- unset($result[0][$field]);
- }
- }
- if (empty($result[0])) {
- unset($result[0]);
- }
- }
- }
- /**
- * Returns a single field of the first of query results for a given SQL query, or false if empty.
- *
- * @param string $name Name of the field
- * @param string $sql SQL query
- * @return mixed Value of field read.
- */
- public function field($name, $sql) {
- $data = $this->fetchRow($sql);
- if (empty($data[$name])) {
- return false;
- }
- return $data[$name];
- }
- /**
- * Empties the method caches.
- * These caches are used by DboSource::name() and DboSource::conditions()
- *
- * @return void
- */
- public function flushMethodCache() {
- $this->_methodCacheChange = true;
- self::$methodCache = array();
- }
- /**
- * 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.
- *
- * @param string $method Name of the method being cached.
- * @param string $key The key name for the cache operation.
- * @param mixed $value The value to cache into memory.
- * @return mixed Either null on failure, or the value if its set.
- */
- public function cacheMethod($method, $key, $value = null) {
- if ($this->cacheMethods === false) {
- return $value;
- }
- if (!$this->_methodCacheChange && empty(self::$methodCache)) {
- self::$methodCache = Cache::read('method_cache', '_cake_core_');
- }
- if ($value === null) {
- return (isset(self::$methodCache[$method][$key])) ? self::$methodCache[$method][$key] : null;
- }
- $this->_methodCacheChange = true;
- return self::$methodCache[$method][$key] = $value;
- }
- /**
- * Returns a quoted name of $data for use in an SQL statement.
- * Strips fields out of SQL functions before quoting.
- *
- * 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.
- *
- * @param 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()
- * @return string SQL field
- */
- public function name($data) {
- if (is_object($data) && isset($data->type)) {
- return $data->value;
- }
- if ($data === '*') {
- return '*';
- }
- if (is_array($data)) {
- foreach ($data as $i => $dataItem) {
- $data[$i] = $this->name($dataItem);
- }
- return $data;
- }
- $cacheKey = md5($this->startQuote . $data . $this->endQuote);
- if ($return = $this->cacheMethod(__FUNCTION__, $cacheKey)) {
- return $return;
- }
- $data = trim($data);
- if (preg_match('/^[\w-]+(?:\.[^ \*]*)*$/', $data)) { // string, string.string
- if (strpos($data, '.') === false) { // string
- return $this->cacheMethod(__FUNCTION__, $cacheKey, $this->startQuote . $data . $this->endQuote);
- }
- $items = explode('.', $data);
- return $this->cacheMethod(__FUNCTION__, $cacheKey,
- $this->startQuote . implode($this->endQuote . '.' . $this->startQuote, $items) . $this->endQuote
- );
- }
- if (preg_match('/^[\w-]+\.\*$/', $data)) { // string.*
- return $this->cacheMethod(__FUNCTION__, $cacheKey,
- $this->startQuote . str_replace('.*', $this->endQuote . '.*', $data)
- );
- }
- if (preg_match('/^([\w-]+)\((.*)\)$/', $data, $matches)) { // Functions
- return $this->cacheMethod(__FUNCTION__, $cacheKey,
- $matches[1] . '(' . $this->name($matches[2]) . ')'
- );
- }
- if (
- preg_match('/^([\w-]+(\.[\w-]+|\(.*\))*)\s+' . preg_quote($this->alias) . '\s*([\w-]+)$/i', $data, $matches
- )) {
- return $this->cacheMethod(
- __FUNCTION__, $cacheKey,
- preg_replace(
- '/\s{2,}/', ' ', $this->name($matches[1]) . ' ' . $this->alias . ' ' . $this->name($matches[3])
- )
- );
- }
- if (preg_match('/^[\w-_\s]*[\w-_]+/', $data)) {
- return $this->cacheMethod(__FUNCTION__, $cacheKey, $this->startQuote . $data . $this->endQuote);
- }
- return $this->cacheMethod(__FUNCTION__, $cacheKey, $data);
- }
- /**
- * Checks if the source is connected to the database.
- *
- * @return boolean True if the database is connected, else false
- */
- public function isConnected() {
- return $this->connected;
- }
- /**
- * Checks if the result is valid
- *
- * @return boolean True if the result is valid else false
- */
- public function hasResult() {
- return $this->_result instanceof PDOStatement;
- }
- /**
- * Get the query log as an array.
- *
- * @param boolean $sorted Get the queries sorted by time taken, defaults to false.
- * @param boolean $clear If True the existing log will cleared.
- * @return array Array of queries run as an array
- */
- public function getLog($sorted = false, $clear = true) {
- if ($sorted) {
- $log = sortByKey($this->_queriesLog, 'took', 'desc', SORT_NUMERIC);
- } else {
- $log = $this->_queriesLog;
- }
- if ($clear) {
- $this->_queriesLog = array();
- }
- return array('log' => $log, 'count' => $this->_queriesCnt, 'time' => $this->_queriesTime);
- }
- /**
- * 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.
- *
- * @param boolean $sorted Get the queries sorted by time taken, defaults to false.
- * @return void
- */
- public function showLog($sorted = false) {
- $log = $this->getLog($sorted, false);
- if (empty($log['log'])) {
- return;
- }
- if (PHP_SAPI !== 'cli') {
- $controller = null;
- $View = new View($controller, false);
- $View->set('sqlLogs', array($this->configKeyName => $log));
- echo $View->element('sql_dump', array('_forced_from_dbo_' => true));
- } else {
- foreach ($log['log'] as $k => $i) {
- print (($k + 1) . ". {$i['query']}\n");
- }
- }
- }
- /**
- * Log given SQL query.
- *
- * @param string $sql SQL statement
- * @param array $params Values binded to the query (prepared statements)
- * @return void
- */
- public function logQuery($sql, $params = array()) {
- $this->_queriesCnt++;
- $this->_queriesTime += $this->took;
- $this->_queriesLog[] = array(
- 'query' => $sql,
- 'params' => $params,
- 'affected' => $this->affected,
- 'numRows' => $this->numRows,
- 'took' => $this->took
- );
- if (count($this->_queriesLog) > $this->_queriesLogMax) {
- array_shift($this->_queriesLog);
- }
- }
- /**
- * Gets full table name including prefix
- *
- * @param Model|string $model Either a Model object or a string table name.
- * @param boolean $quote Whether you want the table name quoted.
- * @param boolean $schema Whether you want the schema name included.
- * @return string Full quoted table name
- */
- public function fullTableName($model, $quote = true, $schema = true) {
- if (is_object($model)) {
- $schemaName = $model->schemaName;
- $table = $model->tablePrefix . $model->table;
- } elseif (!empty($this->config['prefix']) && strpos($model, $this->config['prefix']) !== 0) {
- $table = $this->config['prefix'] . strval($model);
- } else {
- $table = strval($model);
- }
- if ($schema && !isset($schemaName)) {
- $schemaName = $this->getSchemaName();
- }
- if ($quote) {
- if ($schema && !empty($schemaName)) {
- if (strstr($table, '.') === false) {
- return $this->name($schemaName) . '.' . $this->name($table);
- }
- }
- return $this->name($table);
- }
- if ($schema && !empty($schemaName)) {
- if (strstr($table, '.') === false) {
- return $schemaName . '.' . $table;
- }
- }
- return $table;
- }
- /**
- * The "C" in CRUD
- *
- * Creates new records in the database.
- *
- * @param Model $Model Model object that the record is for.
- * @param array $fields An array of field names to insert. If null, $Model->data will be
- * used to generate field names.
- * @param array $values An array of values with keys matching the fields. If null, $Model->data will
- * be used to generate values.
- * @return boolean Success
- */
- public function create(Model $Model, $fields = null, $values = null) {
- $id = null;
- if (!$fields) {
- unset($fields, $values);
- $fields = array_keys($Model->data);
- $values = array_values($Model->data);
- }
- $count = count($fields);
- for ($i = 0; $i < $count; $i++) {
- $valueInsert[] = $this->value($values[$i], $Model->getColumnType($fields[$i]));
- $fieldInsert[] = $this->name($fields[$i]);
- if ($fields[$i] == $Model->primaryKey) {
- $id = $values[$i];
- }
- }
- $query = array(
- 'table' => $this->fullTableName($Model),
- 'fields' => implode(', ', $fieldInsert),
- 'values' => implode(', ', $valueInsert)
- );
- if ($this->execute($this->renderStatement('create', $query))) {
- if (empty($id)) {
- $id = $this->lastInsertId($this->fullTableName($Model, false, false), $Model->primaryKey);
- }
- $Model->setInsertID($id);
- $Model->id = $id;
- return true;
- }
- $Model->onError();
- return false;
- }
- /**
- * The "R" in CRUD
- *
- * Reads record(s) from the database.
- *
- * @param Model $Model A Model object that the query is for.
- * @param array $queryData An array of queryData information containing keys similar to Model::find().
- * @param integer $recursive Number of levels of association
- * @return mixed boolean false on error/failure. An array of results on success.
- */
- public function read(Model $Model, $queryData = array(), $recursive = null) {
- $queryData = $this->_scrubQueryData($queryData);
- $array = array('callbacks' => $queryData['callbacks']);
- if ($recursive === null && isset($queryData['recursive'])) {
- $recursive = $queryData['recursive'];
- }
- if ($recursive !== null) {
- $modelRecursive = $Model->recursive;
- $Model->recursive = $recursive;
- }
- if (!empty($queryData['fields'])) {
- $noAssocFields = true;
- $queryData['fields'] = $this->fields($Model, null, $queryData['fields']);
- } else {
- $noAssocFields = false;
- $queryData['fields'] = $this->fields($Model);
- }
- if ($Model->recursive === -1) {
- // Primary model data only, no joins.
- $associations = array();
- } else {
- $associations = $Model->associations();
- if ($Model->recursive === 0) {
- // Primary model data and its domain.
- unset($associations[2], $associations[3]);
- }
- }
- $originalJoins = $queryData['joins'];
- $queryData['joins'] = array();
- // Generate hasOne and belongsTo associations inside $queryData
- $linkedModels = array();
- foreach ($associations as $type) {
- if ($type !== 'hasOne' && $type !== 'belongsTo') {
- continue;
- }
- foreach ($Model->{$type} as $assoc => $assocData) {
- $LinkModel = $Model->{$assoc};
- if ($Model->useDbConfig !== $LinkModel->useDbConfig) {
- continue;
- }
- if ($noAssocFields) {
- $assocData['fields'] = false;
- }
- $external = isset($assocData['external']);
- if ($this->generateAssociationQuery($Model, $LinkModel, $type, $assoc, $assocData, $queryData, $external) === true) {
- $linkedModels[$type . '/' . $assoc] = true;
- }
- }
- }
- if (!empty($originalJoins)) {
- $queryData['joins'] = array_merge($queryData['joins'], $originalJoins);
- }
- // Build SQL statement with the primary model, plus hasOne and belongsTo associations
- $query = $this->buildAssociationQuery($Model, $queryData);
- $resultSet = $this->fetchAll($query, $Model->cacheQueries);
- unset($query);
- if ($resultSet === false) {
- $Model->onError();
- return false;
- }
- $filtered = array();
- // Filter hasOne and belongsTo associations
- if ($queryData['callbacks'] === true || $queryData['callbacks'] === 'after') {
- $filtered = $this->_filterResults($resultSet, $Model);
- }
- // Deep associations
- if ($Model->recursive > -1) {
- $joined = array();
- if (isset($queryData['joins'][0]['alias'])) {
- $joined[$Model->alias] = (array)Hash::extract($queryData['joins'], '{n}.alias');
- }
- foreach ($associations as $type) {
- foreach ($Model->{$type} as $assoc => $assocData) {
- $LinkModel = $Model->{$assoc};
- if (!isset($linkedModels[$type . '/' . $assoc])) {
- $db = $Model->useDbConfig === $LinkModel->useDbConfig ? $this : $LinkModel->getDataSource();
- } elseif ($Model->recursive > 1) {
- $db = $this;
- }
- if (isset($db) && method_exists($db, 'queryAssociation')) {
- $stack = array($assoc);
- $stack['_joined'] = $joined;
- $db->queryAssociation($Model, $LinkModel, $type, $assoc, $assocData, $array, true, $resultSet, $Model->recursive - 1, $stack);
- if ($type === 'hasMany' || $type === 'hasAndBelongsToMany') {
- $filtered[] = $assoc;
- }
- }
- }
- }
- if ($queryData['callbacks'] === true || $queryData['callbacks'] === 'after') {
- $this->_filterResults($resultSet, $Model, $filtered);
- }
- }
- if ($recursive !== null) {
- $Model->recursive = $modelRecursive;
- }
- return $resultSet;
- }
- /**
- * Passes association results through afterFind filters of the corresponding model.
- *
- * The primary model is always excluded, because the filtering is later done by Model::_filterResults().
- *
- * @param array $resultSet Reference of resultset to be filtered.
- * @param Model $Model Instance of model to operate against.
- * @param array $filtered List of classes already filtered, to be skipped.
- * @return array Array of results that have been filtered through $Model->afterFind.
- */
- protected function _filterResults(&$resultSet, Model $Model, $filtered = array()) {
- if (!is_array($resultSet)) {
- return array();
- }
- $current = reset($resultSet);
- if (!is_array($current)) {
- return array();
- }
- $keys = array_diff(array_keys($current), $filtered, array($Model->alias));
- $filtering = array();
- foreach ($keys as $className) {
- if (!isset($Model->{$className}) || !is_object($Model->{$className})) {
- continue;
- }
- $LinkedModel = $Model->{$className};
- $filtering[] = $className;
- foreach ($resultSet as $key => &$result) {
- $data = $LinkedModel->afterFind(array(array($className => $result[$className])), false);
- if (isset($data[0][$className])) {
- $result[$className] = $data[0][$className];
- } else {
- unset($resultSet[$key]);
- }
- }
- }
- return $filtering;
- }
- /**
- * Queries associations.
- *
- * Used to fetch results on recursive models.
- *
- * - 'hasMany' associations with no limit set:
- * Fetch, filter and merge is done recursively for every level.
- *
- * - 'hasAndBelongsToMany' associations:
- * Fetch and filter is done unaffected by the (recursive) level set.
- *
- * @param Model $Model Primary Model object.
- * @param Model $LinkModel Linked model object.
- * @param string $type Association type, one of the model association types ie. hasMany.
- * @param string $association Association name.
- * @param array $assocData Association data.
- * @param array $queryData An array of queryData information containing keys similar to Model::find().
- * @param boolean $external Whether or not the association query is on an external datasource.
- * @param array $resultSet Existing results.
- * @param integer $recursive Number of levels of association.
- * @param array $stack
- * @return mixed
- * @throws CakeException when results cannot be created.
- */
- public function queryAssociation(Model $Model, Model $LinkModel, $type, $association, $assocData, &$queryData, $external, &$resultSet, $recursive, $stack) {
- if (isset($stack['_joined'])) {
- $joined = $stack['_joined'];
- unset($stack['_joined']);
- }
- $queryTemplate = $this->generateAssociationQuery($Model, $LinkModel, $type, $association, $assocData, $queryData, $external);
- if (empty($queryTemplate)) {
- return;
- }
- if (!is_array($resultSet)) {
- throw new CakeException(__d('cake_dev', 'Error in Model %s', get_class($Model)));
- }
- if ($type === 'hasMany' && empty($assocData['limit']) && !empty($assocData['foreignKey'])) {
- // 'hasMany' associations with no limit set.
- $assocIds = array();
- foreach ($resultSet as $result) {
- $assocIds[] = $this->insertQueryData('{$__cakeID__$}', $result, $association, $Model, $stack);
- }
- $assocIds = array_filter($assocIds);
- // Fetch
- $assocResultSet = array();
- if (!empty($assocIds)) {
- $assocResultSet = $this->_fetchHasMany($Model, $queryTemplate, $assocIds);
- }
- // Recursively query associations
- if ($recursive > 0 && !empty($assocResultSet) && is_array($assocResultSet)) {
- foreach ($LinkModel->associations() as $type1) {
- foreach ($LinkModel->{$type1} as $assoc1 => $assocData1) {
- $DeepModel = $LinkModel->{$assoc1};
- $tmpStack = $stack;
- $tmpStack[] = $assoc1;
- $db = $LinkModel->useDbConfig === $DeepModel->useDbConfig ? $this : $DeepModel->getDataSource();
- $db->queryAssociation($LinkModel, $DeepModel, $type1, $assoc1, $assocData1, $queryData, true, $assocResultSet, $recursive - 1, $tmpStack);
- }
- }
- }
- // Filter
- if ($queryData['callbacks'] === true || $queryData['callbacks'] === 'after') {
- $this->_filterResults($assocResultSet, $Model);
- }
- // Merge
- return $this->_mergeHasMany($resultSet, $assocResultSet, $association, $Model);
- } elseif ($type === 'hasAndBelongsToMany') {
- // 'hasAndBelongsToMany' associations.
- $assocIds = array();
- foreach ($resultSet as $result) {
- $assocIds[] = $this->insertQueryData('{$__cakeID__$}', $result, $association, $Model, $stack);
- }
- $assocIds = array_filter($assocIds);
- // Fetch
- $assocResultSet = array();
- if (!empty($assocIds)) {
- $assocResultSet = $this->_fetchHasAndBelongsToMany($Model, $queryTemplate, $assocIds, $association);
- }
- $habtmAssocData = $Model->hasAndBelongsToMany[$association];
- $foreignKey = $habtmAssocData['foreignKey'];
- $joinKeys = array($foreignKey, $habtmAssocData['associationForeignKey']);
- list($with, $habtmFields) = $Model->joinModel($habtmAssocData['with'], $joinKeys);
- $habtmFieldsCount = count($habtmFields);
- // Filter
- if ($queryData['callbacks'] === true || $queryData['callbacks'] === 'after') {
- $this->_filterResults($assocResultSet, $Model);
- }
- }
- $modelAlias = $Model->alias;
- $primaryKey = $Model->primaryKey;
- $selfJoin = ($Model->name === $LinkModel->name);
- foreach ($resultSet as &$row) {
- if ($type === 'hasOne' || $type === 'belongsTo' || $type === 'hasMany') {
- $assocResultSet = array();
- if (
- ($type === 'hasOne' || $type === 'belongsTo') &&
- isset($row[$LinkModel->alias], $joined[$Model->alias]) &&
- in_array($LinkModel->alias, $joined[$Model->alias])
- ) {
- $joinedData = Hash::filter($row[$LinkModel->alias]);
- if (!empty($joinedData)) {
- $assocResultSet[0] = array($LinkModel->alias => $row[$LinkModel->alias]);
- }
- } else {
- $query = $this->insertQueryData($queryTemplate, $row, $association, $Model, $stack);
- if ($query !== false) {
- $assocResultSet = $this->fetchAll($query, $Model->cacheQueries);
- }
- }
- }
- if (!empty($assocResultSet) && is_array($assocResultSet)) {
- if ($recursive > 0) {
- foreach ($LinkModel->associations() as $type1) {
- foreach ($LinkModel->{$type1} as $assoc1 => $assocData1) {
- $DeepModel = $LinkModel->{$assoc1};
- if (
- $type1 === 'belongsTo' ||
- ($type === 'belongsTo' && $DeepModel->alias === $modelAlias) ||
- ($DeepModel->alias !== $modelAlias)
- ) {
- $tmpStack = $stack;
- $tmpStack[] = $assoc1;
- $db = $LinkModel->useDbConfig === $DeepModel->useDbConfig ? $this : $DeepModel->getDataSource();
- $db->queryAssociation($LinkModel, $DeepModel, $type1, $assoc1, $assocData1, $queryData, true, $assocResultSet, $recursive - 1, $tmpStack);
- }
- }
- }
- }
- if ($type === 'hasAndBelongsToMany') {
- $merge = array();
- foreach ($assocResultSet as $data) {
- if (isset($data[$with]) && $data[$with][$foreignKey] === $row[$modelAlias][$primaryKey]) {
- if ($habtmFieldsCount <= 2) {
- unset($data[$with]);
- }
- $merge[] = $data;
- }
- }
- if (empty($merge) && !isset($row[$association])) {
- $row[$association] = $merge;
- } else {
- $this->_mergeAssociation($row, $merge, $association, $type);
- }
- } else {
- $this->_mergeAssociation($row, $assocResultSet, $association, $type, $selfJoin);
- }
- if ($type !== 'hasAndBelongsToMany' && isset($row[$association])) {
- $row[$association] = $LinkModel->afterFind($row[$association], false);
- }
- } else {
- $tempArray[0][$association] = false;
- $this->_mergeAssociation($row, $tempArray, $association, $type, $selfJoin);
- }
- }
- }
- /**
- * Fetch 'hasMany' associations.
- *
- * This is just a proxy to maintain BC.
- *
- * @param Model $Model Primary model object.
- * @param string $query Association query template.
- * @param array $ids Array of IDs of associated records.
- * @return array Association results.
- * @see DboSource::_fetchHasMany()
- */
- public function fetchAssociated(Model $Model, $query, $ids) {
- return $this->_fetchHasMany($Model, $query, $ids);
- }
- /**
- * Fetch 'hasMany' associations.
- *
- * @param Model $Model Primary model object.
- * @param string $query Association query template.
- * @param array $ids Array of IDs of associated records.
- * @return array Association results.
- */
- protected function _fetchHasMany(Model $Model, $query, $ids) {
- $ids = array_unique($ids);
- $query = str_replace('{$__cakeID__$}', implode(', ', $ids), $query);
- if (count($ids) > 1) {
- $query = str_replace('= (', 'IN (', $query);
- }
- return $this->fetchAll($query, $Model->cacheQueries);
- }
- /**
- * Fetch 'hasAndBelongsToMany' associations.
- *
- * @param Model $Model Primary model object.
- * @param string $query Association query.
- * @param array $ids Array of IDs of associated records.
- * @param string $association Association name.
- * @return array Association results.
- */
- protected function _fetchHasAndBelongsToMany(Model $Model, $query, $ids, $association) {
- $ids = array_unique($ids);
- if (count($ids) > 1) {
- $query = str_replace('{$__cakeID__$}', '(' . implode(', ', $ids) . ')', $query);
- $query = str_replace('= (', 'IN (', $query);
- } else {
- $query = str_replace('{$__cakeID__$}', $ids[0], $query);
- }
- $query = str_replace(' WHERE 1 = 1', '', $query);
- return $this->fetchAll($query, $Model->cacheQueries);
- }
- /**
- * Merge the results of 'hasMany' associations.
- *
- * Note: this function also deals with the formatting of the data.
- *
- * @param array $resultSet Data to merge into.
- * @param array $assocResultSet Data to merge.
- * @param string $association Name of Model being merged.
- * @param Model $Model Model being merged onto.
- * @return void
- */
- protected function _mergeHasMany(&$resultSet, $assocResultSet, $association, Model $Model) {
- $modelAlias = $Model->alias;
- $primaryKey = $Model->primaryKey;
- $foreignKey = $Model->hasMany[$association]['foreignKey'];
- foreach ($resultSet as &$result) {
- if (!isset($result[$modelAlias])) {
- continue;
- }
- $resultPrimaryKey = $result[$modelAlias][$primaryKey];
- $merged = array();
- foreach ($assocResultSet as $data) {
- if ($resultPrimaryKey !== $data[$association][$foreignKey]) {
- continue;
- }
- if (count($data) > 1) {
- $data = array_merge($data[$association], $data);
- unset($data[$association]);
- foreach ($data as $key => $name) {
- if (is_numeric($key)) {
- $data[$association][] = $name;
- unset($data[$key]);
- }
- }
- $merged[] = $data;
- } else {
- $merged[] = $data[$association];
- }
- }
- $result = Hash::mergeDiff($result, array($association => $merged));
- }
- }
- /**
- * Merge association of merge into data
- *
- * @param array $data
- * @param array $merge
- * @param string $association
- * @param string $type
- * @param boolean $selfJoin
- * @return void
- */
- protected function _mergeAssociation(&$data, &$merge, $association, $type, $selfJoin = false) {
- if (isset($merge[0]) && !isset($merge[0][$association])) {
- $association = Inflector::pluralize($association);
- }
- $dataAssociation =& $data[$association];
- if ($type === 'belongsTo' || $type === 'hasOne') {
- if (isset($merge[$association])) {
- $dataAssociation = $merge[$association][0];
- } else {
- if (!empty($merge[0][$association])) {
- foreach ($merge[0] as $assoc => $data2) {
- if ($assoc !== $association) {
- $merge[0][$association][$assoc] = $data2;
- }
- }
- }
- if (!isset($dataAssociation)) {
- $dataAssociation = array();
- if ($merge[0][$association]) {
- $dataAssociation = $merge[0][$association];
- }
- } else {
- if (is_array($merge[0][$association])) {
- foreach ($dataAssociation as $k => $v) {
- if (!is_array($v)) {
- $dataAssocTmp[$k] = $v;
- }
- }
- foreach ($merge[0][$association] as $k => $v) {
- if (!is_array($v)) {
- $mergeAssocTmp[$k] = $v;
- }
- }
- $dataKeys = array_keys($data);
- $mergeKeys = array_keys($merge[0]);
- if ($mergeKeys[0] === $dataKeys[0] || $mergeKeys === $dataKeys) {
- $dataAssociation[$association] = $merge[0][$association];
- } else {
- $diff = Hash::diff($dataAssocTmp, $mergeAssocTmp);
- $dataAssociation = array_merge($merge[0][$association], $diff);
- }
- } elseif ($selfJoin && array_key_exists($association, $merge[0])) {
- $dataAssociation = array_merge($dataAssociation, array($association => array()));
- }
- }
- }
- } else {
- if (isset($merge[0][$association]) && $merge[0][$association] === false) {
- if (!isset($dataAssociation)) {
- $dataAssociation = array();
- }
- } else {
- foreach ($merge as $row) {
- $insert = array();
- if (count($row) === 1) {
- $insert = $row[$association];
- } elseif (isset($row[$association])) {
- $insert = array_merge($row[$association], $row);
- unset($insert[$association]);
- }
- if (empty($dataAssociation) || (isset($dataAssociation) && !in_array($insert, $dataAssociation, true))) {
- $dataAssociation[] = $insert;
- }
- }
- }
- }
- }
- /**
- * Prepares fields required by an SQL statement.
- *
- * When no fields are set, all the $Model fields are returned.
- *
- * @param Model $Model
- * @param array $queryData An array of queryData information containing keys similar to Model::find().
- * @return array Array containing SQL fields.
- */
- public function prepareFields(Model $Model, $queryData) {
- if (empty($queryData['fields'])) {
- $queryData['fields'] = $this->fields($Model);
- } elseif (!empty($Model->hasMany) && $Model->recursive > -1) {
- // hasMany relationships need the $Model primary key.
- $assocFields = $this->fields($Model, null, "{$Model->alias}.{$Model->primaryKey}");
- $passedFields = $queryData['fields'];
- if (
- count($passedFields) > 1 ||
- (strpos($passedFields[0], $assocFields[0]) === false && !preg_match('/^[a-z]+\(/i', $passedFields[0]))
- ) {
- $queryData['fields'] = array_merge($passedFields, $assocFields);
- }
- }
- return array_unique($queryData['fields']);
- }
- /**
- * Builds an SQL statement.
- *
- * This is merely a convenient wrapper to DboSource::buildStatement().
- *
- * @param Model $Model
- * @param array $queryData An array of queryData information containing keys similar to Model::find().
- * @return string String containing an SQL statement.
- * @see DboSource::buildStatement()
- */
- public function buildAssociationQuery(Model $Model, $queryData) {
- $queryData = $this->_scrubQueryData($queryData);
- return $this->buildStatement(
- array(
- 'fields' => $this->prepareFields($Model, $queryData),
- 'table' => $this->fullTableName($Model),
- 'alias' => $Model->alias,
- 'limit' => $queryData['limit'],
- 'offset' => $queryData['offset'],
- 'joins' => $queryData['joins'],
- 'conditions' => $queryData['conditions'],
- 'order' => $queryData['order'],
- 'group' => $queryData['group']
- ),
- $Model
- );
- }
- /**
- * Generates a query or part of a query from a single model or two associated models.
- *
- * Builds a string containing an SQL statement template.
- *
- * @param Model $Model Primary Model object.
- * @param Model|null $LinkModel Linked model object.
- * @param string $type Association type, one of the model association types ie. hasMany.
- * @param string $association Association name.
- * @param array $assocData Association data.
- * @param array $queryData An array of queryData information containing keys similar to Model::find().
- * @param boolean $external Whether or not the association query is on an external datasource.
- * @return mixed
- * String representing a query.
- * True, when $external is false and association $type is 'hasOne' or 'belongsTo'.
- */
- public function generateAssociationQuery(Model $Model, $LinkModel, $type, $association, $assocData, &$queryData, $external) {
- $assocData = $this->_scrubQueryData($assocData);
- $queryData = $this->_scrubQueryData($queryData);
- if ($LinkModel === null) {
- return $this->buildStatement(
- array(
- 'fields' => array_unique($queryData['fields']),
- 'table' => $this->fullTableName($Model),
- 'alias' => $Model->alias,
- 'limit' => $queryData['limit'],
- 'offset' => $queryData['offset'],
- 'joins' => $queryData['joins'],
- 'conditions' => $queryData['conditions'],
- 'order' => $queryData['order'],
- 'group' => $queryData['group']
- ),
- $Model
- );
- }
- if ($external && !empty($assocData['finderQuery'])) {
- return $assocData['finderQuery'];
- }
- if ($type === 'hasMany' || $type === 'hasAndBelongsToMany') {
- if (empty($assocData['offset']) && !empty($assocData['page'])) {
- $assocData['offset'] = ($assocData['page'] - 1) * $assocData['limit'];
- }
- }
- switch ($type) {
- case 'hasOne':
- case 'belongsTo':
- $conditions = $this->_mergeConditions(
- $assocData['conditions'],
- $this->getConstraint($type, $Model, $LinkModel, $association, array_merge($assocData, compact('external')))
- );
- if ($external) {
- // Not self join
- if ($Model->name !== $LinkModel->name) {
- $modelAlias = $Model->alias;
- foreach ($conditions as $key => $condition) {
- if (is_numeric($key) && strpos($condition, $modelAlias . '.') !== false) {
- unset($conditions[$key]);
- }
- }
- }
- $query = array_merge($assocData, array(
- 'conditions' => $conditions,
- 'table' => $this->fullTableName($LinkModel),
- 'fields' => $this->fields($LinkModel, $association, $assocData['fields']),
- 'alias' => $association,
- 'group' => null
- ));
- } else {
- $join = array(
- 'table' => $LinkModel,
- 'alias' => $association,
- 'type' => isset($assocData['type']) ? $assocData['type'] : 'LEFT',
- 'conditions' => trim($this->conditions($conditions, true, false, $Model))
- );
- $fields = array();
- if ($assocData['fields'] !== false) {
- $fields = $this->fields($LinkModel, $association, $assocData['fields']);
- }
- $queryData['fields'] = array_merge($this->prepareFields($Model, $queryData), $fields);
- if (!empty($assocData['order'])) {
- $queryData['order'][] = $assocData['order'];
- }
- if (!in_array($join, $queryData['joins'], true)) {
- $queryData['joins'][] = $join;
- }
- return true;
- }
- break;
- case 'hasMany':
- $assocData['fields'] = $this->fields($LinkModel, $association, $assocData['fields']);
- if (!empty($assocData['foreignKey'])) {
- $assocData['fields'] = array_merge($assocData['fields'], $this->fields($LinkModel, $association, array("{$association}.{$assocData['foreignKey']}")));
- }
- $query = array(
- 'conditions' => $this->_mergeConditions($this->getConstraint('hasMany', $Model, $LinkModel, $association, $assocData), $assocData['conditions']),
- 'fields' => array_unique($assocData['fields']),
- 'table' => $this->fullTableName($LinkModel),
- 'alias' => $association,
- 'order' => $assocData['order'],
- 'limit' => $assocData['limit'],
- 'offset' => $assocData['offset'],
- 'group' …
Large files files are truncated, but you can click here to view the full file