ClearDeletedTeamAvatars

Complexity

Total Complexity

1

Size/Duplication

Total Lines	46
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
B	up()	0	40	1

<?php

use BZIon\Phinx\KernelReadyMigration;

class ClearDeletedTeamAvatars extends KernelReadyMigration
{
    /**
     * {@inheritdoc}
     */
    public function up()
    {
        $playersTable = $this->table('players');
        $playersTable
            ->changeColumn('avatar', 'string', [
                'limit' => 200,
                'null' => true,
                'comment' => "The path to the player's avatar relative to the bzion project root",
            ])
            ->update()
        ;

        $this->execute("
            UPDATE
                players
            SET
                avatar = NULL 
            WHERE
                status IN ('deleted', 'disabled')
        ");

        $teamsTable = $this->table('teams');
        $teamsTable
            ->changeColumn('avatar', 'string', [
                'limit' => 200,
                'null' => true,
                'comment' => "The path to the player's avatar relative to the bzion project root",
            ])
            ->update()
        ;

        $this->execute("
            UPDATE
                teams
            SET
                avatar = NULL
            WHERE
                status IN ('deleted', 'disabled')
        ");
    }
}