app/DoctrineMigrations/Version20190401105353.php

   1 <?php
   2
   3 namespace Application\Migrations;
   4
   5 use Doctrine\DBAL\Schema\Schema;
   6 use Wallabag\CoreBundle\Doctrine\WallabagMigration;
   7
   8 /**
   9  * Add hashed_url in entry.
  10  */
  11 class Version20190401105353 extends WallabagMigration
  12 {
  13     /**
  14      * @param Schema $schema
  15      */
  16     public function up(Schema $schema)
  17     {
  18         $entryTable = $schema->getTable($this->getTable('entry'));
  19
  20         $this->skipIf($entryTable->hasColumn('hashed_url'), 'It seems that you already played this migration.');
  21
  22         $entryTable->addColumn('hashed_url', 'text', [
  23             'length' => 32,
  24             'notnull' => false,
  25         ]);
  26
  27         // sqlite doesn't have the MD5 function by default
  28         if ('sqlite' !== $this->connection->getDatabasePlatform()->getName()) {
  29             $this->addSql('UPDATE ' . $this->getTable('entry') . ' SET hashed_url = MD5(url)');
  30         }
  31     }
  32
  33     /**
  34      * @param Schema $schema
  35      */
  36     public function down(Schema $schema)
  37     {
  38         $entryTable = $schema->getTable($this->getTable('entry'));
  39
  40         $this->skipIf(!$entryTable->hasColumn('hashed_url'), 'It seems that you already played this migration.');
  41
  42         $entryTable->dropColumn('hashed_url');
  43     }
  44 }