Version20170608091640::up() - Code Metrics - Inspection of "Merge pull request #622 from ahilles107/fix_kernel..." - ahilles107/web-publisher - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 19732d...076741 )

by Paweł

created 2018-09-12 09:14 UTC

Version20170608091640::up() A

↳ Parent: Version20170608091640

Complexity

Conditions	1
Paths	1

Size

Total Lines

Duplication

Lines	11
Ratio	100 %

Importance

Changes

Metric	Value
dl	11
loc	11
rs	9.9
c	0
b	0
f	0
cc	1
nc	1
nop	1

<?php

namespace SWP\Migrations;

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

/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20170608091640 extends AbstractMigration

{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // 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('ALTER TABLE swp_rule ADD description VARCHAR(255) DEFAULT NULL');
        $this->addSql('ALTER TABLE swp_rule ADD name VARCHAR(255) DEFAULT NULL');
        $this->addSql('UPDATE swp_article SET package_id = (SELECT p.id FROM swp_package AS p WHERE p.guid = code ORDER BY p.id DESC LIMIT 1)');
        $this->addSql('delete from swp_article where is_publishable = false and package_id = (select p.id from swp_package as p where p.guid = code order by p.id desc limit 1)');
        $this->addSql('update swp_package set status = \'published\' where (select count(*) from swp_article as a where a.package_id = id) > 0');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // 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_rule DROP description');
        $this->addSql('ALTER TABLE swp_rule DROP name');
    }
}


1		<?php
2
3		namespace SWP\Migrations;
4
5		use Doctrine\DBAL\Migrations\AbstractMigration;
6		use Doctrine\DBAL\Schema\Schema;
7
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11	View Code Duplication	class Version20170608091640 extends AbstractMigration
		0 ignored issues – show Deprecated Code introduced 2018-09-12 09:26 UTC by Report Bug Copy Issue Report The class `Doctrine\DBAL\Migrations\AbstractMigration` has been deprecated with message: Please use Doctrine\Migrations\AbstractMigration This class, trait or interface has been deprecated. The supplier of the file has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the type will be removed from the class and what other constant to use instead. Loading history... Duplication introduced 2018-09-12 09:26 UTC by Report Bug Copy Issue Report 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...
12		{
13		/**
14		* @param Schema $schema
15		*/
16		public function up(Schema $schema)
17		{
18		// this up() migration is auto-generated, please modify it to your needs
19		$this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
20
21		$this->addSql('ALTER TABLE swp_rule ADD description VARCHAR(255) DEFAULT NULL');
22		$this->addSql('ALTER TABLE swp_rule ADD name VARCHAR(255) DEFAULT NULL');
23		$this->addSql('UPDATE swp_article SET package_id = (SELECT p.id FROM swp_package AS p WHERE p.guid = code ORDER BY p.id DESC LIMIT 1)');
24		$this->addSql('delete from swp_article where is_publishable = false and package_id = (select p.id from swp_package as p where p.guid = code order by p.id desc limit 1)');
25		$this->addSql('update swp_package set status = \'published\' where (select count(*) from swp_article as a where a.package_id = id) > 0');
26		}
27
28		/**
29		* @param Schema $schema
30		*/
31		public function down(Schema $schema)
32		{
33		// this down() migration is auto-generated, please modify it to your needs
34		$this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
35
36		$this->addSql('ALTER TABLE swp_rule DROP description');
37		$this->addSql('ALTER TABLE swp_rule DROP name');
38		}
39		}
40

ahilles107 / web-publisher

Push — master ( 19732d...076741 )

Version20170608091640::up() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like