public function testCompareForeignKey_RestrictNoAction_AreTheSame()
{
$fk1 = new ForeignKeyConstraint(array("foo"), "bar", array("baz"), "fk1", array('onDelete' => 'NO ACTION'));
$fk2 = new ForeignKeyConstraint(array("foo"), "bar", array("baz"), "fk1", array('onDelete' => 'RESTRICT'));
$c = new Comparator();
$this->assertFalse($c->diffForeignKey($fk1, $fk2));
}
/**
* @group DBAL-492
*/
public function testCompareForeignKeyNamesUnqualified_AsNoSchemaInformationIsAvailable()
{
$fk1 = new ForeignKeyConstraint(array("foo"), "foo.bar", array("baz"), "fk1");
$fk2 = new ForeignKeyConstraint(array("foo"), "baz.bar", array("baz"), "fk1");
$c = new Comparator();
$this->assertFalse($c->diffForeignKey($fk1, $fk2));
}
/**
* @group DBAL-617
*/
public function testCompareQuotedAndUnquotedForeignKeyColumns()
{
$fk1 = new ForeignKeyConstraint(array("foo"), "bar", array("baz"), "fk1", array('onDelete' => 'NO ACTION'));
$fk2 = new ForeignKeyConstraint(array("`foo`"), "bar", array("`baz`"), "fk1", array('onDelete' => 'NO ACTION'));
$comparator = new Comparator();
$diff = $comparator->diffForeignKey($fk1, $fk2);
$this->assertFalse($diff);
}
