Create OneToOne relationship with migrations

Hello!
I wan`t create OneToOne relationship between entities using migration, but in the ExtendExtension class i found only addOneToManyRelation, addManyToOneRelation and addManyToManyRelation methods. How i can create OneToOne relationship?

Topic

[jakabadambalazsParticipant]

me neither! Have you found a solution for this yet?

---

oro/platform(1.6.2) + oro/doctrine-extensions(1.0.7) + symfony/symfony(v2.3.27)

[Pavel LevinParticipant]

Unfortunately, solutions, except the use of neToMany relationship, I have not found

[hugevalParticipant]

Hi! To create OneToOne relationship using migration, you can use Doctrine native methods Doctrine\DBAL\Schema\Table::addColumn() and Doctrine\DBAL\Schema\Table::addForeignKeyConstraint()

[jakabadambalazsParticipant]

hi @hugeval, thanks but that is not what I am looking for(probably I wasn’t clear enough in my question)
What I am trying to do is to create a migration extension for my bundle so that other bundles can use it in their migration classes and add the association dynamically – much like you use the noteExtension.

This means that my migration extension class (implements ExtendExtensionAwareInterface) needs to use the injected Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtension class to add these relationships.

On ExtendExtension the methods for doing this are: addOneToManyRelation, addManyToOneRelation and addManyToManyRelation, but i am missing addOneToOneRelation.

ref.: https://github.com/orocrm/platform/tree/master/src/Oro/Bundle/EntityExtendBundle#add-relation

---

oro/platform(1.6.2) + oro/doctrine-extensions(1.0.7) + symfony/symfony(v2.3.27)

[Geoffroy CochardParticipant]

Hi,

As said @hugeval, to create a OneToOne relationship through migrations i’m using this to link orocrm_contact to partner_table by example.
But when Entity\Extend is generated, methods to manage OneToMany is generated …
My DB schema is correct (FK Ok, Relation OK)

PHP

/** * Add oneToOne to owner (sourTable) */ $options = [ 'extend' => [ 'cascade' => $cascade, 'is_extend' => true, 'owner' => ExtendScope::OWNER_CUSTOM, 'without_default' => true, 'relation' => [ $relationKey => [ 'cascade' => $cascade ] ] ] ]; $selfTableName = $sourceTable instanceof Table ? $sourceTable->getName() : $sourceTable; $selfTable = $sourceTable instanceof Table ? $sourceTable : $schema->getTable($sourceTable); $targetTableName = self::PARTNER_TABLE_NAME; $targetTable = $schema->getTable(self::PARTNER_TABLE_NAME); $targetColumnName = 'id'; // -- Add relation SourceTable $selfTable->addColumn('partner_id', Type::INTEGER, ['notnull' => false]); $selfTable->addIndex(['partner_id']); $selfTable->addForeignKeyConstraint( $targetTable, ['partner_id'], ['id'], ['onDelete' => 'SET NULL'] ); // -- Add relation - End // -- Add EntityExtend Options $options[ExtendOptionsManager::TARGET_OPTION] = [ 'table_name' => $targetTableName, 'column' => $targetColumnName, ]; $options[ExtendOptionsManager::TYPE_OPTION] = RelationType::ONE_TO_ONE; $this->extendOptionsManager->setColumnOptions( $selfTableName, 'partner', $options ); // -- Add EntityExtend Options - End

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47

/**          * Add oneToOne to owner (sourTable)          */         $options = [             'extend' => [                 'cascade' => $cascade,                 'is_extend' => true,                 'owner' => ExtendScope::OWNER_CUSTOM,                 'without_default' => true,                 'relation' => [                     $relationKey => [                         'cascade' => $cascade                     ]                 ]             ]         ];           $selfTableName        = $sourceTable instanceof Table ? $sourceTable->getName() : $sourceTable;         $selfTable            = $sourceTable instanceof Table ? $sourceTable : $schema->getTable($sourceTable);         $targetTableName      = self::PARTNER_TABLE_NAME;         $targetTable          = $schema->getTable(self::PARTNER_TABLE_NAME);         $targetColumnName     = 'id';           // -- Add relation SourceTable         $selfTable->addColumn('partner_id', Type::INTEGER, ['notnull' => false]);         $selfTable->addIndex(['partner_id']);         $selfTable->addForeignKeyConstraint(             $targetTable,             ['partner_id'],             ['id'],             ['onDelete' => 'SET NULL']         );         // -- Add relation - End           // -- Add EntityExtend Options         $options[ExtendOptionsManager::TARGET_OPTION] = [             'table_name' => $targetTableName,             'column'     => $targetColumnName,         ];         $options[ExtendOptionsManager::TYPE_OPTION] = RelationType::ONE_TO_ONE;           $this->extendOptionsManager->setColumnOptions(             $selfTableName,             'partner',             $options         );         // -- Add EntityExtend Options - End

In database line config is generated like this :

OroCRM\Bundle\AccountBundle\Entity\Account - partner - oneToOne

1	OroCRM\Bundle\AccountBundle\Entity\Account - partner - oneToOne

And Entity\Extend in cache about “partner” Relation :

PHP

<?php namespace Extend\Entity; abstract class EX_OroCRMAccountBundle_Account implements \Oro\Bundle\EntityExtendBundle\Entity\ExtendEntityInterface { protected $partner; public function setPartner($value) { if ((!$value instanceof \Traversable && !is_array($value) && !$value instanceof \ArrayAccess) || !$this->partner instanceof \Doctrine\Common\Collections\Collection) { $this->partner = $value; return $this; } foreach ($this->partner as $item) { $this->removePartner($item); } foreach ($value as $item) { $this->addPartner($item); } return $this; } public function removePartner($value) { if ($this->partner && $this->partner->contains($value)) { $this->partner->removeElement($value); } } public function getPartner() { return $this->partner; } public function addPartner($value) { if (!$this->partner->contains($value)) { $this->partner->add($value); } } public function __construct() { $this->partner = new \Doctrine\Common\Collections\ArrayCollection(); } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48

<?php   namespace Extend\Entity;   abstract class EX_OroCRMAccountBundle_Account implements \Oro\Bundle\EntityExtendBundle\Entity\ExtendEntityInterface {     protected $partner;       public function setPartner($value)     {         if ((!$value instanceof \Traversable && !is_array($value) && !$value instanceof \ArrayAccess) ||             !$this->partner instanceof \Doctrine\Common\Collections\Collection) {             $this->partner = $value;             return $this;         }         foreach ($this->partner as $item) {             $this->removePartner($item);         }         foreach ($value as $item) {             $this->addPartner($item);         }         return $this;     }       public function removePartner($value)     {         if ($this->partner && $this->partner->contains($value)) {             $this->partner->removeElement($value);         }     }       public function getPartner()     {         return $this->partner;     }       public function addPartner($value)     {         if (!$this->partner->contains($value)) {             $this->partner->add($value);         }     }       public function __construct()     {         $this->partner = new \Doctrine\Common\Collections\ArrayCollection();     } }

[Author]

Replies