app/DoctrineMigrations/Version20170510082609.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  * Changed length for username, username_canonical, email and email_canonical fields in wallabag_user table.
  12  */
  13 class Version20170510082609 extends AbstractMigration implements ContainerAwareInterface
  14 {
  15     private $fields = [
  16         'username',
  17         'username_canonical',
  18         'email',
  19         'email_canonical',
  20     ];
  21
  22     /**
  23      * @var ContainerInterface
  24      */
  25     private $container;
  26
  27     public function setContainer(ContainerInterface $container = null)
  28     {
  29         $this->container = $container;
  30     }
  31
  32     private function getTable($tableName)
  33     {
  34         return $this->container->getParameter('database_table_prefix').$tableName;
  35     }
  36
  37     /**
  38      * @param Schema $schema
  39      */
  40     public function up(Schema $schema)
  41     {
  42         $this->skipIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'This migration only apply to MySQL');
  43
  44         foreach ($this->fields as $field) {
  45             $this->addSql('ALTER TABLE '.$this->getTable('user').' CHANGE '.$field.' '.$field.' VARCHAR(180) NOT NULL;');
  46         }
  47     }
  48
  49     /**
  50      * @param Schema $schema
  51      */
  52     public function down(Schema $schema)
  53     {
  54         $this->skipIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'This migration only apply to MySQL');
  55
  56         foreach ($this->fields as $field) {
  57             $this->addSql('ALTER TABLE '.$this->getTable('user').' CHANGE '.$field.' '.$field.' VARCHAR(255) NOT NULL;');
  58         }
  59     }
  60 }