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