Version20240816121145_DatabaseEntry::down() - Code Metrics - Inspection of "split tests folder into unit and integration tests" - st-universe/core - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — dev ( 5ebfc2...850c22 )

by Janko

created 2024-11-26 10:02 UTC

Version20240816121145_DatabaseEntry::down() A

↳ Parent: Version20240816121145_DatabaseEntry

Complexity

Conditions	1
Paths	1

Size

Total Lines	7
Code Lines	5

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
eloc	5
nc	1
nop	1
dl	0
loc	7
rs	10
c	0
b	0
f	0

<?php

declare(strict_types=1);

namespace Stu\Migrations\Pgsql;

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

final class Version20240816121145_DatabaseEntry extends AbstractMigration
{
    #[Override]
    public function getDescription(): string
    {
        return 'Add database entry foreign keys and indices';
    }

    #[Override]
    public function up(Schema $schema): void
    {
        $this->addSql('ALTER TABLE stu_ships ALTER database_id DROP NOT NULL');
        $this->addSql('UPDATE stu_ships SET database_id = null WHERE database_id = 0');
        $this->addSql('ALTER TABLE stu_colonies ADD CONSTRAINT FK_D1C60F73F0AA09DB FOREIGN KEY (database_id) REFERENCES stu_database_entrys (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('CREATE UNIQUE INDEX UNIQ_D1C60F73F0AA09DB ON stu_colonies (database_id)');
        $this->addSql('ALTER TABLE stu_ships ADD CONSTRAINT FK_A560DD56F0AA09DB FOREIGN KEY (database_id) REFERENCES stu_database_entrys (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('CREATE UNIQUE INDEX UNIQ_A560DD56F0AA09DB ON stu_ships (database_id)');
    }

    #[Override]
    public function down(Schema $schema): void
    {
        $this->addSql('ALTER TABLE stu_ships DROP CONSTRAINT FK_A560DD56F0AA09DB');
        $this->addSql('DROP INDEX UNIQ_A560DD56F0AA09DB');
        $this->addSql('ALTER TABLE stu_colonies DROP CONSTRAINT FK_D1C60F73F0AA09DB');
        $this->addSql('DROP INDEX UNIQ_D1C60F73F0AA09DB');
    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			namespace Stu\Migrations\Pgsql;
6
7			use Override;
			0 ignored issues – show Bug introduced 2024-11-14 12:29 UTC by Report Bug Copy Issue Report The type `Override` 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...
8			use Doctrine\DBAL\Schema\Schema;
9			use Doctrine\Migrations\AbstractMigration;
10
11			final class Version20240816121145_DatabaseEntry extends AbstractMigration
12			{
13			#[Override]
14			public function getDescription(): string
15			{
16			return 'Add database entry foreign keys and indices';
17			}
18
19			#[Override]
20			public function up(Schema $schema): void
21			{
22			$this->addSql('ALTER TABLE stu_ships ALTER database_id DROP NOT NULL');
23			$this->addSql('UPDATE stu_ships SET database_id = null WHERE database_id = 0');
24			$this->addSql('ALTER TABLE stu_colonies ADD CONSTRAINT FK_D1C60F73F0AA09DB FOREIGN KEY (database_id) REFERENCES stu_database_entrys (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
25			$this->addSql('CREATE UNIQUE INDEX UNIQ_D1C60F73F0AA09DB ON stu_colonies (database_id)');
26			$this->addSql('ALTER TABLE stu_ships ADD CONSTRAINT FK_A560DD56F0AA09DB FOREIGN KEY (database_id) REFERENCES stu_database_entrys (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
27			$this->addSql('CREATE UNIQUE INDEX UNIQ_A560DD56F0AA09DB ON stu_ships (database_id)');
28			}
29
30			#[Override]
31			public function down(Schema $schema): void
32			{
33			$this->addSql('ALTER TABLE stu_ships DROP CONSTRAINT FK_A560DD56F0AA09DB');
34			$this->addSql('DROP INDEX UNIQ_A560DD56F0AA09DB');
35			$this->addSql('ALTER TABLE stu_colonies DROP CONSTRAINT FK_D1C60F73F0AA09DB');
36			$this->addSql('DROP INDEX UNIQ_D1C60F73F0AA09DB');
37			}
38			}
39

st-universe / core

Push — dev ( 5ebfc2...850c22 )

Version20240816121145_DatabaseEntry::down() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like