3 namespace Application\Migrations
;
5 use Doctrine\DBAL\Migrations\AbstractMigration
;
6 use Doctrine\DBAL\Schema\Schema
;
7 use Symfony\Component\DependencyInjection\ContainerAwareInterface
;
8 use Symfony\Component\DependencyInjection\ContainerInterface
;
9 use Wallabag\CoreBundle\Entity\Entry
;
11 class Version20160410190541
extends AbstractMigration
implements ContainerAwareInterface
14 * @var ContainerInterface
18 public function setContainer(ContainerInterface
$container = null)
20 $this->container
= $container;
24 * @param Schema $schema
26 public function up(Schema
$schema)
28 $this->addSql('ALTER TABLE `wallabag_entry` ADD `uuid` LONGTEXT DEFAULT NULL');
30 $em = $this->container
->get('doctrine.orm.entity_manager');
31 $queryBuilder = $this->connection
->createQueryBuilder();
34 ->andWhere('e.uuid IS NULL');
35 $entries = $queryBuilder->execute();
37 /** @var Entry $entry */
38 foreach ($entries as $entry) {
39 $entry->generateUuid();
47 * @param Schema $schema
49 public function down(Schema
$schema)
51 $this->addSql('ALTER TABLE `wallabag_entry` DROP `uuid`');