/tests/Doctrine/Tests/DBAL/Functional/Schema/SchemaManagerFunctionalTestCase.php
PHP | 486 lines | 477 code | 6 blank | 3 comment | 1 complexity | 4297db41a67fccfc183859432a88743c MD5 | raw file
Possible License(s): LGPL-2.1
- <?php
- namespace Doctrine\Tests\DBAL\Functional\Schema;
- use Doctrine\DBAL\Types\Type,
- Doctrine\DBAL\Schema\AbstractSchemaManager;
- require_once __DIR__ . '/../../../TestInit.php';
- class SchemaManagerFunctionalTestCase extends \Doctrine\Tests\DbalFunctionalTestCase
- {
- /**
- * @var \Doctrine\DBAL\Schema\AbstractSchemaManager
- */
- protected $_sm;
- protected function setUp()
- {
- parent::setUp();
- $class = get_class($this);
- $e = explode('\\', $class);
- $testClass = end($e);
- $dbms = strtolower(str_replace('SchemaManagerTest', null, $testClass));
- if ($this->_conn->getDatabasePlatform()->getName() !== $dbms) {
- $this->markTestSkipped('The ' . $testClass .' requires the use of ' . $dbms);
- }
- $this->_sm = $this->_conn->getSchemaManager();
- }
- public function testListSequences()
- {
- if(!$this->_conn->getDatabasePlatform()->supportsSequences()) {
- $this->markTestSkipped($this->_conn->getDriver()->getName().' does not support sequences.');
- }
- $sequence = new \Doctrine\DBAL\Schema\Sequence('list_sequences_test_seq', 20, 10);
- $this->_sm->createSequence($sequence);
-
- $sequences = $this->_sm->listSequences();
-
- $this->assertInternalType('array', $sequences, 'listSequences() should return an array.');
- $foundSequence = null;
- foreach($sequences AS $sequence) {
- $this->assertInstanceOf('Doctrine\DBAL\Schema\Sequence', $sequence, 'Array elements of listSequences() should be Sequence instances.');
- if(strtolower($sequence->getName()) == 'list_sequences_test_seq') {
- $foundSequence = $sequence;
- }
- }
- $this->assertNotNull($foundSequence, "Sequence with name 'list_sequences_test_seq' was not found.");
- $this->assertEquals(20, $foundSequence->getAllocationSize(), "Allocation Size is expected to be 20.");
- $this->assertEquals(10, $foundSequence->getInitialValue(), "Initial Value is expected to be 10.");
- }
- public function testListDatabases()
- {
- if (!$this->_sm->getDatabasePlatform()->supportsCreateDropDatabase()) {
- $this->markTestSkipped('Cannot drop Database client side with this Driver.');
- }
- $this->_sm->dropAndCreateDatabase('test_create_database');
- $databases = $this->_sm->listDatabases();
- $databases = \array_map('strtolower', $databases);
-
- $this->assertEquals(true, \in_array('test_create_database', $databases));
- }
- public function testListTables()
- {
- $this->createTestTable('list_tables_test');
- $tables = $this->_sm->listTables();
- $this->assertInternalType('array', $tables);
- $this->assertTrue(count($tables) > 0, "List Tables has to find at least one table named 'list_tables_test'.");
- $foundTable = false;
- foreach ($tables AS $table) {
- $this->assertInstanceOf('Doctrine\DBAL\Schema\Table', $table);
- if (strtolower($table->getName()) == 'list_tables_test') {
- $foundTable = true;
- $this->assertTrue($table->hasColumn('id'));
- $this->assertTrue($table->hasColumn('test'));
- $this->assertTrue($table->hasColumn('foreign_key_test'));
- }
- }
- $this->assertTrue( $foundTable , "The 'list_tables_test' table has to be found.");
- }
- public function createListTableColumns()
- {
- $table = new \Doctrine\DBAL\Schema\Table('list_table_columns');
- $table->addColumn('id', 'integer', array('notnull' => true));
- $table->addColumn('test', 'string', array('length' => 255, 'notnull' => false));
- $table->addColumn('foo', 'text', array('notnull' => true));
- $table->addColumn('bar', 'decimal', array('precision' => 10, 'scale' => 4, 'notnull' => false));
- $table->addColumn('baz1', 'datetime');
- $table->addColumn('baz2', 'time');
- $table->addColumn('baz3', 'date');
- return $table;
- }
- public function testListTableColumns()
- {
- $table = $this->createListTableColumns();
- $this->_sm->dropAndCreateTable($table);
- $columns = $this->_sm->listTableColumns('list_table_columns');
- $this->assertArrayHasKey('id', $columns);
- $this->assertEquals('id', strtolower($columns['id']->getname()));
- $this->assertInstanceOf('Doctrine\DBAL\Types\IntegerType', $columns['id']->gettype());
- $this->assertEquals(false, $columns['id']->getunsigned());
- $this->assertEquals(true, $columns['id']->getnotnull());
- $this->assertEquals(null, $columns['id']->getdefault());
- $this->assertInternalType('array', $columns['id']->getPlatformOptions());
- $this->assertArrayHasKey('test', $columns);
- $this->assertEquals('test', strtolower($columns['test']->getname()));
- $this->assertInstanceOf('Doctrine\DBAL\Types\StringType', $columns['test']->gettype());
- $this->assertEquals(255, $columns['test']->getlength());
- $this->assertEquals(false, $columns['test']->getfixed());
- $this->assertEquals(false, $columns['test']->getnotnull());
- $this->assertEquals(null, $columns['test']->getdefault());
- $this->assertInternalType('array', $columns['test']->getPlatformOptions());
- $this->assertEquals('foo', strtolower($columns['foo']->getname()));
- $this->assertInstanceOf('Doctrine\DBAL\Types\TextType', $columns['foo']->gettype());
- $this->assertEquals(false, $columns['foo']->getunsigned());
- $this->assertEquals(false, $columns['foo']->getfixed());
- $this->assertEquals(true, $columns['foo']->getnotnull());
- $this->assertEquals(null, $columns['foo']->getdefault());
- $this->assertInternalType('array', $columns['foo']->getPlatformOptions());
- $this->assertEquals('bar', strtolower($columns['bar']->getname()));
- $this->assertInstanceOf('Doctrine\DBAL\Types\DecimalType', $columns['bar']->gettype());
- $this->assertEquals(null, $columns['bar']->getlength());
- $this->assertEquals(10, $columns['bar']->getprecision());
- $this->assertEquals(4, $columns['bar']->getscale());
- $this->assertEquals(false, $columns['bar']->getunsigned());
- $this->assertEquals(false, $columns['bar']->getfixed());
- $this->assertEquals(false, $columns['bar']->getnotnull());
- $this->assertEquals(null, $columns['bar']->getdefault());
- $this->assertInternalType('array', $columns['bar']->getPlatformOptions());
- $this->assertEquals('baz1', strtolower($columns['baz1']->getname()));
- $this->assertInstanceOf('Doctrine\DBAL\Types\DateTimeType', $columns['baz1']->gettype());
- $this->assertEquals(true, $columns['baz1']->getnotnull());
- $this->assertEquals(null, $columns['baz1']->getdefault());
- $this->assertInternalType('array', $columns['baz1']->getPlatformOptions());
- $this->assertEquals('baz2', strtolower($columns['baz2']->getname()));
- $this->assertContains($columns['baz2']->gettype()->getName(), array('time', 'date', 'datetime'));
- $this->assertEquals(true, $columns['baz2']->getnotnull());
- $this->assertEquals(null, $columns['baz2']->getdefault());
- $this->assertInternalType('array', $columns['baz2']->getPlatformOptions());
-
- $this->assertEquals('baz3', strtolower($columns['baz3']->getname()));
- $this->assertContains($columns['baz2']->gettype()->getName(), array('time', 'date', 'datetime'));
- $this->assertEquals(true, $columns['baz3']->getnotnull());
- $this->assertEquals(null, $columns['baz3']->getdefault());
- $this->assertInternalType('array', $columns['baz3']->getPlatformOptions());
- }
- public function testDiffListTableColumns()
- {
- if ($this->_sm->getDatabasePlatform()->getName() == 'oracle') {
- $this->markTestSkipped('Does not work with Oracle, since it cannot detect DateTime, Date and Time differenecs (at the moment).');
- }
- $offlineTable = $this->createListTableColumns();
- $onlineTable = $this->_sm->listTableDetails('list_table_columns');
- $comparator = new \Doctrine\DBAL\Schema\Comparator();
- $diff = $comparator->diffTable($offlineTable, $onlineTable);
- $this->assertFalse($diff, "No differences should be detected with the offline vs online schema.");
- }
- public function testListTableIndexes()
- {
- $table = $this->getTestTable('list_table_indexes_test');
- $table->addUniqueIndex(array('test'), 'test_index_name');
- $table->addIndex(array('id', 'test'), 'test_composite_idx');
- $this->_sm->createTable($table);
- $tableIndexes = $this->_sm->listTableIndexes('list_table_indexes_test');
- $this->assertEquals(3, count($tableIndexes));
- $this->assertArrayHasKey('primary', $tableIndexes, 'listTableIndexes() has to return a "primary" array key.');
- $this->assertEquals(array('id'), array_map('strtolower', $tableIndexes['primary']->getColumns()));
- $this->assertTrue($tableIndexes['primary']->isUnique());
- $this->assertTrue($tableIndexes['primary']->isPrimary());
- $this->assertEquals('test_index_name', $tableIndexes['test_index_name']->getName());
- $this->assertEquals(array('test'), array_map('strtolower', $tableIndexes['test_index_name']->getColumns()));
- $this->assertTrue($tableIndexes['test_index_name']->isUnique());
- $this->assertFalse($tableIndexes['test_index_name']->isPrimary());
- $this->assertEquals('test_composite_idx', $tableIndexes['test_composite_idx']->getName());
- $this->assertEquals(array('id', 'test'), array_map('strtolower', $tableIndexes['test_composite_idx']->getColumns()));
- $this->assertFalse($tableIndexes['test_composite_idx']->isUnique());
- $this->assertFalse($tableIndexes['test_composite_idx']->isPrimary());
- }
- public function testDropAndCreateIndex()
- {
- $table = $this->getTestTable('test_create_index');
- $table->addUniqueIndex(array('test'), 'test');
- $this->_sm->dropAndCreateTable($table);
- $this->_sm->dropAndCreateIndex($table->getIndex('test'), $table);
- $tableIndexes = $this->_sm->listTableIndexes('test_create_index');
- $this->assertInternalType('array', $tableIndexes);
- $this->assertEquals('test', strtolower($tableIndexes['test']->getName()));
- $this->assertEquals(array('test'), array_map('strtolower', $tableIndexes['test']->getColumns()));
- $this->assertTrue($tableIndexes['test']->isUnique());
- $this->assertFalse($tableIndexes['test']->isPrimary());
- }
- public function testCreateTableWithForeignKeys()
- {
- if(!$this->_sm->getDatabasePlatform()->supportsForeignKeyConstraints()) {
- $this->markTestSkipped('Platform does not support foreign keys.');
- }
- $tableB = $this->getTestTable('test_foreign');
- $this->_sm->dropAndCreateTable($tableB);
- $tableA = $this->getTestTable('test_create_fk');
- $tableA->addForeignKeyConstraint('test_foreign', array('foreign_key_test'), array('id'));
- $this->_sm->dropAndCreateTable($tableA);
- $fkTable = $this->_sm->listTableDetails('test_create_fk');
- $fkConstraints = $fkTable->getForeignKeys();
- $this->assertEquals(1, count($fkConstraints), "Table 'test_create_fk1' has to have one foreign key.");
- $fkConstraint = current($fkConstraints);
- $this->assertType('\Doctrine\DBAL\Schema\ForeignKeyConstraint', $fkConstraint);
- $this->assertEquals('test_foreign', strtolower($fkConstraint->getForeignTableName()));
- $this->assertEquals(array('foreign_key_test'), array_map('strtolower', $fkConstraint->getColumns()));
- $this->assertEquals(array('id'), array_map('strtolower', $fkConstraint->getForeignColumns()));
- $this->assertTrue($fkTable->columnsAreIndexed($fkConstraint->getColumns()), "The columns of a foreign key constraint should always be indexed.");
- }
- public function testListForeignKeys()
- {
- if(!$this->_conn->getDatabasePlatform()->supportsForeignKeyConstraints()) {
- $this->markTestSkipped('Does not support foreign key constraints.');
- }
- $this->createTestTable('test_create_fk1');
- $this->createTestTable('test_create_fk2');
- $foreignKey = new \Doctrine\DBAL\Schema\ForeignKeyConstraint(
- array('foreign_key_test'), 'test_create_fk2', array('id'), 'foreign_key_test_fk', array('onDelete' => 'CASCADE')
- );
- $this->_sm->createForeignKey($foreignKey, 'test_create_fk1');
- $fkeys = $this->_sm->listTableForeignKeys('test_create_fk1');
- $this->assertEquals(1, count($fkeys), "Table 'test_create_fk1' has to have one foreign key.");
-
- $this->assertInstanceOf('Doctrine\DBAL\Schema\ForeignKeyConstraint', $fkeys[0]);
- $this->assertEquals(array('foreign_key_test'), array_map('strtolower', $fkeys[0]->getLocalColumns()));
- $this->assertEquals(array('id'), array_map('strtolower', $fkeys[0]->getForeignColumns()));
- $this->assertEquals('test_create_fk2', strtolower($fkeys[0]->getForeignTableName()));
- if($fkeys[0]->hasOption('onDelete')) {
- $this->assertEquals('CASCADE', $fkeys[0]->getOption('onDelete'));
- }
- }
- protected function getCreateExampleViewSql()
- {
- $this->markTestSkipped('No Create Example View SQL was defined for this SchemaManager');
- }
- public function testCreateSchema()
- {
- $this->createTestTable('test_table');
- $schema = $this->_sm->createSchema();
- $this->assertTrue($schema->hasTable('test_table'));
- }
- public function testAlterTableScenario()
- {
- if(!$this->_sm->getDatabasePlatform()->supportsAlterTable()) {
- $this->markTestSkipped('Alter Table is not supported by this platform.');
- }
- $this->createTestTable('alter_table');
- $this->createTestTable('alter_table_foreign');
- $table = $this->_sm->listTableDetails('alter_table');
- $this->assertTrue($table->hasColumn('id'));
- $this->assertTrue($table->hasColumn('test'));
- $this->assertTrue($table->hasColumn('foreign_key_test'));
- $this->assertEquals(0, count($table->getForeignKeys()));
- $this->assertEquals(1, count($table->getIndexes()));
- $tableDiff = new \Doctrine\DBAL\Schema\TableDiff("alter_table");
- $tableDiff->addedColumns['foo'] = new \Doctrine\DBAL\Schema\Column('foo', Type::getType('integer'));
- $tableDiff->removedColumns['test'] = $table->getColumn('test');
- $this->_sm->alterTable($tableDiff);
- $table = $this->_sm->listTableDetails('alter_table');
- $this->assertFalse($table->hasColumn('test'));
- $this->assertTrue($table->hasColumn('foo'));
- $tableDiff = new \Doctrine\DBAL\Schema\TableDiff("alter_table");
- $tableDiff->addedIndexes[] = new \Doctrine\DBAL\Schema\Index('foo_idx', array('foo'));
- $this->_sm->alterTable($tableDiff);
- $table = $this->_sm->listTableDetails('alter_table');
- $this->assertEquals(2, count($table->getIndexes()));
- $this->assertTrue($table->hasIndex('foo_idx'));
- $this->assertEquals(array('foo'), array_map('strtolower', $table->getIndex('foo_idx')->getColumns()));
- $this->assertFalse($table->getIndex('foo_idx')->isPrimary());
- $this->assertFalse($table->getIndex('foo_idx')->isUnique());
- $tableDiff = new \Doctrine\DBAL\Schema\TableDiff("alter_table");
- $tableDiff->changedIndexes[] = new \Doctrine\DBAL\Schema\Index('foo_idx', array('foo', 'foreign_key_test'));
- $this->_sm->alterTable($tableDiff);
- $table = $this->_sm->listTableDetails('alter_table');
- $this->assertEquals(2, count($table->getIndexes()));
- $this->assertTrue($table->hasIndex('foo_idx'));
- $this->assertEquals(array('foo', 'foreign_key_test'), array_map('strtolower', $table->getIndex('foo_idx')->getColumns()));
- $tableDiff = new \Doctrine\DBAL\Schema\TableDiff("alter_table");
- $tableDiff->removedIndexes[] = new \Doctrine\DBAL\Schema\Index('foo_idx', array('foo', 'foreign_key_test'));
- $fk = new \Doctrine\DBAL\Schema\ForeignKeyConstraint(array('foreign_key_test'), 'alter_table_foreign', array('id'));
- $tableDiff->addedForeignKeys[] = $fk;
- $this->_sm->alterTable($tableDiff);
- $table = $this->_sm->listTableDetails('alter_table');
- // dont check for index size here, some platforms automatically add indexes for foreign keys.
- $this->assertFalse($table->hasIndex('foo_idx'));
- $this->assertEquals(1, count($table->getForeignKeys()));
- $fks = $table->getForeignKeys();
- $foreignKey = current($fks);
- $this->assertEquals('alter_table_foreign', strtolower($foreignKey->getForeignTableName()));
- $this->assertEquals(array('foreign_key_test'), array_map('strtolower', $foreignKey->getColumns()));
- $this->assertEquals(array('id'), array_map('strtolower', $foreignKey->getForeignColumns()));
- }
- public function testCreateAndListViews()
- {
- $this->createTestTable('view_test_table');
- $name = "doctrine_test_view";
- $sql = "SELECT * FROM view_test_table";
- $view = new \Doctrine\DBAL\Schema\View($name, $sql);
- $this->_sm->dropAndCreateView($view);
- $views = $this->_sm->listViews();
- }
- public function testAutoincrementDetection()
- {
- if (!$this->_sm->getDatabasePlatform()->supportsIdentityColumns()) {
- $this->markTestSkipped('This test is only supported on platforms that have autoincrement');
- }
- $table = new \Doctrine\DBAL\Schema\Table('test_autoincrement');
- $table->setSchemaConfig($this->_sm->createSchemaConfig());
- $table->addColumn('id', 'integer', array('autoincrement' => true));
- $table->setPrimaryKey(array('id'));
- $this->_sm->createTable($table);
- $inferredTable = $this->_sm->listTableDetails('test_autoincrement');
- $this->assertTrue($inferredTable->hasColumn('id'));
- $this->assertTrue($inferredTable->getColumn('id')->getAutoincrement());
- }
- /**
- * @group DBAL-42
- */
- public function testGetColumnComment()
- {
- if (!$this->_conn->getDatabasePlatform()->supportsInlineColumnComments() && !$this->_conn->getDatabasePlatform()->supportsCommentOnStatement()) {
- $this->markTestSkipped('Database does not support column comments.');
- }
- $table = new \Doctrine\DBAL\Schema\Table('column_comment_test');
- $table->addColumn('id', 'integer', array('comment' => 'This is a comment'));
- $table->setPrimaryKey(array('id'));
- $this->_sm->createTable($table);
- $columns = $this->_sm->listTableColumns("column_comment_test");
- $this->assertEquals(1, count($columns));
- $this->assertEquals('This is a comment', $columns['id']->getComment());
- }
- /**
- * @group DBAL-42
- */
- public function testAutomaticallyAppendCommentOnMarkedColumns()
- {
- if (!$this->_conn->getDatabasePlatform()->supportsInlineColumnComments() && !$this->_conn->getDatabasePlatform()->supportsCommentOnStatement()) {
- $this->markTestSkipped('Database does not support column comments.');
- }
- $table = new \Doctrine\DBAL\Schema\Table('column_comment_test2');
- $table->addColumn('id', 'integer', array('comment' => 'This is a comment'));
- $table->addColumn('obj', 'object', array('comment' => 'This is a comment'));
- $table->addColumn('arr', 'array', array('comment' => 'This is a comment'));
- $table->setPrimaryKey(array('id'));
- $this->_sm->createTable($table);
- $columns = $this->_sm->listTableColumns("column_comment_test2");
- $this->assertEquals(3, count($columns));
- $this->assertEquals('This is a comment', $columns['id']->getComment());
- $this->assertEquals('This is a comment', $columns['obj']->getComment(), "The Doctrine2 Typehint should be stripped from comment.");
- $this->assertInstanceOf('Doctrine\DBAL\Types\ObjectType', $columns['obj']->getType(), "The Doctrine2 should be detected from comment hint.");
- $this->assertEquals('This is a comment', $columns['arr']->getComment(), "The Doctrine2 Typehint should be stripped from comment.");
- $this->assertInstanceOf('Doctrine\DBAL\Types\ArrayType', $columns['arr']->getType(), "The Doctrine2 should be detected from comment hint.");
- }
- /**
- * @param string $name
- * @param array $data
- */
- protected function createTestTable($name = 'test_table', $data = array())
- {
- $options = array();
- if (isset($data['options'])) {
- $options = $data['options'];
- }
- $table = $this->getTestTable($name, $options);
- $this->_sm->dropAndCreateTable($table);
- }
- protected function getTestTable($name, $options=array())
- {
- $table = new \Doctrine\DBAL\Schema\Table($name, array(), array(), array(), false, $options);
- $table->setSchemaConfig($this->_sm->createSchemaConfig());
- $table->addColumn('id', 'integer', array('notnull' => true));
- $table->setPrimaryKey(array('id'));
- $table->addColumn('test', 'string', array('length' => 255));
- $table->addColumn('foreign_key_test', 'integer');
- return $table;
- }
- protected function assertHasTable($tables, $tableName)
- {
- $foundTable = false;
- foreach ($tables AS $table) {
- $this->assertInstanceOf('Doctrine\DBAL\Schema\Table', $table, 'No Table instance was found in tables array.');
- if (strtolower($table->getName()) == 'list_tables_test_new_name') {
- $foundTable = true;
- }
- }
- $this->assertTrue($foundTable, "Could not find new table");
- }
- }