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());
}
