Completed
Push — 1.4 ( ff4c92...d193f9 )
by Paweł
15s
created

Version20190208103320::up()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 10

Duplication

Lines 10
Ratio 100 %

Importance

Changes 0
Metric Value
dl 10
loc 10
rs 9.9332
c 0
b 0
f 0
cc 1
nc 1
nop 1
1
<?php
2
3
declare(strict_types=1);
4
5
namespace SWP\Migrations;
6
7
use Doctrine\DBAL\Schema\Schema;
8
use Doctrine\Migrations\AbstractMigration;
9
10
/**
11
 * Auto-generated Migration: Please modify to your needs!
12
 */
13 View Code Duplication
final class Version20190208103320 extends AbstractMigration
1 ignored issue
show
Duplication introduced by
This class seems to be duplicated in your project.

Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation.

You can also find more detailed suggestions in the “Code” section of your repository.

Loading history...
14
{
15
    public function up(Schema $schema): void
16
    {
17
        // this up() migration is auto-generated, please modify it to your needs
18
        $this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
19
20
        $this->addSql('DROP SEQUENCE request_metrics_id_seq CASCADE');
21
        $this->addSql('DROP TABLE request_metrics');
22
        $this->addSql('ALTER TABLE swp_publish_destination ADD content_lists TEXT DEFAULT NULL');
23
        $this->addSql('COMMENT ON COLUMN swp_publish_destination.content_lists IS \'(DC2Type:array)\'');
24
    }
25
26
    public function down(Schema $schema): void
27
    {
28
        // this down() migration is auto-generated, please modify it to your needs
29
        $this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
30
31
        $this->addSql('CREATE SEQUENCE request_metrics_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
32
        $this->addSql('CREATE TABLE request_metrics (
33
          id INT NOT NULL, 
34
          uri TEXT NOT NULL, 
35
          route VARCHAR(255) NOT NULL, 
36
          duration INT NOT NULL, 
37
          created TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, 
38
          PRIMARY KEY(id)
39
        )');
40
        $this->addSql('ALTER TABLE swp_publish_destination DROP content_lists');
41
    }
42
}
43