Version20181003144137::up() - Code Metrics - unil-lettres/dilps-tiresias - Measure and Improve Code Quality continuously with Scrutinizer

Version20181003144137::up() A
last analyzed 2025-08-05 08:14 UTC

↳ Parent: Version20181003144137

Complexity

Conditions	1
Paths	1

Size

Total Lines	183
Code Lines	21

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes

Metric	Value
eloc	21
c	0
b	0
f	0
dl	0
loc	183
ccs	0
cts	42
cp	0
rs	9.584
cc	1
nc	1
nop	1
crap	2

How to fix Long Method

<?php

declare(strict_types=1);

namespace Application\Migration;

use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;

class Version20181003144137 extends AbstractMigration
{
    public function up(Schema $schema): void
    {
        $this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT 
NOW(),
creator_id,
owner_id,
id,
\'2451911\',
\'2488434\'
FROM card WHERE dating REGEXP \'(\\\\W|^)XXI(e|ème|)(\\\\W|$)\'');

        $this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT 
NOW(),
creator_id,
owner_id,
id,
\'2415386\',
\'2451910\'
FROM card WHERE dating REGEXP \'(\\\\W|^)XX(e|ème|)(\\\\W|$)\'');

        $this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT 
NOW(),
creator_id,
owner_id,
id,
\'2378862\',
\'2415385\'
FROM card WHERE dating REGEXP \'(\\\\W|^)XIX(e|ème|)(\\\\W|$)\'');

        $this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT 
NOW(),
creator_id,
owner_id,
id,
\'2342338\',
\'2378861\'
FROM card WHERE dating REGEXP \'(\\\\W|^)XVIII(e|ème|)(\\\\W|$)\'');

        $this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT 
NOW(),
creator_id,
owner_id,
id,
\'2305814\',
\'2342337\'
FROM card WHERE dating REGEXP \'(\\\\W|^)XVII(e|ème|)(\\\\W|$)\'');

        $this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT 
NOW(),
creator_id,
owner_id,
id,
\'2269289\',
\'2305813\'
FROM card WHERE dating REGEXP \'(\\\\W|^)XVI(e|ème|)(\\\\W|$)\'');

        $this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT 
NOW(),
creator_id,
owner_id,
id,
\'2232765\',
\'2269288\'
FROM card WHERE dating REGEXP \'(\\\\W|^)XV(e|ème|)(\\\\W|$)\'');

        $this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT 
NOW(),
creator_id,
owner_id,
id,
\'2196241\',
\'2232764\'
FROM card WHERE dating REGEXP \'(\\\\W|^)XIV(e|ème|)(\\\\W|$)\'');

        $this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT 
NOW(),
creator_id,
owner_id,
id,
\'2159717\',
\'2196240\'
FROM card WHERE dating REGEXP \'(\\\\W|^)XIII(e|ème|)(\\\\W|$)\'');

        $this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT 
NOW(),
creator_id,
owner_id,
id,
\'2123192\',
\'2159716\'
FROM card WHERE dating REGEXP \'(\\\\W|^)XII(e|ème|)(\\\\W|$)\'');

        $this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT 
NOW(),
creator_id,
owner_id,
id,
\'2086668\',
\'2123191\'
FROM card WHERE dating REGEXP \'(\\\\W|^)XI(e|ème|)(\\\\W|$)\'');

        $this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT 
NOW(),
creator_id,
owner_id,
id,
\'2050144\',
\'2086667\'
FROM card WHERE dating REGEXP \'(\\\\W|^)X(e|ème|)(\\\\W|$)\'');

        $this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT 
NOW(),
creator_id,
owner_id,
id,
\'2013620\',
\'2050143\'
FROM card WHERE dating REGEXP \'(\\\\W|^)IX(e|ème|)(\\\\W|$)\'');

        $this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT 
NOW(),
creator_id,
owner_id,
id,
\'1977095\',
\'2013619\'
FROM card WHERE dating REGEXP \'(\\\\W|^)VIII(e|ème|)(\\\\W|$)\'');

        $this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT 
NOW(),
creator_id,
owner_id,
id,
\'1940571\',
\'1977094\'
FROM card WHERE dating REGEXP \'(\\\\W|^)VII(e|ème|)(\\\\W|$)\'');

        $this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT 
NOW(),
creator_id,
owner_id,
id,
\'1904047\',
\'1940570\'
FROM card WHERE dating REGEXP \'(\\\\W|^)VI(e|ème|)(\\\\W|$)\'');

        $this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT 
NOW(),
creator_id,
owner_id,
id,
\'1867523\',
\'1904046\'
FROM card WHERE dating REGEXP \'(\\\\W|^)V(e|ème|)(\\\\W|$)\'');

        $this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT 
NOW(),
creator_id,
owner_id,
id,
\'1830998\',
\'1867522\'
FROM card WHERE dating REGEXP \'(\\\\W|^)IV(e|ème|)(\\\\W|$)\'');

        $this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT 
NOW(),
creator_id,
owner_id,
id,
\'1794474\',
\'1830997\'
FROM card WHERE dating REGEXP \'(\\\\W|^)III(e|ème|)(\\\\W|$)\'');

        $this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT 
NOW(),
creator_id,
owner_id,
id,
\'1757950\',
\'1794473\'
FROM card WHERE dating REGEXP \'(\\\\W|^)II(e|ème|)(\\\\W|$)\'');

        $this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT 
NOW(),
creator_id,
owner_id,
id,
\'1721426\',
\'1757949\'
FROM card WHERE dating REGEXP \'(\\\\W|^)I(e|ème|)(\\\\W|$)\'');
    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			namespace Application\Migration;
6
7			use Doctrine\DBAL\Schema\Schema;
8			use Doctrine\Migrations\AbstractMigration;
9
10			class Version20181003144137 extends AbstractMigration
11			{
12			public function up(Schema $schema): void
13			{
14			$this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT
15			NOW(),
16			creator_id,
17			owner_id,
18			id,
19			\'2451911\',
20			\'2488434\'
21			FROM card WHERE dating REGEXP \'(\\\\W\|^)XXI(e\|ème\|)(\\\\W\|$)\'');
22
23			$this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT
24			NOW(),
25			creator_id,
26			owner_id,
27			id,
28			\'2415386\',
29			\'2451910\'
30			FROM card WHERE dating REGEXP \'(\\\\W\|^)XX(e\|ème\|)(\\\\W\|$)\'');
31
32			$this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT
33			NOW(),
34			creator_id,
35			owner_id,
36			id,
37			\'2378862\',
38			\'2415385\'
39			FROM card WHERE dating REGEXP \'(\\\\W\|^)XIX(e\|ème\|)(\\\\W\|$)\'');
40
41			$this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT
42			NOW(),
43			creator_id,
44			owner_id,
45			id,
46			\'2342338\',
47			\'2378861\'
48			FROM card WHERE dating REGEXP \'(\\\\W\|^)XVIII(e\|ème\|)(\\\\W\|$)\'');
49
50			$this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT
51			NOW(),
52			creator_id,
53			owner_id,
54			id,
55			\'2305814\',
56			\'2342337\'
57			FROM card WHERE dating REGEXP \'(\\\\W\|^)XVII(e\|ème\|)(\\\\W\|$)\'');
58
59			$this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT
60			NOW(),
61			creator_id,
62			owner_id,
63			id,
64			\'2269289\',
65			\'2305813\'
66			FROM card WHERE dating REGEXP \'(\\\\W\|^)XVI(e\|ème\|)(\\\\W\|$)\'');
67
68			$this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT
69			NOW(),
70			creator_id,
71			owner_id,
72			id,
73			\'2232765\',
74			\'2269288\'
75			FROM card WHERE dating REGEXP \'(\\\\W\|^)XV(e\|ème\|)(\\\\W\|$)\'');
76
77			$this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT
78			NOW(),
79			creator_id,
80			owner_id,
81			id,
82			\'2196241\',
83			\'2232764\'
84			FROM card WHERE dating REGEXP \'(\\\\W\|^)XIV(e\|ème\|)(\\\\W\|$)\'');
85
86			$this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT
87			NOW(),
88			creator_id,
89			owner_id,
90			id,
91			\'2159717\',
92			\'2196240\'
93			FROM card WHERE dating REGEXP \'(\\\\W\|^)XIII(e\|ème\|)(\\\\W\|$)\'');
94
95			$this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT
96			NOW(),
97			creator_id,
98			owner_id,
99			id,
100			\'2123192\',
101			\'2159716\'
102			FROM card WHERE dating REGEXP \'(\\\\W\|^)XII(e\|ème\|)(\\\\W\|$)\'');
103
104			$this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT
105			NOW(),
106			creator_id,
107			owner_id,
108			id,
109			\'2086668\',
110			\'2123191\'
111			FROM card WHERE dating REGEXP \'(\\\\W\|^)XI(e\|ème\|)(\\\\W\|$)\'');
112
113			$this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT
114			NOW(),
115			creator_id,
116			owner_id,
117			id,
118			\'2050144\',
119			\'2086667\'
120			FROM card WHERE dating REGEXP \'(\\\\W\|^)X(e\|ème\|)(\\\\W\|$)\'');
121
122			$this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT
123			NOW(),
124			creator_id,
125			owner_id,
126			id,
127			\'2013620\',
128			\'2050143\'
129			FROM card WHERE dating REGEXP \'(\\\\W\|^)IX(e\|ème\|)(\\\\W\|$)\'');
130
131			$this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT
132			NOW(),
133			creator_id,
134			owner_id,
135			id,
136			\'1977095\',
137			\'2013619\'
138			FROM card WHERE dating REGEXP \'(\\\\W\|^)VIII(e\|ème\|)(\\\\W\|$)\'');
139
140			$this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT
141			NOW(),
142			creator_id,
143			owner_id,
144			id,
145			\'1940571\',
146			\'1977094\'
147			FROM card WHERE dating REGEXP \'(\\\\W\|^)VII(e\|ème\|)(\\\\W\|$)\'');
148
149			$this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT
150			NOW(),
151			creator_id,
152			owner_id,
153			id,
154			\'1904047\',
155			\'1940570\'
156			FROM card WHERE dating REGEXP \'(\\\\W\|^)VI(e\|ème\|)(\\\\W\|$)\'');
157
158			$this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT
159			NOW(),
160			creator_id,
161			owner_id,
162			id,
163			\'1867523\',
164			\'1904046\'
165			FROM card WHERE dating REGEXP \'(\\\\W\|^)V(e\|ème\|)(\\\\W\|$)\'');
166
167			$this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT
168			NOW(),
169			creator_id,
170			owner_id,
171			id,
172			\'1830998\',
173			\'1867522\'
174			FROM card WHERE dating REGEXP \'(\\\\W\|^)IV(e\|ème\|)(\\\\W\|$)\'');
175
176			$this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT
177			NOW(),
178			creator_id,
179			owner_id,
180			id,
181			\'1794474\',
182			\'1830997\'
183			FROM card WHERE dating REGEXP \'(\\\\W\|^)III(e\|ème\|)(\\\\W\|$)\'');
184
185			$this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT
186			NOW(),
187			creator_id,
188			owner_id,
189			id,
190			\'1757950\',
191			\'1794473\'
192			FROM card WHERE dating REGEXP \'(\\\\W\|^)II(e\|ème\|)(\\\\W\|$)\'');
193
194			$this->addSql('INSERT INTO dating (creation_date, creator_id, owner_id, card_id, `from`, `to`) SELECT
195			NOW(),
196			creator_id,
197			owner_id,
198			id,
199			\'1721426\',
200			\'1757949\'
201			FROM card WHERE dating REGEXP \'(\\\\W\|^)I(e\|ème\|)(\\\\W\|$)\'');
202			}
203			}
204

unil-lettres / dilps-tiresias

Version20181003144137::up() A last analyzed 2025-08-05 08:14 UTC

Complexity

Size

Duplication

Code Coverage

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like

Version20181003144137::up() A
last analyzed 2025-08-05 08:14 UTC