App\Game\Infrastructure\Repository\DoctrineMigrations\Version20210411114720

Complexity

Total Complexity

6

Size/Duplication

Total Lines	54
Duplicated Lines	0 %

Test Coverage

Coverage

0%

Importance

Changes

0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	up()	0	4	1
A	createAndUpdateDate()	0	4	1
A	createHistoryTable()	0	11	1
A	createPlayerTable()	0	13	1
A	getDescription()	0	3	1
A	down()	0	4	1

<?php

declare(strict_types=1);

namespace App\Game\Infrastructure\Repository\DoctrineMigrations;

use Doctrine\DBAL\Schema\Schema;

The type Doctrine\DBAL\Schema\Schema was not found. Maybe you did not declare it correctly or list all dependencies?

use Doctrine\DBAL\Schema\Table;

The type Doctrine\DBAL\Schema\Table was not found. Maybe you did not declare it correctly or list all dependencies?

use Doctrine\DBAL\Types\Types;

The type Doctrine\DBAL\Types\Types was not found. Maybe you did not declare it correctly or list all dependencies?

use Doctrine\Migrations\AbstractMigration;

The type Doctrine\Migrations\AbstractMigration was not found. Maybe you did not declare it correctly or list all dependencies?

final class Version20210411114720 extends AbstractMigration
{
    private const PLAYER_TABLE = 'player';
    private const HISTORY_TABLE = 'history';

    public function getDescription(): string
    {
        return 'Create tables.';
    }

    public function up(Schema $schema): void
    {
        $this->createPlayerTable($schema);
        $this->createHistoryTable($schema);
    }

    public function down(Schema $schema): void
    {
        $schema->dropTable(self::PLAYER_TABLE);
        $schema->dropTable(self::HISTORY_TABLE);
    }

    private function createPlayerTable(Schema $schema): void
    {
        $table = $schema->createTable(self::PLAYER_TABLE);
        $table->addColumn('id', Types::GUID)->setUnsigned(true)->setAutoincrement(true);
        $table->addColumn('nickname', Types::STRING);
        $table->addColumn('password', Types::STRING);
        $table->addColumn('level', Types::SMALLINT);
        $table->addColumn('role', Types::STRING);

        $this->createAndUpdateDate($table);

        $table->setPrimaryKey(['id']);
        $table->addUniqueIndex(['nickname']);
    }

    private function createHistoryTable(Schema $schema): void
    {
        $table = $schema->createTable(self::HISTORY_TABLE);
        $table->addColumn('id', Types::GUID)->setUnsigned(true)->setAutoincrement(true);
        $table->addColumn('player', Types::GUID);
        $table->addColumn('level', Types::GUID);

        $this->createAndUpdateDate($table);

        $table->setPrimaryKey(['id']);
        $table->addForeignKeyConstraint(self::PLAYER_TABLE, ['player'], ['id']);
    }

    private function createAndUpdateDate(Table $table): void
    {
        $table->addColumn('createdAt', Types::DATETIME_IMMUTABLE)->setNotnull(true);
        $table->addColumn('updatedAt', Types::DATETIME_IMMUTABLE)->setNotnull(true);
    }
}