Version20170625123000::up() - Code Metrics - Inspection of "Migrations: Add thematic + attendance changes" - chamilo/chamilo-lms - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 221dc3...6b1522 )

by Julito

created 2021-02-20 19:04 UTC

Version20170625123000::up() F

↳ Parent: Version20170625123000

Complexity

Conditions	30
Paths	> 20000

Size

Total Lines	144
Code Lines	76

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	30
eloc	76
nc	536870912
nop	1
dl	0
loc	144
rs	0
c	1
b	0
f	0

How to fix Long Method Complexity

<?php

/* For licensing terms, see /license.txt */

namespace Chamilo\CoreBundle\Migrations\Schema\V200;

use Chamilo\CoreBundle\Migrations\AbstractMigrationChamilo;
use Doctrine\DBAL\Schema\Schema;

/**
 * c_attendance.
 */
class Version20170625123000 extends AbstractMigrationChamilo
{
    public function up(Schema $schema): void
    {
        $em = $this->getEntityManager();
        $container = $this->getContainer();

        // CAttendance
        $table = $schema->getTable('c_attendance');
        if ($table->hasIndex('course')) {
            $this->addSql('DROP INDEX course ON c_attendance');
        }
        if ($table->hasIndex('session_id')) {
            $this->addSql('DROP INDEX session_id ON c_attendance');
        }

        $this->addSql('ALTER TABLE c_attendance CHANGE active active INT NOT NULL');

        if (false === $table->hasColumn('resource_node_id')) {
            $this->addSql('ALTER TABLE c_attendance ADD resource_node_id INT DEFAULT NULL');
            $this->addSql('ALTER TABLE c_attendance ADD CONSTRAINT FK_413634921BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id) ON DELETE CASCADE');
            $this->addSql('CREATE UNIQUE INDEX UNIQ_413634921BAD783F ON c_attendance (resource_node_id)');
        }

        $table = $schema->getTable('c_attendance_calendar');
        if ($table->hasIndex('course')) {
            $this->addSql('DROP INDEX course ON c_attendance_calendar');
        }

        if ($table->hasIndex('attendance_id')) {
            $this->addSql('DROP INDEX attendance_id ON c_attendance_calendar');
        }

        $this->addSql('ALTER TABLE c_attendance_calendar CHANGE attendance_id attendance_id INT DEFAULT NULL;');

        if (false === $table->hasForeignKey('FK_AA3A9AB8163DDA15')) {
            $this->addSql('ALTER TABLE c_attendance_calendar ADD CONSTRAINT FK_AA3A9AB8163DDA15 FOREIGN KEY (attendance_id) REFERENCES c_attendance (iid);');
        }

        if ($table->hasIndex('attendance_id')) {
            $this->addSql('DROP INDEX attendance_id ON c_attendance_calendar');
        }

        if (false === $table->hasIndex('attendance_id')) {
            $this->addSql('CREATE INDEX IDX_AA3A9AB8163DDA15 ON c_attendance_calendar (attendance_id);');
        }

        $table = $schema->getTable('c_attendance_sheet');

        if ($table->hasIndex('course')) {
            $this->addSql('DROP INDEX course ON c_attendance_sheet;');
        }

        if ($table->hasIndex('user')) {
            $this->addSql('DROP INDEX user ON c_attendance_sheet;');
        }

        $this->addSql('UPDATE c_attendance_sheet SET attendance_calendar_id = NULL WHERE attendance_calendar_id = 0;');
        $this->addSql('ALTER TABLE c_attendance_sheet CHANGE user_id user_id INT DEFAULT NULL, CHANGE attendance_calendar_id attendance_calendar_id INT DEFAULT NULL');

        //ALTER TABLE c_attendance_sheet DROP c_id

        if (false === $table->hasForeignKey('FK_AD1394FAA76ED395')) {
            $this->addSql('ALTER TABLE c_attendance_sheet ADD CONSTRAINT FK_AD1394FAA76ED395 FOREIGN KEY (user_id) REFERENCES user (id);');
        }

        if (false === $table->hasForeignKey('FK_AD1394FA19EA43C3')) {
            $this->addSql('ALTER TABLE c_attendance_sheet ADD CONSTRAINT FK_AD1394FA19EA43C3 FOREIGN KEY (attendance_calendar_id) REFERENCES c_attendance_calendar (iid);');
        }

        if (false === $table->hasIndex('IDX_AD1394FA19EA43C3')) {
            $this->addSql('CREATE INDEX IDX_AD1394FA19EA43C3 ON c_attendance_sheet (attendance_calendar_id);');
        }
        if ($table->hasIndex('user')) {
            $this->addSql('DROP INDEX user ON c_attendance_sheet;');
        }

        if (false === $table->hasIndex('IDX_AD1394FAA76ED395')) {
            $this->addSql('CREATE INDEX IDX_AD1394FAA76ED395 ON c_attendance_sheet (user_id);');
        }

        $table = $schema->getTable('c_attendance_result');

        if ($table->hasIndex('course')) {
            $this->addSql('DROP INDEX course ON c_attendance_result');
        }

        $this->addSql('UPDATE c_attendance_result SET attendance_id = NULL WHERE attendance_id = 0;');
        //ALTER TABLE c_attendance_result DROP c_id, ;
        $this->addSql('ALTER TABLE c_attendance_result CHANGE user_id user_id INT DEFAULT NULL, CHANGE attendance_id attendance_id INT DEFAULT NULL ');

        //ALTER TABLE c_attendance_sheet DROP c_id

        if (false === $table->hasForeignKey('FK_2C7640A76ED395')) {
            $this->addSql('ALTER TABLE c_attendance_result ADD CONSTRAINT FK_2C7640A76ED395 FOREIGN KEY (user_id) REFERENCES user (id);');
        }
        if (false === $table->hasForeignKey('FK_2C7640163DDA15')) {
            $this->addSql('ALTER TABLE c_attendance_result ADD CONSTRAINT FK_2C7640163DDA15 FOREIGN KEY (attendance_id) REFERENCES c_attendance (iid);');
        }
        if ($table->hasIndex('user_id')) {
            $this->addSql('DROP INDEX user_id ON c_attendance_result;');
        }
        if (false === $table->hasIndex('IDX_2C7640A76ED395')) {
            $this->addSql('CREATE INDEX IDX_2C7640A76ED395 ON c_attendance_result (user_id);');
        }

        if ($table->hasIndex('attendance_id')) {
            $this->addSql('DROP INDEX attendance_id ON c_attendance_result;');
        }

        if (false === $table->hasIndex('IDX_2C7640163DDA15')) {
            $this->addSql('CREATE INDEX IDX_2C7640163DDA15 ON c_attendance_result (attendance_id);');
        }

        $table = $schema->getTable('c_attendance_calendar_rel_group');

        if ($table->hasIndex('course')) {
            $this->addSql('DROP INDEX course ON c_attendance_calendar_rel_group');
        }

        //ALTER TABLE c_attendance_calendar_rel_group DROP c_id,
        $this->addSql('UPDATE c_attendance_calendar_rel_group SET group_id = NULL WHERE group_id = 0');
        $this->addSql('UPDATE c_attendance_calendar_rel_group SET calendar_id = NULL WHERE calendar_id = 0');
        $this->addSql('ALTER TABLE c_attendance_calendar_rel_group CHANGE group_id group_id INT DEFAULT NULL, CHANGE calendar_id calendar_id INT DEFAULT NULL;');

        if ($table->hasIndex('course')) {
            $this->addSql('DROP INDEX course ON c_attendance_calendar_rel_group');
        }

        if (false === $table->hasForeignKey('FK_C2AB1FACFE54D947')) {
            $this->addSql('ALTER TABLE c_attendance_calendar_rel_group ADD CONSTRAINT FK_C2AB1FACFE54D947 FOREIGN KEY (group_id) REFERENCES c_group_info (iid);');
        }

        if (false === $table->hasForeignKey('FK_C2AB1FACA40A2C8')) {
            $this->addSql('ALTER TABLE c_attendance_calendar_rel_group ADD CONSTRAINT FK_C2AB1FACA40A2C8 FOREIGN KEY (calendar_id) REFERENCES c_attendance_calendar (iid);');
        }

        if (false === $table->hasIndex('IDX_C2AB1FACA40A2C8')) {
            $this->addSql('CREATE INDEX IDX_C2AB1FACA40A2C8 ON c_attendance_calendar_rel_group (calendar_id);');
        }

        if ($table->hasIndex('group')) {
            $this->addSql('DROP INDEX `group` ON c_attendance_calendar_rel_group;');
        }
        if (false === $table->hasIndex('IDX_C2AB1FACFE54D947')) {
            $this->addSql('CREATE INDEX IDX_C2AB1FACFE54D947 ON c_attendance_calendar_rel_group (group_id);');
        }
    }

    public function down(Schema $schema): void
    {
    }
}


1			<?php
2
3			/* For licensing terms, see /license.txt */
4
5			namespace Chamilo\CoreBundle\Migrations\Schema\V200;
6
7			use Chamilo\CoreBundle\Migrations\AbstractMigrationChamilo;
8			use Doctrine\DBAL\Schema\Schema;
9
10			/**
11			* c_attendance.
12			*/
13			class Version20170625123000 extends AbstractMigrationChamilo
14			{
15			public function up(Schema $schema): void
16			{
17			$em = $this->getEntityManager();
18			$container = $this->getContainer();
19
20			// CAttendance
21			$table = $schema->getTable('c_attendance');
22			if ($table->hasIndex('course')) {
23			$this->addSql('DROP INDEX course ON c_attendance');
24			}
25			if ($table->hasIndex('session_id')) {
26			$this->addSql('DROP INDEX session_id ON c_attendance');
27			}
28
29			$this->addSql('ALTER TABLE c_attendance CHANGE active active INT NOT NULL');
30
31			if (false === $table->hasColumn('resource_node_id')) {
32			$this->addSql('ALTER TABLE c_attendance ADD resource_node_id INT DEFAULT NULL');
33			$this->addSql('ALTER TABLE c_attendance ADD CONSTRAINT FK_413634921BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id) ON DELETE CASCADE');
34			$this->addSql('CREATE UNIQUE INDEX UNIQ_413634921BAD783F ON c_attendance (resource_node_id)');
35			}
36
37			$table = $schema->getTable('c_attendance_calendar');
38			if ($table->hasIndex('course')) {
39			$this->addSql('DROP INDEX course ON c_attendance_calendar');
40			}
41
42			if ($table->hasIndex('attendance_id')) {
43			$this->addSql('DROP INDEX attendance_id ON c_attendance_calendar');
44			}
45
46			$this->addSql('ALTER TABLE c_attendance_calendar CHANGE attendance_id attendance_id INT DEFAULT NULL;');
47
48			if (false === $table->hasForeignKey('FK_AA3A9AB8163DDA15')) {
49			$this->addSql('ALTER TABLE c_attendance_calendar ADD CONSTRAINT FK_AA3A9AB8163DDA15 FOREIGN KEY (attendance_id) REFERENCES c_attendance (iid);');
50			}
51
52			if ($table->hasIndex('attendance_id')) {
53			$this->addSql('DROP INDEX attendance_id ON c_attendance_calendar');
54			}
55
56			if (false === $table->hasIndex('attendance_id')) {
57			$this->addSql('CREATE INDEX IDX_AA3A9AB8163DDA15 ON c_attendance_calendar (attendance_id);');
58			}
59
60			$table = $schema->getTable('c_attendance_sheet');
61
62			if ($table->hasIndex('course')) {
63			$this->addSql('DROP INDEX course ON c_attendance_sheet;');
64			}
65
66			if ($table->hasIndex('user')) {
67			$this->addSql('DROP INDEX user ON c_attendance_sheet;');
68			}
69
70			$this->addSql('UPDATE c_attendance_sheet SET attendance_calendar_id = NULL WHERE attendance_calendar_id = 0;');
71			$this->addSql('ALTER TABLE c_attendance_sheet CHANGE user_id user_id INT DEFAULT NULL, CHANGE attendance_calendar_id attendance_calendar_id INT DEFAULT NULL');
72
73			//ALTER TABLE c_attendance_sheet DROP c_id
74
75			if (false === $table->hasForeignKey('FK_AD1394FAA76ED395')) {
76			$this->addSql('ALTER TABLE c_attendance_sheet ADD CONSTRAINT FK_AD1394FAA76ED395 FOREIGN KEY (user_id) REFERENCES user (id);');
77			}
78
79			if (false === $table->hasForeignKey('FK_AD1394FA19EA43C3')) {
80			$this->addSql('ALTER TABLE c_attendance_sheet ADD CONSTRAINT FK_AD1394FA19EA43C3 FOREIGN KEY (attendance_calendar_id) REFERENCES c_attendance_calendar (iid);');
81			}
82
83			if (false === $table->hasIndex('IDX_AD1394FA19EA43C3')) {
84			$this->addSql('CREATE INDEX IDX_AD1394FA19EA43C3 ON c_attendance_sheet (attendance_calendar_id);');
85			}
86			if ($table->hasIndex('user')) {
87			$this->addSql('DROP INDEX user ON c_attendance_sheet;');
88			}
89
90			if (false === $table->hasIndex('IDX_AD1394FAA76ED395')) {
91			$this->addSql('CREATE INDEX IDX_AD1394FAA76ED395 ON c_attendance_sheet (user_id);');
92			}
93
94			$table = $schema->getTable('c_attendance_result');
95
96			if ($table->hasIndex('course')) {
97			$this->addSql('DROP INDEX course ON c_attendance_result');
98			}
99
100			$this->addSql('UPDATE c_attendance_result SET attendance_id = NULL WHERE attendance_id = 0;');
101			//ALTER TABLE c_attendance_result DROP c_id, ;
102			$this->addSql('ALTER TABLE c_attendance_result CHANGE user_id user_id INT DEFAULT NULL, CHANGE attendance_id attendance_id INT DEFAULT NULL ');
103
104			//ALTER TABLE c_attendance_sheet DROP c_id
105
106			if (false === $table->hasForeignKey('FK_2C7640A76ED395')) {
107			$this->addSql('ALTER TABLE c_attendance_result ADD CONSTRAINT FK_2C7640A76ED395 FOREIGN KEY (user_id) REFERENCES user (id);');
108			}
109			if (false === $table->hasForeignKey('FK_2C7640163DDA15')) {
110			$this->addSql('ALTER TABLE c_attendance_result ADD CONSTRAINT FK_2C7640163DDA15 FOREIGN KEY (attendance_id) REFERENCES c_attendance (iid);');
111			}
112			if ($table->hasIndex('user_id')) {
113			$this->addSql('DROP INDEX user_id ON c_attendance_result;');
114			}
115			if (false === $table->hasIndex('IDX_2C7640A76ED395')) {
116			$this->addSql('CREATE INDEX IDX_2C7640A76ED395 ON c_attendance_result (user_id);');
117			}
118
119			if ($table->hasIndex('attendance_id')) {
120			$this->addSql('DROP INDEX attendance_id ON c_attendance_result;');
121			}
122
123			if (false === $table->hasIndex('IDX_2C7640163DDA15')) {
124			$this->addSql('CREATE INDEX IDX_2C7640163DDA15 ON c_attendance_result (attendance_id);');
125			}
126
127			$table = $schema->getTable('c_attendance_calendar_rel_group');
128
129			if ($table->hasIndex('course')) {
130			$this->addSql('DROP INDEX course ON c_attendance_calendar_rel_group');
131			}
132
133			//ALTER TABLE c_attendance_calendar_rel_group DROP c_id,
134			$this->addSql('UPDATE c_attendance_calendar_rel_group SET group_id = NULL WHERE group_id = 0');
135			$this->addSql('UPDATE c_attendance_calendar_rel_group SET calendar_id = NULL WHERE calendar_id = 0');
136			$this->addSql('ALTER TABLE c_attendance_calendar_rel_group CHANGE group_id group_id INT DEFAULT NULL, CHANGE calendar_id calendar_id INT DEFAULT NULL;');
137
138			if ($table->hasIndex('course')) {
139			$this->addSql('DROP INDEX course ON c_attendance_calendar_rel_group');
140			}
141
142			if (false === $table->hasForeignKey('FK_C2AB1FACFE54D947')) {
143			$this->addSql('ALTER TABLE c_attendance_calendar_rel_group ADD CONSTRAINT FK_C2AB1FACFE54D947 FOREIGN KEY (group_id) REFERENCES c_group_info (iid);');
144			}
145
146			if (false === $table->hasForeignKey('FK_C2AB1FACA40A2C8')) {
147			$this->addSql('ALTER TABLE c_attendance_calendar_rel_group ADD CONSTRAINT FK_C2AB1FACA40A2C8 FOREIGN KEY (calendar_id) REFERENCES c_attendance_calendar (iid);');
148			}
149
150			if (false === $table->hasIndex('IDX_C2AB1FACA40A2C8')) {
151			$this->addSql('CREATE INDEX IDX_C2AB1FACA40A2C8 ON c_attendance_calendar_rel_group (calendar_id);');
152			}
153
154			if ($table->hasIndex('group')) {
155			$this->addSql('DROP INDEX `group` ON c_attendance_calendar_rel_group;');
156			}
157			if (false === $table->hasIndex('IDX_C2AB1FACFE54D947')) {
158			$this->addSql('CREATE INDEX IDX_C2AB1FACFE54D947 ON c_attendance_calendar_rel_group (group_id);');
159			}
160			}
161
162			public function down(Schema $schema): void
163			{
164			}
165			}
166

chamilo / chamilo-lms

Push — master ( 221dc3...6b1522 )

Version20170625123000::up() F

Complexity

Size

Duplication

Importance

How to fix Long Method Complexity

Long Method

Duplication Side-by-Side

Filter issues like