public function providerForTestGetModifyTableIndicesDDL() { $schema1 = <<<EOF <database name="test" identifierQuoting="true"> <table name="foo"> <column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> <column name="bar" type="INTEGER" /> <column name="baz" type="VARCHAR" size="12" required="true" /> <index name="bar_fk"> <index-column name="bar"/> </index> <index name="bar_baz_fk"> <index-column name="bar"/> <index-column name="baz"/> </index> </table> </database> EOF; $schema2 = <<<EOF <database name="test" identifierQuoting="true"> <table name="foo"> <column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> <column name="bar" type="INTEGER" /> <column name="baz" type="VARCHAR" size="12" required="true" /> <index name="bar_baz_fk"> <index-column name="id"/> <index-column name="bar"/> <index-column name="baz"/> </index> <index name="baz_fk"> <index-column name="baz"/> </index> </table> </database> EOF; $t1 = $this->getDatabaseFromSchema($schema1)->getTable('foo'); $t2 = $this->getDatabaseFromSchema($schema2)->getTable('foo'); $tc = new TableComparator(); $tc->setFromTable($t1); $tc->setToTable($t2); $tc->compareIndices(); return [[$tc->getTableDiff()]]; }
public function testCompareModifiedIndices() { $t1 = new Table(); $c1 = new Column('Foo'); $c1->getDomain()->copy($this->platform->getDomainForType('VARCHAR')); $c1->getDomain()->replaceSize(255); $c1->setNotNull(false); $t1->addColumn($c1); $i1 = new Index('Foo_Index'); $i1->addColumn($c1); $t1->addIndex($i1); $t2 = new Table(); $c2 = new Column('Foo'); $c2->getDomain()->copy($this->platform->getDomainForType('DOUBLE')); $c2->getDomain()->replaceScale(2); $c2->getDomain()->replaceSize(3); $c2->setNotNull(true); $c2->getDomain()->setDefaultValue(new ColumnDefaultValue(123, ColumnDefaultValue::TYPE_VALUE)); $t2->addColumn($c2); $i2 = new Unique('Foo_Index'); $i2->addColumn($c2); $t2->addIndex($i2); $tc = new TableComparator(); $tc->setFromTable($t1); $tc->setToTable($t2); $nbDiffs = $tc->compareIndices(); $tableDiff = $tc->getTableDiff(); $this->assertEquals(1, $nbDiffs); $this->assertEquals(1, count($tableDiff->getModifiedIndices())); $this->assertEquals(array('Foo_Index' => array($i1, $i2)), $tableDiff->getModifiedIndices()); }