phpmyadmin /
error-reporting-server
| @@ 533-550 (lines=18) @@ | ||
| 530 | $this->assertTrue($this->adapter->hasForeignKey($table->getName(), array('ref_table_id'))); |
|
| 531 | } |
|
| 532 | ||
| 533 | public function dropForeignKey() |
|
| 534 | { |
|
| 535 | $refTable = new \Phinx\Db\Table('ref_table', array(), $this->adapter); |
|
| 536 | $refTable->addColumn('field1', 'string')->save(); |
|
| 537 | ||
| 538 | $table = new \Phinx\Db\Table('table', array(), $this->adapter); |
|
| 539 | $table->addColumn('ref_table_id', 'integer')->save(); |
|
| 540 | ||
| 541 | $fk = new \Phinx\Db\Table\ForeignKey(); |
|
| 542 | $fk->setReferencedTable($refTable) |
|
| 543 | ->setColumns(array('ref_table_id')) |
|
| 544 | ->setReferencedColumns(array('id')); |
|
| 545 | ||
| 546 | $this->adapter->addForeignKey($table, $fk); |
|
| 547 | $this->assertTrue($this->adapter->hasForeignKey($table->getName(), array('ref_table_id'))); |
|
| 548 | $this->adapter->dropForeignKey($table->getName(), array('ref_table_id')); |
|
| 549 | $this->assertFalse($this->adapter->hasForeignKey($table->getName(), array('ref_table_id'))); |
|
| 550 | } |
|
| 551 | ||
| 552 | public function testHasDatabase() |
|
| 553 | { |
|
| @@ 582-599 (lines=18) @@ | ||
| 579 | $this->assertTrue($this->adapter->hasForeignKey($table->getName(), array('ref_table_id'))); |
|
| 580 | } |
|
| 581 | ||
| 582 | public function testDropForeignKey() |
|
| 583 | { |
|
| 584 | $refTable = new \Phinx\Db\Table('ref_table', array(), $this->adapter); |
|
| 585 | $refTable->addColumn('field1', 'string')->save(); |
|
| 586 | ||
| 587 | $table = new \Phinx\Db\Table('table', array(), $this->adapter); |
|
| 588 | $table->addColumn('ref_table_id', 'integer')->save(); |
|
| 589 | ||
| 590 | $fk = new \Phinx\Db\Table\ForeignKey(); |
|
| 591 | $fk->setReferencedTable($refTable) |
|
| 592 | ->setColumns(array('ref_table_id')) |
|
| 593 | ->setReferencedColumns(array('id')); |
|
| 594 | ||
| 595 | $this->adapter->addForeignKey($table, $fk); |
|
| 596 | $this->assertTrue($this->adapter->hasForeignKey($table->getName(), array('ref_table_id'))); |
|
| 597 | $this->adapter->dropForeignKey($table->getName(), array('ref_table_id')); |
|
| 598 | $this->assertFalse($this->adapter->hasForeignKey($table->getName(), array('ref_table_id'))); |
|
| 599 | } |
|
| 600 | ||
| 601 | public function testHasDatabase() |
|
| 602 | { |
|
