Code Duplication - OpenConext/Stepup-Middleware - Measure and Improve Code Quality continuously with Scrutinizer

Code Duplication Length = 19-28 lines in 6 locations

src/Surfnet/Migrations/Version20141112093720.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20141112093720 extends AbstractMigration
{
    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 second_factor (id VARCHAR(36) NOT NULL, identity_id VARCHAR(36) DEFAULT NULL, type VARCHAR(16) NOT NULL, second_factor_identifier VARCHAR(32) NOT NULL, INDEX IDX_1806C29EFF3ED4A8 (identity_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
        $this->addSql('ALTER TABLE second_factor ADD CONSTRAINT FK_1806C29EFF3ED4A8 FOREIGN KEY (identity_id) REFERENCES identity (id)');
    }

    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('DROP TABLE second_factor');
    }
}


src/Surfnet/Migrations/Version20141114095245.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20141114095245 extends AbstractMigration
{
    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 unverified_second_factor (id VARCHAR(36) NOT NULL, identity_id VARCHAR(36) DEFAULT NULL, type VARCHAR(16) NOT NULL, second_factor_identifier VARCHAR(32) NOT NULL, INDEX IDX_D79226A2FF3ED4A8 (identity_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
        $this->addSql('ALTER TABLE unverified_second_factor ADD CONSTRAINT FK_D79226A2FF3ED4A8 FOREIGN KEY (identity_id) REFERENCES identity (id)');
    }

    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('DROP TABLE unverified_second_factor');
    }
}


src/Surfnet/Migrations/Version20141202121811.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20141202121811 extends AbstractMigration
{
    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('DROP TABLE second_factor');
    }

    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('CREATE TABLE second_factor (id VARCHAR(36) NOT NULL COLLATE utf8_unicode_ci, identity_id VARCHAR(36) DEFAULT NULL COLLATE utf8_unicode_ci, type VARCHAR(16) NOT NULL COLLATE utf8_unicode_ci, second_factor_identifier VARCHAR(32) NOT NULL COLLATE utf8_unicode_ci, INDEX IDX_1806C29EFF3ED4A8 (identity_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
        $this->addSql('ALTER TABLE second_factor ADD CONSTRAINT FK_1806C29EFF3ED4A8 FOREIGN KEY (identity_id) REFERENCES identity (id)');
    }
}


src/Surfnet/Migrations/Version20141208162045.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20141208162045 extends AbstractMigration
{
    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 vetted_second_factor (id VARCHAR(36) NOT NULL, identity_id VARCHAR(36) DEFAULT NULL, type VARCHAR(16) NOT NULL, second_factor_identifier VARCHAR(32) NOT NULL, INDEX IDX_29F96B72FF3ED4A8 (identity_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
        $this->addSql('ALTER TABLE vetted_second_factor ADD CONSTRAINT FK_29F96B72FF3ED4A8 FOREIGN KEY (identity_id) REFERENCES identity (id)');
    }

    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('DROP TABLE vetted_second_factor');
    }
}


src/Surfnet/Migrations/Version20171113123232.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20171113123232 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 verified_second_factor ADD registration_requested_at DATETIME NOT NULL');
        $this->addSql('UPDATE verified_second_factor SET registration_requested_at = NOW()');
    }

    /**
     * @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 verified_second_factor DROP registration_requested_at');
    }
}


src/Surfnet/Migrations/Version20180409100948.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20180409100948 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(
            sprintf(
            "ALTER TABLE institution_configuration_options ADD number_of_tokens_per_identity_option TINYINT(1) DEFAULT '%d' NOT NULL",
                NumberOfTokensPerIdentityOption::DISABLED
            )
        );
    }

    /**
     * @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 institution_configuration_options DROP number_of_tokens_per_identity_option');
    }
}


		@@ 11-29 (lines=19) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20141112093720 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('CREATE TABLE second_factor (id VARCHAR(36) NOT NULL, identity_id VARCHAR(36) DEFAULT NULL, type VARCHAR(16) NOT NULL, second_factor_identifier VARCHAR(32) NOT NULL, INDEX IDX_1806C29EFF3ED4A8 (identity_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
19		$this->addSql('ALTER TABLE second_factor ADD CONSTRAINT FK_1806C29EFF3ED4A8 FOREIGN KEY (identity_id) REFERENCES identity (id)');
20		}
21
22		public function down(Schema $schema)
23		{
24		// this down() migration is auto-generated, please modify it to your needs
25		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
26
27		$this->addSql('DROP TABLE second_factor');
28		}
29		}
30

		@@ 11-29 (lines=19) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20141114095245 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('CREATE TABLE unverified_second_factor (id VARCHAR(36) NOT NULL, identity_id VARCHAR(36) DEFAULT NULL, type VARCHAR(16) NOT NULL, second_factor_identifier VARCHAR(32) NOT NULL, INDEX IDX_D79226A2FF3ED4A8 (identity_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
19		$this->addSql('ALTER TABLE unverified_second_factor ADD CONSTRAINT FK_D79226A2FF3ED4A8 FOREIGN KEY (identity_id) REFERENCES identity (id)');
20		}
21
22		public function down(Schema $schema)
23		{
24		// this down() migration is auto-generated, please modify it to your needs
25		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
26
27		$this->addSql('DROP TABLE unverified_second_factor');
28		}
29		}
30

		@@ 11-29 (lines=19) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20141202121811 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('DROP TABLE second_factor');
19		}
20
21		public function down(Schema $schema)
22		{
23		// this down() migration is auto-generated, please modify it to your needs
24		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
25
26		$this->addSql('CREATE TABLE second_factor (id VARCHAR(36) NOT NULL COLLATE utf8_unicode_ci, identity_id VARCHAR(36) DEFAULT NULL COLLATE utf8_unicode_ci, type VARCHAR(16) NOT NULL COLLATE utf8_unicode_ci, second_factor_identifier VARCHAR(32) NOT NULL COLLATE utf8_unicode_ci, INDEX IDX_1806C29EFF3ED4A8 (identity_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
27		$this->addSql('ALTER TABLE second_factor ADD CONSTRAINT FK_1806C29EFF3ED4A8 FOREIGN KEY (identity_id) REFERENCES identity (id)');
28		}
29		}
30

		@@ 11-29 (lines=19) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20141208162045 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('CREATE TABLE vetted_second_factor (id VARCHAR(36) NOT NULL, identity_id VARCHAR(36) DEFAULT NULL, type VARCHAR(16) NOT NULL, second_factor_identifier VARCHAR(32) NOT NULL, INDEX IDX_29F96B72FF3ED4A8 (identity_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
19		$this->addSql('ALTER TABLE vetted_second_factor ADD CONSTRAINT FK_29F96B72FF3ED4A8 FOREIGN KEY (identity_id) REFERENCES identity (id)');
20		}
21
22		public function down(Schema $schema)
23		{
24		// this down() migration is auto-generated, please modify it to your needs
25		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
26
27		$this->addSql('DROP TABLE vetted_second_factor');
28		}
29		}
30

		@@ 11-35 (lines=25) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20171113123232 extends AbstractMigration
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 verified_second_factor ADD registration_requested_at DATETIME NOT NULL');
22		$this->addSql('UPDATE verified_second_factor SET registration_requested_at = NOW()');
23		}
24
25		/**
26		* @param Schema $schema
27		*/
28		public function down(Schema $schema)
29		{
30		// this down() migration is auto-generated, please modify it to your needs
31		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
32
33		$this->addSql('ALTER TABLE verified_second_factor DROP registration_requested_at');
34		}
35		}
36

		@@ 12-39 (lines=28) @@
9		/**
10		* Auto-generated Migration: Please modify to your needs!
11		*/
12		class Version20180409100948 extends AbstractMigration
13		{
14		/**
15		* @param Schema $schema
16		*/
17		public function up(Schema $schema)
18		{
19		// this up() migration is auto-generated, please modify it to your needs
20		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
21
22		$this->addSql(
23		sprintf(
24		"ALTER TABLE institution_configuration_options ADD number_of_tokens_per_identity_option TINYINT(1) DEFAULT '%d' NOT NULL",
25		NumberOfTokensPerIdentityOption::DISABLED
26		)
27		);
28		}
29
30		/**
31		* @param Schema $schema
32		*/
33		public function down(Schema $schema)
34		{
35		// this down() migration is auto-generated, please modify it to your needs
36		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
37		$this->addSql('ALTER TABLE institution_configuration_options DROP number_of_tokens_per_identity_option');
38		}
39		}
40

OpenConext / Stepup-Middleware

Code Duplication Length = 19-28 lines in 6 locations

src/Surfnet/Migrations/Version20141112093720.php 1 location

src/Surfnet/Migrations/Version20141114095245.php 1 location

src/Surfnet/Migrations/Version20141202121811.php 1 location

src/Surfnet/Migrations/Version20141208162045.php 1 location

src/Surfnet/Migrations/Version20171113123232.php 1 location

src/Surfnet/Migrations/Version20180409100948.php 1 location