/**
* 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());
}
