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     /**
  33      * @param Schema $schema
  34      */
  35     public function up(Schema $schema)
  36     {
  37         $this->skipIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'This migration only apply to MySQL');
  38
  39         foreach ($this->fields as $field) {
  40             $this->addSql('ALTER TABLE ' . $this->getTable('user') . ' CHANGE ' . $field . ' ' . $field . ' VARCHAR(180) NOT NULL;');
  41         }
  42     }
  43
  44     /**
  45      * @param Schema $schema
  46      */
  47     public function down(Schema $schema)
  48     {
  49         $this->skipIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'This migration only apply to MySQL');
  50
  51         foreach ($this->fields as $field) {
  52             $this->addSql('ALTER TABLE ' . $this->getTable('user') . ' CHANGE ' . $field . ' ' . $field . ' VARCHAR(255) NOT NULL;');
  53         }
  54     }
  55
  56     private function getTable($tableName)
  57     {
  58         return $this->container->getParameter('database_table_prefix') . $tableName;
  59     }
  60 }