Ecodev /
artisans
| Conditions | 1 |
| Paths | 1 |
| Total Lines | 267 |
| Code Lines | 10 |
| Lines | 0 |
| Ratio | 0 % |
| Changes | 1 | ||
| Bugs | 0 | Features | 0 |
Small methods make your code easier to understand, in particular if combined with a good name. Besides, if your method is small, finding a good name is usually much easier.
For example, if you find yourself adding comments to a method's body, this is usually a good sign to extract the commented part to a new method, and use the comment as a starting point when coming up with a good name for this new method.
Commonly applied refactorings include:
If many parameters/temporary variables are present:
| 1 | <?php |
||
| 11 | public function up(Schema $schema): void |
||
| 12 | { |
||
| 13 | $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', |
||
| 14 | 'Migration can only be executed safely on \'mysql\'.'); |
||
| 15 | |||
| 16 | $this->addSql('CREATE TABLE country (id INT AUTO_INCREMENT NOT NULL, creator_id INT DEFAULT NULL, owner_id INT DEFAULT NULL, updater_id INT DEFAULT NULL, creation_date DATETIME DEFAULT NULL, update_date DATETIME DEFAULT NULL, code VARCHAR(2) NOT NULL, name VARCHAR(191) NOT NULL, UNIQUE INDEX UNIQ_5373C96677153098 (code), INDEX IDX_5373C96661220EA6 (creator_id), INDEX IDX_5373C9667E3C61F9 (owner_id), INDEX IDX_5373C966E37ECFB0 (updater_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
||
| 17 | $this->addSql('ALTER TABLE country ADD CONSTRAINT FK_5373C96661220EA6 FOREIGN KEY (creator_id) REFERENCES user (id) ON DELETE SET NULL'); |
||
| 18 | $this->addSql('ALTER TABLE country ADD CONSTRAINT FK_5373C9667E3C61F9 FOREIGN KEY (owner_id) REFERENCES user (id) ON DELETE SET NULL'); |
||
| 19 | $this->addSql('ALTER TABLE country ADD CONSTRAINT FK_5373C966E37ECFB0 FOREIGN KEY (updater_id) REFERENCES user (id) ON DELETE SET NULL'); |
||
| 20 | |||
| 21 | $this->addSql('INSERT INTO country (id, code, name) VALUES |
||
| 22 | (1, "CH", "Suisse"), |
||
| 23 | (2, "FR", "France"), |
||
| 24 | (3, "AU", "Australie"), |
||
| 25 | (4, "AT", "Autriche"), |
||
| 26 | (5, "BE", "Belgique"), |
||
| 27 | (6, "CA", "Canada"), |
||
| 28 | (7, "CZ", "République tchèque"), |
||
| 29 | (8, "DK", "Danemark"), |
||
| 30 | (9, "FI", "Finlande"), |
||
| 31 | (10, "DE", "Allemagne"), |
||
| 32 | (11, "GR", "Grèce"), |
||
| 33 | (12, "HU", "Hongrie"), |
||
| 34 | (13, "IS", "Islande"), |
||
| 35 | (14, "IE", "Irlande"), |
||
| 36 | (15, "IT", "Italie"), |
||
| 37 | (16, "JP", "Japon"), |
||
| 38 | (17, "LU", "Luxembourg"), |
||
| 39 | (18, "MX", "Mexique"), |
||
| 40 | (19, "NL", "Pays-Bas"), |
||
| 41 | (20, "NZ", "Nouvelle-Zélande"), |
||
| 42 | (21, "NO", "Norvège"), |
||
| 43 | (22, "PL", "Pologne"), |
||
| 44 | (23, "PT", "Portugal"), |
||
| 45 | (24, "SK", "Slovaquie"), |
||
| 46 | (25, "KR", "Corée du Sud"), |
||
| 47 | (26, "ES", "Espagne"), |
||
| 48 | (27, "SE", "Suède"), |
||
| 49 | (28, "TR", "Turquie"), |
||
| 50 | (29, "GB", "Angleterre"), |
||
| 51 | (30, "US", "États-Unis"), |
||
| 52 | (31, "AX", "Îles Åland"), |
||
| 53 | (32, "AF", "Afghanistan"), |
||
| 54 | (33, "AL", "Albanie"), |
||
| 55 | (34, "DZ", "Algérie"), |
||
| 56 | (35, "AS", "Samoa américaines"), |
||
| 57 | (36, "AD", "Andorre"), |
||
| 58 | (37, "AO", "Angola"), |
||
| 59 | (38, "AI", "Anguilla"), |
||
| 60 | (39, "AQ", "Antarctique"), |
||
| 61 | (40, "AG", "Antigua et Barbuda"), |
||
| 62 | (41, "AR", "Argentine"), |
||
| 63 | (42, "AM", "Arménie"), |
||
| 64 | (43, "AW", "Aruba"), |
||
| 65 | (44, "AZ", "Azerbaïdjan"), |
||
| 66 | (45, "BS", "Bahamas"), |
||
| 67 | (46, "BH", "Bahreïn"), |
||
| 68 | (47, "BD", "Bangladesh"), |
||
| 69 | (48, "BB", "Barbade"), |
||
| 70 | (49, "BY", "Biélorussie"), |
||
| 71 | (50, "BZ", "Belize"), |
||
| 72 | (51, "BJ", "Bénin"), |
||
| 73 | (52, "BM", "Bermudes"), |
||
| 74 | (53, "BT", "Bhutan"), |
||
| 75 | (54, "BO", "Bolivie"), |
||
| 76 | (55, "BQ", "Bonaire, Saint-Eustache et Saba"), |
||
| 77 | (56, "BA", "Bosnie-Herzégovine"), |
||
| 78 | (57, "BW", "Botswana"), |
||
| 79 | (58, "BV", "Île Bouvet"), |
||
| 80 | (59, "BR", "Brésil"), |
||
| 81 | (60, "IO", "Territoire britannique de l\'océan Indien"), |
||
| 82 | (61, "VG", "Îles Vierges"), |
||
| 83 | (62, "BN", "Brunéi Darussalam"), |
||
| 84 | (63, "BG", "Bulgarie"), |
||
| 85 | (64, "BF", "Burkina Faso"), |
||
| 86 | (65, "BI", "Burundi"), |
||
| 87 | (66, "KH", "Cambodge"), |
||
| 88 | (67, "CM", "Cameroun"), |
||
| 89 | (68, "CV", "Cap-Vert"), |
||
| 90 | (69, "KY", "Îles Caïmans"), |
||
| 91 | (70, "CF", "Centrafrique"), |
||
| 92 | (71, "TD", "Tchad"), |
||
| 93 | (72, "CL", "Chili"), |
||
| 94 | (73, "CN", "Chine"), |
||
| 95 | (74, "CX", "Île Christmas"), |
||
| 96 | (75, "CC", "Îles Cocos"), |
||
| 97 | (76, "CO", "Colombie"), |
||
| 98 | (77, "KM", "Comores"), |
||
| 99 | (78, "CK", "Îles Cook"), |
||
| 100 | (79, "CR", "Costa Rica"), |
||
| 101 | (80, "HR", "Croatie"), |
||
| 102 | (81, "CU", "Cuba"), |
||
| 103 | (82, "CW", "Curaçao"), |
||
| 104 | (83, "CY", "Chypre"), |
||
| 105 | (84, "CD", "République démocratique du Congo"), |
||
| 106 | (85, "DJ", "Djibouti"), |
||
| 107 | (86, "DM", "Dominique"), |
||
| 108 | (87, "DO", "République Dominicaine"), |
||
| 109 | (88, "TL", "Timor Oriental"), |
||
| 110 | (89, "EC", "Équateur"), |
||
| 111 | (90, "EG", "Égypte"), |
||
| 112 | (91, "SV", "Salvador"), |
||
| 113 | (92, "GQ", "Guinée équatoriale"), |
||
| 114 | (93, "ER", "Érythrée"), |
||
| 115 | (94, "EE", "Estonie"), |
||
| 116 | (95, "ET", "Éthiopie"), |
||
| 117 | (96, "FK", "Îles Malouines"), |
||
| 118 | (97, "FO", "Îles Féroé"), |
||
| 119 | (98, "FJ", "Fidji"), |
||
| 120 | (99, "GF", "Guyane"), |
||
| 121 | (100, "PF", "Polynésie Française"), |
||
| 122 | (101, "TF", "Terres australes françaises"), |
||
| 123 | (102, "GA", "Gabon"), |
||
| 124 | (103, "GM", "Gambie"), |
||
| 125 | (104, "GE", "Géorgie"), |
||
| 126 | (105, "GH", "Ghana"), |
||
| 127 | (106, "GI", "Gibraltar"), |
||
| 128 | (107, "GL", "Groenland"), |
||
| 129 | (108, "GD", "Grenade"), |
||
| 130 | (109, "GP", "Guadeloupe"), |
||
| 131 | (110, "GU", "Guam"), |
||
| 132 | (111, "GT", "Guatemala"), |
||
| 133 | (112, "GG", "Guernesey"), |
||
| 134 | (113, "GN", "Guinée"), |
||
| 135 | (114, "GW", "Guinée-Bissau"), |
||
| 136 | (115, "GY", "Guyana"), |
||
| 137 | (116, "HT", "Haïti"), |
||
| 138 | (117, "HM", "Île Heard et îles McDonald"), |
||
| 139 | (118, "HN", "Honduras"), |
||
| 140 | (119, "HK", "Hong Kong"), |
||
| 141 | (120, "IN", "Inde"), |
||
| 142 | (121, "ID", "Indonésie"), |
||
| 143 | (122, "IR", "Iran"), |
||
| 144 | (123, "IQ", "Irak"), |
||
| 145 | (124, "IM", "Île de Man"), |
||
| 146 | (125, "IL", "Israël"), |
||
| 147 | (126, "CI", "Côte d\'Ivoire"), |
||
| 148 | (127, "JM", "Jamaïque"), |
||
| 149 | (128, "JE", "Jersey"), |
||
| 150 | (129, "JO", "Jordanie"), |
||
| 151 | (130, "KZ", "Kazakhstan"), |
||
| 152 | (131, "KE", "Kenya"), |
||
| 153 | (132, "KI", "Kiribati"), |
||
| 154 | (133, "XK", "Kosovo"), |
||
| 155 | (134, "KW", "Koweït"), |
||
| 156 | (135, "KG", "Kirghizistan"), |
||
| 157 | (136, "LA", "Laos"), |
||
| 158 | (137, "LV", "Lettonie"), |
||
| 159 | (138, "LB", "Liban"), |
||
| 160 | (139, "LS", "Lesotho"), |
||
| 161 | (140, "LR", "Liberia"), |
||
| 162 | (141, "LY", "Libye"), |
||
| 163 | (142, "LI", "Liechtenstein"), |
||
| 164 | (143, "LT", "Lituanie"), |
||
| 165 | (144, "MO", "Macao"), |
||
| 166 | (145, "MK", "Macédoine"), |
||
| 167 | (146, "MG", "Madagascar"), |
||
| 168 | (147, "MW", "Malawi"), |
||
| 169 | (148, "MY", "Malaisie"), |
||
| 170 | (149, "MV", "Maldives"), |
||
| 171 | (150, "ML", "Mali"), |
||
| 172 | (151, "MT", "Malte"), |
||
| 173 | (152, "MH", "Îles Marshall"), |
||
| 174 | (153, "MQ", "Martinique"), |
||
| 175 | (154, "MR", "Mauritanie"), |
||
| 176 | (155, "MU", "Maurice"), |
||
| 177 | (156, "YT", "Mayotte"), |
||
| 178 | (157, "FM", "Micronésie"), |
||
| 179 | (158, "MD", "Moldavie"), |
||
| 180 | (159, "MC", "Monaco"), |
||
| 181 | (160, "MN", "Mongolie"), |
||
| 182 | (161, "ME", "Monténégro"), |
||
| 183 | (162, "MS", "Montserrat"), |
||
| 184 | (163, "MA", "Maroc"), |
||
| 185 | (164, "MZ", "Mozambique"), |
||
| 186 | (165, "MM", "Myanmar"), |
||
| 187 | (166, "NA", "Namibie"), |
||
| 188 | (167, "NR", "Nauru"), |
||
| 189 | (168, "NP", "Népal"), |
||
| 190 | (169, "AN", "Antilles néerlandaises"), |
||
| 191 | (170, "NC", "Nouvelle-Calédonie"), |
||
| 192 | (171, "NI", "Nicaragua"), |
||
| 193 | (172, "NE", "Niger"), |
||
| 194 | (173, "NG", "Nigeria"), |
||
| 195 | (174, "NU", "Nioué"), |
||
| 196 | (175, "NF", "Île Norfolk"), |
||
| 197 | (176, "KP", "Corée du Nord"), |
||
| 198 | (177, "MP", "Îles Mariannes du Nord"), |
||
| 199 | (178, "OM", "Oman"), |
||
| 200 | (179, "PK", "Pakistan"), |
||
| 201 | (180, "PW", "Palaos"), |
||
| 202 | (181, "PS", "Territoire palestinien"), |
||
| 203 | (182, "PA", "Panama"), |
||
| 204 | (183, "PG", "Papouasie-Nouvelle Guinée"), |
||
| 205 | (184, "PY", "Paraguay"), |
||
| 206 | (185, "PE", "Pérou"), |
||
| 207 | (186, "PH", "Philippines"), |
||
| 208 | (187, "PN", "Pitcairn"), |
||
| 209 | (188, "PR", "Porto Rico"), |
||
| 210 | (189, "QA", "Qatar"), |
||
| 211 | (190, "RE", "Réunion"), |
||
| 212 | (191, "CG", "Congo-Brazzaville"), |
||
| 213 | (192, "RO", "Roumanie"), |
||
| 214 | (193, "RU", "Russie"), |
||
| 215 | (194, "RW", "Rwanda"), |
||
| 216 | (195, "ST", "São Tomé-et-Príncipe"), |
||
| 217 | (196, "BL", "Saint-Barthélémy"), |
||
| 218 | (197, "SH", "Sainte-Hélène"), |
||
| 219 | (198, "KN", "Saint-Christophe-et-Niévès"), |
||
| 220 | (199, "LC", "Sainte-Lucie"), |
||
| 221 | (200, "MF", "Saint-Martin"), |
||
| 222 | (201, "PM", "Saint-Pierre et Miquelon"), |
||
| 223 | (202, "VC", "Saint-Vincent-et-les Grenadines"), |
||
| 224 | (203, "WS", "Samoa"), |
||
| 225 | (204, "SM", "Saint-Marin"), |
||
| 226 | (205, "SA", "Arabie saoudite"), |
||
| 227 | (206, "SN", "Sénégal"), |
||
| 228 | (207, "RS", "Serbie"), |
||
| 229 | (208, "SC", "Seychelles"), |
||
| 230 | (209, "SL", "Sierra Leone"), |
||
| 231 | (210, "SG", "Singapour"), |
||
| 232 | (211, "SX", "Saint-Martin"), |
||
| 233 | (212, "SI", "Slovénie"), |
||
| 234 | (213, "SB", "Îles Salomon"), |
||
| 235 | (214, "SO", "Somalie"), |
||
| 236 | (215, "ZA", "Afrique du Sud"), |
||
| 237 | (216, "GS", "Géorgie du Sud et les îles Sandwich du Sud"), |
||
| 238 | (217, "SS", "Sud-Soudan"), |
||
| 239 | (218, "LK", "Sri Lanka"), |
||
| 240 | (219, "SD", "Soudan"), |
||
| 241 | (220, "SR", "Surinam"), |
||
| 242 | (221, "SJ", "Svalbard et Île Jan Mayen"), |
||
| 243 | (222, "SZ", "Swaziland"), |
||
| 244 | (223, "SY", "Syrie"), |
||
| 245 | (224, "TW", "Taïwan"), |
||
| 246 | (225, "TJ", "Tadjikistan"), |
||
| 247 | (226, "TZ", "Tanzanie"), |
||
| 248 | (227, "TH", "Thaïlande"), |
||
| 249 | (228, "TG", "République Togolaise"), |
||
| 250 | (229, "TK", "Tokelau"), |
||
| 251 | (230, "TO", "Tonga"), |
||
| 252 | (231, "TT", "Trinidad et Tobago"), |
||
| 253 | (232, "TN", "Tunisie"), |
||
| 254 | (233, "TM", "Turkménistan"), |
||
| 255 | (234, "TC", "Îles Turques-et-Caïques"), |
||
| 256 | (235, "TV", "Tuvalu"), |
||
| 257 | (236, "UM", "Îles mineures éloignées des États-Unis"), |
||
| 258 | (237, "VI", "Îles Vierges des États-Unis"), |
||
| 259 | (238, "UG", "Ouganda"), |
||
| 260 | (239, "UA", "Ukraine"), |
||
| 261 | (240, "AE", "Émirats Arabes Unis"), |
||
| 262 | (241, "UY", "Uruguay"), |
||
| 263 | (242, "UZ", "Ouzbékistan"), |
||
| 264 | (243, "VU", "Vanuatu"), |
||
| 265 | (244, "VA", "Vatican"), |
||
| 266 | (245, "VE", "Vénézuéla"), |
||
| 267 | (246, "VN", "Vietnam"), |
||
| 268 | (247, "WF", "Wallis-et-Futuna"), |
||
| 269 | (248, "EH", "Sahara Occidental"), |
||
| 270 | (249, "YE", "Yémen"), |
||
| 271 | (250, "ZM", "Zambie"), |
||
| 272 | (251, "ZW", "Zimbabwe") |
||
| 273 | '); |
||
| 274 | |||
| 275 | $this->addSql('ALTER TABLE user ADD country_id INT DEFAULT NULL'); |
||
| 276 | $this->addSql('ALTER TABLE user ADD CONSTRAINT FK_8D93D649F92F3E70 FOREIGN KEY (country_id) REFERENCES country (id) ON DELETE SET NULL'); |
||
| 277 | $this->addSql('CREATE INDEX IDX_8D93D649F92F3E70 ON user (country_id)'); |
||
| 278 | } |
||
| 280 |
