aboutsummaryrefslogtreecommitdiffhomepage
path: root/app/DoctrineMigrations
diff options
context:
space:
mode:
Diffstat (limited to 'app/DoctrineMigrations')
-rw-r--r--app/DoctrineMigrations/Version20190806130304.php82
-rw-r--r--app/DoctrineMigrations/Version20190806131006.php22
2 files changed, 72 insertions, 32 deletions
diff --git a/app/DoctrineMigrations/Version20190806130304.php b/app/DoctrineMigrations/Version20190806130304.php
index 27d3ddad..b1e8f8d0 100644
--- a/app/DoctrineMigrations/Version20190806130304.php
+++ b/app/DoctrineMigrations/Version20190806130304.php
@@ -1,24 +1,86 @@
1<?php declare(strict_types=1); 1<?php
2 2
3namespace Application\Migrations; 3namespace Application\Migrations;
4 4
5use Doctrine\DBAL\Schema\Schema; 5use Doctrine\DBAL\Schema\Schema;
6use Doctrine\Migrations\AbstractMigration; 6use Wallabag\CoreBundle\Doctrine\WallabagMigration;
7 7
8/** 8/**
9 * Auto-generated Migration: Please modify to your needs! 9 * Adding more index to kill some slow queries.
10 */ 10 */
11final class Version20190806130304 extends AbstractMigration 11final class Version20190806130304 extends WallabagMigration
12{ 12{
13 public function up(Schema $schema) : void 13 public function up(Schema $schema): void
14 { 14 {
15 $this->addSql('ALTER TABLE wallabag_entry CHANGE language language VARCHAR(20) DEFAULT NULL'); 15 switch ($this->connection->getDatabasePlatform()->getName()) {
16 $this->addSql('CREATE INDEX user_language ON wallabag_entry (language, user_id)'); 16 case 'sqlite':
17 $this->addSql('DROP INDEX uid');
18 $this->addSql('DROP INDEX created_at');
19 $this->addSql('DROP INDEX hashed_url_user_id');
20 $this->addSql('DROP INDEX IDX_F4D18282A76ED395');
21 $this->addSql('DROP INDEX hashed_given_url_user_id');
22 $this->addSql('CREATE TEMPORARY TABLE __temp__wallabag_entry AS SELECT id, user_id, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, domain_name, preview_picture, uid, http_status, published_at, starred_at, origin_url, archived_at, given_url, reading_time, published_by, headers, hashed_url, hashed_given_url FROM ' . $this->getTable('entry', true));
23 $this->addSql('DROP TABLE ' . $this->getTable('entry', true));
24 $this->addSql('CREATE TABLE ' . $this->getTable('entry', true) . ' (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER DEFAULT NULL, 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, domain_name CLOB DEFAULT NULL COLLATE BINARY, preview_picture CLOB DEFAULT NULL COLLATE BINARY, uid VARCHAR(23) DEFAULT NULL COLLATE BINARY, http_status VARCHAR(3) DEFAULT NULL COLLATE BINARY, published_at DATETIME DEFAULT NULL, starred_at DATETIME DEFAULT NULL, origin_url CLOB DEFAULT NULL COLLATE BINARY, archived_at DATETIME DEFAULT NULL, given_url CLOB DEFAULT NULL COLLATE BINARY, reading_time INTEGER NOT NULL, published_by CLOB DEFAULT NULL COLLATE BINARY --(DC2Type:array)
25 , headers CLOB DEFAULT NULL COLLATE BINARY --(DC2Type:array)
26 , hashed_url VARCHAR(40) DEFAULT NULL COLLATE BINARY, hashed_given_url VARCHAR(40) DEFAULT NULL COLLATE BINARY, language VARCHAR(20) DEFAULT NULL, CONSTRAINT FK_F4D18282A76ED395 FOREIGN KEY (user_id) REFERENCES "wallabag_user" (id) NOT DEFERRABLE INITIALLY IMMEDIATE)');
27 $this->addSql('INSERT INTO ' . $this->getTable('entry', true) . ' (id, user_id, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, domain_name, preview_picture, uid, http_status, published_at, starred_at, origin_url, archived_at, given_url, reading_time, published_by, headers, hashed_url, hashed_given_url) SELECT id, user_id, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, domain_name, preview_picture, uid, http_status, published_at, starred_at, origin_url, archived_at, given_url, reading_time, published_by, headers, hashed_url, hashed_given_url FROM __temp__wallabag_entry');
28 $this->addSql('DROP TABLE __temp__wallabag_entry');
29 $this->addSql('CREATE INDEX uid ON ' . $this->getTable('entry', true) . ' (uid)');
30 $this->addSql('CREATE INDEX created_at ON ' . $this->getTable('entry', true) . ' (created_at)');
31 $this->addSql('CREATE INDEX hashed_url_user_id ON ' . $this->getTable('entry', true) . ' (user_id, hashed_url)');
32 $this->addSql('CREATE INDEX IDX_F4D18282A76ED395 ON ' . $this->getTable('entry', true) . ' (user_id)');
33 $this->addSql('CREATE INDEX hashed_given_url_user_id ON ' . $this->getTable('entry', true) . ' (user_id, hashed_given_url)');
34 $this->addSql('CREATE INDEX user_language ON ' . $this->getTable('entry', true) . ' (language, user_id)');
35 $this->addSql('CREATE INDEX user_starred ON ' . $this->getTable('entry', true) . ' (user_id, is_starred, starred_at)');
36 break;
37 case 'mysql':
38 $this->addSql('ALTER TABLE ' . $this->getTable('entry') . ' MODIFY language VARCHAR(20) DEFAULT NULL');
39 $this->addSql('CREATE INDEX user_language ON ' . $this->getTable('entry') . ' (language, user_id)');
40 $this->addSql('CREATE INDEX user_starred ON ' . $this->getTable('entry') . ' (user_id, is_starred, starred_at)');
41 break;
42 case 'postgresql':
43 $this->addSql('ALTER TABLE ' . $this->getTable('entry') . ' ALTER COLUMN language VARCHAR(20) DEFAULT NULL');
44 $this->addSql('CREATE INDEX user_language ON ' . $this->getTable('entry') . ' (language, user_id)');
45 $this->addSql('CREATE INDEX user_starred ON ' . $this->getTable('entry') . ' (user_id, is_starred, starred_at)');
46 break;
47 }
17 } 48 }
18 49
19 public function down(Schema $schema) : void 50 public function down(Schema $schema): void
20 { 51 {
21 $this->addSql('DROP INDEX user_language ON `wallabag_entry`'); 52 switch ($this->connection->getDatabasePlatform()->getName()) {
22 $this->addSql('ALTER TABLE `wallabag_entry` CHANGE language language LONGTEXT DEFAULT NULL COLLATE utf8mb4_unicode_ci'); 53 case 'sqlite':
54 $this->addSql('DROP INDEX IDX_F4D18282A76ED395');
55 $this->addSql('DROP INDEX created_at');
56 $this->addSql('DROP INDEX uid');
57 $this->addSql('DROP INDEX hashed_url_user_id');
58 $this->addSql('DROP INDEX hashed_given_url_user_id');
59 $this->addSql('DROP INDEX user_language');
60 $this->addSql('DROP INDEX user_starred');
61 $this->addSql('CREATE TEMPORARY TABLE __temp__wallabag_entry AS SELECT id, user_id, uid, title, url, hashed_url, origin_url, given_url, hashed_given_url, is_archived, archived_at, is_starred, content, created_at, updated_at, published_at, published_by, starred_at, mimetype, language, reading_time, domain_name, preview_picture, http_status, headers FROM ' . $this->getTable('entry', true));
62 $this->addSql('DROP TABLE ' . $this->getTable('entry', true));
63 $this->addSql('CREATE TABLE ' . $this->getTable('entry', true) . ' (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER DEFAULT NULL, uid VARCHAR(23) DEFAULT NULL, title CLOB DEFAULT NULL, url CLOB DEFAULT NULL, hashed_url VARCHAR(40) DEFAULT NULL, origin_url CLOB DEFAULT NULL, given_url CLOB DEFAULT NULL, hashed_given_url VARCHAR(40) DEFAULT NULL, is_archived BOOLEAN NOT NULL, archived_at DATETIME DEFAULT NULL, is_starred BOOLEAN NOT NULL, content CLOB DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, published_at DATETIME DEFAULT NULL, published_by CLOB DEFAULT NULL --(DC2Type:array)
64 , starred_at DATETIME DEFAULT NULL, mimetype CLOB DEFAULT NULL, reading_time INTEGER NOT NULL, domain_name CLOB DEFAULT NULL, preview_picture CLOB DEFAULT NULL, http_status VARCHAR(3) DEFAULT NULL, headers CLOB DEFAULT NULL --(DC2Type:array)
65 , language CLOB DEFAULT NULL COLLATE BINARY)');
66 $this->addSql('INSERT INTO ' . $this->getTable('entry', true) . ' (id, user_id, uid, title, url, hashed_url, origin_url, given_url, hashed_given_url, is_archived, archived_at, is_starred, content, created_at, updated_at, published_at, published_by, starred_at, mimetype, language, reading_time, domain_name, preview_picture, http_status, headers) SELECT id, user_id, uid, title, url, hashed_url, origin_url, given_url, hashed_given_url, is_archived, archived_at, is_starred, content, created_at, updated_at, published_at, published_by, starred_at, mimetype, language, reading_time, domain_name, preview_picture, http_status, headers FROM __temp__wallabag_entry');
67 $this->addSql('DROP TABLE __temp__wallabag_entry');
68 $this->addSql('CREATE INDEX IDX_F4D18282A76ED395 ON ' . $this->getTable('entry', true) . ' (user_id)');
69 $this->addSql('CREATE INDEX created_at ON ' . $this->getTable('entry', true) . ' (created_at)');
70 $this->addSql('CREATE INDEX uid ON ' . $this->getTable('entry', true) . ' (uid)');
71 $this->addSql('CREATE INDEX hashed_url_user_id ON ' . $this->getTable('entry', true) . ' (user_id, hashed_url)');
72 $this->addSql('CREATE INDEX hashed_given_url_user_id ON ' . $this->getTable('entry', true) . ' (user_id, hashed_given_url)');
73 break;
74 case 'mysql':
75 $this->addSql('ALTER TABLE ' . $this->getTable('entry') . ' MODIFY language LONGTEXT DEFAULT NULL');
76 $this->addSql('DROP INDEX user_language ON ' . $this->getTable('entry'));
77 $this->addSql('DROP INDEX user_starred ON ' . $this->getTable('entry'));
78 break;
79 case 'postgresql':
80 $this->addSql('ALTER TABLE ' . $this->getTable('entry') . ' ALTER COLUMN language LONGTEXT DEFAULT NULL');
81 $this->addSql('DROP INDEX user_language ON ' . $this->getTable('entry'));
82 $this->addSql('DROP INDEX user_starred ON ' . $this->getTable('entry'));
83 break;
84 }
23 } 85 }
24} 86}
diff --git a/app/DoctrineMigrations/Version20190806131006.php b/app/DoctrineMigrations/Version20190806131006.php
deleted file mode 100644
index 7ad45b57..00000000
--- a/app/DoctrineMigrations/Version20190806131006.php
+++ /dev/null
@@ -1,22 +0,0 @@
1<?php declare(strict_types=1);
2
3namespace Application\Migrations;
4
5use Doctrine\DBAL\Schema\Schema;
6use Doctrine\Migrations\AbstractMigration;
7
8/**
9 * Auto-generated Migration: Please modify to your needs!
10 */
11final class Version20190806131006 extends AbstractMigration
12{
13 public function up(Schema $schema) : void
14 {
15 $this->addSql('CREATE INDEX user_starred ON wallabag_entry (user_id, is_starred, starred_at)');
16 }
17
18 public function down(Schema $schema) : void
19 {
20 $this->addSql('DROP INDEX user_starred ON `wallabag_entry`');
21 }
22}