/cake/tests/cases/console/libs/schema.test.php
PHP | 353 lines | 202 code | 39 blank | 112 comment | 3 complexity | 75d03693816b1dea463e78b11e2e44e9 MD5 | raw file
- <?php
- /**
- * SchemaShellTest Test file
- *
- * PHP versions 4 and 5
- *
- * CakePHP : Rapid Development Framework (http://www.cakephp.org)
- * Copyright 2006-2010, Cake Software Foundation, Inc.
- *
- * Licensed under The MIT License
- * Redistributions of files must retain the above copyright notice.
- *
- * @filesource
- * @copyright Copyright 2006-2010, Cake Software Foundation, Inc.
- * @link http://www.cakefoundation.org/projects/info/cakephp CakePHP Project
- * @package cake
- * @subpackage cake.tests.cases.console.libs.Shells
- * @since CakePHP v 1.3
- * @license http://www.opensource.org/licenses/mit-license.php The MIT License
- */
- App::import('Shell', 'Shell', false);
- App::import('Model', 'Schema', false);
- if (!defined('DISABLE_AUTO_DISPATCH')) {
- define('DISABLE_AUTO_DISPATCH', true);
- }
- if (!class_exists('ShellDispatcher')) {
- ob_start();
- $argv = false;
- require CAKE . 'console' . DS . 'cake.php';
- ob_end_clean();
- }
- if (!class_exists('SchemaShell')) {
- require CAKE . 'console' . DS . 'libs' . DS . 'schema.php';
- }
- Mock::generatePartial(
- 'ShellDispatcher', 'TestSchemaShellMockShellDispatcher',
- array('getInput', 'stdout', 'stderr', '_stop', '_initEnvironment')
- );
- Mock::generatePartial(
- 'SchemaShell', 'MockSchemaShell',
- array('in', 'out', 'hr', 'createFile', 'error', 'err', '_stop')
- );
- Mock::generate('CakeSchema', 'MockSchemaCakeSchema');
- /**
- * Test for Schema database management
- *
- * @package cake
- * @subpackage cake.tests.cases.libs
- */
- class SchemaShellTestSchema extends CakeSchema {
- /**
- * name property
- *
- * @var string 'MyApp'
- * @access public
- */
- var $name = 'SchemaShellTest';
- /**
- * connection property
- *
- * @var string 'test_suite'
- * @access public
- */
- var $connection = 'test_suite';
- /**
- * comments property
- *
- * @var array
- * @access public
- */
- var $comments = array(
- 'id' => array('type' => 'integer', 'null' => false, 'default' => 0, 'key' => 'primary'),
- 'post_id' => array('type' => 'integer', 'null' => false, 'default' => 0),
- 'user_id' => array('type' => 'integer', 'null' => false),
- 'title' => array('type' => 'string', 'null' => false, 'length' => 100),
- 'comment' => array('type' => 'text', 'null' => false, 'default' => null),
- 'published' => array('type' => 'string', 'null' => true, 'default' => 'N', 'length' => 1),
- 'created' => array('type' => 'datetime', 'null' => true, 'default' => null),
- 'updated' => array('type' => 'datetime', 'null' => true, 'default' => null),
- 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => true)),
- );
- /**
- * posts property
- *
- * @var array
- * @access public
- */
- var $articles = array(
- 'id' => array('type' => 'integer', 'null' => false, 'default' => 0, 'key' => 'primary'),
- 'user_id' => array('type' => 'integer', 'null' => true, 'default' => ''),
- 'title' => array('type' => 'string', 'null' => false, 'default' => 'Title'),
- 'body' => array('type' => 'text', 'null' => true, 'default' => null),
- 'summary' => array('type' => 'text', 'null' => true),
- 'published' => array('type' => 'string', 'null' => true, 'default' => 'Y', 'length' => 1),
- 'created' => array('type' => 'datetime', 'null' => true, 'default' => null),
- 'updated' => array('type' => 'datetime', 'null' => true, 'default' => null),
- 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => true)),
- );
- }
- /**
- * SchemaShellTest class
- *
- * @package cake
- * @subpackage cake.tests.cases.console.libs.Shells
- */
- class SchemaShellTest extends CakeTestCase {
- var $fixtures = array('core.article', 'core.user');
- /**
- * startTest method
- *
- * @return void
- * @access public
- */
- function startTest() {
- $this->Dispatcher =& new TestSchemaShellMockShellDispatcher();
- $this->Shell =& new MockSchemaShell($this->Dispatcher);
- $this->Shell->Dispatch =& $this->Dispatcher;
- }
- /**
- * endTest method
- *
- * @return void
- * @access public
- */
- function endTest() {
- ClassRegistry::flush();
- }
- /**
- * test startup method
- *
- * @return void
- **/
- function testStartup() {
- $this->Shell->startup();
- $this->assertTrue(isset($this->Shell->Schema));
- $this->assertTrue(is_a($this->Shell->Schema, 'CakeSchema'));
- $this->assertEqual(strtolower($this->Shell->Schema->name), APP_DIR);
- $this->assertEqual($this->Shell->Schema->file, 'schema.php');
- unset($this->Shell->Schema);
- $this->Shell->params = array(
- 'name' => 'TestSchema'
- );
- $this->Shell->startup();
- $this->assertEqual($this->Shell->Schema->name, 'TestSchema');
- $this->assertEqual($this->Shell->Schema->file, 'test_schema.php');
- $this->assertEqual($this->Shell->Schema->connection, 'default');
- $this->assertEqual($this->Shell->Schema->path, APP . 'config' . DS . 'sql');
- unset($this->Shell->Schema);
- $this->Shell->params = array(
- 'file' => 'other_file.php',
- 'connection' => 'test_suite',
- 'path' => '/test/path'
- );
- $this->Shell->startup();
- $this->assertEqual(strtolower($this->Shell->Schema->name), APP_DIR);
- $this->assertEqual($this->Shell->Schema->file, 'other_file.php');
- $this->assertEqual($this->Shell->Schema->connection, 'test_suite');
- $this->assertEqual($this->Shell->Schema->path, '/test/path');
- }
- /**
- * Test View - and that it dumps the schema file to stdout
- *
- * @return void
- **/
- function testView() {
- $this->Shell->startup();
- $this->Shell->Schema->path = APP . 'config' . DS . 'schema';
- $this->Shell->params['file'] = 'i18n.php';
- $this->Shell->expectOnce('_stop');
- $this->Shell->view();
- }
- /**
- * test dump() with sql file generation
- *
- * @return void
- **/
- function testDumpWithFileWriting() {
- $file =& new File(APP . 'config' . DS . 'sql' . DS . 'i18n.php');
- $contents = $file->read();
- $file =& new File(TMP . 'tests' . DS . 'i18n.php');
- $file->write($contents);
- $this->Shell->params = array('name' => 'i18n');
- $this->Shell->args = array('write');
- $this->Shell->startup();
- $this->Shell->Schema->path = TMP . 'tests';
- $this->Shell->dump();
- $sql =& new File(TMP . 'tests' . DS . 'i18n.sql');
- $contents = $sql->read();
- $this->assertPattern('/DROP TABLE/', $contents);
- $this->assertPattern('/CREATE TABLE `i18n`/', $contents);
- $this->assertPattern('/id/', $contents);
- $this->assertPattern('/model/', $contents);
- $this->assertPattern('/field/', $contents);
- $this->assertPattern('/locale/', $contents);
- $this->assertPattern('/foreign_key/', $contents);
- $this->assertPattern('/content/', $contents);
- $sql->delete();
- $file->delete();
- }
- /**
- * test generate with snapshot generation
- *
- * @return void
- */
- function testGenerateSnaphot() {
- $this->Shell->path = TMP;
- $this->Shell->params['file'] = 'schema.php';
- $this->Shell->args = array('snapshot');
- $this->Shell->Schema =& new MockSchemaCakeSchema();
- $this->Shell->Schema->setReturnValue('read', array('schema data'));
- $this->Shell->Schema->setReturnValue('write', true);
- $this->Shell->Schema->expectOnce('read');
- $this->Shell->Schema->expectOnce('write', array(array('schema data', 'file' => 'schema_1.php')));
- $this->Shell->generate();
- }
- /**
- * test generate without a snapshot.
- *
- * @return void
- **/
- function testGenerateNoOverwrite() {
- touch(TMP . 'schema.php');
- $this->Shell->params['file'] = 'schema.php';
- $this->Shell->args = array();
- $this->Shell->setReturnValue('in', 'q');
- $this->Shell->Schema =& new MockSchemaCakeSchema();
- $this->Shell->Schema->path = TMP;
- $this->Shell->Schema->expectNever('read');
- $result = $this->Shell->generate();
- unlink(TMP . 'schema.php');
- }
- /**
- * test generate with overwriting of the schema files.
- *
- * @return void
- **/
- function testGenerateOverwrite() {
- touch(TMP . 'schema.php');
- $this->Shell->params['file'] = 'schema.php';
- $this->Shell->args = array();
- $this->Shell->setReturnValue('in', 'o');
- $this->Shell->expectAt(1, 'out', array(new PatternExpectation('/Schema file:\s[a-z\.]+\sgenerated/')));
- $this->Shell->Schema =& new MockSchemaCakeSchema();
- $this->Shell->Schema->path = TMP;
- $this->Shell->Schema->setReturnValue('read', array('schema data'));
- $this->Shell->Schema->setReturnValue('write', true);
- $this->Shell->Schema->expectOnce('read');
- $this->Shell->Schema->expectOnce('write', array(array('schema data', 'file' => 'schema.php')));
- $this->Shell->generate();
- unlink(TMP . 'schema.php');
- }
- /**
- * Test schema run create with no table args.
- *
- * @return void
- **/
- function testRunCreateNoArgs() {
- $this->Shell->params = array(
- 'connection' => 'test_suite',
- 'name' => 'i18n',
- 'path' => APP . 'config' . DS . 'sql'
- );
- $this->Shell->args = array('create');
- $this->Shell->startup();
- $this->Shell->setReturnValue('in', 'y');
- $this->Shell->run();
- $db =& ConnectionManager::getDataSource('test_suite');
- $sources = $db->listSources();
- $this->assertTrue(in_array($db->config['prefix'] . 'i18n', $sources));
- }
- /**
- * Test schema run create with no table args.
- *
- * @return void
- **/
- function testRunCreateWithTableArgs() {
- $this->Shell->params = array(
- 'connection' => 'test_suite',
- 'name' => 'DbAcl',
- 'path' => APP . 'config' . DS . 'sql'
- );
- $this->Shell->args = array('create', 'acos');
- $this->Shell->startup();
- $this->Shell->setReturnValue('in', 'y');
- $this->Shell->run();
- $db =& ConnectionManager::getDataSource('test_suite');
- $sources = $db->listSources();
- $this->assertTrue(in_array($db->config['prefix'] . 'acos', $sources));
- $this->assertFalse(in_array($db->config['prefix'] . 'aros', $sources));
- $this->assertFalse(in_array('aros_acos', $sources));
- }
- /**
- * test run update with a table arg.
- *
- * @return void
- **/
- function testRunUpdateWithTable() {
- $this->Shell->params = array(
- 'name' => 'SchemaShellTest',
- 'connection' => 'test_suite',
- 'f' => true
- );
- $this->Shell->args = array('update', 'articles');
- $this->Shell->startup();
- $this->Shell->setReturnValue('in', 'y');
- $this->Shell->run();
- $article =& new Model(array('name' => 'Article', 'ds' => 'test_suite'));
- $fields = $article->schema();
- $this->assertTrue(isset($fields['summary']));
- $this->_fixtures['core.article']->drop($this->db);
- $this->_fixtures['core.article']->create($this->db);
- }
- }
- ?>