pictcode / lib / Cake / Model / Datasource / DataSource.php @ 22fd3a57
履歴 | 表示 | アノテート | ダウンロード (10.239 KB)
| 1 | 
      <?php
     | 
  
|---|---|
| 2 | 
      /**
     | 
  
| 3 | 
       * DataSource base class
     | 
  
| 4 | 
       *
     | 
  
| 5 | 
       * CakePHP(tm) : Rapid Development Framework (http://cakephp.org)
     | 
  
| 6 | 
       * Copyright (c) Cake Software Foundation, Inc. (http://cakefoundation.org)
     | 
  
| 7 | 
       *
     | 
  
| 8 | 
       * Licensed under The MIT License
     | 
  
| 9 | 
       * For full copyright and license information, please see the LICENSE.txt
     | 
  
| 10 | 
       * Redistributions of files must retain the above copyright notice.
     | 
  
| 11 | 
       *
     | 
  
| 12 | 
       * @copyright     Copyright (c) Cake Software Foundation, Inc. (http://cakefoundation.org)
     | 
  
| 13 | 
       * @link          http://cakephp.org CakePHP(tm) Project
     | 
  
| 14 | 
       * @package       Cake.Model.Datasource
     | 
  
| 15 | 
       * @since         CakePHP(tm) v 0.10.5.1790
     | 
  
| 16 | 
       * @license       http://www.opensource.org/licenses/mit-license.php MIT License
     | 
  
| 17 | 
       */
     | 
  
| 18 | 
       | 
  
| 19 | 
      /**
     | 
  
| 20 | 
       * DataSource base class
     | 
  
| 21 | 
       *
     | 
  
| 22 | 
       * DataSources are the link between models and the source of data that models represent.
     | 
  
| 23 | 
       *
     | 
  
| 24 | 
       * @link          http://book.cakephp.org/2.0/en/models/datasources.html#basic-api-for-datasources
     | 
  
| 25 | 
       * @package       Cake.Model.Datasource
     | 
  
| 26 | 
       */
     | 
  
| 27 | 
      class DataSource extends Object {  | 
  
| 28 | 
       | 
  
| 29 | 
      /**
     | 
  
| 30 | 
       * Are we connected to the DataSource?
     | 
  
| 31 | 
       *
     | 
  
| 32 | 
       * @var bool
     | 
  
| 33 | 
       */
     | 
  
| 34 | 
      public $connected = false;  | 
  
| 35 | 
       | 
  
| 36 | 
      /**
     | 
  
| 37 | 
       * The default configuration of a specific DataSource
     | 
  
| 38 | 
       *
     | 
  
| 39 | 
       * @var array
     | 
  
| 40 | 
       */
     | 
  
| 41 | 
      protected $_baseConfig = array();  | 
  
| 42 | 
       | 
  
| 43 | 
      /**
     | 
  
| 44 | 
       * Holds references to descriptions loaded by the DataSource
     | 
  
| 45 | 
       *
     | 
  
| 46 | 
       * @var array
     | 
  
| 47 | 
       */
     | 
  
| 48 | 
      protected $_descriptions = array();  | 
  
| 49 | 
       | 
  
| 50 | 
      /**
     | 
  
| 51 | 
       * Holds a list of sources (tables) contained in the DataSource
     | 
  
| 52 | 
       *
     | 
  
| 53 | 
       * @var array
     | 
  
| 54 | 
       */
     | 
  
| 55 | 
      protected $_sources = null;  | 
  
| 56 | 
       | 
  
| 57 | 
      /**
     | 
  
| 58 | 
       * The DataSource configuration
     | 
  
| 59 | 
       *
     | 
  
| 60 | 
       * @var array
     | 
  
| 61 | 
       */
     | 
  
| 62 | 
      public $config = array();  | 
  
| 63 | 
       | 
  
| 64 | 
      /**
     | 
  
| 65 | 
       * Whether or not this DataSource is in the middle of a transaction
     | 
  
| 66 | 
       *
     | 
  
| 67 | 
       * @var bool
     | 
  
| 68 | 
       */
     | 
  
| 69 | 
      protected $_transactionStarted = false;  | 
  
| 70 | 
       | 
  
| 71 | 
      /**
     | 
  
| 72 | 
       * Whether or not source data like available tables and schema descriptions
     | 
  
| 73 | 
       * should be cached
     | 
  
| 74 | 
       *
     | 
  
| 75 | 
       * @var bool
     | 
  
| 76 | 
       */
     | 
  
| 77 | 
      public $cacheSources = true;  | 
  
| 78 | 
       | 
  
| 79 | 
      /**
     | 
  
| 80 | 
       * Constructor.
     | 
  
| 81 | 
       *
     | 
  
| 82 | 
       * @param array $config Array of configuration information for the datasource.
     | 
  
| 83 | 
       */
     | 
  
| 84 | 
      public function __construct($config = array()) {  | 
  
| 85 | 
                      parent::__construct();
     | 
  
| 86 | 
      $this->setConfig($config);  | 
  
| 87 | 
      }  | 
  
| 88 | 
       | 
  
| 89 | 
      /**
     | 
  
| 90 | 
       * Caches/returns cached results for child instances
     | 
  
| 91 | 
       *
     | 
  
| 92 | 
       * @param mixed $data Unused in this class.
     | 
  
| 93 | 
       * @return array|null Array of sources available in this datasource.
     | 
  
| 94 | 
       */
     | 
  
| 95 | 
      public function listSources($data = null) {  | 
  
| 96 | 
      if ($this->cacheSources === false) {  | 
  
| 97 | 
      return null;  | 
  
| 98 | 
      }  | 
  
| 99 | 
       | 
  
| 100 | 
      if ($this->_sources !== null) {  | 
  
| 101 | 
      return $this->_sources;  | 
  
| 102 | 
      }  | 
  
| 103 | 
       | 
  
| 104 | 
      $key = ConnectionManager::getSourceName($this) . '_' . $this->config['database'] . '_list';  | 
  
| 105 | 
      $key = preg_replace('/[^A-Za-z0-9_\-.+]/', '_', $key);  | 
  
| 106 | 
      $sources = Cache::read($key, '_cake_model_');  | 
  
| 107 | 
       | 
  
| 108 | 
      if (empty($sources)) {  | 
  
| 109 | 
      $sources = $data;  | 
  
| 110 | 
      Cache::write($key, $data, '_cake_model_');  | 
  
| 111 | 
      }  | 
  
| 112 | 
       | 
  
| 113 | 
      return $this->_sources = $sources;  | 
  
| 114 | 
      }  | 
  
| 115 | 
       | 
  
| 116 | 
      /**
     | 
  
| 117 | 
       * Returns a Model description (metadata) or null if none found.
     | 
  
| 118 | 
       *
     | 
  
| 119 | 
       * @param Model|string $model The model to describe.
     | 
  
| 120 | 
       * @return array|null Array of Metadata for the $model
     | 
  
| 121 | 
       */
     | 
  
| 122 | 
      public function describe($model) {  | 
  
| 123 | 
      if ($this->cacheSources === false) {  | 
  
| 124 | 
      return null;  | 
  
| 125 | 
      }  | 
  
| 126 | 
      if (is_string($model)) {  | 
  
| 127 | 
      $table = $model;  | 
  
| 128 | 
                      } else {
     | 
  
| 129 | 
      $table = $model->tablePrefix . $model->table;  | 
  
| 130 | 
      }  | 
  
| 131 | 
       | 
  
| 132 | 
      if (isset($this->_descriptions[$table])) {  | 
  
| 133 | 
      return $this->_descriptions[$table];  | 
  
| 134 | 
      }  | 
  
| 135 | 
      $cache = $this->_cacheDescription($table);  | 
  
| 136 | 
       | 
  
| 137 | 
      if ($cache !== null) {  | 
  
| 138 | 
      $this->_descriptions[$table] =& $cache;  | 
  
| 139 | 
      return $cache;  | 
  
| 140 | 
      }  | 
  
| 141 | 
      return null;  | 
  
| 142 | 
      }  | 
  
| 143 | 
       | 
  
| 144 | 
      /**
     | 
  
| 145 | 
       * Begin a transaction
     | 
  
| 146 | 
       *
     | 
  
| 147 | 
       * @return bool Returns true if a transaction is not in progress
     | 
  
| 148 | 
       */
     | 
  
| 149 | 
      public function begin() {  | 
  
| 150 | 
      return !$this->_transactionStarted;  | 
  
| 151 | 
      }  | 
  
| 152 | 
       | 
  
| 153 | 
      /**
     | 
  
| 154 | 
       * Commit a transaction
     | 
  
| 155 | 
       *
     | 
  
| 156 | 
       * @return bool Returns true if a transaction is in progress
     | 
  
| 157 | 
       */
     | 
  
| 158 | 
      public function commit() {  | 
  
| 159 | 
      return $this->_transactionStarted;  | 
  
| 160 | 
      }  | 
  
| 161 | 
       | 
  
| 162 | 
      /**
     | 
  
| 163 | 
       * Rollback a transaction
     | 
  
| 164 | 
       *
     | 
  
| 165 | 
       * @return bool Returns true if a transaction is in progress
     | 
  
| 166 | 
       */
     | 
  
| 167 | 
      public function rollback() {  | 
  
| 168 | 
      return $this->_transactionStarted;  | 
  
| 169 | 
      }  | 
  
| 170 | 
       | 
  
| 171 | 
      /**
     | 
  
| 172 | 
       * Converts column types to basic types
     | 
  
| 173 | 
       *
     | 
  
| 174 | 
       * @param string $real Real column type (i.e. "varchar(255)")
     | 
  
| 175 | 
       * @return string Abstract column type (i.e. "string")
     | 
  
| 176 | 
       */
     | 
  
| 177 | 
      public function column($real) {  | 
  
| 178 | 
      return false;  | 
  
| 179 | 
      }  | 
  
| 180 | 
       | 
  
| 181 | 
      /**
     | 
  
| 182 | 
       * Used to create new records. The "C" CRUD.
     | 
  
| 183 | 
       *
     | 
  
| 184 | 
       * To-be-overridden in subclasses.
     | 
  
| 185 | 
       *
     | 
  
| 186 | 
       * @param Model $Model The Model to be created.
     | 
  
| 187 | 
       * @param array $fields An Array of fields to be saved.
     | 
  
| 188 | 
       * @param array $values An Array of values to save.
     | 
  
| 189 | 
       * @return bool success
     | 
  
| 190 | 
       */
     | 
  
| 191 | 
      public function create(Model $Model, $fields = null, $values = null) {  | 
  
| 192 | 
      return false;  | 
  
| 193 | 
      }  | 
  
| 194 | 
       | 
  
| 195 | 
      /**
     | 
  
| 196 | 
       * Used to read records from the Datasource. The "R" in CRUD
     | 
  
| 197 | 
       *
     | 
  
| 198 | 
       * To-be-overridden in subclasses.
     | 
  
| 199 | 
       *
     | 
  
| 200 | 
       * @param Model $Model The model being read.
     | 
  
| 201 | 
       * @param array $queryData An array of query data used to find the data you want
     | 
  
| 202 | 
       * @param int $recursive Number of levels of association
     | 
  
| 203 | 
       * @return mixed
     | 
  
| 204 | 
       */
     | 
  
| 205 | 
      public function read(Model $Model, $queryData = array(), $recursive = null) {  | 
  
| 206 | 
      return false;  | 
  
| 207 | 
      }  | 
  
| 208 | 
       | 
  
| 209 | 
      /**
     | 
  
| 210 | 
       * Update a record(s) in the datasource.
     | 
  
| 211 | 
       *
     | 
  
| 212 | 
       * To-be-overridden in subclasses.
     | 
  
| 213 | 
       *
     | 
  
| 214 | 
       * @param Model $Model Instance of the model class being updated
     | 
  
| 215 | 
       * @param array $fields Array of fields to be updated
     | 
  
| 216 | 
       * @param array $values Array of values to be update $fields to.
     | 
  
| 217 | 
       * @param mixed $conditions The array of conditions to use.
     | 
  
| 218 | 
       * @return bool Success
     | 
  
| 219 | 
       */
     | 
  
| 220 | 
      public function update(Model $Model, $fields = null, $values = null, $conditions = null) {  | 
  
| 221 | 
      return false;  | 
  
| 222 | 
      }  | 
  
| 223 | 
       | 
  
| 224 | 
      /**
     | 
  
| 225 | 
       * Delete a record(s) in the datasource.
     | 
  
| 226 | 
       *
     | 
  
| 227 | 
       * To-be-overridden in subclasses.
     | 
  
| 228 | 
       *
     | 
  
| 229 | 
       * @param Model $Model The model class having record(s) deleted
     | 
  
| 230 | 
       * @param mixed $conditions The conditions to use for deleting.
     | 
  
| 231 | 
       * @return bool Success
     | 
  
| 232 | 
       */
     | 
  
| 233 | 
      public function delete(Model $Model, $conditions = null) {  | 
  
| 234 | 
      return false;  | 
  
| 235 | 
      }  | 
  
| 236 | 
       | 
  
| 237 | 
      /**
     | 
  
| 238 | 
       * Returns the ID generated from the previous INSERT operation.
     | 
  
| 239 | 
       *
     | 
  
| 240 | 
       * @param mixed $source The source name.
     | 
  
| 241 | 
       * @return mixed Last ID key generated in previous INSERT
     | 
  
| 242 | 
       */
     | 
  
| 243 | 
      public function lastInsertId($source = null) {  | 
  
| 244 | 
      return false;  | 
  
| 245 | 
      }  | 
  
| 246 | 
       | 
  
| 247 | 
      /**
     | 
  
| 248 | 
       * Returns the number of rows returned by last operation.
     | 
  
| 249 | 
       *
     | 
  
| 250 | 
       * @param mixed $source The source name.
     | 
  
| 251 | 
       * @return int Number of rows returned by last operation
     | 
  
| 252 | 
       */
     | 
  
| 253 | 
      public function lastNumRows($source = null) {  | 
  
| 254 | 
      return false;  | 
  
| 255 | 
      }  | 
  
| 256 | 
       | 
  
| 257 | 
      /**
     | 
  
| 258 | 
       * Returns the number of rows affected by last query.
     | 
  
| 259 | 
       *
     | 
  
| 260 | 
       * @param mixed $source The source name.
     | 
  
| 261 | 
       * @return int Number of rows affected by last query.
     | 
  
| 262 | 
       */
     | 
  
| 263 | 
      public function lastAffected($source = null) {  | 
  
| 264 | 
      return false;  | 
  
| 265 | 
      }  | 
  
| 266 | 
       | 
  
| 267 | 
      /**
     | 
  
| 268 | 
       * Check whether the conditions for the Datasource being available
     | 
  
| 269 | 
       * are satisfied. Often used from connect() to check for support
     | 
  
| 270 | 
       * before establishing a connection.
     | 
  
| 271 | 
       *
     | 
  
| 272 | 
       * @return bool Whether or not the Datasources conditions for use are met.
     | 
  
| 273 | 
       */
     | 
  
| 274 | 
      public function enabled() {  | 
  
| 275 | 
      return true;  | 
  
| 276 | 
      }  | 
  
| 277 | 
       | 
  
| 278 | 
      /**
     | 
  
| 279 | 
       * Sets the configuration for the DataSource.
     | 
  
| 280 | 
       * Merges the $config information with the _baseConfig and the existing $config property.
     | 
  
| 281 | 
       *
     | 
  
| 282 | 
       * @param array $config The configuration array
     | 
  
| 283 | 
       * @return void
     | 
  
| 284 | 
       */
     | 
  
| 285 | 
      public function setConfig($config = array()) {  | 
  
| 286 | 
      $this->config = array_merge($this->_baseConfig, $this->config, $config);  | 
  
| 287 | 
      }  | 
  
| 288 | 
       | 
  
| 289 | 
      /**
     | 
  
| 290 | 
       * Cache the DataSource description
     | 
  
| 291 | 
       *
     | 
  
| 292 | 
       * @param string $object The name of the object (model) to cache
     | 
  
| 293 | 
       * @param mixed $data The description of the model, usually a string or array
     | 
  
| 294 | 
       * @return mixed
     | 
  
| 295 | 
       */
     | 
  
| 296 | 
      protected function _cacheDescription($object, $data = null) {  | 
  
| 297 | 
      if ($this->cacheSources === false) {  | 
  
| 298 | 
      return null;  | 
  
| 299 | 
      }  | 
  
| 300 | 
       | 
  
| 301 | 
      if ($data !== null) {  | 
  
| 302 | 
      $this->_descriptions[$object] =& $data;  | 
  
| 303 | 
      }  | 
  
| 304 | 
       | 
  
| 305 | 
      $key = ConnectionManager::getSourceName($this) . '_' . $object;  | 
  
| 306 | 
      $cache = Cache::read($key, '_cake_model_');  | 
  
| 307 | 
       | 
  
| 308 | 
      if (empty($cache)) {  | 
  
| 309 | 
      $cache = $data;  | 
  
| 310 | 
      Cache::write($key, $cache, '_cake_model_');  | 
  
| 311 | 
      }  | 
  
| 312 | 
       | 
  
| 313 | 
      return $cache;  | 
  
| 314 | 
      }  | 
  
| 315 | 
       | 
  
| 316 | 
      /**
     | 
  
| 317 | 
       * Replaces `{$__cakeID__$}` and `{$__cakeForeignKey__$}` placeholders in query data.
     | 
  
| 318 | 
       *
     | 
  
| 319 | 
       * @param string $query Query string needing replacements done.
     | 
  
| 320 | 
       * @param array $data Array of data with values that will be inserted in placeholders.
     | 
  
| 321 | 
       * @param string $association Name of association model being replaced.
     | 
  
| 322 | 
       * @param Model $Model Model instance.
     | 
  
| 323 | 
       * @param array $stack The context stack.
     | 
  
| 324 | 
       * @return mixed String of query data with placeholders replaced, or false on failure.
     | 
  
| 325 | 
       */
     | 
  
| 326 | 
      public function insertQueryData($query, $data, $association, Model $Model, $stack) {  | 
  
| 327 | 
      $keys = array('{$__cakeID__$}', '{$__cakeForeignKey__$}');  | 
  
| 328 | 
       | 
  
| 329 | 
      $modelAlias = $Model->alias;  | 
  
| 330 | 
       | 
  
| 331 | 
      foreach ($keys as $key) {  | 
  
| 332 | 
      if (strpos($query, $key) === false) {  | 
  
| 333 | 
                                      continue;
     | 
  
| 334 | 
      }  | 
  
| 335 | 
       | 
  
| 336 | 
      $insertKey = $InsertModel = null;  | 
  
| 337 | 
      switch ($key) {  | 
  
| 338 | 
      case '{$__cakeID__$}':  | 
  
| 339 | 
      $InsertModel = $Model;  | 
  
| 340 | 
      $insertKey = $Model->primaryKey;  | 
  
| 341 | 
       | 
  
| 342 | 
                                              break;
     | 
  
| 343 | 
      case '{$__cakeForeignKey__$}':  | 
  
| 344 | 
      foreach ($Model->associations() as $type) {  | 
  
| 345 | 
      foreach ($Model->{$type} as $assoc => $assocData) {  | 
  
| 346 | 
      if ($assoc !== $association) {  | 
  
| 347 | 
                                                                      continue;
     | 
  
| 348 | 
      }  | 
  
| 349 | 
       | 
  
| 350 | 
      if (isset($assocData['foreignKey'])) {  | 
  
| 351 | 
      $InsertModel = $Model->{$assoc};  | 
  
| 352 | 
      $insertKey = $assocData['foreignKey'];  | 
  
| 353 | 
      }  | 
  
| 354 | 
       | 
  
| 355 | 
      break 3;  | 
  
| 356 | 
      }  | 
  
| 357 | 
      }  | 
  
| 358 | 
       | 
  
| 359 | 
                                              break;
     | 
  
| 360 | 
      }  | 
  
| 361 | 
       | 
  
| 362 | 
      $val = $dataType = null;  | 
  
| 363 | 
      if (!empty($insertKey) && !empty($InsertModel)) {  | 
  
| 364 | 
      if (isset($data[$modelAlias][$insertKey])) {  | 
  
| 365 | 
      $val = $data[$modelAlias][$insertKey];  | 
  
| 366 | 
      } elseif (isset($data[$association][$insertKey])) {  | 
  
| 367 | 
      $val = $data[$association][$insertKey];  | 
  
| 368 | 
                                      } else {
     | 
  
| 369 | 
      $found = false;  | 
  
| 370 | 
      foreach (array_reverse($stack) as $assocData) {  | 
  
| 371 | 
      if (isset($data[$assocData]) && isset($data[$assocData][$insertKey])) {  | 
  
| 372 | 
      $val = $data[$assocData][$insertKey];  | 
  
| 373 | 
      $found = true;  | 
  
| 374 | 
                                                              break;
     | 
  
| 375 | 
      }  | 
  
| 376 | 
      }  | 
  
| 377 | 
       | 
  
| 378 | 
      if (!$found) {  | 
  
| 379 | 
      $val = '';  | 
  
| 380 | 
      }  | 
  
| 381 | 
      }  | 
  
| 382 | 
       | 
  
| 383 | 
      $dataType = $InsertModel->getColumnType($InsertModel->primaryKey);  | 
  
| 384 | 
      }  | 
  
| 385 | 
       | 
  
| 386 | 
      if (empty($val) && $val !== '0') {  | 
  
| 387 | 
      return false;  | 
  
| 388 | 
      }  | 
  
| 389 | 
       | 
  
| 390 | 
      $query = str_replace($key, $this->value($val, $dataType), $query);  | 
  
| 391 | 
      }  | 
  
| 392 | 
       | 
  
| 393 | 
      return $query;  | 
  
| 394 | 
      }  | 
  
| 395 | 
       | 
  
| 396 | 
      /**
     | 
  
| 397 | 
       * To-be-overridden in subclasses.
     | 
  
| 398 | 
       *
     | 
  
| 399 | 
       * @param Model $Model Model instance
     | 
  
| 400 | 
       * @param string $key Key name to make
     | 
  
| 401 | 
       * @return string Key name for model.
     | 
  
| 402 | 
       */
     | 
  
| 403 | 
      public function resolveKey(Model $Model, $key) {  | 
  
| 404 | 
      return $Model->alias . $key;  | 
  
| 405 | 
      }  | 
  
| 406 | 
       | 
  
| 407 | 
      /**
     | 
  
| 408 | 
       * Returns the schema name. Override this in subclasses.
     | 
  
| 409 | 
       *
     | 
  
| 410 | 
       * @return string|null The schema name
     | 
  
| 411 | 
       */
     | 
  
| 412 | 
      public function getSchemaName() {  | 
  
| 413 | 
      return null;  | 
  
| 414 | 
      }  | 
  
| 415 | 
       | 
  
| 416 | 
      /**
     | 
  
| 417 | 
       * Closes a connection. Override in subclasses.
     | 
  
| 418 | 
       *
     | 
  
| 419 | 
       * @return bool
     | 
  
| 420 | 
       */
     | 
  
| 421 | 
      public function close() {  | 
  
| 422 | 
      return $this->connected = false;  | 
  
| 423 | 
      }  | 
  
| 424 | 
       | 
  
| 425 | 
      /**
     | 
  
| 426 | 
       * Closes the current datasource.
     | 
  
| 427 | 
       */
     | 
  
| 428 | 
      public function __destruct() {  | 
  
| 429 | 
      if ($this->_transactionStarted) {  | 
  
| 430 | 
                              $this->rollback();
     | 
  
| 431 | 
      }  | 
  
| 432 | 
      if ($this->connected) {  | 
  
| 433 | 
                              $this->close();
     | 
  
| 434 | 
      }  | 
  
| 435 | 
      }  | 
  
| 436 | 
       | 
  
| 437 | 
      }  |