diff options
author | Nicolas LÅ“uillet <nicolas@loeuillet.org> | 2017-05-10 10:46:32 +0200 |
---|---|---|
committer | Nicolas LÅ“uillet <nicolas@loeuillet.org> | 2017-05-10 10:46:32 +0200 |
commit | 8c3158eba8654509a8c5e0323d4f37b01488b011 (patch) | |
tree | 8f086c328fb67dfd58eb78c80cbb5750b8891c99 /app/DoctrineMigrations/Version20170510082609.php | |
parent | e538c85ba7f028ff59ceb96f3b4779b1ef41bc14 (diff) | |
download | wallabag-8c3158eba8654509a8c5e0323d4f37b01488b011.tar.gz wallabag-8c3158eba8654509a8c5e0323d4f37b01488b011.tar.zst wallabag-8c3158eba8654509a8c5e0323d4f37b01488b011.zip |
Added migration to change length for user fields
Diffstat (limited to 'app/DoctrineMigrations/Version20170510082609.php')
-rw-r--r-- | app/DoctrineMigrations/Version20170510082609.php | 60 |
1 files changed, 60 insertions, 0 deletions
diff --git a/app/DoctrineMigrations/Version20170510082609.php b/app/DoctrineMigrations/Version20170510082609.php new file mode 100644 index 00000000..a99af2d2 --- /dev/null +++ b/app/DoctrineMigrations/Version20170510082609.php | |||
@@ -0,0 +1,60 @@ | |||
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 | } | ||