PlayerElo

Complexity

Total Complexity

1

Size/Duplication

Total Lines	55
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
A	change()	0	49	1

<?php

use Phinx\Migration\AbstractMigration;

class PlayerElo extends AbstractMigration
{
    /**
     * {@inheritdoc}
     */
    public function change()
    {
        $players = $this->table('players');
        $players
            ->addColumn('elo', 'integer', [
                'limit' => 10,
                'signed' => false,
                'null' => false,
                'default' => 1200,
                'comment' => 'The current ELO for this player'
            ])
            ->update()
        ;

        $playerELOs = $this->table('player_elo', ['id' => false, 'primary_key' => 'id']);
        $playerELOs
            ->addColumn('id', 'integer', ['limit' => 10, 'signed' => false, 'identity' => true])
            ->addColumn('user_id', 'integer', [
                'limit' => 10,
                'signed' => false,
                'null' => false,
                'comment' => 'The player whose had their individual ELO change',
            ])
            ->addColumn('match_id', 'integer', [
                'limit' => 10,
                'signed' => false,
                'null' => false,
                'comment' => 'The match the player participated in, which resulted in this ELO change'
            ])
            ->addColumn('elo_diff', 'integer', [
                'signed' => false,
                'null' => false,
                'comment' => 'The change in ELO for this player from this match'
            ])
            ->addColumn('elo_previous', 'integer', [
                'signed' => false,
                'null' => false,
                'comment' => 'The ELO the player had prior to participating in this match'
            ])
            ->addColumn('elo_new', 'integer', [
                'signed' => false,
                'null' => false,
                'comment' => 'The new ELO for the player after participating in this match'
            ])
            ->addForeignKey('user_id', 'players', 'id', ['delete' => 'CASCADE'])
            ->addForeignKey('match_id', 'matches', 'id', ['delete' => 'CASCADE'])
            ->create()
        ;
    }
}