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

Version20240805080302::down() A
last analyzed 2025-08-05 08:14 UTC

↳ Parent: Version20240805080302

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	15

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	15
c	1
b	0
f	0
dl	0
loc	3
ccs	0
cts	2
cp	0
rs	9.7666
cc	1
nc	1
nop	1
crap	2

<?php

declare(strict_types=1);

namespace Application\Migration;

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

class Version20240805080302 extends AbstractMigration
{
    public function up(Schema $schema): void
    {
        $this->addSql(<<<'SQL'
                CREATE FULLTEXT INDEX FULLTEXT__CARD_CUSTOM_SEARCH ON card (
                    dating,
                    cached_artist_names,
                    addition,
                    expanded_name,
                    material,
                    dilps_domain,
                    technique_author,
                    object_reference,
                    corpus,
                    street,
                    locality,
                    code,
                    name
                );

                CREATE FULLTEXT INDEX FULLTEXT__CARD_LOCALITY ON card (
                    locality
                );

                CREATE FULLTEXT INDEX FULLTEXT__CARD_NAMES ON card (
                    name, expanded_name
                );

                CREATE FULLTEXT INDEX FULLTEXT__COUNTRY_NAME ON country (
                    name
                );

                CREATE FULLTEXT INDEX FULLTEXT__DOMAIN_NAME ON domain (
                    name
                );

                CREATE FULLTEXT INDEX FULLTEXT__INSTITUTION_NAME ON institution (
                    name
                );

                CREATE FULLTEXT INDEX FULLTEXT__INSTITUTION_LOCALITY ON institution (
                    locality
                );

            SQL);
    }

    public function down(Schema $schema): void
    {
        $this->addSql(<<<'SQL'
                DROP INDEX FULLTEXT__CARD_CUSTOM_SEARCH ON card;

                DROP INDEX FULLTEXT__CARD_LOCALITY ON card;

                DROP INDEX FULLTEXT__CARD_NAMES ON card;

                DROP INDEX FULLTEXT__COUNTRY_NAME ON country;

                DROP INDEX FULLTEXT__DOMAIN_NAME ON domain;

                DROP INDEX FULLTEXT__INSTITUTION_NAME ON institution;

                DROP INDEX FULLTEXT__INSTITUTION_LOCALITY ON institution;
            SQL);
    }
}


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 Version20240805080302 extends AbstractMigration
11			{
12			public function up(Schema $schema): void
13			{
14			$this->addSql(<<<'SQL'
15			CREATE FULLTEXT INDEX FULLTEXT__CARD_CUSTOM_SEARCH ON card (
16			dating,
17			cached_artist_names,
18			addition,
19			expanded_name,
20			material,
21			dilps_domain,
22			technique_author,
23			object_reference,
24			corpus,
25			street,
26			locality,
27			code,
28			name
29			);
30
31			CREATE FULLTEXT INDEX FULLTEXT__CARD_LOCALITY ON card (
32			locality
33			);
34
35			CREATE FULLTEXT INDEX FULLTEXT__CARD_NAMES ON card (
36			name, expanded_name
37			);
38
39			CREATE FULLTEXT INDEX FULLTEXT__COUNTRY_NAME ON country (
40			name
41			);
42
43			CREATE FULLTEXT INDEX FULLTEXT__DOMAIN_NAME ON domain (
44			name
45			);
46
47			CREATE FULLTEXT INDEX FULLTEXT__INSTITUTION_NAME ON institution (
48			name
49			);
50
51			CREATE FULLTEXT INDEX FULLTEXT__INSTITUTION_LOCALITY ON institution (
52			locality
53			);
54
55			SQL);
56			}
57
58			public function down(Schema $schema): void
59			{
60			$this->addSql(<<<'SQL'
61			DROP INDEX FULLTEXT__CARD_CUSTOM_SEARCH ON card;
62
63			DROP INDEX FULLTEXT__CARD_LOCALITY ON card;
64
65			DROP INDEX FULLTEXT__CARD_NAMES ON card;
66
67			DROP INDEX FULLTEXT__COUNTRY_NAME ON country;
68
69			DROP INDEX FULLTEXT__DOMAIN_NAME ON domain;
70
71			DROP INDEX FULLTEXT__INSTITUTION_NAME ON institution;
72
73			DROP INDEX FULLTEXT__INSTITUTION_LOCALITY ON institution;
74			SQL);
75			}
76			}
77

unil-lettres / dilps-tiresias

Version20240805080302::down() A last analyzed 2025-08-05 08:14 UTC

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like

Version20240805080302::down() A
last analyzed 2025-08-05 08:14 UTC