123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310 |
- <?php
- /**
- * CakePHP(tm) Tests <http://book.cakephp.org/2.0/en/development/testing.html>
- * Copyright 2005-2012, Cake Software Foundation, Inc. (http://cakefoundation.org)
- *
- * Licensed under The MIT License
- * Redistributions of files must retain the above copyright notice
- *
- * @copyright Copyright 2005-2012, Cake Software Foundation, Inc. (http://cakefoundation.org)
- * @link http://book.cakephp.org/2.0/en/development/testing.html CakePHP(tm) Tests
- * @package Cake.TestSuite.Fixture
- * @since CakePHP(tm) v 1.2.0.4667
- * @license MIT License (http://www.opensource.org/licenses/mit-license.php)
- */
- App::uses('CakeSchema', 'Model');
- /**
- * CakeTestFixture is responsible for building and destroying tables to be used
- * during testing.
- *
- * @package Cake.TestSuite.Fixture
- */
- class CakeTestFixture {
- /**
- * Name of the object
- *
- * @var string
- */
- public $name = null;
- /**
- * Cake's DBO driver (e.g: DboMysql).
- *
- * @var object
- */
- public $db = null;
- /**
- * Fixture Datasource
- *
- * @var string
- */
- public $useDbConfig = 'test';
- /**
- * Full Table Name
- *
- * @var string
- */
- public $table = null;
- /**
- * List of datasources where this fixture has been created
- *
- * @var array
- */
- public $created = array();
- /**
- * Fields / Schema for the fixture.
- * This array should match the output of Model::schema()
- *
- * @var array
- */
- public $fields = array();
- /**
- * Fixture records to be inserted.
- *
- * @var array
- */
- public $records = array();
- /**
- * The primary key for the table this fixture represents.
- *
- * @var string
- */
- public $primaryKey = null;
- /**
- * Instantiate the fixture.
- *
- * @throws CakeException on invalid datasource usage.
- */
- public function __construct() {
- if ($this->name === null) {
- if (preg_match('/^(.*)Fixture$/', get_class($this), $matches)) {
- $this->name = $matches[1];
- } else {
- $this->name = get_class($this);
- }
- }
- $connection = 'test';
- if (!empty($this->useDbConfig)) {
- $connection = $this->useDbConfig;
- if (strpos($connection, 'test') !== 0) {
- $message = __d(
- 'cake_dev',
- 'Invalid datasource name "%s" for "%s" fixture. Fixture datasource names must begin with "test".',
- $connection,
- $this->name
- );
- throw new CakeException($message);
- }
- }
- $this->Schema = new CakeSchema(array('name' => 'TestSuite', 'connection' => $connection));
- $this->init();
- }
- /**
- * Initialize the fixture.
- *
- * @return void
- * @throws MissingModelException Whe importing from a model that does not exist.
- */
- public function init() {
- if (isset($this->import) && (is_string($this->import) || is_array($this->import))) {
- $import = array_merge(
- array('connection' => 'default', 'records' => false),
- is_array($this->import) ? $this->import : array('model' => $this->import)
- );
- $this->Schema->connection = $import['connection'];
- if (isset($import['model'])) {
- list($plugin, $modelClass) = pluginSplit($import['model'], true);
- App::uses($modelClass, $plugin . 'Model');
- if (!class_exists($modelClass)) {
- throw new MissingModelException(array('class' => $modelClass));
- }
- $model = new $modelClass(null, null, $import['connection']);
- $db = $model->getDataSource();
- if (empty($model->tablePrefix)) {
- $model->tablePrefix = $db->config['prefix'];
- }
- $this->fields = $model->schema(true);
- $this->fields[$model->primaryKey]['key'] = 'primary';
- $this->table = $db->fullTableName($model, false, false);
- $this->primaryKey = $model->primaryKey;
- ClassRegistry::config(array('ds' => 'test'));
- ClassRegistry::flush();
- } elseif (isset($import['table'])) {
- $model = new Model(null, $import['table'], $import['connection']);
- $db = ConnectionManager::getDataSource($import['connection']);
- $db->cacheSources = false;
- $model->useDbConfig = $import['connection'];
- $model->name = Inflector::camelize(Inflector::singularize($import['table']));
- $model->table = $import['table'];
- $model->tablePrefix = $db->config['prefix'];
- $this->fields = $model->schema(true);
- $this->primaryKey = $model->primaryKey;
- ClassRegistry::flush();
- }
- if (!empty($db->config['prefix']) && strpos($this->table, $db->config['prefix']) === 0) {
- $this->table = str_replace($db->config['prefix'], '', $this->table);
- }
- if (isset($import['records']) && $import['records'] !== false && isset($model) && isset($db)) {
- $this->records = array();
- $query = array(
- 'fields' => $db->fields($model, null, array_keys($this->fields)),
- 'table' => $db->fullTableName($model),
- 'alias' => $model->alias,
- 'conditions' => array(),
- 'order' => null,
- 'limit' => null,
- 'group' => null
- );
- $records = $db->fetchAll($db->buildStatement($query, $model), false, $model->alias);
- if ($records !== false && !empty($records)) {
- $this->records = Hash::extract($records, '{n}.' . $model->alias);
- }
- }
- }
- if (!isset($this->table)) {
- $this->table = Inflector::underscore(Inflector::pluralize($this->name));
- }
- if (!isset($this->primaryKey) && isset($this->fields['id'])) {
- $this->primaryKey = 'id';
- }
- }
- /**
- * Run before all tests execute, should return SQL statement to create table for this fixture could be executed successfully.
- *
- * @param DboSource $db An instance of the database object used to create the fixture table
- * @return boolean True on success, false on failure
- */
- public function create($db) {
- if (!isset($this->fields) || empty($this->fields)) {
- return false;
- }
- if (empty($this->fields['tableParameters']['engine'])) {
- $canUseMemory = true;
- foreach ($this->fields as $args) {
- if (is_string($args)) {
- $type = $args;
- } elseif (!empty($args['type'])) {
- $type = $args['type'];
- } else {
- continue;
- }
- if (in_array($type, array('blob', 'text', 'binary'))) {
- $canUseMemory = false;
- break;
- }
- }
- if ($canUseMemory) {
- $this->fields['tableParameters']['engine'] = 'MEMORY';
- }
- }
- $this->Schema->build(array($this->table => $this->fields));
- try {
- $db->execute($db->createSchema($this->Schema), array('log' => false));
- $this->created[] = $db->configKeyName;
- } catch (Exception $e) {
- $msg = __d(
- 'cake_dev',
- 'Fixture creation for "%s" failed "%s"',
- $this->table,
- $e->getMessage()
- );
- CakeLog::error($msg);
- trigger_error($msg, E_USER_WARNING);
- return false;
- }
- return true;
- }
- /**
- * Run after all tests executed, should return SQL statement to drop table for this fixture.
- *
- * @param DboSource $db An instance of the database object used to create the fixture table
- * @return boolean True on success, false on failure
- */
- public function drop($db) {
- if (empty($this->fields)) {
- return false;
- }
- $this->Schema->build(array($this->table => $this->fields));
- try {
- $db->execute($db->dropSchema($this->Schema), array('log' => false));
- $this->created = array_diff($this->created, array($db->configKeyName));
- } catch (Exception $e) {
- return false;
- }
- return true;
- }
- /**
- * Run before each tests is executed, should return a set of SQL statements to insert records for the table
- * of this fixture could be executed successfully.
- *
- * @param DboSource $db An instance of the database into which the records will be inserted
- * @return boolean on success or if there are no records to insert, or false on failure
- */
- public function insert($db) {
- if (!isset($this->_insert)) {
- $values = array();
- if (isset($this->records) && !empty($this->records)) {
- $fields = array();
- foreach ($this->records as $record) {
- $fields = array_merge($fields, array_keys(array_intersect_key($record, $this->fields)));
- }
- $fields = array_unique($fields);
- $default = array_fill_keys($fields, null);
- foreach ($this->records as $record) {
- $fields = array_keys($record);
- $values[] = array_values(array_merge($default, $record));
- }
- $nested = $db->useNestedTransactions;
- $db->useNestedTransactions = false;
- $result = $db->insertMulti($this->table, $fields, $values);
- if ($this->primaryKey && in_array($this->fields[$this->primaryKey]['type'], array('integer', 'biginteger'))) {
- $db->resetSequence($this->table, $this->primaryKey);
- }
- $db->useNestedTransactions = $nested;
- return $result;
- }
- return true;
- }
- }
- /**
- * Truncates the current fixture. Can be overwritten by classes extending
- * CakeFixture to trigger other events before / after truncate.
- *
- * @param DboSource $db A reference to a db instance
- * @return boolean
- */
- public function truncate($db) {
- $fullDebug = $db->fullDebug;
- $db->fullDebug = false;
- $return = $db->truncate($this->table);
- $db->fullDebug = $fullDebug;
- return $return;
- }
- }
|