Version20210502131525::up() - Code Metrics - Inspection of "Feat/create user bounded context (#171)" - Dev-Int/glsr - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — develop ( e1f02f...e3219b )

by Laurent

created 2021-05-06 20:17 UTC

Version20210502131525::up() B

↳ Parent: Version20210502131525

Complexity

Conditions	1
Paths	1

Size

Total Lines	77
Code Lines	70

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	70
c	1
b	0
f	0
dl	0
loc	77
rs	8.6545
cc	1
nc	1
nop	1

How to fix Long Method

<?php

declare(strict_types=1);

/*
 * This file is part of the G.L.S.R. Apps package.
 *
 * (c) Dev-Int Création <[email protected]>.
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

namespace Core\Infrastructure\Doctrine\Migrations;

use Doctrine\DBAL\Schema\Schema;
filter:
    dependency_paths: ["lib/*"]
use Doctrine\Migrations\AbstractMigration;
filter:
    dependency_paths: ["lib/*"]

/**
 * Auto-generated Migration: Please modify to your needs!
 */
final class Version20210502131525 extends AbstractMigration
{
    public function getDescription(): string
    {
        return 'Create the first throw of necessary tables.';
    }

    public function up(Schema $schema): void
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->addSql(
            'CREATE TABLE company (' .
            'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', ' .
            'company_name VARCHAR(255) NOT NULL, ' .
            'address VARCHAR(255) NOT NULL, ' .
            'zip_code VARCHAR(5) NOT NULL, ' .
            'town VARCHAR(255) NOT NULL, ' .
            'country VARCHAR(255) NOT NULL, ' .
            'phone VARCHAR(14) NOT NULL, ' .
            'facsimile VARCHAR(14) DEFAULT NULL, ' .
            'email VARCHAR(255) NOT NULL, ' .
            'contact_name VARCHAR(255) NOT NULL, ' .
            'cellphone VARCHAR(14) NOT NULL, ' .
            'slug VARCHAR(255) NOT NULL, ' .
            'UNIQUE INDEX UNIQ_4FBF094F1D4E64E8 (company_name), ' .
            'UNIQUE INDEX UNIQ_4FBF094F989D9B62 (slug), ' .
            'PRIMARY KEY(uuid)' .
            ') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'
        );
        $this->addSql(
            'CREATE TABLE settings (' .
            'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', ' .
            'locale VARCHAR(255) NOT NULL, ' .
            'currency VARCHAR(255) NOT NULL, ' .
            'PRIMARY KEY(uuid)' .
            ') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'
        );
        $this->addSql(
            'CREATE TABLE supplier (' .
            'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', ' .
            'family_log VARCHAR(255) NOT NULL, ' .
            'delay_delivery INT NOT NULL, ' .
            'order_days LONGTEXT NOT NULL COMMENT \'(DC2Type:array)\', ' .
            'active TINYINT(1) NOT NULL, ' .
            'company_name VARCHAR(255) NOT NULL, ' .
            'address VARCHAR(255) NOT NULL, ' .
            'zip_code VARCHAR(5) NOT NULL, ' .
            'town VARCHAR(255) NOT NULL, ' .
            'country VARCHAR(255) NOT NULL, ' .
            'phone VARCHAR(14) NOT NULL, ' .
            'facsimile VARCHAR(14) DEFAULT NULL, ' .
            'email VARCHAR(255) NOT NULL, ' .
            'contact_name VARCHAR(255) NOT NULL, ' .
            'cellphone VARCHAR(14) NOT NULL, s' .
            'lug VARCHAR(255) NOT NULL, ' .
            'UNIQUE INDEX UNIQ_9B2A6C7E1D4E64E8 (company_name), ' .
            'UNIQUE INDEX UNIQ_9B2A6C7E989D9B62 (slug), ' .
            'PRIMARY KEY(uuid)' .
            ') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'
        );
        $this->addSql(
            'CREATE TABLE user (' .
            'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', ' .
            'username VARCHAR(150) NOT NULL, ' .
            'email VARCHAR(255) NOT NULL, ' .
            'password VARCHAR(120) NOT NULL, ' .
            'roles LONGTEXT NOT NULL COMMENT \'(DC2Type:array)\', ' .
            'PRIMARY KEY(uuid)' .
            ') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'
        );
        $this->addSql(
            'CREATE TABLE messenger_messages (' .
            'id BIGINT AUTO_INCREMENT NOT NULL, ' .
            'body LONGTEXT NOT NULL, ' .
            'headers LONGTEXT NOT NULL, ' .
            'queue_name VARCHAR(190) NOT NULL, ' .
            'created_at DATETIME NOT NULL, ' .
            'available_at DATETIME NOT NULL, ' .
            'delivered_at DATETIME DEFAULT NULL, ' .
            'INDEX IDX_75EA56E0FB7336F0 (queue_name), ' .
            'INDEX IDX_75EA56E0E3BD61CE (available_at), ' .
            'INDEX IDX_75EA56E016BA31DB (delivered_at), ' .
            'PRIMARY KEY(id)' .
            ') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'
        );
    }

    public function down(Schema $schema): void
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->addSql('DROP TABLE company');
        $this->addSql('DROP TABLE settings');
        $this->addSql('DROP TABLE supplier');
        $this->addSql('DROP TABLE user');
        $this->addSql('DROP TABLE messenger_messages');
    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			/*
6			* This file is part of the G.L.S.R. Apps package.
7			*
8			* (c) Dev-Int Création <[email protected]>.
9			*
10			* For the full copyright and license information, please view the LICENSE
11			* file that was distributed with this source code.
12			*/
13
14			namespace Core\Infrastructure\Doctrine\Migrations;
15
16			use Doctrine\DBAL\Schema\Schema;
			0 ignored issues – show Bug introduced 2021-02-19 16:54 UTC by Report Bug Copy Issue Report The type `Doctrine\DBAL\Schema\Schema` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
17			use Doctrine\Migrations\AbstractMigration;
			0 ignored issues – show Bug introduced 2021-05-02 13:27 UTC by Report Bug Copy Issue Report The type `Doctrine\Migrations\AbstractMigration` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
18
19			/**
20			* Auto-generated Migration: Please modify to your needs!
21			*/
22			final class Version20210502131525 extends AbstractMigration
23			{
24			public function getDescription(): string
25			{
26			return 'Create the first throw of necessary tables.';
27			}
28
29			public function up(Schema $schema): void
30			{
31			// this up() migration is auto-generated, please modify it to your needs
32			$this->addSql(
33			'CREATE TABLE company (' .
34			'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', ' .
35			'company_name VARCHAR(255) NOT NULL, ' .
36			'address VARCHAR(255) NOT NULL, ' .
37			'zip_code VARCHAR(5) NOT NULL, ' .
38			'town VARCHAR(255) NOT NULL, ' .
39			'country VARCHAR(255) NOT NULL, ' .
40			'phone VARCHAR(14) NOT NULL, ' .
41			'facsimile VARCHAR(14) DEFAULT NULL, ' .
42			'email VARCHAR(255) NOT NULL, ' .
43			'contact_name VARCHAR(255) NOT NULL, ' .
44			'cellphone VARCHAR(14) NOT NULL, ' .
45			'slug VARCHAR(255) NOT NULL, ' .
46			'UNIQUE INDEX UNIQ_4FBF094F1D4E64E8 (company_name), ' .
47			'UNIQUE INDEX UNIQ_4FBF094F989D9B62 (slug), ' .
48			'PRIMARY KEY(uuid)' .
49			') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'
50			);
51			$this->addSql(
52			'CREATE TABLE settings (' .
53			'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', ' .
54			'locale VARCHAR(255) NOT NULL, ' .
55			'currency VARCHAR(255) NOT NULL, ' .
56			'PRIMARY KEY(uuid)' .
57			') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'
58			);
59			$this->addSql(
60			'CREATE TABLE supplier (' .
61			'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', ' .
62			'family_log VARCHAR(255) NOT NULL, ' .
63			'delay_delivery INT NOT NULL, ' .
64			'order_days LONGTEXT NOT NULL COMMENT \'(DC2Type:array)\', ' .
65			'active TINYINT(1) NOT NULL, ' .
66			'company_name VARCHAR(255) NOT NULL, ' .
67			'address VARCHAR(255) NOT NULL, ' .
68			'zip_code VARCHAR(5) NOT NULL, ' .
69			'town VARCHAR(255) NOT NULL, ' .
70			'country VARCHAR(255) NOT NULL, ' .
71			'phone VARCHAR(14) NOT NULL, ' .
72			'facsimile VARCHAR(14) DEFAULT NULL, ' .
73			'email VARCHAR(255) NOT NULL, ' .
74			'contact_name VARCHAR(255) NOT NULL, ' .
75			'cellphone VARCHAR(14) NOT NULL, s' .
76			'lug VARCHAR(255) NOT NULL, ' .
77			'UNIQUE INDEX UNIQ_9B2A6C7E1D4E64E8 (company_name), ' .
78			'UNIQUE INDEX UNIQ_9B2A6C7E989D9B62 (slug), ' .
79			'PRIMARY KEY(uuid)' .
80			') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'
81			);
82			$this->addSql(
83			'CREATE TABLE user (' .
84			'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', ' .
85			'username VARCHAR(150) NOT NULL, ' .
86			'email VARCHAR(255) NOT NULL, ' .
87			'password VARCHAR(120) NOT NULL, ' .
88			'roles LONGTEXT NOT NULL COMMENT \'(DC2Type:array)\', ' .
89			'PRIMARY KEY(uuid)' .
90			') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'
91			);
92			$this->addSql(
93			'CREATE TABLE messenger_messages (' .
94			'id BIGINT AUTO_INCREMENT NOT NULL, ' .
95			'body LONGTEXT NOT NULL, ' .
96			'headers LONGTEXT NOT NULL, ' .
97			'queue_name VARCHAR(190) NOT NULL, ' .
98			'created_at DATETIME NOT NULL, ' .
99			'available_at DATETIME NOT NULL, ' .
100			'delivered_at DATETIME DEFAULT NULL, ' .
101			'INDEX IDX_75EA56E0FB7336F0 (queue_name), ' .
102			'INDEX IDX_75EA56E0E3BD61CE (available_at), ' .
103			'INDEX IDX_75EA56E016BA31DB (delivered_at), ' .
104			'PRIMARY KEY(id)' .
105			') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'
106			);
107			}
108
109			public function down(Schema $schema): void
110			{
111			// this down() migration is auto-generated, please modify it to your needs
112			$this->addSql('DROP TABLE company');
113			$this->addSql('DROP TABLE settings');
114			$this->addSql('DROP TABLE supplier');
115			$this->addSql('DROP TABLE user');
116			$this->addSql('DROP TABLE messenger_messages');
117			}
118			}
119

Dev-Int / glsr

Push — develop ( e1f02f...e3219b )

Version20210502131525::up() B

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like