Version20230508153435::up() - Code Metrics - Inspection of "Merge branch 'master' of github.com:chamilo/chamil..." - chamilo/chamilo-lms - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 727abb...ceefce )

by Yannick

created 2024-01-14 23:53 UTC

Version20230508153435::up() F

↳ Parent: Version20230508153435

Complexity

Conditions	48
Paths	0

Size

Total Lines	294
Code Lines	149

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	1

Metric	Value
cc	48
eloc	149
nc	0
nop	1
dl	0
loc	294
rs	3.3333
c	1
b	0
f	1

How to fix Long Method Complexity

<?php

declare(strict_types=1);

namespace Chamilo\CoreBundle\Migrations\Schema\V200;

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

final class Version20230508153435 extends AbstractMigrationChamilo
{
    public function getDescription(): string
    {
        return 'Replace "name" with "title" fields in tables';
    }

    public function up(Schema $schema): void
    {
        if ($schema->hasTable('block')) {
            $this->addSql(
                'ALTER TABLE block CHANGE name title varchar(255) COLLATE "utf8_unicode_ci" NULL'
            );
        }

        if ($schema->hasTable('branch_sync')) {
            $this->addSql(
                'ALTER TABLE branch_sync CHANGE branch_name title VARCHAR(250) NOT NULL'
            );
        }

        if ($schema->hasTable('c_attendance')) {
            $this->addSql(
                'ALTER TABLE c_attendance CHANGE name title LONGTEXT NOT NULL'
            );
        }

        if ($schema->hasTable('c_blog')) {
            $this->addSql(
                'ALTER TABLE c_blog CHANGE blog_name title LONGTEXT NOT NULL'
            );
        }

        if ($schema->hasTable('c_dropbox_category')) {
            $this->addSql(
                'ALTER TABLE c_dropbox_category CHANGE cat_name title LONGTEXT NOT NULL'
            );
        }

        if ($schema->hasTable('c_exercise_category')) {
            $this->addSql(
                'ALTER TABLE c_exercise_category CHANGE name title VARCHAR(255) NOT NULL'
            );
        }

        if ($schema->hasTable('c_forum_category')) {
            $this->addSql(
                'ALTER TABLE c_forum_category CHANGE cat_title title VARCHAR(255) NOT NULL'
            );
        }

        if ($schema->hasTable('c_forum_forum')) {
            $this->addSql(
                'ALTER TABLE c_forum_forum CHANGE forum_title title VARCHAR(255) NOT NULL'
            );
        }

        if ($schema->hasTable('c_forum_post')) {
            $this->addSql(
                'ALTER TABLE c_forum_post CHANGE post_title title VARCHAR(250) NOT NULL'
            );
        }

        if ($schema->hasTable('c_forum_thread')) {
            $this->addSql(
                'ALTER TABLE c_forum_thread CHANGE thread_title title VARCHAR(255) NOT NULL'
            );
        }

        if ($schema->hasTable('c_glossary')) {
            $this->addSql(
                'ALTER TABLE c_glossary CHANGE name title LONGTEXT NOT NULL'
            );
        }

        if ($schema->hasTable('c_group_info')) {
            $this->addSql(
                'ALTER TABLE c_group_info CHANGE name title VARCHAR(100) NOT NULL'
            );
        }

        if ($schema->hasTable('c_link_category')) {
            $this->addSql(
                'ALTER TABLE c_link_category CHANGE category_title title VARCHAR(255) NOT NULL'
            );
        }

        if ($schema->hasTable('c_lp')) {
            $this->addSql(
                'ALTER TABLE c_lp CHANGE name title VARCHAR(255) NOT NULL'
            );
        }

        if ($schema->hasTable('c_lp_category')) {
            $this->addSql(
                'ALTER TABLE c_lp_category CHANGE name title LONGTEXT NOT NULL'
            );
        }

        if ($schema->hasTable('c_online_link')) {
            $this->addSql(
                'ALTER TABLE c_online_link CHANGE name title VARCHAR(50) NOT NULL'
            );
        }

        if ($schema->hasTable('c_quiz_question_option')) {
            $this->addSql(
                'ALTER TABLE c_quiz_question_option CHANGE name title VARCHAR(255) NOT NULL'
            );
        }

        if ($schema->hasTable('c_survey_group')) {
            $this->addSql(
                'ALTER TABLE c_survey_group CHANGE name title VARCHAR(100) NOT NULL'
            );
        }

        if ($schema->hasTable('c_tool')) {
            $this->addSql(
                'ALTER TABLE c_tool CHANGE name title LONGTEXT NOT NULL'
            );
        }

        if ($schema->hasTable('career')) {
            $this->addSql(
                'ALTER TABLE career CHANGE name title VARCHAR(255) NOT NULL'
            );
        }

        if ($schema->hasTable('chat_video')) {
            $this->addSql(
                'DROP INDEX idx_chat_video_room_name ON chat_video'
            );
            $this->addSql(
                'ALTER TABLE chat_video CHANGE room_name title VARCHAR(255) NOT NULL'
            );
            $this->addSql(
                'CREATE INDEX idx_chat_video_title ON chat_video (title)'
            );
        }

        if ($schema->hasTable('class_item')) {
            $this->addSql(
                'ALTER TABLE class_item CHANGE name title LONGTEXT NOT NULL'
            );
        }

        if ($schema->hasTable('course_category')) {
            $this->addSql(
                'ALTER TABLE course_category CHANGE name title LONGTEXT NOT NULL'
            );
        }

        if ($schema->hasTable('course_module')) {
            $this->addSql(
                'ALTER TABLE course_module CHANGE name title VARCHAR(255) NOT NULL'
            );
        }

        if ($schema->hasTable('course_type')) {
            $this->addSql(
                'ALTER TABLE course_type CHANGE name title VARCHAR(50) NOT NULL'
            );
        }

        if ($schema->hasTable('grade_model')) {
            $this->addSql(
                'ALTER TABLE grade_model CHANGE name title VARCHAR(255) NOT NULL'
            );
        }

        if ($schema->hasTable('gradebook_linkeval_log')) {
            $this->addSql(
                'ALTER TABLE gradebook_linkeval_log CHANGE name title LONGTEXT NOT NULL'
            );
        }

        if ($schema->hasTable('gradebook_category')) {
            $this->addSql(
                'ALTER TABLE gradebook_category CHANGE name title LONGTEXT NOT NULL'
            );
        }

        if ($schema->hasTable('gradebook_evaluation')) {
            $this->addSql(
                'ALTER TABLE gradebook_evaluation CHANGE name title LONGTEXT NOT NULL'
            );
        }

        if ($schema->hasTable('mail_template')) {
            $this->addSql(
                'ALTER TABLE mail_template CHANGE name title VARCHAR(255) NOT NULL'
            );
        }

        if ($schema->hasTable('usergroup')) {
            $this->addSql(
                'ALTER TABLE usergroup CHANGE name title VARCHAR(255) NOT NULL'
            );
        }

        if ($schema->hasTable('sequence_row_entity')) {
            $this->addSql(
                'ALTER TABLE sequence_row_entity CHANGE name title VARCHAR(255) NOT NULL'
            );
        }

        if ($schema->hasTable('ticket_project')) {
            $this->addSql(
                'ALTER TABLE ticket_project CHANGE name title VARCHAR(255) NOT NULL'
            );
        }

        if ($schema->hasTable('skill')) {
            $this->addSql(
                'ALTER TABLE skill CHANGE name title VARCHAR(255) NOT NULL'
            );
        }

        if ($schema->hasTable('sequence_variable')) {
            $this->addSql(
                'ALTER TABLE sequence_variable CHANGE name title VARCHAR(255) DEFAULT NULL'
            );
        }


        if ($schema->hasTable('specific_field')) {
            $this->addSql(
                'ALTER TABLE specific_field CHANGE name title VARCHAR(200) NOT NULL'
            );
        }

        if ($schema->hasTable('ticket_priority')) {
            $this->addSql(
                'ALTER TABLE ticket_priority CHANGE name title VARCHAR(255) NOT NULL'
            );
        }

        if ($schema->hasTable('sequence_type_entity')) {
            $this->addSql(
                'ALTER TABLE sequence_type_entity CHANGE name title VARCHAR(255) NOT NULL'
            );
        }

        if ($schema->hasTable('promotion')) {
            $this->addSql(
                'ALTER TABLE promotion CHANGE name title VARCHAR(255) NOT NULL'
            );
        }

        if ($schema->hasTable('sequence')) {
            $this->addSql(
                'ALTER TABLE sequence CHANGE name title VARCHAR(255) NOT NULL'
            );
        }

        if ($schema->hasTable('ticket_category')) {
            $this->addSql(
                'ALTER TABLE ticket_category CHANGE name title VARCHAR(255) NOT NULL'
            );
        }

        if ($schema->hasTable('session')) {
            $this->addSql(
                'DROP INDEX name ON session'
            );
            $this->addSql(
                'ALTER TABLE session CHANGE name title VARCHAR(150) NOT NULL'
            );
            $this->addSql(
                'CREATE UNIQUE INDEX title ON session (title)'
            );
        }

        if ($schema->hasTable('skill_profile')) {
            $this->addSql(
                'ALTER TABLE skill_profile CHANGE name title VARCHAR(255) NOT NULL'
            );
        }

        if ($schema->hasTable('ticket_status')) {
            $this->addSql(
                'ALTER TABLE ticket_status CHANGE name title VARCHAR(255) NOT NULL'
            );
        }

        if ($schema->hasTable('session_category')) {
            $this->addSql(
                'ALTER TABLE session_category CHANGE name title VARCHAR(100) NOT NULL'
            );
        }

        if ($schema->hasTable('skill_level')) {
            $this->addSql(
                'ALTER TABLE skill_level CHANGE name title VARCHAR(255) NOT NULL'
            );
        }

        if ($schema->hasTable('skill_level_profile')) {
            $this->addSql(
                'ALTER TABLE skill_level_profile CHANGE name title VARCHAR(255) NOT NULL'
            );
        }

    }

    public function down(Schema $schema): void
    {
        $table = $schema->getTable('skill_level_profile');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE skill_level_profile CHANGE title name VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('skill_level');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE skill_level CHANGE title name VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('session_category');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE session_category CHANGE title name VARCHAR(100) NOT NULL');
        }

        $table = $schema->getTable('ticket_status');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE ticket_status CHANGE title name VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('skill_profile');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE skill_profile CHANGE title name VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('session');
        if ($table->hasColumn('title')) {
            $this->addSql('DROP INDEX title ON session');
            $this->addSql('ALTER TABLE session CHANGE title name VARCHAR(150) NOT NULL');
            $this->addSql('CREATE UNIQUE INDEX name ON session (name)');
        }

        $table = $schema->getTable('ticket_category');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE ticket_category CHANGE title name VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('sequence');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE sequence CHANGE title name VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('promotion');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE promotion CHANGE title name VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('mail_template');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE mail_template CHANGE title name VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('sequence_type_entity');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE sequence_type_entity CHANGE title name VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('ticket_priority');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE ticket_priority CHANGE title name VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('specific_field');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE specific_field CHANGE title name VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('sequence_variable');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE sequence_variable CHANGE title name VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('skill');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE skill CHANGE title name VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('ticket_project');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE ticket_project CHANGE title name VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('sequence_row_entity');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE sequence_row_entity CHANGE title name VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('usergroup');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE usergroup CHANGE title name VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('gradebook_evaluation');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE gradebook_evaluation CHANGE title name LONGTEXT NOT NULL');
        }

        $table = $schema->getTable('gradebook_category');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE gradebook_category CHANGE title name LONGTEXT NOT NULL');
        }

        $table = $schema->getTable('gradebook_linkeval_log');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE gradebook_linkeval_log CHANGE title name LONGTEXT NOT NULL');
        }

        $table = $schema->getTable('grade_model');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE grade_model CHANGE title name VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('course_type');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE course_type CHANGE title name VARCHAR(50) NOT NULL');
        }

        $table = $schema->getTable('course_module');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE course_module CHANGE title name VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('course_category');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE course_category CHANGE title name LONGTEXT NOT NULL');
        }

        $table = $schema->getTable('class_item');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE class_item CHANGE title name LONGTEXT NOT NULL');
        }

        $table = $schema->getTable('chat_video');
        if ($table->hasColumn('title')) {
            $this->addSql(
                'DROP INDEX idx_chat_video_title ON chat_video'
            );
            $this->addSql(
                'ALTER TABLE chat_video CHANGE title room_name VARCHAR(255) NOT NULL'
            );
            $this->addSql(
                'CREATE INDEX idx_chat_video_room_name ON chat_video (room_name)'
            );
        }

        $table = $schema->getTable('career');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE career CHANGE title name VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('c_tool');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE c_tool CHANGE title name LONGTEXT NOT NULL');
        }

        $table = $schema->getTable('c_survey_group');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE c_survey_group CHANGE title name VARCHAR(20) NOT NULL');
        }

        $table = $schema->getTable('c_quiz_question_option');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE c_quiz_question_option CHANGE title name VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('c_online_link');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE c_online_link CHANGE title name VARCHAR(50) NOT NULL');
        }

        $table = $schema->getTable('c_lp_category');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE c_lp_category CHANGE title name LONGTEXT NOT NULL');
        }

        $table = $schema->getTable('c_lp');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE c_lp CHANGE title name VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('c_link_category');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE c_link_category CHANGE title category_title VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('c_group_info');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE c_group_info CHANGE title name VARCHAR(100) NOT NULL');
        }

        $table = $schema->getTable('c_glossary');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE c_glossary CHANGE title name LONGTEXT NOT NULL');
        }

        $table = $schema->getTable('c_forum_thread');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE c_forum_thread CHANGE title thread_title VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('c_forum_post');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE c_forum_post CHANGE title post_title VARCHAR(250) NOT NULL');
        }

        $table = $schema->getTable('c_forum_forum');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE c_forum_forum CHANGE title forum_title VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('c_forum_category');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE c_forum_category CHANGE title cat_title VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('c_exercise_category');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE c_exercise_category CHANGE title name VARCHAR(255) NOT NULL');
        }

        $table = $schema->getTable('c_dropbox_category');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE c_dropbox_category CHANGE title cat_name LONGTEXT NOT NULL');
        }

        $table = $schema->getTable('c_blog');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE c_blog CHANGE title blog_name LONGTEXT NOT NULL');
        }

        $table = $schema->getTable('c_attendance');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE c_attendance CHANGE title name LONGTEXT NOT NULL');
        }

        $table = $schema->getTable('branch_sync');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE branch_sync CHANGE title branch_name VARCHAR(250) NOT NULL');
        }

        $table = $schema->getTable('block');
        if ($table->hasColumn('title')) {
            $this->addSql('ALTER TABLE block CHANGE title name varchar(255) COLLATE "utf8_unicode_ci" NULL');
        }
    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			namespace Chamilo\CoreBundle\Migrations\Schema\V200;
6
7			use Chamilo\CoreBundle\Migrations\AbstractMigrationChamilo;
8			use Doctrine\DBAL\Schema\Schema;
9
10			final class Version20230508153435 extends AbstractMigrationChamilo
11			{
12			public function getDescription(): string
13			{
14			return 'Replace "name" with "title" fields in tables';
15			}
16
17			public function up(Schema $schema): void
18			{
19			if ($schema->hasTable('block')) {
20			$this->addSql(
21			'ALTER TABLE block CHANGE name title varchar(255) COLLATE "utf8_unicode_ci" NULL'
22			);
23			}
24
25			if ($schema->hasTable('branch_sync')) {
26			$this->addSql(
27			'ALTER TABLE branch_sync CHANGE branch_name title VARCHAR(250) NOT NULL'
28			);
29			}
30
31			if ($schema->hasTable('c_attendance')) {
32			$this->addSql(
33			'ALTER TABLE c_attendance CHANGE name title LONGTEXT NOT NULL'
34			);
35			}
36
37			if ($schema->hasTable('c_blog')) {
38			$this->addSql(
39			'ALTER TABLE c_blog CHANGE blog_name title LONGTEXT NOT NULL'
40			);
41			}
42
43			if ($schema->hasTable('c_dropbox_category')) {
44			$this->addSql(
45			'ALTER TABLE c_dropbox_category CHANGE cat_name title LONGTEXT NOT NULL'
46			);
47			}
48
49			if ($schema->hasTable('c_exercise_category')) {
50			$this->addSql(
51			'ALTER TABLE c_exercise_category CHANGE name title VARCHAR(255) NOT NULL'
52			);
53			}
54
55			if ($schema->hasTable('c_forum_category')) {
56			$this->addSql(
57			'ALTER TABLE c_forum_category CHANGE cat_title title VARCHAR(255) NOT NULL'
58			);
59			}
60
61			if ($schema->hasTable('c_forum_forum')) {
62			$this->addSql(
63			'ALTER TABLE c_forum_forum CHANGE forum_title title VARCHAR(255) NOT NULL'
64			);
65			}
66
67			if ($schema->hasTable('c_forum_post')) {
68			$this->addSql(
69			'ALTER TABLE c_forum_post CHANGE post_title title VARCHAR(250) NOT NULL'
70			);
71			}
72
73			if ($schema->hasTable('c_forum_thread')) {
74			$this->addSql(
75			'ALTER TABLE c_forum_thread CHANGE thread_title title VARCHAR(255) NOT NULL'
76			);
77			}
78
79			if ($schema->hasTable('c_glossary')) {
80			$this->addSql(
81			'ALTER TABLE c_glossary CHANGE name title LONGTEXT NOT NULL'
82			);
83			}
84
85			if ($schema->hasTable('c_group_info')) {
86			$this->addSql(
87			'ALTER TABLE c_group_info CHANGE name title VARCHAR(100) NOT NULL'
88			);
89			}
90
91			if ($schema->hasTable('c_link_category')) {
92			$this->addSql(
93			'ALTER TABLE c_link_category CHANGE category_title title VARCHAR(255) NOT NULL'
94			);
95			}
96
97			if ($schema->hasTable('c_lp')) {
98			$this->addSql(
99			'ALTER TABLE c_lp CHANGE name title VARCHAR(255) NOT NULL'
100			);
101			}
102
103			if ($schema->hasTable('c_lp_category')) {
104			$this->addSql(
105			'ALTER TABLE c_lp_category CHANGE name title LONGTEXT NOT NULL'
106			);
107			}
108
109			if ($schema->hasTable('c_online_link')) {
110			$this->addSql(
111			'ALTER TABLE c_online_link CHANGE name title VARCHAR(50) NOT NULL'
112			);
113			}
114
115			if ($schema->hasTable('c_quiz_question_option')) {
116			$this->addSql(
117			'ALTER TABLE c_quiz_question_option CHANGE name title VARCHAR(255) NOT NULL'
118			);
119			}
120
121			if ($schema->hasTable('c_survey_group')) {
122			$this->addSql(
123			'ALTER TABLE c_survey_group CHANGE name title VARCHAR(100) NOT NULL'
124			);
125			}
126
127			if ($schema->hasTable('c_tool')) {
128			$this->addSql(
129			'ALTER TABLE c_tool CHANGE name title LONGTEXT NOT NULL'
130			);
131			}
132
133			if ($schema->hasTable('career')) {
134			$this->addSql(
135			'ALTER TABLE career CHANGE name title VARCHAR(255) NOT NULL'
136			);
137			}
138
139			if ($schema->hasTable('chat_video')) {
140			$this->addSql(
141			'DROP INDEX idx_chat_video_room_name ON chat_video'
142			);
143			$this->addSql(
144			'ALTER TABLE chat_video CHANGE room_name title VARCHAR(255) NOT NULL'
145			);
146			$this->addSql(
147			'CREATE INDEX idx_chat_video_title ON chat_video (title)'
148			);
149			}
150
151			if ($schema->hasTable('class_item')) {
152			$this->addSql(
153			'ALTER TABLE class_item CHANGE name title LONGTEXT NOT NULL'
154			);
155			}
156
157			if ($schema->hasTable('course_category')) {
158			$this->addSql(
159			'ALTER TABLE course_category CHANGE name title LONGTEXT NOT NULL'
160			);
161			}
162
163			if ($schema->hasTable('course_module')) {
164			$this->addSql(
165			'ALTER TABLE course_module CHANGE name title VARCHAR(255) NOT NULL'
166			);
167			}
168
169			if ($schema->hasTable('course_type')) {
170			$this->addSql(
171			'ALTER TABLE course_type CHANGE name title VARCHAR(50) NOT NULL'
172			);
173			}
174
175			if ($schema->hasTable('grade_model')) {
176			$this->addSql(
177			'ALTER TABLE grade_model CHANGE name title VARCHAR(255) NOT NULL'
178			);
179			}
180
181			if ($schema->hasTable('gradebook_linkeval_log')) {
182			$this->addSql(
183			'ALTER TABLE gradebook_linkeval_log CHANGE name title LONGTEXT NOT NULL'
184			);
185			}
186
187			if ($schema->hasTable('gradebook_category')) {
188			$this->addSql(
189			'ALTER TABLE gradebook_category CHANGE name title LONGTEXT NOT NULL'
190			);
191			}
192
193			if ($schema->hasTable('gradebook_evaluation')) {
194			$this->addSql(
195			'ALTER TABLE gradebook_evaluation CHANGE name title LONGTEXT NOT NULL'
196			);
197			}
198
199			if ($schema->hasTable('mail_template')) {
200			$this->addSql(
201			'ALTER TABLE mail_template CHANGE name title VARCHAR(255) NOT NULL'
202			);
203			}
204
205			if ($schema->hasTable('usergroup')) {
206			$this->addSql(
207			'ALTER TABLE usergroup CHANGE name title VARCHAR(255) NOT NULL'
208			);
209			}
210
211			if ($schema->hasTable('sequence_row_entity')) {
212			$this->addSql(
213			'ALTER TABLE sequence_row_entity CHANGE name title VARCHAR(255) NOT NULL'
214			);
215			}
216
217			if ($schema->hasTable('ticket_project')) {
218			$this->addSql(
219			'ALTER TABLE ticket_project CHANGE name title VARCHAR(255) NOT NULL'
220			);
221			}
222
223			if ($schema->hasTable('skill')) {
224			$this->addSql(
225			'ALTER TABLE skill CHANGE name title VARCHAR(255) NOT NULL'
226			);
227			}
228
229			if ($schema->hasTable('sequence_variable')) {
230			$this->addSql(
231			'ALTER TABLE sequence_variable CHANGE name title VARCHAR(255) DEFAULT NULL'
232			);
233			}
234
235
236			if ($schema->hasTable('specific_field')) {
237			$this->addSql(
238			'ALTER TABLE specific_field CHANGE name title VARCHAR(200) NOT NULL'
239			);
240			}
241
242			if ($schema->hasTable('ticket_priority')) {
243			$this->addSql(
244			'ALTER TABLE ticket_priority CHANGE name title VARCHAR(255) NOT NULL'
245			);
246			}
247
248			if ($schema->hasTable('sequence_type_entity')) {
249			$this->addSql(
250			'ALTER TABLE sequence_type_entity CHANGE name title VARCHAR(255) NOT NULL'
251			);
252			}
253
254			if ($schema->hasTable('promotion')) {
255			$this->addSql(
256			'ALTER TABLE promotion CHANGE name title VARCHAR(255) NOT NULL'
257			);
258			}
259
260			if ($schema->hasTable('sequence')) {
261			$this->addSql(
262			'ALTER TABLE sequence CHANGE name title VARCHAR(255) NOT NULL'
263			);
264			}
265
266			if ($schema->hasTable('ticket_category')) {
267			$this->addSql(
268			'ALTER TABLE ticket_category CHANGE name title VARCHAR(255) NOT NULL'
269			);
270			}
271
272			if ($schema->hasTable('session')) {
273			$this->addSql(
274			'DROP INDEX name ON session'
275			);
276			$this->addSql(
277			'ALTER TABLE session CHANGE name title VARCHAR(150) NOT NULL'
278			);
279			$this->addSql(
280			'CREATE UNIQUE INDEX title ON session (title)'
281			);
282			}
283
284			if ($schema->hasTable('skill_profile')) {
285			$this->addSql(
286			'ALTER TABLE skill_profile CHANGE name title VARCHAR(255) NOT NULL'
287			);
288			}
289
290			if ($schema->hasTable('ticket_status')) {
291			$this->addSql(
292			'ALTER TABLE ticket_status CHANGE name title VARCHAR(255) NOT NULL'
293			);
294			}
295
296			if ($schema->hasTable('session_category')) {
297			$this->addSql(
298			'ALTER TABLE session_category CHANGE name title VARCHAR(100) NOT NULL'
299			);
300			}
301
302			if ($schema->hasTable('skill_level')) {
303			$this->addSql(
304			'ALTER TABLE skill_level CHANGE name title VARCHAR(255) NOT NULL'
305			);
306			}
307
308			if ($schema->hasTable('skill_level_profile')) {
309			$this->addSql(
310			'ALTER TABLE skill_level_profile CHANGE name title VARCHAR(255) NOT NULL'
311			);
312			}
313
314			}
315
316			public function down(Schema $schema): void
317			{
318			$table = $schema->getTable('skill_level_profile');
319			if ($table->hasColumn('title')) {
320			$this->addSql('ALTER TABLE skill_level_profile CHANGE title name VARCHAR(255) NOT NULL');
321			}
322
323			$table = $schema->getTable('skill_level');
324			if ($table->hasColumn('title')) {
325			$this->addSql('ALTER TABLE skill_level CHANGE title name VARCHAR(255) NOT NULL');
326			}
327
328			$table = $schema->getTable('session_category');
329			if ($table->hasColumn('title')) {
330			$this->addSql('ALTER TABLE session_category CHANGE title name VARCHAR(100) NOT NULL');
331			}
332
333			$table = $schema->getTable('ticket_status');
334			if ($table->hasColumn('title')) {
335			$this->addSql('ALTER TABLE ticket_status CHANGE title name VARCHAR(255) NOT NULL');
336			}
337
338			$table = $schema->getTable('skill_profile');
339			if ($table->hasColumn('title')) {
340			$this->addSql('ALTER TABLE skill_profile CHANGE title name VARCHAR(255) NOT NULL');
341			}
342
343			$table = $schema->getTable('session');
344			if ($table->hasColumn('title')) {
345			$this->addSql('DROP INDEX title ON session');
346			$this->addSql('ALTER TABLE session CHANGE title name VARCHAR(150) NOT NULL');
347			$this->addSql('CREATE UNIQUE INDEX name ON session (name)');
348			}
349
350			$table = $schema->getTable('ticket_category');
351			if ($table->hasColumn('title')) {
352			$this->addSql('ALTER TABLE ticket_category CHANGE title name VARCHAR(255) NOT NULL');
353			}
354
355			$table = $schema->getTable('sequence');
356			if ($table->hasColumn('title')) {
357			$this->addSql('ALTER TABLE sequence CHANGE title name VARCHAR(255) NOT NULL');
358			}
359
360			$table = $schema->getTable('promotion');
361			if ($table->hasColumn('title')) {
362			$this->addSql('ALTER TABLE promotion CHANGE title name VARCHAR(255) NOT NULL');
363			}
364
365			$table = $schema->getTable('mail_template');
366			if ($table->hasColumn('title')) {
367			$this->addSql('ALTER TABLE mail_template CHANGE title name VARCHAR(255) NOT NULL');
368			}
369
370			$table = $schema->getTable('sequence_type_entity');
371			if ($table->hasColumn('title')) {
372			$this->addSql('ALTER TABLE sequence_type_entity CHANGE title name VARCHAR(255) NOT NULL');
373			}
374
375			$table = $schema->getTable('ticket_priority');
376			if ($table->hasColumn('title')) {
377			$this->addSql('ALTER TABLE ticket_priority CHANGE title name VARCHAR(255) NOT NULL');
378			}
379
380			$table = $schema->getTable('specific_field');
381			if ($table->hasColumn('title')) {
382			$this->addSql('ALTER TABLE specific_field CHANGE title name VARCHAR(255) NOT NULL');
383			}
384
385			$table = $schema->getTable('sequence_variable');
386			if ($table->hasColumn('title')) {
387			$this->addSql('ALTER TABLE sequence_variable CHANGE title name VARCHAR(255) NOT NULL');
388			}
389
390			$table = $schema->getTable('skill');
391			if ($table->hasColumn('title')) {
392			$this->addSql('ALTER TABLE skill CHANGE title name VARCHAR(255) NOT NULL');
393			}
394
395			$table = $schema->getTable('ticket_project');
396			if ($table->hasColumn('title')) {
397			$this->addSql('ALTER TABLE ticket_project CHANGE title name VARCHAR(255) NOT NULL');
398			}
399
400			$table = $schema->getTable('sequence_row_entity');
401			if ($table->hasColumn('title')) {
402			$this->addSql('ALTER TABLE sequence_row_entity CHANGE title name VARCHAR(255) NOT NULL');
403			}
404
405			$table = $schema->getTable('usergroup');
406			if ($table->hasColumn('title')) {
407			$this->addSql('ALTER TABLE usergroup CHANGE title name VARCHAR(255) NOT NULL');
408			}
409
410			$table = $schema->getTable('gradebook_evaluation');
411			if ($table->hasColumn('title')) {
412			$this->addSql('ALTER TABLE gradebook_evaluation CHANGE title name LONGTEXT NOT NULL');
413			}
414
415			$table = $schema->getTable('gradebook_category');
416			if ($table->hasColumn('title')) {
417			$this->addSql('ALTER TABLE gradebook_category CHANGE title name LONGTEXT NOT NULL');
418			}
419
420			$table = $schema->getTable('gradebook_linkeval_log');
421			if ($table->hasColumn('title')) {
422			$this->addSql('ALTER TABLE gradebook_linkeval_log CHANGE title name LONGTEXT NOT NULL');
423			}
424
425			$table = $schema->getTable('grade_model');
426			if ($table->hasColumn('title')) {
427			$this->addSql('ALTER TABLE grade_model CHANGE title name VARCHAR(255) NOT NULL');
428			}
429
430			$table = $schema->getTable('course_type');
431			if ($table->hasColumn('title')) {
432			$this->addSql('ALTER TABLE course_type CHANGE title name VARCHAR(50) NOT NULL');
433			}
434
435			$table = $schema->getTable('course_module');
436			if ($table->hasColumn('title')) {
437			$this->addSql('ALTER TABLE course_module CHANGE title name VARCHAR(255) NOT NULL');
438			}
439
440			$table = $schema->getTable('course_category');
441			if ($table->hasColumn('title')) {
442			$this->addSql('ALTER TABLE course_category CHANGE title name LONGTEXT NOT NULL');
443			}
444
445			$table = $schema->getTable('class_item');
446			if ($table->hasColumn('title')) {
447			$this->addSql('ALTER TABLE class_item CHANGE title name LONGTEXT NOT NULL');
448			}
449
450			$table = $schema->getTable('chat_video');
451			if ($table->hasColumn('title')) {
452			$this->addSql(
453			'DROP INDEX idx_chat_video_title ON chat_video'
454			);
455			$this->addSql(
456			'ALTER TABLE chat_video CHANGE title room_name VARCHAR(255) NOT NULL'
457			);
458			$this->addSql(
459			'CREATE INDEX idx_chat_video_room_name ON chat_video (room_name)'
460			);
461			}
462
463			$table = $schema->getTable('career');
464			if ($table->hasColumn('title')) {
465			$this->addSql('ALTER TABLE career CHANGE title name VARCHAR(255) NOT NULL');
466			}
467
468			$table = $schema->getTable('c_tool');
469			if ($table->hasColumn('title')) {
470			$this->addSql('ALTER TABLE c_tool CHANGE title name LONGTEXT NOT NULL');
471			}
472
473			$table = $schema->getTable('c_survey_group');
474			if ($table->hasColumn('title')) {
475			$this->addSql('ALTER TABLE c_survey_group CHANGE title name VARCHAR(20) NOT NULL');
476			}
477
478			$table = $schema->getTable('c_quiz_question_option');
479			if ($table->hasColumn('title')) {
480			$this->addSql('ALTER TABLE c_quiz_question_option CHANGE title name VARCHAR(255) NOT NULL');
481			}
482
483			$table = $schema->getTable('c_online_link');
484			if ($table->hasColumn('title')) {
485			$this->addSql('ALTER TABLE c_online_link CHANGE title name VARCHAR(50) NOT NULL');
486			}
487
488			$table = $schema->getTable('c_lp_category');
489			if ($table->hasColumn('title')) {
490			$this->addSql('ALTER TABLE c_lp_category CHANGE title name LONGTEXT NOT NULL');
491			}
492
493			$table = $schema->getTable('c_lp');
494			if ($table->hasColumn('title')) {
495			$this->addSql('ALTER TABLE c_lp CHANGE title name VARCHAR(255) NOT NULL');
496			}
497
498			$table = $schema->getTable('c_link_category');
499			if ($table->hasColumn('title')) {
500			$this->addSql('ALTER TABLE c_link_category CHANGE title category_title VARCHAR(255) NOT NULL');
501			}
502
503			$table = $schema->getTable('c_group_info');
504			if ($table->hasColumn('title')) {
505			$this->addSql('ALTER TABLE c_group_info CHANGE title name VARCHAR(100) NOT NULL');
506			}
507
508			$table = $schema->getTable('c_glossary');
509			if ($table->hasColumn('title')) {
510			$this->addSql('ALTER TABLE c_glossary CHANGE title name LONGTEXT NOT NULL');
511			}
512
513			$table = $schema->getTable('c_forum_thread');
514			if ($table->hasColumn('title')) {
515			$this->addSql('ALTER TABLE c_forum_thread CHANGE title thread_title VARCHAR(255) NOT NULL');
516			}
517
518			$table = $schema->getTable('c_forum_post');
519			if ($table->hasColumn('title')) {
520			$this->addSql('ALTER TABLE c_forum_post CHANGE title post_title VARCHAR(250) NOT NULL');
521			}
522
523			$table = $schema->getTable('c_forum_forum');
524			if ($table->hasColumn('title')) {
525			$this->addSql('ALTER TABLE c_forum_forum CHANGE title forum_title VARCHAR(255) NOT NULL');
526			}
527
528			$table = $schema->getTable('c_forum_category');
529			if ($table->hasColumn('title')) {
530			$this->addSql('ALTER TABLE c_forum_category CHANGE title cat_title VARCHAR(255) NOT NULL');
531			}
532
533			$table = $schema->getTable('c_exercise_category');
534			if ($table->hasColumn('title')) {
535			$this->addSql('ALTER TABLE c_exercise_category CHANGE title name VARCHAR(255) NOT NULL');
536			}
537
538			$table = $schema->getTable('c_dropbox_category');
539			if ($table->hasColumn('title')) {
540			$this->addSql('ALTER TABLE c_dropbox_category CHANGE title cat_name LONGTEXT NOT NULL');
541			}
542
543			$table = $schema->getTable('c_blog');
544			if ($table->hasColumn('title')) {
545			$this->addSql('ALTER TABLE c_blog CHANGE title blog_name LONGTEXT NOT NULL');
546			}
547
548			$table = $schema->getTable('c_attendance');
549			if ($table->hasColumn('title')) {
550			$this->addSql('ALTER TABLE c_attendance CHANGE title name LONGTEXT NOT NULL');
551			}
552
553			$table = $schema->getTable('branch_sync');
554			if ($table->hasColumn('title')) {
555			$this->addSql('ALTER TABLE branch_sync CHANGE title branch_name VARCHAR(250) NOT NULL');
556			}
557
558			$table = $schema->getTable('block');
559			if ($table->hasColumn('title')) {
560			$this->addSql('ALTER TABLE block CHANGE title name varchar(255) COLLATE "utf8_unicode_ci" NULL');
561			}
562			}
563			}
564

chamilo / chamilo-lms

Push — master ( 727abb...ceefce )

Version20230508153435::up() F

Complexity

Size

Duplication

Importance

How to fix Long Method Complexity

Long Method

Duplication Side-by-Side

Filter issues like