for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
/**
* AnimeDb package.
*
* @author Peter Gribanov <[email protected]>
* @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)
DELETE FROM
WHERE
"command" = "animedb:propose-update"
');
anime-db /
app-bundle
