Version0_19_0::down() - Code Metrics - Inspection of "Release/0.19.0" - DigitalState/Identities - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — develop (#54)

by Mario

created 2020-08-03 14:31 UTC

Version0_19_0::down() A

↳ Parent: Version0_19_0

Complexity

Conditions	1
Paths	1

Size

Total Lines	93
Code Lines	26

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	26
c	1
b	0
f	0
nc	1
nop	1
dl	0
loc	93
rs	9.504

How to fix Long Method

<?php

namespace App\Migration;

use Doctrine\DBAL\Schema\Schema;
filter:
    dependency_paths: ["lib/*"]
use Doctrine\Migrations\AbstractMigration;
filter:
    dependency_paths: ["lib/*"]
use Doctrine\DBAL\Migrations\Version;
filter:
    dependency_paths: ["lib/*"]
use Ds\Component\Acl\Migration\Version0_19_0 as Acl;
filter:
    dependency_paths: ["lib/*"]

/**
 * Class Version0_19_0
 */
final class Version0_19_0 extends AbstractMigration
{
    /**
     * @var \Ds\Component\Acl\Migration\Version0_19_0
     */
    private $acl;

    /**
     * Constructor
     *
     * @param \Doctrine\DBAL\Migrations\Version  $version
     */
    public function __construct(Version $version)
    {
        parent::__construct($version);
        $this->acl = new Acl($version);
    }

    /**
     * Up migration
     *
     * @param \Doctrine\DBAL\Schema\Schema $schema
     */
    public function up(Schema $schema)
    {
        $this->acl->up($schema);
        $this->addSql('ALTER TABLE app_anonymous_role ADD entity_uuids JSON DEFAULT NULL');
        $this->addSql('COMMENT ON COLUMN app_anonymous_role.entity_uuids IS \'(DC2Type:json_array)\'');
        $this->addSql('ALTER TABLE app_individual_role ADD entity_uuids JSON DEFAULT NULL');
        $this->addSql('COMMENT ON COLUMN app_individual_role.entity_uuids IS \'(DC2Type:json_array)\'');
        $this->addSql('ALTER TABLE app_organization_role ADD entity_uuids JSON DEFAULT NULL');
        $this->addSql('COMMENT ON COLUMN app_organization_role.entity_uuids IS \'(DC2Type:json_array)\'');
        $this->addSql('ALTER TABLE app_staff_role ADD entity_uuids JSON DEFAULT NULL');
        $this->addSql('COMMENT ON COLUMN app_staff_role.entity_uuids IS \'(DC2Type:json_array)\'');
        $this->addSql('ALTER TABLE app_system_role ADD entity_uuids JSON DEFAULT NULL');
        $this->addSql('COMMENT ON COLUMN app_system_role.entity_uuids IS \'(DC2Type:json_array)\'');
        $this->addSql('
            UPDATE
                app_anonymous_role
            SET
                entity_uuids = (
                    SELECT
                        array_to_json(array_agg(app_bu.uuid))
                    FROM
                        app_anonymous_role_bu
                    INNER JOIN
                        app_bu ON
                        app_bu.id = app_anonymous_role_bu.business_unit_id
                    WHERE
                        app_anonymous_role_bu.anonymous_role_id = app_anonymous_role.id
                )
        ');
        $this->addSql('UPDATE app_anonymous_role SET entity_uuids = \'[]\' WHERE entity_uuids IS NULL');
        $this->addSql('
            UPDATE
                app_individual_role
            SET
                entity_uuids = (
                    SELECT
                        array_to_json(array_agg(app_bu.uuid))
                    FROM
                        app_individual_role_bu
                    INNER JOIN
                        app_bu ON
                        app_bu.id = app_individual_role_bu.business_unit_id
                    WHERE
                        app_individual_role_bu.individual_role_id = app_individual_role.id
                )
        ');
        $this->addSql('UPDATE app_individual_role SET entity_uuids = \'[]\' WHERE entity_uuids IS NULL');
        $this->addSql('
            UPDATE
                app_organization_role
            SET
                entity_uuids = (
                    SELECT
                        array_to_json(array_agg(app_bu.uuid))
                    FROM
                        app_organization_role_bu
                    INNER JOIN
                        app_bu ON
                        app_bu.id = app_organization_role_bu.business_unit_id
                    WHERE
                        app_organization_role_bu.organization_role_id = app_organization_role.id
                )
        ');
        $this->addSql('UPDATE app_organization_role SET entity_uuids = \'[]\' WHERE entity_uuids IS NULL');
        $this->addSql('
            UPDATE
                app_staff_role
            SET
                entity_uuids = (
                    SELECT
                        array_to_json(array_agg(app_bu.uuid))
                    FROM
                        app_staff_role_bu
                    INNER JOIN
                        app_bu ON
                        app_bu.id = app_staff_role_bu.business_unit_id
                    WHERE
                        app_staff_role_bu.staff_role_id = app_staff_role.id
                )
        ');
        $this->addSql('UPDATE app_staff_role SET entity_uuids = \'[]\' WHERE entity_uuids IS NULL');
        $this->addSql('
            UPDATE
                app_system_role
            SET
                entity_uuids = (
                    SELECT
                        array_to_json(array_agg(app_bu.uuid))
                    FROM
                        app_system_role_bu
                    INNER JOIN
                        app_bu ON
                        app_bu.id = app_system_role_bu.business_unit_id
                    WHERE
                        app_system_role_bu.system_role_id = app_system_role.id
                )
        ');
        $this->addSql('UPDATE app_system_role SET entity_uuids = \'[]\' WHERE entity_uuids IS NULL');
        $this->addSql('ALTER TABLE app_anonymous_role ALTER entity_uuids SET NOT NULL');
        $this->addSql('ALTER TABLE app_individual_role ALTER entity_uuids SET NOT NULL');
        $this->addSql('ALTER TABLE app_organization_role ALTER entity_uuids SET NOT NULL');
        $this->addSql('ALTER TABLE app_staff_role ALTER entity_uuids SET NOT NULL');
        $this->addSql('ALTER TABLE app_system_role ALTER entity_uuids SET NOT NULL');
        $this->addSql('DROP TABLE app_anonymous_role_bu');
        $this->addSql('DROP TABLE app_individual_role_bu');
        $this->addSql('DROP TABLE app_organization_role_bu');
        $this->addSql('DROP TABLE app_staff_role_bu');
        $this->addSql('DROP TABLE app_system_role_bu');
    }

    /**
     * Down migration
     *
     * @param \Doctrine\DBAL\Schema\Schema $schema
     */
    public function down(Schema $schema)
    {
        $this->acl->down($schema);
        $this->addSql('CREATE TABLE app_anonymous_role_bu (anonymous_role_id INT NOT NULL, business_unit_id INT NOT NULL, PRIMARY KEY(anonymous_role_id, business_unit_id))');
        $this->addSql('CREATE INDEX IDX_B09CAAD23089E0B ON app_anonymous_role_bu (anonymous_role_id)');
        $this->addSql('CREATE INDEX IDX_B09CAADA58ECB40 ON app_anonymous_role_bu (business_unit_id)');
        $this->addSql('CREATE TABLE app_individual_role_bu (individual_role_id INT NOT NULL, business_unit_id INT NOT NULL, PRIMARY KEY(individual_role_id, business_unit_id))');
        $this->addSql('CREATE INDEX IDX_68A9160EFDFA321 ON app_individual_role_bu (individual_role_id)');
        $this->addSql('CREATE INDEX IDX_68A9160A58ECB40 ON app_individual_role_bu (business_unit_id)');
        $this->addSql('CREATE TABLE app_organization_role_bu (organization_role_id INT NOT NULL, business_unit_id INT NOT NULL, PRIMARY KEY(organization_role_id, business_unit_id))');
        $this->addSql('CREATE INDEX IDX_79C5DB011BD1AAEF ON app_organization_role_bu (organization_role_id)');
        $this->addSql('CREATE INDEX IDX_79C5DB01A58ECB40 ON app_organization_role_bu (business_unit_id)');
        $this->addSql('CREATE TABLE app_staff_role_bu (staff_role_id INT NOT NULL, business_unit_id INT NOT NULL, PRIMARY KEY(staff_role_id, business_unit_id))');
        $this->addSql('CREATE INDEX IDX_998CF18F8AB5351A ON app_staff_role_bu (staff_role_id)');
        $this->addSql('CREATE INDEX IDX_998CF18FA58ECB40 ON app_staff_role_bu (business_unit_id)');
        $this->addSql('CREATE TABLE app_system_role_bu (system_role_id INT NOT NULL, business_unit_id INT NOT NULL, PRIMARY KEY(system_role_id, business_unit_id))');
        $this->addSql('CREATE INDEX IDX_6CCE35F83A705E3F ON app_system_role_bu (system_role_id)');
        $this->addSql('CREATE INDEX IDX_6CCE35F8A58ECB40 ON app_system_role_bu (business_unit_id)');
        $this->addSql('
            INSERT INTO app_anonymous_role_bu (
                anonymous_role_id,
                business_unit_id
            )
            SELECT
                app_anonymous_role.id,
                app_bu.id
            FROM
                app_anonymous_role,
                app_bu
            WHERE
                app_anonymous_role.entity_uuids::text LIKE CONCAT(\'%\', app_bu.uuid, \'%\')
        ');
        $this->addSql('
            INSERT INTO app_individual_role_bu (
                individual_role_id,
                business_unit_id
            )
            SELECT
                app_individual_role.id,
                app_bu.id
            FROM
                app_individual_role,
                app_bu
            WHERE
                app_individual_role.entity_uuids::text LIKE CONCAT(\'%\', app_bu.uuid, \'%\')
        ');
        $this->addSql('
            INSERT INTO app_organization_role_bu (
                organization_role_id,
                business_unit_id
            )
            SELECT
                app_organization_role.id,
                app_bu.id
            FROM
                app_organization_role,
                app_bu
            WHERE
                app_organization_role.entity_uuids::text LIKE CONCAT(\'%\', app_bu.uuid, \'%\')
        ');
        $this->addSql('
            INSERT INTO app_staff_role_bu (
                staff_role_id,
                business_unit_id
            )
            SELECT
                app_staff_role.id,
                app_bu.id
            FROM
                app_staff_role,
                app_bu
            WHERE
                app_staff_role.entity_uuids::text LIKE CONCAT(\'%\', app_bu.uuid, \'%\')
        ');
        $this->addSql('
            INSERT INTO app_system_role_bu (
                system_role_id,
                business_unit_id
            )
            SELECT
                app_system_role.id,
                app_bu.id
            FROM
                app_system_role,
                app_bu
            WHERE
                app_system_role.entity_uuids::text LIKE CONCAT(\'%\', app_bu.uuid, \'%\')
        ');
        $this->addSql('ALTER TABLE app_anonymous_role DROP entity_uuids');
        $this->addSql('ALTER TABLE app_individual_role DROP entity_uuids');
        $this->addSql('ALTER TABLE app_organization_role DROP entity_uuids');
        $this->addSql('ALTER TABLE app_staff_role DROP entity_uuids');
        $this->addSql('ALTER TABLE app_system_role DROP entity_uuids');
    }
}


1			<?php
2
3			namespace App\Migration;
4
5			use Doctrine\DBAL\Schema\Schema;
			0 ignored issues – show Bug introduced 2020-07-30 19:12 UTC by Report Bug Copy Issue Report The type `Doctrine\DBAL\Schema\Schema` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
6			use Doctrine\Migrations\AbstractMigration;
			0 ignored issues – show Bug introduced 2020-07-30 19:12 UTC by Report Bug Copy Issue Report The type `Doctrine\Migrations\AbstractMigration` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
7			use Doctrine\DBAL\Migrations\Version;
			0 ignored issues – show Bug introduced 2020-07-30 19:12 UTC by Report Bug Copy Issue Report The type `Doctrine\DBAL\Migrations\Version` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
8			use Ds\Component\Acl\Migration\Version0_19_0 as Acl;
			0 ignored issues – show Bug introduced 2020-07-30 19:12 UTC by Report Bug Copy Issue Report The type `Ds\Component\Acl\Migration\Version0_19_0` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
9
10			/**
11			* Class Version0_19_0
12			*/
13			final class Version0_19_0 extends AbstractMigration
14			{
15			/**
16			* @var \Ds\Component\Acl\Migration\Version0_19_0
17			*/
18			private $acl;
19
20			/**
21			* Constructor
22			*
23			* @param \Doctrine\DBAL\Migrations\Version $version
24			*/
25			public function __construct(Version $version)
26			{
27			parent::__construct($version);
28			$this->acl = new Acl($version);
29			}
30
31			/**
32			* Up migration
33			*
34			* @param \Doctrine\DBAL\Schema\Schema $schema
35			*/
36			public function up(Schema $schema)
37			{
38			$this->acl->up($schema);
39			$this->addSql('ALTER TABLE app_anonymous_role ADD entity_uuids JSON DEFAULT NULL');
40			$this->addSql('COMMENT ON COLUMN app_anonymous_role.entity_uuids IS \'(DC2Type:json_array)\'');
41			$this->addSql('ALTER TABLE app_individual_role ADD entity_uuids JSON DEFAULT NULL');
42			$this->addSql('COMMENT ON COLUMN app_individual_role.entity_uuids IS \'(DC2Type:json_array)\'');
43			$this->addSql('ALTER TABLE app_organization_role ADD entity_uuids JSON DEFAULT NULL');
44			$this->addSql('COMMENT ON COLUMN app_organization_role.entity_uuids IS \'(DC2Type:json_array)\'');
45			$this->addSql('ALTER TABLE app_staff_role ADD entity_uuids JSON DEFAULT NULL');
46			$this->addSql('COMMENT ON COLUMN app_staff_role.entity_uuids IS \'(DC2Type:json_array)\'');
47			$this->addSql('ALTER TABLE app_system_role ADD entity_uuids JSON DEFAULT NULL');
48			$this->addSql('COMMENT ON COLUMN app_system_role.entity_uuids IS \'(DC2Type:json_array)\'');
49			$this->addSql('
50			UPDATE
51			app_anonymous_role
52			SET
53			entity_uuids = (
54			SELECT
55			array_to_json(array_agg(app_bu.uuid))
56			FROM
57			app_anonymous_role_bu
58			INNER JOIN
59			app_bu ON
60			app_bu.id = app_anonymous_role_bu.business_unit_id
61			WHERE
62			app_anonymous_role_bu.anonymous_role_id = app_anonymous_role.id
63			)
64			');
65			$this->addSql('UPDATE app_anonymous_role SET entity_uuids = \'[]\' WHERE entity_uuids IS NULL');
66			$this->addSql('
67			UPDATE
68			app_individual_role
69			SET
70			entity_uuids = (
71			SELECT
72			array_to_json(array_agg(app_bu.uuid))
73			FROM
74			app_individual_role_bu
75			INNER JOIN
76			app_bu ON
77			app_bu.id = app_individual_role_bu.business_unit_id
78			WHERE
79			app_individual_role_bu.individual_role_id = app_individual_role.id
80			)
81			');
82			$this->addSql('UPDATE app_individual_role SET entity_uuids = \'[]\' WHERE entity_uuids IS NULL');
83			$this->addSql('
84			UPDATE
85			app_organization_role
86			SET
87			entity_uuids = (
88			SELECT
89			array_to_json(array_agg(app_bu.uuid))
90			FROM
91			app_organization_role_bu
92			INNER JOIN
93			app_bu ON
94			app_bu.id = app_organization_role_bu.business_unit_id
95			WHERE
96			app_organization_role_bu.organization_role_id = app_organization_role.id
97			)
98			');
99			$this->addSql('UPDATE app_organization_role SET entity_uuids = \'[]\' WHERE entity_uuids IS NULL');
100			$this->addSql('
101			UPDATE
102			app_staff_role
103			SET
104			entity_uuids = (
105			SELECT
106			array_to_json(array_agg(app_bu.uuid))
107			FROM
108			app_staff_role_bu
109			INNER JOIN
110			app_bu ON
111			app_bu.id = app_staff_role_bu.business_unit_id
112			WHERE
113			app_staff_role_bu.staff_role_id = app_staff_role.id
114			)
115			');
116			$this->addSql('UPDATE app_staff_role SET entity_uuids = \'[]\' WHERE entity_uuids IS NULL');
117			$this->addSql('
118			UPDATE
119			app_system_role
120			SET
121			entity_uuids = (
122			SELECT
123			array_to_json(array_agg(app_bu.uuid))
124			FROM
125			app_system_role_bu
126			INNER JOIN
127			app_bu ON
128			app_bu.id = app_system_role_bu.business_unit_id
129			WHERE
130			app_system_role_bu.system_role_id = app_system_role.id
131			)
132			');
133			$this->addSql('UPDATE app_system_role SET entity_uuids = \'[]\' WHERE entity_uuids IS NULL');
134			$this->addSql('ALTER TABLE app_anonymous_role ALTER entity_uuids SET NOT NULL');
135			$this->addSql('ALTER TABLE app_individual_role ALTER entity_uuids SET NOT NULL');
136			$this->addSql('ALTER TABLE app_organization_role ALTER entity_uuids SET NOT NULL');
137			$this->addSql('ALTER TABLE app_staff_role ALTER entity_uuids SET NOT NULL');
138			$this->addSql('ALTER TABLE app_system_role ALTER entity_uuids SET NOT NULL');
139			$this->addSql('DROP TABLE app_anonymous_role_bu');
140			$this->addSql('DROP TABLE app_individual_role_bu');
141			$this->addSql('DROP TABLE app_organization_role_bu');
142			$this->addSql('DROP TABLE app_staff_role_bu');
143			$this->addSql('DROP TABLE app_system_role_bu');
144			}
145
146			/**
147			* Down migration
148			*
149			* @param \Doctrine\DBAL\Schema\Schema $schema
150			*/
151			public function down(Schema $schema)
152			{
153			$this->acl->down($schema);
154			$this->addSql('CREATE TABLE app_anonymous_role_bu (anonymous_role_id INT NOT NULL, business_unit_id INT NOT NULL, PRIMARY KEY(anonymous_role_id, business_unit_id))');
155			$this->addSql('CREATE INDEX IDX_B09CAAD23089E0B ON app_anonymous_role_bu (anonymous_role_id)');
156			$this->addSql('CREATE INDEX IDX_B09CAADA58ECB40 ON app_anonymous_role_bu (business_unit_id)');
157			$this->addSql('CREATE TABLE app_individual_role_bu (individual_role_id INT NOT NULL, business_unit_id INT NOT NULL, PRIMARY KEY(individual_role_id, business_unit_id))');
158			$this->addSql('CREATE INDEX IDX_68A9160EFDFA321 ON app_individual_role_bu (individual_role_id)');
159			$this->addSql('CREATE INDEX IDX_68A9160A58ECB40 ON app_individual_role_bu (business_unit_id)');
160			$this->addSql('CREATE TABLE app_organization_role_bu (organization_role_id INT NOT NULL, business_unit_id INT NOT NULL, PRIMARY KEY(organization_role_id, business_unit_id))');
161			$this->addSql('CREATE INDEX IDX_79C5DB011BD1AAEF ON app_organization_role_bu (organization_role_id)');
162			$this->addSql('CREATE INDEX IDX_79C5DB01A58ECB40 ON app_organization_role_bu (business_unit_id)');
163			$this->addSql('CREATE TABLE app_staff_role_bu (staff_role_id INT NOT NULL, business_unit_id INT NOT NULL, PRIMARY KEY(staff_role_id, business_unit_id))');
164			$this->addSql('CREATE INDEX IDX_998CF18F8AB5351A ON app_staff_role_bu (staff_role_id)');
165			$this->addSql('CREATE INDEX IDX_998CF18FA58ECB40 ON app_staff_role_bu (business_unit_id)');
166			$this->addSql('CREATE TABLE app_system_role_bu (system_role_id INT NOT NULL, business_unit_id INT NOT NULL, PRIMARY KEY(system_role_id, business_unit_id))');
167			$this->addSql('CREATE INDEX IDX_6CCE35F83A705E3F ON app_system_role_bu (system_role_id)');
168			$this->addSql('CREATE INDEX IDX_6CCE35F8A58ECB40 ON app_system_role_bu (business_unit_id)');
169			$this->addSql('
170			INSERT INTO app_anonymous_role_bu (
171			anonymous_role_id,
172			business_unit_id
173			)
174			SELECT
175			app_anonymous_role.id,
176			app_bu.id
177			FROM
178			app_anonymous_role,
179			app_bu
180			WHERE
181			app_anonymous_role.entity_uuids::text LIKE CONCAT(\'%\', app_bu.uuid, \'%\')
182			');
183			$this->addSql('
184			INSERT INTO app_individual_role_bu (
185			individual_role_id,
186			business_unit_id
187			)
188			SELECT
189			app_individual_role.id,
190			app_bu.id
191			FROM
192			app_individual_role,
193			app_bu
194			WHERE
195			app_individual_role.entity_uuids::text LIKE CONCAT(\'%\', app_bu.uuid, \'%\')
196			');
197			$this->addSql('
198			INSERT INTO app_organization_role_bu (
199			organization_role_id,
200			business_unit_id
201			)
202			SELECT
203			app_organization_role.id,
204			app_bu.id
205			FROM
206			app_organization_role,
207			app_bu
208			WHERE
209			app_organization_role.entity_uuids::text LIKE CONCAT(\'%\', app_bu.uuid, \'%\')
210			');
211			$this->addSql('
212			INSERT INTO app_staff_role_bu (
213			staff_role_id,
214			business_unit_id
215			)
216			SELECT
217			app_staff_role.id,
218			app_bu.id
219			FROM
220			app_staff_role,
221			app_bu
222			WHERE
223			app_staff_role.entity_uuids::text LIKE CONCAT(\'%\', app_bu.uuid, \'%\')
224			');
225			$this->addSql('
226			INSERT INTO app_system_role_bu (
227			system_role_id,
228			business_unit_id
229			)
230			SELECT
231			app_system_role.id,
232			app_bu.id
233			FROM
234			app_system_role,
235			app_bu
236			WHERE
237			app_system_role.entity_uuids::text LIKE CONCAT(\'%\', app_bu.uuid, \'%\')
238			');
239			$this->addSql('ALTER TABLE app_anonymous_role DROP entity_uuids');
240			$this->addSql('ALTER TABLE app_individual_role DROP entity_uuids');
241			$this->addSql('ALTER TABLE app_organization_role DROP entity_uuids');
242			$this->addSql('ALTER TABLE app_staff_role DROP entity_uuids');
243			$this->addSql('ALTER TABLE app_system_role DROP entity_uuids');
244			}
245			}
246

DigitalState / Identities

Pull Request — develop (#54)

Version0_19_0::down() A

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like