OroCRM\Bundle\SalesBundle\Migrations\Schema\v1_25_3\RemoveOldEntityConfigs

Complexity

Total Complexity

1

Size/Duplication

Total Lines	20
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Importance

Changes	1
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	up()	0	14	1

<?php

namespace OroCRM\Bundle\SalesBundle\Migrations\Schema\v1_25_3;

use Doctrine\DBAL\Connection;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\DBAL\Types\Type;

use Oro\Bundle\MigrationBundle\Migration\Migration;
use Oro\Bundle\MigrationBundle\Migration\ParametrizedSqlMigrationQuery;
use Oro\Bundle\MigrationBundle\Migration\QueryBag;

class RemoveOldEntityConfigs implements Migration
{
    /**
     * {@inheritdoc}
     */
    public function up(Schema $schema, QueryBag $queries)
    {
        $class = 'OroCRM\Bundle\SalesBundle\Entity\Lead';
        $fields = ['email', 'phoneNumber'];

        $queries->addPostQuery(
            new ParametrizedSqlMigrationQuery(
                'DELETE FROM oro_entity_config_field WHERE field_name IN (:fields)
                  AND entity_id IN (SELECT id FROM oro_entity_config WHERE class_name = :class)',
                ['class' => $class, 'fields' => $fields],
                ['class' => Type::STRING, 'fields' => Connection::PARAM_STR_ARRAY]
            )
        );
    }
}