Issue with migration

Hi,
I use a migration file to extend Account of the OroCRMAccountBundle.

When i run it the first time i have this errors:

[LogicException]
A new model can be created for custom entity only. Class: Sinabs\MonitoringBundle\Entity\WebSite.

/…

[RuntimeException]
Failed migrations: Oro\Bundle\EntityExtendBundle\Migration\UpdateExtendConfigMigration.

But the database have changed accordingly.

Then when i run doctrine:schema:update it erase the changes done by the migration script.

Here my code

PHP

<?php namespace Sinabs\MonitoringBundle\Entity; use Doctrine\ORM\Mapping as ORM; /** * WebSite * * @ORM\Table() * @ORM\Entity(repositoryClass="Sinabs\MonitoringBundle\Entity\WebSiteRepository") */ class WebSite { /** * @var integer * * @ORM\Column(name="id", type="integer") * @ORM\Id * @ORM\GeneratedValue(strategy="AUTO") */ private $id; /** * @var string * * @ORM\Column(name="name", type="string", length=255) */ private $name; /** * @var string * * @ORM\Column(name="url", type="string", length=255) */ private $url; /** * */ private $account; /** * @ORM\OneToMany(targetEntity="Sinabs\MonitoringBundle\Entity\Sonde", mappedBy="webSite", cascade={"persist", "remove"}) */ private $sondes; /** * Constructor */ public function __construct() { $this->sondes = new \Doctrine\Common\Collections\ArrayCollection(); } /** * Get id * * @return integer */ public function getId() { return $this->id; } /** * Set name * * @param string $name * * @return WebSite */ public function setName($name) { $this->name = $name; return $this; } /** * Get name * * @return string */ public function getName() { return $this->name; } /** * Set url * * @param string $url * * @return WebSite */ public function setUrl($url) { $this->url = $url; return $this; } /** * Get url * * @return string */ public function getUrl() { return $this->url; } /** * Add sonde * * @param \Sinabs\MonitoringBundle\Entity\Sonde $sonde * * @return WebSite */ public function addSonde(\Sinabs\MonitoringBundle\Entity\Sonde $sonde) { $this->sondes[] = $sonde; return $this; } /** * Remove sonde * * @param \Sinabs\MonitoringBundle\Entity\Sonde $sonde */ public function removeSonde(\Sinabs\MonitoringBundle\Entity\Sonde $sonde) { $this->sondes->removeElement($sonde); } /** * Get sondes * * @return \Doctrine\Common\Collections\Collection */ public function getSondes() { return $this->sondes; } }

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 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139

<?php   namespace Sinabs\MonitoringBundle\Entity;   use Doctrine\ORM\Mapping as ORM;   /** * WebSite * * @ORM\Table() * @ORM\Entity(repositoryClass="Sinabs\MonitoringBundle\Entity\WebSiteRepository") */ class WebSite {       /**      * @var integer      *      * @ORM\Column(name="id", type="integer")      * @ORM\Id      * @ORM\GeneratedValue(strategy="AUTO")      */     private $id;       /**      * @var string      *      * @ORM\Column(name="name", type="string", length=255)      */     private $name;       /**      * @var string      *      * @ORM\Column(name="url", type="string", length=255)      */     private $url;       /**      *      */     private $account;          /**      * @ORM\OneToMany(targetEntity="Sinabs\MonitoringBundle\Entity\Sonde", mappedBy="webSite", cascade={"persist", "remove"})      */     private $sondes;       /**      * Constructor      */     public function __construct() {         $this->sondes = new \Doctrine\Common\Collections\ArrayCollection();     }       /**      * Get id      *      * @return integer      */     public function getId() {         return $this->id;     }       /**      * Set name      *      * @param string $name      *      * @return WebSite      */     public function setName($name) {         $this->name = $name;           return $this;     }       /**      * Get name      *      * @return string      */     public function getName() {         return $this->name;     }       /**      * Set url      *      * @param string $url      *      * @return WebSite      */     public function setUrl($url) {         $this->url = $url;           return $this;     }       /**      * Get url      *      * @return string      */     public function getUrl() {         return $this->url;     }       /**      * Add sonde      *      * @param \Sinabs\MonitoringBundle\Entity\Sonde $sonde      *      * @return WebSite      */     public function addSonde(\Sinabs\MonitoringBundle\Entity\Sonde $sonde) {         $this->sondes[] = $sonde;           return $this;     }       /**      * Remove sonde      *      * @param \Sinabs\MonitoringBundle\Entity\Sonde $sonde      */     public function removeSonde(\Sinabs\MonitoringBundle\Entity\Sonde $sonde) {         $this->sondes->removeElement($sonde);     }       /**      * Get sondes      *      * @return \Doctrine\Common\Collections\Collection      */     public function getSondes() {         return $this->sondes;     }   }

PHP

<?php namespace Sinabs\MonitoringBundle\Entity; use Doctrine\ORM\Mapping as ORM; /** * Sonde * * @ORM\Table() * @ORM\Entity(repositoryClass="Sinabs\MonitoringBundle\Entity\SondeRepository") */ class Sonde { /** * @var integer * * @ORM\Column(name="id", type="integer") * @ORM\Id * @ORM\GeneratedValue(strategy="AUTO") */ private $id; /** * @var string * * @ORM\Column(name="url", type="string", length=255) */ private $url; /** * @ORM\ManyToOne(targetEntity="Sinabs\MonitoringBundle\Entity\WebSite", inversedBy="sondes") * @ORM\JoinColumn(nullable=false) */ private $webSite; /** * Get id * * @return integer */ public function getId() { return $this->id; } /** * Set url * * @param string $url * * @return Sonde */ public function setUrl($url) { $this->url = $url; return $this; } /** * Get url * * @return string */ public function getUrl() { return $this->url; } /** * Set webSite * * @param \Sinabs\MonitoringBundle\Entity\WebSite $webSite * * @return Sonde */ public function setWebSite(\Sinabs\MonitoringBundle\Entity\WebSite $webSite) { $this->webSite = $webSite; return $this; } /** * Get webSite * * @return \Sinabs\MonitoringBundle\Entity\WebSite */ public function getWebSite() { return $this->webSite; } }

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 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90

<?php   namespace Sinabs\MonitoringBundle\Entity;   use Doctrine\ORM\Mapping as ORM;   /** * Sonde * * @ORM\Table() * @ORM\Entity(repositoryClass="Sinabs\MonitoringBundle\Entity\SondeRepository") */ class Sonde {       /**      * @var integer      *      * @ORM\Column(name="id", type="integer")      * @ORM\Id      * @ORM\GeneratedValue(strategy="AUTO")      */     private $id;       /**      * @var string      *      * @ORM\Column(name="url", type="string", length=255)      */     private $url;       /**      * @ORM\ManyToOne(targetEntity="Sinabs\MonitoringBundle\Entity\WebSite", inversedBy="sondes")      * @ORM\JoinColumn(nullable=false)          */     private $webSite;       /**      * Get id      *      * @return integer      */     public function getId() {         return $this->id;     }       /**      * Set url      *      * @param string $url      *      * @return Sonde      */     public function setUrl($url) {         $this->url = $url;           return $this;     }       /**      * Get url      *      * @return string      */     public function getUrl() {         return $this->url;     }       /**      * Set webSite      *      * @param \Sinabs\MonitoringBundle\Entity\WebSite $webSite      *      * @return Sonde      */     public function setWebSite(\Sinabs\MonitoringBundle\Entity\WebSite $webSite) {         $this->webSite = $webSite;           return $this;     }       /**      * Get webSite      *      * @return \Sinabs\MonitoringBundle\Entity\WebSite      */     public function getWebSite() {         return $this->webSite;     }   }

:

PHP

<?php namespace Sinabs\MonitoringBundle\Migrations\Schema\v1_0; use Doctrine\DBAL\Schema\Schema; use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtension; use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtensionAwareInterface; use Oro\Bundle\EntityExtendBundle\EntityConfig\ExtendScope; use Oro\Bundle\MigrationBundle\Migration\Migration; use Oro\Bundle\MigrationBundle\Migration\QueryBag; class OroCRMAccountMigration implements Migration, ExtendExtensionAwareInterface { protected $webSites; public function setExtendExtension(ExtendExtension $extendExtension) { $this->webSites = $extendExtension; } public function up(Schema $schema, QueryBag $queries) { $webSites = $this->webSites; /** extend table orocrm_account * */ $table = $schema->getTable('orocrm_account'); /** * define and add our custom fields */ $webSites->addOneToManyRelation( $schema, $table, // owning side table 'webSites', // owning side field name 'WebSite', // target side table ['name'], // column names are used to show a title of related entity ['name'], // column names are used to show detailed info about related entity ['name'], // Column names are used to show related entity in a grid ['extend' => ['owner' => ExtendScope::OWNER_CUSTOM]] ); $webSites->addOneToManyInverseRelation( $schema, $table, // owning side table 'webSites', // owning side field name 'WebSite', // target side table 'account', // target side field name 'name', // column name is used to show related entity ['extend' => ['owner' => ExtendScope::OWNER_CUSTOM]] ); } }

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 49

<?php   namespace Sinabs\MonitoringBundle\Migrations\Schema\v1_0;   use Doctrine\DBAL\Schema\Schema; use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtension; use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtensionAwareInterface; use Oro\Bundle\EntityExtendBundle\EntityConfig\ExtendScope; use Oro\Bundle\MigrationBundle\Migration\Migration; use Oro\Bundle\MigrationBundle\Migration\QueryBag;   class OroCRMAccountMigration implements Migration, ExtendExtensionAwareInterface {       protected $webSites;       public function setExtendExtension(ExtendExtension $extendExtension) {         $this->webSites = $extendExtension;     }       public function up(Schema $schema, QueryBag $queries) {           $webSites = $this->webSites;         /** extend table orocrm_account * */         $table = $schema->getTable('orocrm_account');         /**          * define and add our custom fields          */         $webSites->addOneToManyRelation(                 $schema,                 $table, // owning side table                 'webSites', // owning side field name                 'WebSite', // target side table                 ['name'], // column names are used to show a title of related entity                 ['name'], // column names are used to show detailed info about related entity                 ['name'], // Column names are used to show related entity in a grid                 ['extend' => ['owner' => ExtendScope::OWNER_CUSTOM]]         );         $webSites->addOneToManyInverseRelation(                 $schema,                 $table, // owning side table                 'webSites', // owning side field name                 'WebSite', // target side table                 'account', // target side field name                 'name', // column name is used to show related entity                 ['extend' => ['owner' => ExtendScope::OWNER_CUSTOM]]         );     }   }

It seems like i have forgot some steps before define migration script correctly.

Sorry for my english… I am french

Topic

[Vova SorokaParticipant]

Hi @adriwan_kenoby,

To get it work you need to make your WebSite entity as configurable one, or even extendable one if you want to allow adding new fields to it by an administrator or by another bundle.
Some details about configurable and extendable entities you can find in The Oro Book. Look at Configure Entities and Extending Entities sections.

[adriwan_kenobyParticipant]

Hi @Vova Soroka,

Thanks for your reply.

I have add config annotation and create extend entity.

Now all works fine after a doctrine:schema:update command.

[adriwan_kenobyParticipant]

I have found the solution yesterday.

Am I right ?

– The extend entity allow to use migration for the entity

– the config annotation display the entity in the entiy manager and allow user to manage it

– create extension for config dumper, the entity generator and the migrations allow to manage association throught th UI.

[adriwan_kenobyParticipant]

I have also add the annotation

@ORM\ManyToOne(targetEntity=”OroCRM\Bundle\AccountBundle\Entity\Account”, inversedBy=”webSites”)

to the $account attribute of my WebSite class to make the relation bidirectionnal

but i am not sure that is necessary.

[Vova SorokaParticipant]

Am I right ?
– The extend entity allow to use migration for the entity
– the config annotation display the entity in the entiy manager and allow user to manage it
– create extension for config dumper, the entity generator and the migrations allow to manage association throught th UI.

– The extended entity can be changed by someone, not only by author. For example an administrator can add new fields to this entity throught the UI. Or any developer can do the same using the migrations.
– Yes, if an entity has the config annotation it will be shown on the entity management and an administrator can change some metadata of this entity. But only author of such entity can add new fields.
– Usually you do not need to create the config dumper and entity generator extensions. They are used if a new functionality is added, for example in case if you need to implement some not standard relationship between entities.

I have also add the annotation
@ORM\ManyToOne(targetEntity=”OroCRM\Bundle\AccountBundle\Entity\Account”, inversedBy=”webSites”)
to the $account attribute of my WebSite class to make the relation bidirectionnal
but i am not sure that is necessary.

If you create the association using Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtension::addOneToManyRelation, you do not need to add the $account property at all, it will be generated automatically.
But if you need regular unidirectional relation to the Account entity, you can use standard Doctrine way. In this case the WebSite entity may be or may not be configurable.

[adriwan_kenobyParticipant]

Thanks a lot @Vova Soroka

[adriwan_kenobyParticipant]

But if i haven’t the $account property in my website class then i haven’t getter and setter…

And the account_id doesn’t appear on the website table, it s look like their is no relation.

Moreover i always have error the first time i run oro:migration:load

[RuntimeException]
Unknown auxiliary section: _website.

[RuntimeException]
Failed migrations: Oro\Bundle\EntityExtendBundle\Migration\UpdateExtendConfigMigration.

The second time their is no error

[adriwan_kenobyParticipant]

I have changed the table name of WebSite in _website.

Remove $account from WebSite.

Remove the config dumper, entity generator, migration Extensions.

I confirm that i want a bidirectionnal relation between an account an my WebSite entity.

[Author]

Replies