Exists 'dropManyToOneRelation' in migrations?

There is a method ‘addManyToOneRelation’ for migrations. Exists ‘dropManyToOneRelation’ in migrations?

Topic

[spyout98Participant]

If no, how do I remove a ManyToOneRelation in OroCRM or OroPlatform?

That is my migration code:

PHP

<?php namespace Ibv\Bundle\SmcContactBundle\Migrations\Schema\v1_3; 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\EntityBundle\EntityConfig\DatagridScope; use Oro\Bundle\MigrationBundle\Migration\Migration; use Oro\Bundle\MigrationBundle\Migration\QueryBag; class CreateAssociationWithRelationshipProgram implements Migration, ExtendExtensionAwareInterface { protected $extendExtension; public function setExtendExtension(ExtendExtension $extendExtension) { $this->extendExtension = $extendExtension; } public function up(Schema $schema, QueryBag $queries) { $table = $schema->createTable('smccontact_relationshipprogram'); $table->addColumn('name', 'string'); $table->addColumn('label', 'string'); $table->setPrimaryKey(['name']); $table->addUniqueIndex(['label'], 'index_label_in_smccontact_relationshipprogram'); $this->extendExtension->addManyToOneRelation( $schema, 'orocrm_contact', 'relationship_program', 'smccontact_relationshipprogram', 'label', [ 'extend' => [ 'owner' => ExtendScope::OWNER_CUSTOM, 'nullable' => true, 'on_delete' => null ], 'view' => ['is_displayable' => true] ] ); } }

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

<?php   namespace Ibv\Bundle\SmcContactBundle\Migrations\Schema\v1_3;   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\EntityBundle\EntityConfig\DatagridScope; use Oro\Bundle\MigrationBundle\Migration\Migration; use Oro\Bundle\MigrationBundle\Migration\QueryBag;   class CreateAssociationWithRelationshipProgram implements Migration, ExtendExtensionAwareInterface {     protected $extendExtension;       public function setExtendExtension(ExtendExtension $extendExtension)     {         $this->extendExtension = $extendExtension;     }       public function up(Schema $schema, QueryBag $queries)     {         $table = $schema->createTable('smccontact_relationshipprogram');         $table->addColumn('name', 'string');         $table->addColumn('label', 'string');         $table->setPrimaryKey(['name']);         $table->addUniqueIndex(['label'], 'index_label_in_smccontact_relationshipprogram');           $this->extendExtension->addManyToOneRelation(             $schema,             'orocrm_contact',             'relationship_program',             'smccontact_relationshipprogram',             'label',             [                 'extend' => [                     'owner' => ExtendScope::OWNER_CUSTOM,                     'nullable' => true,                     'on_delete' => null                 ],                 'view' => ['is_displayable' => true]             ]         );     } }

I want to destroy this relationship in another migration.

[spyout98Participant]

?

[MichaelKeymaster]

Same question on GitHub

[spyout98Participant]

I’ve created there too. Because I don’t know exactly where is the best place for this kind of question.

[MichaelKeymaster]

Either one is good place. Linking them for the conveninence of others looking for the same answer later.

[spyout98Participant]

Anyway, how do I do this? To remove completely the relation in orocrm_contact table and others possible auxiliar tables and records in another tables that Oro may created?

[AlexanderModerator]

Hi @spyout98

The custom relation config can be removed with ‘RemoveOneToManyRelationQuery’, so the relation will not be available in UI
For example, the migration I’ve been using with ‘User’ entity to check:

PHP

namespace Oro\Bundle\UserBundle\Migrations\Schema\v2_3; use Doctrine\DBAL\Schema\Schema; use Oro\Bundle\EntityConfigBundle\Migration\RemoveOneToManyRelationQuery; use Oro\Bundle\MigrationBundle\Migration\Migration; use Oro\Bundle\MigrationBundle\Migration\QueryBag; use Oro\Bundle\UserBundle\Entity\User; class TestMigrationRemove implements Migration { /** * {@inheritdoc} */ public function up(Schema $schema, QueryBag $queries) { $queries->addQuery(new RemoveOneToManyRelationQuery(User::class, 'o2m')); } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

namespace Oro\Bundle\UserBundle\Migrations\Schema\v2_3;   use Doctrine\DBAL\Schema\Schema;   use Oro\Bundle\EntityConfigBundle\Migration\RemoveOneToManyRelationQuery; use Oro\Bundle\MigrationBundle\Migration\Migration; use Oro\Bundle\MigrationBundle\Migration\QueryBag; use Oro\Bundle\UserBundle\Entity\User;   class TestMigrationRemove implements Migration {     /**      * {@inheritdoc}      */     public function up(Schema $schema, QueryBag $queries)     {         $queries->addQuery(new RemoveOneToManyRelationQuery(User::class, 'o2m'));     } }

But in general ‘RemoveOneToManyRelationQuery’, ‘RemoveManyToManyRelationQuery’, ‘RemoveManyToOneRelationQuery’ removes ONLY configuration of an extend relation, so the data fields are still remains in database.

You can execute the command app/console doctrine:schema:update --dump-sql and the result will be something like

MySQL

ALTER TABLE oro_user DROP FOREIGN KEY fk_oro_user_default_o2m_id; DROP INDEX idx_oro_user_default_o2m_id ON oro_user; ALTER TABLE oro_user DROP default_o2m_id; ALTER TABLE orocrm_contact DROP FOREIGN KEY fk_orocrm_contact_user_o2m_id; DROP INDEX idx_orocrm_contact_user_o2m_id ON orocrm_contact; ALTER TABLE orocrm_contact DROP user_o2m_id;

1 2 3 4 5 6

ALTER TABLE oro_user DROP FOREIGN KEY fk_oro_user_default_o2m_id; DROP INDEX idx_oro_user_default_o2m_id ON oro_user; ALTER TABLE oro_user DROP default_o2m_id; ALTER TABLE orocrm_contact DROP FOREIGN KEY fk_orocrm_contact_user_o2m_id; DROP INDEX idx_orocrm_contact_user_o2m_id ON orocrm_contact; ALTER TABLE orocrm_contact DROP user_o2m_id;

so, the removal of indices, foreign keys and columns is still the developers responsibility and you will need to add such drops into migration as well, e.g.

PHP

$table = $schema->getTable('entity_table'); $table->dropIndex('index name'); $table->dropColumn('column name');

1 2 3

$table = $schema->getTable('entity_table'); $table->dropIndex('index name'); $table->dropColumn('column name');

[spyout98Participant]

Thank you so much, @Alexander!

[Author]

Replies