統計
| ブランチ: | リビジョン:

pictcode_admin / lib / Cake / Model / Datasource / DataSource.php @ 5ad38a95

履歴 | 表示 | アノテート | ダウンロード (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
}