public function testCompareSeveralTableDifferences()
{
$d1 = new Database();
$t1 = new Table('Foo_Table');
$c1 = new Column('Foo');
$c1->getDomain()->copy($this->platform->getDomainForType('DOUBLE'));
$c1->getDomain()->replaceScale(2);
$c1->getDomain()->replaceSize(3);
$c1->setNotNull(true);
$c1->getDomain()->setDefaultValue(new ColumnDefaultValue(123, ColumnDefaultValue::TYPE_VALUE));
$t1->addColumn($c1);
$d1->addTable($t1);
$t2 = new Table('Bar');
$c2 = new Column('Bar_Column');
$c2->getDomain()->copy($this->platform->getDomainForType('DOUBLE'));
$t2->addColumn($c2);
$d1->addTable($t2);
$t11 = new Table('Baz');
$d1->addTable($t11);
$d2 = new Database();
$t3 = new Table('Foo_Table');
$c3 = new Column('Foo1');
$c3->getDomain()->copy($this->platform->getDomainForType('DOUBLE'));
$c3->getDomain()->replaceScale(2);
$c3->getDomain()->replaceSize(3);
$c3->setNotNull(true);
$c3->getDomain()->setDefaultValue(new ColumnDefaultValue(123, ColumnDefaultValue::TYPE_VALUE));
$t3->addColumn($c3);
$d2->addTable($t3);
$t4 = new Table('Bar2');
$c4 = new Column('Bar_Column');
$c4->getDomain()->copy($this->platform->getDomainForType('DOUBLE'));
$t4->addColumn($c4);
$d2->addTable($t4);
$t5 = new Table('Biz');
$c5 = new Column('Biz_Column');
$c5->getDomain()->copy($this->platform->getDomainForType('INTEGER'));
$t5->addColumn($c5);
$d2->addTable($t5);
// Foo_Table was modified, Bar was renamed, Baz was removed, Biz was added
$dc = new DatabaseComparator();
$dc->setFromDatabase($d1);
$dc->setToDatabase($d2);
$nbDiffs = $dc->compareTables();
$databaseDiff = $dc->getDatabaseDiff();
$this->assertEquals(4, $nbDiffs);
$this->assertEquals(array('Bar' => 'Bar2'), $databaseDiff->getRenamedTables());
$this->assertEquals(array('Biz' => $t5), $databaseDiff->getAddedTables());
$this->assertEquals(array('Baz' => $t11), $databaseDiff->getRemovedTables());
$tableDiff = TableComparator::computeDiff($t1, $t3);
$this->assertEquals(array('Foo_Table' => $tableDiff), $databaseDiff->getModifiedTables());
}
public function testCompareSeveralRenamedSameTables()
{
$d1 = new Database();
$t1 = new Table('table1');
$c1 = new Column('col1');
$c1->getDomain()->copy($this->platform->getDomainForType('INTEGER'));
$t1->addColumn($c1);
$d1->addTable($t1);
$t2 = new Table('table2');
$c2 = new Column('col1');
$c2->getDomain()->copy($this->platform->getDomainForType('INTEGER'));
$t2->addColumn($c2);
$d1->addTable($t2);
$t3 = new Table('table3');
$c3 = new Column('col1');
$c3->getDomain()->copy($this->platform->getDomainForType('INTEGER'));
$t3->addColumn($c3);
$d1->addTable($t3);
$d2 = new Database();
$t4 = new Table('table4');
$c4 = new Column('col1');
$c4->getDomain()->copy($this->platform->getDomainForType('INTEGER'));
$t4->addColumn($c4);
$d2->addTable($t4);
$t5 = new Table('table5');
$c5 = new Column('col1');
$c5->getDomain()->copy($this->platform->getDomainForType('INTEGER'));
$t5->addColumn($c5);
$d2->addTable($t5);
$t6 = new Table('table3');
$c6 = new Column('col1');
$c6->getDomain()->copy($this->platform->getDomainForType('INTEGER'));
$t6->addColumn($c6);
$d2->addTable($t6);
// table1 and table2 were removed and table4, table5 added with same columns (does not always mean its a rename, hence we
// can not guarantee it)
$dc = new DatabaseComparator();
$dc->setFromDatabase($d1);
$dc->setToDatabase($d2);
$nbDiffs = $dc->compareTables();
$databaseDiff = $dc->getDatabaseDiff();
$this->assertEquals(4, $nbDiffs);
$this->assertEquals(0, count($databaseDiff->getRenamedTables()));
$this->assertEquals(array('table4', 'table5'), array_keys($databaseDiff->getAddedTables()));
$this->assertEquals(array('table1', 'table2'), array_keys($databaseDiff->getRemovedTables()));
}
