PHP Phoenix\Database\Element Table::getForeignKeys示例

示例#1

文件： CommonQueryBuilder.php 项目： lulco/phoenix

 protected function addForeignKeys(Table $table)
 {
     $queries = [];
     foreach ($table->getForeignKeys() as $foreignKey) {
         $queries[] = 'ALTER TABLE ' . $this->escapeString($table->getName()) . ' ADD ' . $this->createForeignKey($foreignKey, $table) . ';';
     }
     return $queries;
 }

示例#2

文件： TableTest.php 项目： lulco/phoenix

 public function testForeignKeys()
 {
     $table = new Table('test');
     $this->assertCount(0, $table->getForeignKeys());
     $this->assertInstanceOf('\\Phoenix\\Database\\Element\\Table', $table->addForeignKey(new ForeignKey('first_column', 'foreign_table')));
     $this->assertCount(1, $table->getForeignKeys());
     $this->assertInstanceOf('\\Phoenix\\Database\\Element\\Table', $table->addForeignKey(new ForeignKey('second_column', 'foreign_table')));
     $this->assertCount(2, $table->getForeignKeys());
     foreach ($table->getForeignKeys() as $foreignKey) {
         $this->assertInstanceOf('\\Phoenix\\Database\\Element\\ForeignKey', $foreignKey);
     }
     $this->assertInstanceOf('\\Phoenix\\Database\\Element\\Table', $table->dropForeignKey('first_column'));
     $this->assertCount(1, $table->getForeignKeysToDrop());
     $this->assertEquals('test_first_column', $table->getForeignKeysToDrop()[0]);
 }