PlayerStatusColumnConversion

Complexity

Total Complexity

2

Size/Duplication

Total Lines	53
Duplicated Lines	100 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
B	up()	27	27	1
A	down()	22	22	1

<?php

use Phinx\Migration\AbstractMigration;

class PlayerStatusColumnConversion extends AbstractMigration

This class seems to be duplicated in your project.

{
    public function up()
    {
        $playersTable = $this->table('players');
        $playersTable
            ->addColumn('is_disabled', 'boolean', [
                'after' => 'last_login',
                'null' => false,
                'default' => false,
                'comment' => 'Whether or not this account has been disabled by an admin and cannot log in',
            ])
            ->addColumn('is_deleted', 'boolean', [
                'after' => 'is_disabled',
                'null' => false,
                'default' => false,
                'comment' => 'Whether or not this player has been soft-deleted',
            ])
            ->update()
        ;

        $this->query("UPDATE players SET is_deleted = 1 WHERE status = 'deleted';");
        $this->query("UPDATE players SET is_disabled = 1 WHERE status = 'disabled';");

        $playersTable
            ->removeColumn('status')
            ->update()
        ;
    }

    public function down()
    {
        $playersTable = $this->table('players');
        $playersTable
            ->addColumn('status', 'set', [
                'values' => ['active','disabled','deleted','reported','banned','test'],
                'null' => false,
                'default' => 'active',
                'comment' => 'The status of this player',
            ])
            ->update()
        ;

        $this->query("UPDATE players SET status = 'deleted' WHERE is_deleted = 1;");
        $this->query("UPDATE players SET status = 'disabled' WHERE is_disabled = 1;");

        $playersTable
            ->removeColumn('is_disabled')
            ->removeColumn('is_deleted')
            ->update()
        ;
    }
}