pictcode_admin / lib / Cake / Model / Datasource / DataSource.php @ 5ad38a95
履歴 | 表示 | アノテート | ダウンロード (10.239 KB)
| 1 | 5ad38a95 | spyder1211 | <?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 | } |