public function testValidateReturnsTrueWhenTableHasNoPkButIsAView()
{
$table = new Table('foo');
$table->setSkipSql(true);
$appData = $this->getAppDataForTable($table);
$validator = new SchemaValidator($appData);
$this->assertTrue($validator->validate());
}
public function testSetSkipSql()
{
$table = new Table('books');
$table->setSkipSql(true);
$this->assertTrue($table->isSkipSql());
}
public function testCompareRemovedTableSkipSql()
{
$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');
$t2->setSkipSql(true);
$d1->addTable($t2);
$d2 = new Database();
$t3 = new Table('Foo_Table');
$c3 = new Column('Foo');
$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);
$dc = new DatabaseComparator();
$dc->setFromDatabase($d1);
$dc->setToDatabase($d2);
$nbDiffs = $dc->compareTables();
$databaseDiff = $dc->getDatabaseDiff();
$this->assertEquals(0, $nbDiffs);
}
