Version20140424162725_AddUpdateTitlesTask::down()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 9
Code Lines 2

Duplication

Lines 0
Ratio 0 %

Code Coverage

Tests 0
CRAP Score 2

Importance

Changes 1
Bugs 0 Features 1
Metric Value
dl 0
loc 9
c 1
b 0
f 1
ccs 0
cts 9
cp 0
rs 9.6666
cc 1
eloc 2
nc 1
nop 1
crap 2
1
<?php
2
/**
3
 * AnimeDb package.
4
 *
5
 * @author    Peter Gribanov <[email protected]>
6
 * @copyright Copyright (c) 2011, Peter Gribanov
7
 * @license   http://opensource.org/licenses/GPL-3.0 GPL v3
8
 */
9
namespace AnimeDb\Bundle\AniDbFillerBundle\DoctrineMigrations;
10
11
use Doctrine\DBAL\Migrations\AbstractMigration;
12
use Doctrine\DBAL\Schema\Schema;
13
use AnimeDb\Bundle\AppBundle\Entity\Task;
14
15
class Version20140424162725_AddUpdateTitlesTask extends AbstractMigration
16
{
17
    /**
18
     * @param Schema $schema
19
     */
20
    public function up(Schema $schema)
21
    {
22
        // run a update titles db every day at 2:30 am
23
        $this->addSql('
24
            INSERT INTO
25
                "task"
26
                (
27
                    "command",
28
                    "next_run",
29
                    "modify",
30
                    "status"
31
                )
32
            VALUES
33
                (
34
                    "animedb:update-titles -e=prod",
35
                    "'.date('Y-m-d 02:30:00', time()).'",
36
                    "+1 day",
37
                    '.Task::STATUS_ENABLED.'
38
                )');
39
    }
40
41
    /**
42
     * @param Schema $schema
43
     */
44
    public function down(Schema $schema)
45
    {
46
        $this->addSql('
47
            DELETE FROM
48
                "task"
49
            WHERE
50
                "command" = "animedb:update-titles -e=prod"
51
        ');
52
    }
53
}
54