Version20170627015129::down() - Code Metrics - Inspection of "merged master" - geekhub-php/CheTheatre - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Branch — admin-customers (cfcc56)

by Serhii

created 2017-06-29 04:10 UTC

Version20170627015129::down() A

↳ Parent: Version20170627015129

Complexity

Conditions	1
Paths	1

Size

Total Lines	12
Code Lines	6

Duplication

Lines	12
Ratio	100 %

Importance

Changes	1
Bugs	0	Features	0

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

<?php

namespace Application\Migrations;

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

/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20170627015129 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('ALTER TABLE rows_for_sale ADD CONSTRAINT FK_BB4AF581137F3880 FOREIGN KEY (venueSector_id) REFERENCES venue_sector (id)');

        $this->addSql('ALTER TABLE ticket ADD userOrder_id VARCHAR(255) DEFAULT NULL, DROP user_order_id');
        $this->addSql('ALTER TABLE ticket ADD CONSTRAINT FK_97A0ADA358ACF019 FOREIGN KEY (userOrder_id) REFERENCES user_order (id)');
        $this->addSql('CREATE INDEX IDX_97A0ADA358ACF019 ON ticket (userOrder_id)');
        $this->addSql('CREATE UNIQUE INDEX UNIQ_1483A5E9C912ED9D ON users (api_key)');
        //$this->addSql('ALTER TABLE users RENAME INDEX uniq_62534e219be8fd98 TO UNIQ_1483A5E99BE8FD98');

    }

    /**
     * @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 rows_for_sale DROP FOREIGN KEY FK_BB4AF581137F3880');

        $this->addSql('ALTER TABLE ticket DROP FOREIGN KEY FK_97A0ADA358ACF019');
        $this->addSql('DROP INDEX IDX_97A0ADA358ACF019 ON ticket');
        $this->addSql('ALTER TABLE ticket ADD user_order_id INT DEFAULT NULL, DROP userOrder_id');
        $this->addSql('DROP INDEX UNIQ_1483A5E9C912ED9D ON users');
        //$this->addSql('ALTER TABLE users RENAME INDEX uniq_1483a5e99be8fd98 TO UNIQ_62534E219BE8FD98');

    }
}


1		<?php
2
3		namespace Application\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 Version20170627015129 extends AbstractMigration
		0 ignored issues – show Duplication introduced 2017-05-03 03:30 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($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
20
21		// $this->addSql('ALTER TABLE rows_for_sale ADD CONSTRAINT FK_BB4AF581137F3880 FOREIGN KEY (venueSector_id) REFERENCES venue_sector (id)');
		0 ignored issues – show Unused Code Comprehensibility introduced 2017-06-27 03:54 UTC by Report Bug Copy Issue Report `75%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
22		$this->addSql('ALTER TABLE ticket ADD userOrder_id VARCHAR(255) DEFAULT NULL, DROP user_order_id');
23		$this->addSql('ALTER TABLE ticket ADD CONSTRAINT FK_97A0ADA358ACF019 FOREIGN KEY (userOrder_id) REFERENCES user_order (id)');
24		$this->addSql('CREATE INDEX IDX_97A0ADA358ACF019 ON ticket (userOrder_id)');
25		$this->addSql('CREATE UNIQUE INDEX UNIQ_1483A5E9C912ED9D ON users (api_key)');
26		//$this->addSql('ALTER TABLE users RENAME INDEX uniq_62534e219be8fd98 TO UNIQ_1483A5E99BE8FD98');
		0 ignored issues – show Unused Code Comprehensibility introduced 2017-06-27 03:54 UTC by Report Bug Copy Issue Report `86%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
27		}
28
29		/**
30		* @param Schema $schema
31		*/
32		public function down(Schema $schema)
33		{
34		// this down() migration is auto-generated, please modify it to your needs
35		$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
36
37		// $this->addSql('ALTER TABLE rows_for_sale DROP FOREIGN KEY FK_BB4AF581137F3880');
		0 ignored issues – show Unused Code Comprehensibility introduced 2017-06-27 03:54 UTC by Report Bug Copy Issue Report `75%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
38		$this->addSql('ALTER TABLE ticket DROP FOREIGN KEY FK_97A0ADA358ACF019');
39		$this->addSql('DROP INDEX IDX_97A0ADA358ACF019 ON ticket');
40		$this->addSql('ALTER TABLE ticket ADD user_order_id INT DEFAULT NULL, DROP userOrder_id');
41		$this->addSql('DROP INDEX UNIQ_1483A5E9C912ED9D ON users');
42		//$this->addSql('ALTER TABLE users RENAME INDEX uniq_1483a5e99be8fd98 TO UNIQ_62534E219BE8FD98');
		0 ignored issues – show Unused Code Comprehensibility introduced 2017-06-27 03:54 UTC by Report Bug Copy Issue Report `86%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
43		}
44		}
45

geekhub-php / CheTheatre

Branch — admin-customers (cfcc56)

Version20170627015129::down() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like