app/DoctrineMigrations/Version20161214094402.php

   1 <?php
   2
   3 namespace Application\Migrations;
   4
   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
  10 /**
  11  * Renamed uuid to uid in entry table.
  12  */
  13 class Version20161214094402 extends AbstractMigration implements ContainerAwareInterface
  14 {
  15     /**
  16      * @var ContainerInterface
  17      */
  18     private $container;
  19
  20     public function setContainer(ContainerInterface $container = null)
  21     {
  22         $this->container = $container;
  23     }
  24
  25     private function getTable($tableName)
  26     {
  27         return $this->container->getParameter('database_table_prefix').$tableName;
  28     }
  29
  30     /**
  31      * @param Schema $schema
  32      */
  33     public function up(Schema $schema)
  34     {
  35         $entryTable = $schema->getTable($this->getTable('entry'));
  36
  37         $this->skipIf($entryTable->hasColumn('uid'), 'It seems that you already played this migration.');
  38
  39         switch ($this->connection->getDatabasePlatform()->getName()) {
  40             case 'sqlite':
  41                 $this->addSql('CREATE TEMPORARY TABLE __temp__wallabag_entry AS SELECT id, user_id, uuid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public FROM '.$this->getTable('entry'));
  42                 $this->addSql('DROP TABLE '.$this->getTable('entry'));
  43                 $this->addSql('CREATE TABLE '.$this->getTable('entry').' (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, uid CLOB DEFAULT NULL COLLATE BINARY, title CLOB DEFAULT NULL COLLATE BINARY, url CLOB DEFAULT NULL COLLATE BINARY, is_archived BOOLEAN NOT NULL, is_starred BOOLEAN NOT NULL, content CLOB DEFAULT NULL COLLATE BINARY, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, mimetype CLOB DEFAULT NULL COLLATE BINARY, language CLOB DEFAULT NULL COLLATE BINARY, reading_time INTEGER DEFAULT NULL, domain_name CLOB DEFAULT NULL COLLATE BINARY, preview_picture CLOB DEFAULT NULL COLLATE BINARY, is_public BOOLEAN DEFAULT "0", PRIMARY KEY(id));');
  44                 $this->addSql('INSERT INTO '.$this->getTable('entry').' (id, user_id, uid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public) SELECT id, user_id, uuid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public FROM __temp__wallabag_entry;');
  45                 $this->addSql('DROP TABLE __temp__wallabag_entry');
  46                 break;
  47             case 'mysql':
  48                 $this->addSql('ALTER TABLE '.$this->getTable('entry').' CHANGE uuid uid VARCHAR(23)');
  49                 break;
  50             case 'postgresql':
  51                 $this->addSql('ALTER TABLE '.$this->getTable('entry').' RENAME uuid TO uid');
  52         }
  53     }
  54
  55     /**
  56      * @param Schema $schema
  57      */
  58     public function down(Schema $schema)
  59     {
  60         $entryTable = $schema->getTable($this->getTable('entry'));
  61
  62         $this->skipIf($entryTable->hasColumn('uuid'), 'It seems that you already played this migration.');
  63
  64         switch ($this->connection->getDatabasePlatform()->getName()) {
  65             case 'sqlite':
  66                 throw new SkipMigrationException('Too complex ...');
  67                 break;
  68             case 'mysql':
  69                 $this->addSql('ALTER TABLE '.$this->getTable('entry').' CHANGE uid uuid VARCHAR(23)');
  70                 break;
  71             case 'postgresql':
  72                 $this->addSql('ALTER TABLE '.$this->getTable('entry').' RENAME uid TO uuid');
  73         }
  74     }
  75 }