/** * Appends the generated <foreign-key> XML node to its parent node. * * @param ForeignKey $foreignKey The ForeignKey model instance * @param \DOMNode $parentNode The parent DOMNode object */ private function appendForeignKeyNode(ForeignKey $foreignKey, \DOMNode $parentNode) { $foreignKeyNode = $parentNode->appendChild($this->document->createElement('foreign-key')); $foreignKeyNode->setAttribute('foreignTable', $foreignKey->getForeignTableCommonName()); if ($schema = $foreignKey->getForeignSchemaName()) { $foreignKeyNode->setAttribute('foreignSchema', $schema); } $foreignKeyNode->setAttribute('name', $foreignKey->getName()); if ($phpName = $foreignKey->getPhpName()) { $foreignKeyNode->setAttribute('phpName', $phpName); } if ($refPhpName = $foreignKey->getRefPhpName()) { $foreignKeyNode->setAttribute('refPhpName', $refPhpName); } if ($defaultJoin = $foreignKey->getDefaultJoin()) { $foreignKeyNode->setAttribute('defaultJoin', $defaultJoin); } if ($onDeleteBehavior = $foreignKey->getOnDelete()) { $foreignKeyNode->setAttribute('onDelete', $onDeleteBehavior); } if ($onUpdateBehavior = $foreignKey->getOnUpdate()) { $foreignKeyNode->setAttribute('onUpdate', $onUpdateBehavior); } for ($i = 0, $size = count($foreignKey->getLocalColumns()); $i < $size; $i++) { $refNode = $foreignKeyNode->appendChild($this->document->createElement('reference')); $refNode->setAttribute('local', $foreignKey->getLocalColumnName($i)); $refNode->setAttribute('foreign', $foreignKey->getForeignColumnName($i)); } foreach ($foreignKey->getVendorInformation() as $vendorInformation) { $this->appendVendorInformationNode($vendorInformation, $foreignKeyNode); } }
public function testGetInverseForeignKey() { $database = $this->getDatabaseMock('bookstore'); $platform = $this->getPlatformMock(true); $foreignTable = $this->getTableMock('authors'); $localTable = $this->getTableMock('books', ['platform' => $platform, 'database' => $database]); $database->expects($this->any())->method('getTable')->with($this->equalTo('bookstore.authors'))->will($this->returnValue($foreignTable)); $inversedFk = new ForeignKey(); $inversedFk->addReference('id', 'author_id'); $inversedFk->setTable($localTable); $inversedFk->setForeignSchemaName('bookstore'); $inversedFk->setForeignTableCommonName('authors'); $foreignTable->expects($this->any())->method('getForeignKeys')->will($this->returnValue([$inversedFk])); $fk = new ForeignKey(); $fk->setTable($localTable); $fk->addReference('author_id', 'id'); $fk->setForeignSchemaName('bookstore'); $fk->setForeignTableCommonName('authors'); $this->assertSame('authors', $fk->getForeignTableCommonName()); $this->assertSame('bookstore.authors', $fk->getForeignTableName()); $this->assertInstanceOf('Propel\\Generator\\Model\\Table', $fk->getForeignTable()); $this->assertSame($inversedFk, $fk->getInverseFK()); $this->assertTrue($fk->isMatchedByInverseFK()); }