AnimeDb\Bundle\AppBundle\DoctrineMigrations\Version20131128101508_AddProposeUpdateTask

Complexity

Total Complexity

2

Size/Duplication

Total Lines	35
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	1

Test Coverage

Coverage

0%

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	down()	0	9	1
A	up()	0	22	1

<?php
/**
 * AnimeDb package.
 *
 * @author    Peter Gribanov <info@peter-gribanov.ru>
 * @copyright Copyright (c) 2011, Peter Gribanov
 * @license   http://opensource.org/licenses/GPL-3.0 GPL v3
 */
namespace AnimeDb\Bundle\AppBundle\DoctrineMigrations;

use Doctrine\DBAL\Migrations\AbstractMigration;
use Doctrine\DBAL\Schema\Schema;
use AnimeDb\Bundle\AppBundle\Entity\Task;
use AnimeDb\Bundle\AppBundle\Command\ProposeUpdateCommand;

class Version20131128101508_AddProposeUpdateTask extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // run a propose update at 1 am
        $this->addSql('
            INSERT INTO
                "task"
                (
                    "command",
                    "next_run",
                    "modify",
                    "status"
                )
            VALUES
                (?, ?, ?, ?)',
            [
                'animedb:propose-update',
                date('Y-m-d 01:00:00', time() + ProposeUpdateCommand::INERVAL_UPDATE),
                sprintf('+%s second', ProposeUpdateCommand::INERVAL_UPDATE),
                Task::STATUS_ENABLED,
            ]
        );
    }

    public function down(Schema $schema)
    {
        $this->addSql('
            DELETE FROM
                "task"
            WHERE
                "command" = "animedb:propose-update"
        ');
    }
}