Version20170213183245::down() - Code Metrics - Inspection of "Feature/user image" - kreta/Kreta - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — master (#246)

by Beñat

created 2017-02-19 15:18 UTC

Version20170213183245::down() A

↳ Parent: Version20170213183245

Complexity

Conditions	1
Paths	1

Size

Total Lines	10
Code Lines	6

Duplication

Lines	10
Ratio	100 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	6
nc	1
nop	1
dl	10
loc	10
rs	9.4285
c	1
b	0
f	0

<?php

namespace Kreta\IdentityAccess\Infrastructure\Persistence\Doctrine\Migrations;

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

/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20170213183245 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)

    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');


        $this->addSql('CREATE TABLE image (id CHAR(36) NOT NULL COMMENT \'(DC2Type:file_id)\', created_on DATETIME NOT NULL, updated_on DATETIME NOT NULL, name VARCHAR(150) NOT NULL, extension VARCHAR(10) NOT NULL, mime_type VARCHAR(100) NOT NULL, UNIQUE INDEX search_idx (name, extension), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');

        $this->addSql('ALTER TABLE user ADD image_id CHAR(36) DEFAULT NULL COMMENT \'(DC2Type:file_id)\'');
        $this->addSql('ALTER TABLE user ADD CONSTRAINT FK_8D93D6493DA5256D FOREIGN KEY (image_id) REFERENCES image (id)');

        $this->addSql('CREATE UNIQUE INDEX UNIQ_8D93D6493DA5256D ON user (image_id)');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)

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


        $this->addSql('ALTER TABLE user DROP FOREIGN KEY FK_8D93D6493DA5256D');
        $this->addSql('DROP TABLE image');
        $this->addSql('DROP INDEX UNIQ_8D93D6493DA5256D ON user');
        $this->addSql('ALTER TABLE user DROP image_id');
    }
}


1		<?php
2
3		namespace Kreta\IdentityAccess\Infrastructure\Persistence\Doctrine\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		class Version20170213183245 extends AbstractMigration
12		{
13		/**
14		* @param Schema $schema
15		*/
16	View Code Duplication	public function up(Schema $schema)
		0 ignored issues – show Duplication introduced 2017-02-16 16:08 UTC by Report Bug Copy Issue Report This method 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...
17		{
18		// this up() migration is auto-generated, please modify it to your needs
19		$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
		0 ignored issues – show Coding Style introduced 2017-02-16 16:08 UTC by Report Bug Copy Issue Report This line exceeds maximum limit of 120 characters; contains 143 characters Overly long lines are hard to read on any screen. Most code styles therefor impose a maximum limit on the number of characters in a line. Loading history...
20
21		$this->addSql('CREATE TABLE image (id CHAR(36) NOT NULL COMMENT \'(DC2Type:file_id)\', created_on DATETIME NOT NULL, updated_on DATETIME NOT NULL, name VARCHAR(150) NOT NULL, extension VARCHAR(10) NOT NULL, mime_type VARCHAR(100) NOT NULL, UNIQUE INDEX search_idx (name, extension), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
		0 ignored issues – show Coding Style introduced 2017-02-16 16:08 UTC by Report Bug Copy Issue Report This line exceeds maximum limit of 120 characters; contains 377 characters Overly long lines are hard to read on any screen. Most code styles therefor impose a maximum limit on the number of characters in a line. Loading history...
22		$this->addSql('ALTER TABLE user ADD image_id CHAR(36) DEFAULT NULL COMMENT \'(DC2Type:file_id)\'');
23		$this->addSql('ALTER TABLE user ADD CONSTRAINT FK_8D93D6493DA5256D FOREIGN KEY (image_id) REFERENCES image (id)');
		0 ignored issues – show Coding Style introduced 2017-02-16 16:08 UTC by Report Bug Copy Issue Report This line exceeds maximum limit of 120 characters; contains 122 characters Overly long lines are hard to read on any screen. Most code styles therefor impose a maximum limit on the number of characters in a line. Loading history...
24		$this->addSql('CREATE UNIQUE INDEX UNIQ_8D93D6493DA5256D ON user (image_id)');
25		}
26
27		/**
28		* @param Schema $schema
29		*/
30	View Code Duplication	public function down(Schema $schema)
		0 ignored issues – show Duplication introduced 2017-02-16 16:08 UTC by Report Bug Copy Issue Report This method 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...
31		{
32		// this down() migration is auto-generated, please modify it to your needs
33		$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
		0 ignored issues – show Coding Style introduced 2017-02-16 16:08 UTC by Report Bug Copy Issue Report This line exceeds maximum limit of 120 characters; contains 143 characters Overly long lines are hard to read on any screen. Most code styles therefor impose a maximum limit on the number of characters in a line. Loading history...
34
35		$this->addSql('ALTER TABLE user DROP FOREIGN KEY FK_8D93D6493DA5256D');
36		$this->addSql('DROP TABLE image');
37		$this->addSql('DROP INDEX UNIQ_8D93D6493DA5256D ON user');
38		$this->addSql('ALTER TABLE user DROP image_id');
39		}
40		}
41

kreta / Kreta

Pull Request — master (#246)

Version20170213183245::down() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like