]>
Commit | Line | Data |
---|---|---|
5ed503ab NL |
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 | /** | |
01736b5a | 11 | * Renamed uuid to uid in entry table. |
5ed503ab NL |
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': | |
6dfd1a6c NL |
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'); | |
5ed503ab NL |
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': | |
6dfd1a6c | 66 | throw new SkipMigrationException('Too complex ...'); |
5ed503ab NL |
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 | } |