Version20190403081555::down() - Code Metrics - Inspection of "remove softdeletable from article media, add analy..." - superdesk/web-publisher - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — 1.5 (#772)

by Paweł

created 2019-04-03 09:09 UTC

Version20190403081555::down() A

↳ Parent: Version20190403081555

Complexity

Conditions	1
Paths	1

Size

Total Lines

Duplication

Lines	9
Ratio	100 %

Importance

Changes

Metric	Value
dl	9
loc	9
rs	9.9666
c	0
b	0
f	0
cc	1
nc	1
nop	1

<?php

declare(strict_types=1);

namespace SWP\Migrations;

use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;

/**
 * Auto-generated Migration: Please modify to your needs!
 */
final class Version20190403081555 extends AbstractMigration
{
    public function up(Schema $schema): void
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');

        $this->addSql('
            UPDATE 
                swp_article 
            SET 
                feature_media = NULL
            WHERE 
                  feature_media IN (
                    SELECT id FROM swp_article_media WHERE deleted_at IS NOT NULL 
                  )
        ');
        $this->addSql('DELETE FROM swp_article_media WHERE deleted_at IS NOT NULL');
        $this->addSql('ALTER TABLE swp_article_media DROP deleted_at');
        $this->addSql('ALTER TABLE swp_article_media ALTER updated_at TYPE TIMESTAMP(0) WITHOUT TIME ZONE');
        $this->addSql('ALTER TABLE swp_article_media ALTER updated_at DROP DEFAULT');
    }

    public function down(Schema $schema): void
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');

        $this->addSql('ALTER TABLE swp_article_media ADD deleted_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL');
        $this->addSql('ALTER TABLE swp_article_media ALTER updated_at TYPE DATE');
        $this->addSql('ALTER TABLE swp_article_media ALTER updated_at DROP DEFAULT');
    }
}


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 Version20190403081555 extends AbstractMigration
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('
21		UPDATE
22		swp_article
23		SET
24		feature_media = NULL
25		WHERE
26		feature_media IN (
27		SELECT id FROM swp_article_media WHERE deleted_at IS NOT NULL
28		)
29		');
30		$this->addSql('DELETE FROM swp_article_media WHERE deleted_at IS NOT NULL');
31		$this->addSql('ALTER TABLE swp_article_media DROP deleted_at');
32		$this->addSql('ALTER TABLE swp_article_media ALTER updated_at TYPE TIMESTAMP(0) WITHOUT TIME ZONE');
33		$this->addSql('ALTER TABLE swp_article_media ALTER updated_at DROP DEFAULT');
34		}
35
36		public function down(Schema $schema): void
37		{
38		// this down() migration is auto-generated, please modify it to your needs
39		$this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
40
41		$this->addSql('ALTER TABLE swp_article_media ADD deleted_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL');
42		$this->addSql('ALTER TABLE swp_article_media ALTER updated_at TYPE DATE');
43		$this->addSql('ALTER TABLE swp_article_media ALTER updated_at DROP DEFAULT');
44		}
45		}
46

superdesk / web-publisher

Pull Request — 1.5 (#772)

Version20190403081555::down() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like