+global\TrackLastMatch::up()

Complexity

Conditions	2
Paths	2

Size

Total Lines	23
Code Lines	16

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	12
CRAP Score	2.0116

Importance

Changes

0

<?php
    public function up()
    {
        $playersTable = $this->table('players');
        $playersTable
            ->addColumn('last_match', 'integer', array(
                'signed' => false,
                'limit' => 10,
                'null' => true,
                'comment' => 'The timestamp of the last match this player participated in'
            ))
            ->addForeignKey('last_match', 'matches', 'id', array('delete' => 'SET_NULL'))
            ->update();

        $players = $this->fetchAll('SELECT id FROM players');

        foreach ($players as $player) {
            $this->query(
                "UPDATE players SET last_match = (
                    SELECT id FROM matches WHERE FIND_IN_SET(${player['id']}, team_a_players) OR FIND_IN_SET(${player['id']}, team_b_players) ORDER BY timestamp DESC LIMIT 1
                ) WHERE id = " . $player['id']
            );
        }
    }