Total Complexity | 44 |
Total Lines | 521 |
Duplicated Lines | 0 % |
Changes | 4 | ||
Bugs | 0 | Features | 0 |
Complex classes like Version20 often do a lot of different things. To break such a class down, we need to identify a cohesive component within that class. A common approach to find such a component is to look for fields/methods that share the same prefixes, or suffixes.
Once you have determined the fields that belong together, you can apply the Extract Class refactoring. If the component makes sense as a sub-class, Extract Subclass is also a candidate, and is often faster.
While breaking up the class, it is a good idea to analyze how other classes use Version20, and based on these observations, apply Extract Interface, too.
1 | <?php |
||
17 | class Version20 extends AbstractMigrationChamilo |
||
18 | { |
||
19 | public function getDescription(): string |
||
22 | } |
||
23 | |||
24 | public function up(Schema $schema): void |
||
25 | { |
||
26 | $this->addSql('set sql_mode=""'); |
||
27 | // Optimize bulk operations - see https://dev.mysql.com/doc/refman/5.6/en//optimizing-innodb-bulk-data-loading.html |
||
28 | //$this->addSql('set autocommit=0'); |
||
29 | $this->addSql('set unique_checks=0'); |
||
30 | $this->addSql('set foreign_key_checks=0'); |
||
31 | |||
32 | // Basic checks. |
||
33 | $this->abortIf(!$this->adminExist(), 'Admin not found in the system'); |
||
34 | |||
35 | $table = $schema->getTable('user'); |
||
36 | if (false === $table->hasColumn('uuid')) { |
||
37 | $this->addSql("ALTER TABLE user ADD uuid BINARY(16) NOT NULL COMMENT '(DC2Type:uuid)'"); |
||
38 | } |
||
39 | |||
40 | if (false === $schema->hasTable('asset')) { |
||
41 | $this->addSql("CREATE TABLE asset (id BINARY(16) NOT NULL COMMENT '(DC2Type:uuid)', title VARCHAR(255) NOT NULL, category VARCHAR(255) NOT NULL, compressed TINYINT(1) NOT NULL, mime_type LONGTEXT DEFAULT NULL, original_name LONGTEXT DEFAULT NULL, dimensions LONGTEXT DEFAULT NULL COMMENT '(DC2Type:simple_array)', size INT NOT NULL, crop VARCHAR(255) DEFAULT NULL, metadata LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', description LONGTEXT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC;"); |
||
42 | } |
||
43 | |||
44 | $this->addSql('DELETE FROM track_e_attempt WHERE exe_id IS NULL'); |
||
45 | $this->addSql('ALTER TABLE track_e_attempt CHANGE exe_id exe_id INT NOT NULL'); |
||
46 | |||
47 | $this->addSql('UPDATE branch_transaction_status SET title = "No title" WHERE title IS NULL'); |
||
48 | $this->addSql('ALTER TABLE branch_transaction_status CHANGE title title VARCHAR(255) NOT NULL'); |
||
49 | |||
50 | $this->addSql('UPDATE room SET title = "No title" WHERE title IS NULL'); |
||
51 | $this->addSql('ALTER TABLE room CHANGE title title VARCHAR(255) NOT NULL'); |
||
52 | |||
53 | $this->addSql('UPDATE session_rel_course_rel_user SET legal_agreement = 0 WHERE legal_agreement IS NULL'); |
||
54 | $this->addSql('ALTER TABLE session_rel_course_rel_user CHANGE legal_agreement legal_agreement INT NOT NULL'); |
||
55 | |||
56 | $this->addSql('UPDATE session SET nbr_courses = 0 WHERE nbr_courses IS NULL'); |
||
57 | $this->addSql('ALTER TABLE session CHANGE nbr_courses nbr_courses INT NOT NULL'); |
||
58 | |||
59 | $this->addSql('UPDATE session SET nbr_users = 0 WHERE nbr_users IS NULL'); |
||
60 | $this->addSql('ALTER TABLE session CHANGE nbr_users nbr_users INT NOT NULL'); |
||
61 | |||
62 | $this->addSql('UPDATE session SET nbr_classes = 0 WHERE nbr_classes IS NULL'); |
||
63 | $this->addSql('ALTER TABLE session CHANGE nbr_classes nbr_classes INT NOT NULL'); |
||
64 | |||
65 | $this->addSql('UPDATE user_friend_relation_type SET title = "No title" WHERE title IS NULL'); |
||
66 | $this->addSql('ALTER TABLE user_friend_relation_type CHANGE title title VARCHAR(20) NOT NULL'); |
||
67 | |||
68 | $this->addSql('UPDATE settings_options SET variable = "No variable name" WHERE variable IS NULL'); |
||
69 | $this->addSql('ALTER TABLE settings_options CHANGE variable variable VARCHAR(190) NOT NULL'); |
||
70 | |||
71 | if ($schema->hasTable('mail_template')) { |
||
72 | $this->addSql('UPDATE mail_template SET name = "No name" WHERE name IS NULL'); |
||
73 | $this->addSql('ALTER TABLE mail_template CHANGE name name VARCHAR(255) NOT NULL'); |
||
74 | } |
||
75 | |||
76 | $this->addSql('UPDATE session_rel_user SET duration = "0" WHERE duration IS NULL'); |
||
77 | $this->addSql('ALTER TABLE session_rel_user CHANGE duration duration INT NOT NULL'); |
||
78 | |||
79 | if ($schema->hasTable('portfolio_category')) { |
||
80 | $this->addSql('UPDATE portfolio_category SET title = "No name" WHERE title IS NULL'); |
||
81 | $this->addSql('ALTER TABLE portfolio_category CHANGE title title LONGTEXT NOT NULL'); |
||
82 | } |
||
83 | |||
84 | $this->addSql('UPDATE gradebook_linkeval_log SET name = "No name" WHERE name IS NULL'); |
||
85 | $this->addSql('ALTER TABLE gradebook_linkeval_log CHANGE name name LONGTEXT NOT NULL'); |
||
86 | |||
87 | $this->addSql('UPDATE session_category SET name = "No name" WHERE name IS NULL'); |
||
88 | $this->addSql('ALTER TABLE session_category CHANGE name name VARCHAR(100) NOT NULL'); |
||
89 | |||
90 | $this->addSql('UPDATE c_group_info SET name = "No name" WHERE name IS NULL'); |
||
91 | $this->addSql('ALTER TABLE c_group_info CHANGE name name VARCHAR(100) NOT NULL'); |
||
92 | |||
93 | $this->addSql('UPDATE c_group_info SET status = 0 WHERE status IS NULL'); |
||
94 | $this->addSql('ALTER TABLE c_group_info CHANGE status status TINYINT(1) NOT NULL'); |
||
95 | |||
96 | $this->addSql('UPDATE c_quiz_question_option SET name = "No name" WHERE name IS NULL'); |
||
97 | $this->addSql('ALTER TABLE c_quiz_question_option CHANGE name name VARCHAR(255) NOT NULL'); |
||
98 | |||
99 | $this->addSql('UPDATE c_survey SET title = "No title" WHERE title IS NULL'); |
||
100 | $this->addSql('ALTER TABLE c_survey CHANGE title title LONGTEXT NOT NULL'); |
||
101 | |||
102 | $this->addSql('UPDATE c_dropbox_file SET title = "No title" WHERE title IS NULL'); |
||
103 | $this->addSql('ALTER TABLE c_dropbox_file CHANGE title title VARCHAR(255) NOT NULL'); |
||
104 | |||
105 | $this->addSql('UPDATE c_announcement SET title = "No title" WHERE title IS NULL'); |
||
106 | $this->addSql('ALTER TABLE c_announcement CHANGE title title LONGTEXT NOT NULL'); |
||
107 | |||
108 | $this->addSql('UPDATE c_quiz SET hide_question_title = 0 WHERE hide_question_title IS NULL'); |
||
109 | $this->addSql('ALTER TABLE c_quiz CHANGE hide_question_title hide_question_title TINYINT(1) NOT NULL'); |
||
110 | |||
111 | $this->addSql('UPDATE c_link SET title = "No name" WHERE title IS NULL'); |
||
112 | $this->addSql('ALTER TABLE c_link CHANGE title title VARCHAR(255) NOT NULL'); |
||
113 | |||
114 | $this->addSql('UPDATE c_forum_post SET post_title = "No name" WHERE post_title IS NULL'); |
||
115 | $this->addSql('ALTER TABLE c_forum_post CHANGE post_title post_title VARCHAR(250) NOT NULL'); |
||
116 | |||
117 | $this->addSql('UPDATE c_forum_post SET visible = 0 WHERE visible IS NULL'); |
||
118 | $this->addSql('ALTER TABLE c_forum_post CHANGE visible visible TINYINT(1) NOT NULL'); |
||
119 | |||
120 | $this->addSql('UPDATE c_link SET title = "No title" WHERE title IS NULL OR title = "" OR title = "/" '); |
||
121 | $this->addSql('ALTER TABLE c_link CHANGE title title VARCHAR(255) NOT NULL'); |
||
122 | |||
123 | $this->addSql('UPDATE c_document SET title = "No title" WHERE title IS NULL OR title = "" OR title = "/" '); |
||
124 | $this->addSql('ALTER TABLE c_document CHANGE title title VARCHAR(255) NOT NULL'); |
||
125 | |||
126 | $this->addSql('UPDATE c_forum_thread SET thread_title = "No name" WHERE thread_title IS NULL'); |
||
127 | $this->addSql('ALTER TABLE c_forum_thread CHANGE thread_title thread_title VARCHAR(255) NOT NULL'); |
||
128 | |||
129 | $this->addSql('UPDATE c_forum_thread SET thread_sticky = 0 WHERE thread_sticky IS NULL'); |
||
130 | $this->addSql('ALTER TABLE c_forum_thread CHANGE thread_sticky thread_sticky TINYINT(1) NOT NULL'); |
||
131 | |||
132 | $this->addSql('UPDATE ticket_message SET subject = "Ticket #"+ id WHERE subject IS NULL'); |
||
133 | $this->addSql('ALTER TABLE ticket_message CHANGE subject subject VARCHAR(255) NOT NULL'); |
||
134 | |||
135 | $this->addSql('UPDATE settings_current SET variable = "No name" WHERE variable IS NULL'); |
||
136 | $this->addSql('ALTER TABLE settings_current CHANGE variable variable VARCHAR(190) NOT NULL;'); |
||
137 | |||
138 | // Global tool. |
||
139 | if (false === $schema->hasTable('tool')) { |
||
140 | $this->addSql( |
||
141 | 'CREATE TABLE IF NOT EXISTS tool (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;' |
||
142 | ); |
||
143 | $this->addSql('CREATE UNIQUE INDEX UNIQ_20F33ED15E237E06 ON tool (name)'); |
||
144 | } |
||
145 | |||
146 | $table = $schema->getTable('language'); |
||
147 | if ($table->hasIndex('idx_language_dokeos_folder')) { |
||
148 | $this->addSql('DROP INDEX idx_language_dokeos_folder ON language;'); |
||
149 | $this->addSql('ALTER TABLE language DROP dokeos_folder;'); |
||
150 | } |
||
151 | |||
152 | // Update language to ISO. |
||
153 | $this->addSql('UPDATE language SET isocode = "en" WHERE isocode IS NULL'); |
||
154 | $this->addSql('ALTER TABLE language CHANGE isocode isocode VARCHAR(10) NOT NULL'); |
||
155 | $this->addSql('UPDATE language SET english_name = "english" WHERE english_name IS NULL'); |
||
156 | $this->addSql('ALTER TABLE language CHANGE english_name english_name VARCHAR(255) NOT NULL'); |
||
157 | |||
158 | $languages = LanguageFixtures::getLanguages(); |
||
159 | $languages = array_column($languages, 'isocode', 'english_name'); |
||
160 | |||
161 | $sql = 'SELECT * FROM language'; |
||
162 | $connection = $this->getEntityManager()->getConnection(); |
||
163 | $result = $connection->executeQuery($sql); |
||
164 | $items = $result->fetchAllAssociative(); |
||
165 | |||
166 | foreach ($items as $item) { |
||
167 | $id = $item['id']; |
||
168 | $englishName = $item['english_name']; |
||
169 | if (isset($languages[$englishName])) { |
||
170 | $newIso = $languages[$englishName]; |
||
171 | $this->addSql("UPDATE language SET isocode = '$newIso' WHERE id = $id"); |
||
172 | } |
||
173 | } |
||
174 | |||
175 | $this->addSql("UPDATE language SET isocode = 'fr_FR' WHERE isocode = 'fr' "); |
||
176 | $this->addSql("UPDATE language SET isocode = 'pl_PL' WHERE isocode = 'pl' "); |
||
177 | |||
178 | $this->addSql("UPDATE sys_announcement SET lang = 'english' WHERE lang IS NULL OR lang = '' "); |
||
179 | $this->addSql("UPDATE course SET course_language = 'english' WHERE course_language IS NULL OR course_language = '' "); |
||
180 | |||
181 | $this->addSql('UPDATE course SET course_language = (SELECT isocode FROM language WHERE english_name = course_language)'); |
||
182 | $this->addSql('UPDATE sys_announcement SET lang = (SELECT isocode FROM language WHERE english_name = lang);'); |
||
183 | $this->addSql("UPDATE settings_current SET selected_value = (SELECT isocode FROM language WHERE english_name = selected_value) WHERE variable = 'platformLanguage'"); |
||
184 | |||
185 | $table = $schema->getTable('fos_group'); |
||
186 | if (false === $table->hasColumn('name')) { |
||
187 | $this->addSql( |
||
188 | 'ALTER TABLE fos_group ADD name VARCHAR(180) NOT NULL, ADD roles LONGTEXT NOT NULL COMMENT "(DC2Type:array)";' |
||
189 | ); |
||
190 | $this->addSql('CREATE UNIQUE INDEX UNIQ_4B019DDB5E237E06 ON fos_group (name);'); |
||
191 | } |
||
192 | $this->addSql('ALTER TABLE fos_group CHANGE name name VARCHAR(255) NOT NULL'); |
||
193 | |||
194 | $table = $schema->getTable('fos_user_user_group'); |
||
195 | if ($table->hasForeignKey('FK_B3C77447A76ED395')) { |
||
196 | $this->addSql('ALTER TABLE fos_user_user_group DROP FOREIGN KEY FK_B3C77447A76ED395'); |
||
197 | $this->addSql('ALTER TABLE fos_user_user_group ADD CONSTRAINT FK_B3C77447A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE'); |
||
198 | } else { |
||
199 | $this->addSql('ALTER TABLE fos_user_user_group ADD CONSTRAINT FK_B3C77447A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE'); |
||
200 | } |
||
201 | |||
202 | $this->addSql('ALTER TABLE course_request CHANGE user_id user_id INT DEFAULT NULL;'); |
||
203 | |||
204 | $table = $schema->getTable('course_request'); |
||
205 | if (false === $table->hasForeignKey('FK_33548A73A76ED395')) { |
||
206 | $this->addSql( |
||
207 | 'ALTER TABLE course_request ADD CONSTRAINT FK_33548A73A76ED395 FOREIGN KEY (user_id) REFERENCES user (id);' |
||
208 | ); |
||
209 | $this->addSql('CREATE INDEX IDX_33548A73A76ED395 ON course_request (user_id);'); |
||
210 | } |
||
211 | |||
212 | if ($table->hasColumn('directory')) { |
||
213 | $this->addSql('ALTER TABLE course_request DROP directory'); |
||
214 | } |
||
215 | |||
216 | if ($table->hasColumn('db_name')) { |
||
217 | $this->addSql('ALTER TABLE course_request DROP db_name'); |
||
218 | } |
||
219 | |||
220 | $this->addSql('ALTER TABLE course_request CHANGE course_language course_language VARCHAR(20) NOT NULL'); |
||
221 | $this->addSql('ALTER TABLE course_request CHANGE title title VARCHAR(250) NOT NULL'); |
||
222 | |||
223 | $table = $schema->getTable('search_engine_ref'); |
||
224 | if (false === $table->hasColumn('c_id')) { |
||
225 | $this->addSql('ALTER TABLE search_engine_ref ADD c_id INT DEFAULT NULL'); |
||
226 | $this->addSql('UPDATE search_engine_ref SET c_id = (SELECT id FROM course WHERE code = course_code)'); |
||
227 | $this->addSql('ALTER TABLE search_engine_ref DROP course_code'); |
||
228 | $this->addSql( |
||
229 | 'ALTER TABLE search_engine_ref ADD CONSTRAINT FK_473F037891D79BD3 FOREIGN KEY (c_id) REFERENCES course (id);' |
||
230 | ); |
||
231 | $this->addSql('CREATE INDEX IDX_473F037891D79BD3 ON search_engine_ref (c_id);'); |
||
232 | } |
||
233 | |||
234 | $this->addSql('ALTER TABLE hook_observer CHANGE class_name class_name VARCHAR(190) DEFAULT NULL'); |
||
235 | $this->addSql('ALTER TABLE hook_event CHANGE class_name class_name VARCHAR(190) DEFAULT NULL;'); |
||
236 | $this->addSql('ALTER TABLE sequence_value CHANGE user_id user_id INT DEFAULT NULL'); |
||
237 | |||
238 | $table = $schema->getTable('sequence_value'); |
||
239 | if (false === $table->hasForeignKey('FK_66FBF12DA76ED395')) { |
||
240 | $this->addSql( |
||
241 | 'ALTER TABLE sequence_value ADD CONSTRAINT FK_66FBF12DA76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE' |
||
242 | ); |
||
243 | } |
||
244 | |||
245 | if (false === $table->hasIndex('IDX_66FBF12DA76ED395')) { |
||
246 | $this->addSql('CREATE INDEX IDX_66FBF12DA76ED395 ON sequence_value (user_id)'); |
||
247 | } |
||
248 | |||
249 | $table = $schema->getTable('branch_sync'); |
||
250 | $this->addSql('ALTER TABLE branch_sync CHANGE access_url_id access_url_id INT DEFAULT NULL'); |
||
251 | if (false === $table->hasForeignKey('FK_F62F45ED73444FD5')) { |
||
252 | $this->addSql('ALTER TABLE branch_sync ADD CONSTRAINT FK_F62F45ED73444FD5 FOREIGN KEY (access_url_id) REFERENCES access_url (id)'); |
||
253 | } |
||
254 | if (false === $table->hasIndex('IDX_F62F45ED73444FD5')) { |
||
255 | $this->addSql('CREATE INDEX IDX_F62F45ED73444FD5 ON branch_sync (access_url_id)'); |
||
256 | } |
||
257 | |||
258 | $table = $schema->getTable('personal_agenda'); |
||
259 | if ($table->hasColumn('course')) { |
||
260 | $this->addSql('ALTER TABLE personal_agenda DROP course'); |
||
261 | } |
||
262 | |||
263 | if (false === $table->hasForeignKey('FK_D86124608D93D649')) { |
||
264 | $this->addSql('ALTER TABLE personal_agenda ADD CONSTRAINT FK_D86124608D93D649 FOREIGN KEY (user) REFERENCES user (id) ON DELETE CASCADE'); |
||
265 | } |
||
266 | |||
267 | //$this->addSql('ALTER TABLE c_tool_intro CHANGE id tool VARCHAR(255) NOT NULL'); |
||
268 | |||
269 | /*$table = $schema->getTable('course_rel_class'); |
||
270 | if (!$table->hasColumn('c_id')) { |
||
271 | $this->addSql("ALTER TABLE course_rel_class ADD c_id int NOT NULL"); |
||
272 | } |
||
273 | if ($table->hasColumn('course_code')) { |
||
274 | $this->addSql(" |
||
275 | UPDATE course_rel_class cc |
||
276 | SET cc.c_id = (SELECT id FROM course WHERE code = cc.course_code) |
||
277 | "); |
||
278 | |||
279 | $this->addSql("ALTER TABLE course_rel_class DROP course_code"); |
||
280 | $this->addSql("ALTER TABLE course_rel_class DROP PRIMARY KEY"); |
||
281 | $this->addSql("ALTER TABLE course_rel_class MODIFY COLUMN class_id INT DEFAULT NULL"); |
||
282 | $this->addSql("ALTER TABLE course_rel_class ADD PRIMARY KEY (class_id, c_id)"); |
||
283 | $this->addSql("ALTER TABLE course_rel_class ADD FOREIGN KEY (c_id) REFERENCES course (id) ON DELETE RESTRICT"); |
||
284 | }*/ |
||
285 | |||
286 | $tables = [ |
||
287 | 'shared_survey', |
||
288 | 'specific_field_values', |
||
289 | 'templates', |
||
290 | ]; |
||
291 | |||
292 | foreach ($tables as $table) { |
||
293 | //$tableObj = $schema->getTable($table); |
||
294 | /*if (!$tableObj->hasColumn('c_id')) { |
||
295 | $this->addSql("ALTER TABLE $table ADD c_id int NOT NULL"); |
||
296 | |||
297 | if ($tableObj->hasColumn('course_code')) { |
||
298 | $this->addSql(" |
||
299 | UPDATE $table t |
||
300 | SET t.c_id = (SELECT id FROM course WHERE code = t.course_code) |
||
301 | "); |
||
302 | $this->addSql("ALTER TABLE $table DROP course_code"); |
||
303 | } |
||
304 | }*/ |
||
305 | /*$this->addSql(" |
||
306 | ALTER TABLE $table ADD FOREIGN KEY (c_id) REFERENCES course (id) ON DELETE RESTRICT |
||
307 | ");*/ |
||
308 | } |
||
309 | /* |
||
310 | $this->addSql("ALTER TABLE personal_agenda DROP course"); |
||
311 | |||
312 | $this->addSql(" |
||
313 | ALTER TABLE specific_field_values |
||
314 | ADD c_id int(11) NOT NULL, |
||
315 | ADD FOREIGN KEY (c_id) REFERENCES course (id) ON DELETE RESTRICT; |
||
316 | "); |
||
317 | */ |
||
318 | |||
319 | // Create tables. |
||
320 | $this->addSql( |
||
321 | 'CREATE TABLE IF NOT EXISTS scheduled_announcements (id INT AUTO_INCREMENT NOT NULL, subject VARCHAR(255) NOT NULL, message LONGTEXT NOT NULL, date DATETIME DEFAULT NULL, sent TINYINT(1) NOT NULL, session_id INT NOT NULL, c_id INT DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;' |
||
322 | ); |
||
323 | $this->addSql( |
||
324 | 'CREATE TABLE IF NOT EXISTS ext_translations (id INT AUTO_INCREMENT NOT NULL, locale VARCHAR(8) NOT NULL, object_class VARCHAR(190) NOT NULL, field VARCHAR(32) NOT NULL, foreign_key VARCHAR(64) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX translations_lookup_idx (locale, object_class, foreign_key), UNIQUE INDEX lookup_unique_idx (locale, object_class, field, foreign_key), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;' |
||
325 | ); |
||
326 | $this->addSql( |
||
327 | 'CREATE TABLE IF NOT EXISTS ext_log_entries (id INT AUTO_INCREMENT NOT NULL, action VARCHAR(8) NOT NULL, logged_at DATETIME NOT NULL, object_id VARCHAR(64) DEFAULT NULL, object_class VARCHAR(191) NOT NULL, version INT NOT NULL, data LONGTEXT DEFAULT NULL COMMENT "(DC2Type:array)", username VARCHAR(191) DEFAULT NULL, INDEX log_class_lookup_idx (object_class), INDEX log_date_lookup_idx (logged_at), INDEX log_user_lookup_idx (username), INDEX log_version_lookup_idx (object_id, object_class, version), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;' |
||
328 | ); |
||
329 | $this->addSql( |
||
330 | 'CREATE TABLE IF NOT EXISTS mail_template (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, template LONGTEXT DEFAULT NULL, type VARCHAR(255) NOT NULL, score DOUBLE PRECISION DEFAULT NULL, result_id INT NOT NULL, default_template TINYINT(1) NOT NULL, `system` INT DEFAULT 0 NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC' |
||
331 | ); |
||
332 | |||
333 | $table = $schema->getTable('usergroup'); |
||
334 | if (false === $table->hasColumn('author_id')) { |
||
335 | $this->addSql('ALTER TABLE usergroup ADD author_id INT DEFAULT NULL'); |
||
336 | } |
||
337 | |||
338 | if (false === $table->hasColumn('resource_node_id')) { |
||
339 | $this->addSql('ALTER TABLE usergroup ADD resource_node_id BIGINT DEFAULT NULL'); |
||
340 | } |
||
341 | |||
342 | // sequence_resource. |
||
343 | $table = $schema->getTable('sequence_resource'); |
||
344 | |||
345 | if ($table->hasForeignKey('FK_34ADA43998FB19AE')) { |
||
346 | $this->addSql('ALTER TABLE sequence_resource DROP FOREIGN KEY FK_34ADA43998FB19AE;'); |
||
347 | } |
||
348 | |||
349 | $this->addSql('ALTER TABLE sequence_resource ADD CONSTRAINT FK_34ADA43998FB19AE FOREIGN KEY (sequence_id) REFERENCES sequence (id) ON DELETE CASCADE'); |
||
350 | |||
351 | // Update template. |
||
352 | $table = $schema->getTable('templates'); |
||
353 | if ($table->hasColumn('course_code')) { |
||
354 | $this->addSql('DELETE FROM templates WHERE course_code NOT IN (SELECT code FROM course)'); |
||
355 | } |
||
356 | if (false === $table->hasColumn('c_id')) { |
||
357 | $this->addSql('ALTER TABLE templates ADD c_id INT DEFAULT NULL'); |
||
358 | $this->addSql('CREATE INDEX IDX_6F287D8E91D79BD3 ON templates (c_id)'); |
||
359 | $this->addSql( |
||
360 | 'ALTER TABLE templates ADD CONSTRAINT FK_6F287D8E91D79BD3 FOREIGN KEY (c_id) REFERENCES course (id)' |
||
361 | ); |
||
362 | $this->addSql('UPDATE templates SET c_id = (SELECT id FROM course WHERE code = course_code)'); |
||
363 | } |
||
364 | $this->addSql('ALTER TABLE templates CHANGE user_id user_id INT DEFAULT NULL'); |
||
365 | |||
366 | if (false === $table->hasIndex('IDX_6F287D8EA76ED395')) { |
||
367 | $this->addSql('CREATE INDEX IDX_6F287D8EA76ED395 ON templates (user_id)'); |
||
368 | } |
||
369 | if (false === $table->hasForeignKey('FK_6F287D8EA76ED395')) { |
||
370 | $this->addSql('ALTER TABLE templates ADD CONSTRAINT FK_6F287D8EA76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE'); |
||
371 | } |
||
372 | |||
373 | // Drop unused columns |
||
374 | $dropColumnsAndIndex = [ |
||
375 | 'track_e_uploads' => [ |
||
376 | 'columns' => ['upload_cours_id'], |
||
377 | 'index' => ['upload_cours_id'], |
||
378 | ], |
||
379 | 'track_e_hotspot' => [ |
||
380 | 'columns' => ['hotspot_course_code'], |
||
381 | 'index' => ['hotspot_course_code'], |
||
382 | ], |
||
383 | 'templates' => [ |
||
384 | 'columns' => ['course_code'], |
||
385 | 'index' => [], |
||
386 | ], |
||
387 | 'personal_agenda' => [ |
||
388 | 'columns' => ['hotspot_course_code'], |
||
389 | 'index' => [], |
||
390 | ], |
||
391 | 'c_item_property' => [ |
||
392 | 'fks' => [ |
||
393 | 'FK_1D84C18129F6EE60', |
||
394 | 'FK_1D84C181330D47E9', |
||
395 | 'FK_1D84C181613FECDF', |
||
396 | 'FK_1D84C18191D79BD3', |
||
397 | 'FK_1D84C1819C859CC3', |
||
398 | ], |
||
399 | ], |
||
400 | ]; |
||
401 | |||
402 | foreach ($dropColumnsAndIndex as $tableName => $data) { |
||
403 | if ($schema->hasTable($tableName)) { |
||
404 | $table = $schema->getTable($tableName); |
||
405 | |||
406 | $indexList = $data['index'] ?? []; |
||
407 | foreach ($indexList as $index) { |
||
408 | if ($table->hasIndex($index)) { |
||
409 | $table->dropIndex($index); |
||
410 | } |
||
411 | } |
||
412 | |||
413 | $columns = $data['columns'] ?? []; |
||
414 | foreach ($columns as $column) { |
||
415 | if ($table->hasColumn($column)) { |
||
416 | $table->dropColumn($column); |
||
417 | } |
||
418 | } |
||
419 | |||
420 | $fks = $data['fks'] ?? []; |
||
421 | foreach ($fks as $fk) { |
||
422 | if ($table->hasForeignKey($fk)) { |
||
423 | $table->removeForeignKey($fk); |
||
424 | } |
||
425 | } |
||
426 | } |
||
427 | } |
||
428 | |||
429 | // Drop unused tables. |
||
430 | $dropTables = [ |
||
431 | 'event_email_template', |
||
432 | 'event_sent', |
||
433 | 'user_rel_event_type', |
||
434 | 'openid_association', |
||
435 | 'track_stored_values', |
||
436 | 'track_stored_values_stack', |
||
437 | 'course_module', |
||
438 | 'c_resource', |
||
439 | 'track_e_item_property', |
||
440 | ]; |
||
441 | |||
442 | foreach ($dropTables as $table) { |
||
443 | if ($schema->hasTable($table)) { |
||
444 | $schema->dropTable($table); |
||
445 | } |
||
446 | } |
||
447 | |||
448 | // Disable c_id and session_id. |
||
449 | $tables = [ |
||
450 | 'c_announcement' => ['c_id', 'session_id'], |
||
451 | 'c_announcement_attachment' => ['c_id'], |
||
452 | 'c_attendance' => ['c_id', 'session_id'], |
||
453 | 'c_attendance_calendar' => ['c_id'], |
||
454 | 'c_attendance_calendar_rel_group' => ['c_id', 'group_id'], |
||
455 | 'c_attendance_result' => ['c_id'], |
||
456 | 'c_attendance_sheet' => ['c_id'], |
||
457 | 'c_attendance_sheet_log' => ['c_id'], |
||
458 | 'c_calendar_event' => ['c_id', 'session_id'], |
||
459 | 'c_calendar_event_attachment' => ['c_id'], |
||
460 | 'c_calendar_event_repeat' => ['c_id'], |
||
461 | 'c_calendar_event_repeat_not' => ['c_id'], |
||
462 | 'c_course_description' => ['c_id', 'session_id'], |
||
463 | 'c_document' => ['c_id', 'session_id'], |
||
464 | 'c_forum_attachment' => ['c_id'], |
||
465 | 'c_forum_category' => ['c_id', 'session_id', 'cat_id'], |
||
466 | 'c_forum_forum' => ['c_id', 'session_id', 'post_id'], |
||
467 | 'c_forum_notification' => ['c_id'], |
||
468 | 'c_forum_post' => ['c_id', 'post_id'], |
||
469 | 'c_forum_thread' => ['c_id', 'session_id'], |
||
470 | 'c_forum_thread_qualify' => ['c_id', 'session_id'], |
||
471 | 'c_forum_thread_qualify_log' => ['c_id', 'session_id'], |
||
472 | 'c_glossary' => ['c_id', 'session_id', 'glossary_id'], |
||
473 | 'c_group_category' => ['c_id'], |
||
474 | 'c_group_info' => ['c_id', 'session_id'], |
||
475 | //'c_group_rel_tutor' => ['c_id'], |
||
476 | 'c_link' => ['c_id', 'session_id'], |
||
477 | 'c_link_category' => ['c_id', 'session_id'], |
||
478 | |||
479 | 'c_lp' => ['c_id', 'session_id'], |
||
480 | 'c_lp_category' => ['c_id'], |
||
481 | 'c_lp_item' => ['c_id'], |
||
482 | 'c_lp_item_view' => ['c_id', 'session_id'], |
||
483 | // 'c_lp_iv_interaction' => ['c_id'], |
||
484 | //'c_lp_iv_objective' => ['c_id'], |
||
485 | 'c_notebook' => ['c_id', 'session_id'], |
||
486 | 'c_quiz' => ['c_id', 'session_id'], |
||
487 | 'c_quiz_answer' => ['c_id'], |
||
488 | 'c_quiz_question' => ['c_id'], |
||
489 | 'c_quiz_question_category' => ['c_id'], |
||
490 | 'c_quiz_question_option' => ['c_id'], |
||
491 | 'c_quiz_question_rel_category' => ['c_id'], |
||
492 | 'c_quiz_rel_category' => ['c_id'], |
||
493 | 'c_quiz_rel_question' => ['c_id'], |
||
494 | 'c_student_publication' => ['c_id', 'session_id'], |
||
495 | 'c_student_publication_assignment' => ['c_id'], |
||
496 | 'c_student_publication_comment' => ['c_id'], |
||
497 | 'c_student_publication_rel_document' => ['c_id'], |
||
498 | 'c_student_publication_rel_user' => ['c_id'], |
||
499 | 'c_survey' => ['c_id', 'session_id', 'survey_id'], |
||
500 | 'c_survey_answer' => ['c_id', 'answer_id'], |
||
501 | 'c_survey_group' => ['c_id'], |
||
502 | 'c_survey_invitation' => [ |
||
503 | 'c_id', |
||
504 | 'session_id', |
||
505 | 'group_id', |
||
506 | 'survey_invitation_id', |
||
507 | 'survey_group_sec1', |
||
508 | 'survey_group_sec2', |
||
509 | ], |
||
510 | 'c_survey_question' => ['c_id', 'question_id', 'survey_group_pri'], |
||
511 | 'c_survey_question_option' => ['c_id', 'question_option_id'], |
||
512 | 'c_thematic' => ['c_id', 'session_id'], |
||
513 | 'c_thematic_advance' => ['c_id'], |
||
514 | 'c_thematic_plan' => ['c_id'], |
||
515 | 'c_tool' => ['c_id', 'session_id'], |
||
516 | 'c_tool_intro' => ['c_id', 'session_id'], |
||
517 | 'c_wiki' => ['c_id', 'session_id'], |
||
518 | |||
519 | // core tables |
||
520 | |||
521 | 'message' => ['user_receiver_id'], |
||
522 | ]; |
||
523 | |||
524 | $this->addSql('ALTER TABLE c_survey_invitation CHANGE survey_code survey_code VARCHAR(20) DEFAULT NULL'); |
||
525 | |||
526 | foreach ($tables as $tableName => $fields) { |
||
527 | $table = $schema->getTable($tableName); |
||
528 | foreach ($fields as $field) { |
||
529 | if ($table->hasColumn($field)) { |
||
530 | $this->addSql("ALTER TABLE $tableName CHANGE $field $field INT DEFAULT NULL"); |
||
531 | } |
||
532 | } |
||
533 | } |
||
534 | } |
||
535 | |||
536 | public function down(Schema $schema): void |
||
538 | } |
||
539 | } |
||
540 |