Drop one-to-many relation (attachementExtentsion)

Hi,

I’d like to know how can i drop/delete an attachment Association created through migrations like this:

PHP

public function up(Schema $schema, QueryBag $queries) { $this->attachmentExtension->addAttachmentAssociation( $schema, 'cb_newage_panel_view', [], 10 ); }

1 2 3 4 5 6 7 8

public function up(Schema $schema, QueryBag $queries)     {        $this->attachmentExtension->addAttachmentAssociation(             $schema,             'cb_newage_panel_view',             [],             10         );     }

Topic

[Mike KudelyaParticipant]

Hi

If you want to delete ‘Add Attachment’ option in ‘More Actions’ drop-down try to change this “System -> Entity Management -> [Entity] -> [Edit] -> Enable Attachments -> No”.

[bosumfliciParticipant]

Sorry for late reply.

No that’s not what i meant. I create an attachment relation through migration. Later i need to drop that relation. How can i do that?

[Mike KudelyaParticipant]

Hi

To remove the relation, you should first find the ID of the ‘Oro\Bundle\AttachmentBundle\Entity\Attachment’ entity in the oro_entity_config table and delete your entity field (cb_newage_panel_view) from oro_entity_config_field filtering by “where entity_id = ID”. Afterwards, please delete your entity from the oro_attachment table. Also, I have created a small hack for the entity config (oro_entity_config::data). You should modify the config of the ‘Oro\Bundle\AttachmentBundle\Entity\Attachment’ entity and delete the relation. Put the column’s data in the $str variable, recognize the relation name (in my case it is manyToOne|Oro\Bundle\AttachmentBundle\Entity\Attachment|Extend\Entity\ContactData|contact_data_ed9890f2) and unset it. Once you have done that, put it back into the oro_entity_config::data field.
I suggest you run this code in any controller/service of your project, otherwise the unserialize function will give the wrong result.

PHP

$str = '...'; $decoded = unserialize(base64_decode($str)); echo "==================== ORIGINAL:"; print_r($decoded); unset($decoded['extend']['relation']['manyToOne|Oro\Bundle\AttachmentBundle\Entity\Attachment|Extend\Entity\ContactData|contact_data_ed9890f2']); echo "==================== MODIFIED:"; print_r($decoded); echo base64_encode(serialize($decoded)); exit;

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

$str = '...';           $decoded = unserialize(base64_decode($str));           echo "==================== ORIGINAL:";         print_r($decoded);           unset($decoded['extend']['relation']['manyToOne|Oro\Bundle\AttachmentBundle\Entity\Attachment|Extend\Entity\ContactData|contact_data_ed9890f2']);           echo "==================== MODIFIED:";         print_r($decoded);           echo base64_encode(serialize($decoded));           exit;

[Author]

Replies