/** * 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 testAddMultipleReferences() { $fk = new ForeignKey(); $fk->addReference('book_id', 'id'); $fk->addReference('author_id', 'id'); $this->assertTrue($fk->isComposite()); $this->assertCount(2, $fk->getLocalColumns()); $this->assertCount(2, $fk->getForeignColumns()); $this->assertSame('book_id', $fk->getLocalColumnName(0)); $this->assertSame('id', $fk->getForeignColumnName(0)); $this->assertSame('id', $fk->getMappedForeignColumn('book_id')); $this->assertSame('author_id', $fk->getLocalColumnName(1)); $this->assertSame('id', $fk->getForeignColumnName(1)); $this->assertSame('id', $fk->getMappedForeignColumn('author_id')); }