Code Duplication - superdesk/web-publisher - Measure and Improve Code Quality continuously with Scrutinizer

Code Duplication Length = 22-37 lines in 15 locations

src/SWP/Bundle/CoreBundle/Migrations/2018/09/Version20180913090352.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
final class Version20180913090352 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('CREATE SEQUENCE refresh_tokens_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE TABLE refresh_tokens (
          id INT NOT NULL, 
          refresh_token VARCHAR(128) NOT NULL, 
          username VARCHAR(255) NOT NULL, 
          valid TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, 
          PRIMARY KEY(id)
        )');
        $this->addSql('CREATE UNIQUE INDEX UNIQ_9BACE7E1C74F2195 ON refresh_tokens (refresh_token)');
    }

    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('DROP SEQUENCE refresh_tokens_id_seq CASCADE');
        $this->addSql('DROP TABLE refresh_tokens');
    }
}


src/SWP/Bundle/CoreBundle/Migrations/2018/11/Version20181116092734.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
final class Version20181116092734 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('ALTER TABLE swp_author ADD twitter VARCHAR(255) DEFAULT NULL');
        $this->addSql('ALTER TABLE swp_author ADD facebook VARCHAR(255) DEFAULT NULL');
        $this->addSql('ALTER TABLE swp_author ADD instagram VARCHAR(255) DEFAULT NULL');
    }

    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_author DROP twitter');
        $this->addSql('ALTER TABLE swp_author DROP facebook');
        $this->addSql('ALTER TABLE swp_author DROP instagram');
    }
}


src/SWP/Bundle/CoreBundle/Migrations/2019/02/Version20190208103320.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
final class Version20190208103320 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('DROP SEQUENCE request_metrics_id_seq CASCADE');
        $this->addSql('DROP TABLE request_metrics');
        $this->addSql('ALTER TABLE swp_publish_destination ADD content_lists TEXT DEFAULT NULL');
        $this->addSql('COMMENT ON COLUMN swp_publish_destination.content_lists IS \'(DC2Type:array)\'');
    }

    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('CREATE SEQUENCE request_metrics_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE TABLE request_metrics (
          id INT NOT NULL, 
          uri TEXT NOT NULL, 
          route VARCHAR(255) NOT NULL, 
          duration INT NOT NULL, 
          created TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, 
          PRIMARY KEY(id)
        )');
        $this->addSql('ALTER TABLE swp_publish_destination DROP content_lists');
    }
}


src/SWP/Bundle/CoreBundle/Migrations/2019/07/Version20190709090034.php 1 location


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

final class Version20190709090034 extends AbstractMigration
{
    public function up(Schema $schema): void
    {
        $this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');

        $this->addSql('DROP INDEX swp_article_slug_idx');
        $this->addSql('
            CREATE UNIQUE INDEX swp_article_slug_not_null_deleted_at_idx 
            ON swp_article (
              slug, tenant_code, organization_id, 
              deleted_at
            ) 
            WHERE deleted_at IS NOT NULL
        ');

        $this->addSql('
            CREATE UNIQUE INDEX swp_article_slug_null_deleted_at_idx 
            ON swp_article (
              slug, tenant_code, organization_id
            ) 
            WHERE deleted_at IS NULL
        ');
    }

    public function down(Schema $schema): void
    {
        $this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');

        $this->addSql('DROP INDEX swp_article_slug_not_null_deleted_at_idx');
        $this->addSql('DROP INDEX swp_article_slug_null_deleted_at_idx');
        $this->addSql('CREATE UNIQUE INDEX swp_article_slug_idx ON swp_article (
          slug, tenant_code, organization_id, 
          deleted_at
        )');
    }
}


src/SWP/Bundle/CoreBundle/Migrations/Version20170207132939.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20170207132939 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_article ADD feature_media INT DEFAULT NULL');
        $this->addSql('ALTER TABLE swp_article ADD CONSTRAINT FK_FB21E858A372AB05 FOREIGN KEY (feature_media) REFERENCES swp_article_media (id) ON DELETE SET NULL NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('CREATE INDEX IDX_FB21E858A372AB05 ON swp_article (feature_media)');
    }

    /**
     * @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_article DROP CONSTRAINT FK_FB21E858A372AB05');
        $this->addSql('DROP INDEX IDX_FB21E858A372AB05');
        $this->addSql('ALTER TABLE swp_article DROP feature_media');
    }
}


src/SWP/Bundle/CoreBundle/Migrations/Version20170510091222.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20170510091222 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_item ADD source VARCHAR(255) DEFAULT NULL');
        $this->addSql('ALTER TABLE swp_package ADD source VARCHAR(255) DEFAULT NULL');
        $this->addSql('ALTER TABLE swp_article ADD source VARCHAR(255) DEFAULT NULL');
    }

    /**
     * @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_item DROP source');
        $this->addSql('ALTER TABLE swp_package DROP source');
        $this->addSql('ALTER TABLE swp_article DROP source');
    }
}


src/SWP/Bundle/CoreBundle/Migrations/Version20170512132743.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20170512132743 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_user ADD first_name VARCHAR(255) DEFAULT NULL');
        $this->addSql('ALTER TABLE swp_user ADD last_name VARCHAR(255) DEFAULT NULL');
        $this->addSql('ALTER TABLE swp_user ADD about TEXT DEFAULT NULL');
    }

    /**
     * @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_user DROP first_name');
        $this->addSql('ALTER TABLE swp_user DROP last_name');
        $this->addSql('ALTER TABLE swp_user DROP about');
    }
}


src/SWP/Bundle/CoreBundle/Migrations/Version20170525105348.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20170525105348 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_user ADD organization_id INT');
        $this->addSql('ALTER TABLE swp_user ADD CONSTRAINT FK_7384FB3132C8A3DE FOREIGN KEY (organization_id) REFERENCES swp_organization (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('CREATE INDEX IDX_7384FB3132C8A3DE ON swp_user (organization_id)');
    }

    /**
     * @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_user DROP CONSTRAINT FK_7384FB3132C8A3DE');
        $this->addSql('DROP INDEX IDX_7384FB3132C8A3DE');
        $this->addSql('ALTER TABLE swp_user DROP organization_id');
    }
}


src/SWP/Bundle/CoreBundle/Migrations/Version20170608091640.php 1 location


/**
 * 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');
    }
}


src/SWP/Bundle/CoreBundle/Migrations/Version20170829142821.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20170829142821 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        $this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
        $this->addSql('ALTER TABLE swp_article_sources ADD id SERIAL NOT NULL');
        $this->addSql('ALTER TABLE swp_article_sources DROP CONSTRAINT swp_article_sources_pkey');
        $this->addSql('ALTER TABLE swp_article_sources ADD PRIMARY KEY (id)');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        $this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
        $this->addSql('ALTER TABLE swp_article_sources DROP CONSTRAINT swp_article_sources_pkey');
        $this->addSql('ALTER TABLE swp_article_sources DROP id');
        $this->addSql('ALTER TABLE swp_article_sources ADD PRIMARY KEY (article_id, source_id)');
    }
}


src/SWP/Bundle/CoreBundle/Migrations/Version20170831132632.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20170831132632 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('DROP INDEX uniq_ec6095fe5e237e06');
        $this->addSql('DROP INDEX host_idx');
        $this->addSql('CREATE UNIQUE INDEX host_idx ON swp_tenant (domain_name, subdomain, deleted_at)');
    }

    /**
     * @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('DROP INDEX host_idx');
        $this->addSql('CREATE UNIQUE INDEX uniq_ec6095fe5e237e06 ON swp_tenant (name)');
        $this->addSql('CREATE UNIQUE INDEX host_idx ON swp_tenant (domain_name, subdomain)');
    }
}


src/SWP/Bundle/CoreBundle/Migrations/Version20180320081937.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20180320081937 extends AbstractMigration
{
    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('CREATE SEQUENCE swp_package_preview_token_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE TABLE swp_package_preview_token (id INT NOT NULL, route_id INT DEFAULT NULL, token VARCHAR(255) NOT NULL, body TEXT NOT NULL, tenant_code VARCHAR(255) NOT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX IDX_AD1CA87234ECB4E6 ON swp_package_preview_token (route_id)');
        $this->addSql('ALTER TABLE swp_package_preview_token ADD CONSTRAINT FK_AD1CA87234ECB4E6 FOREIGN KEY (route_id) REFERENCES swp_route (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
    }

    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('DROP SEQUENCE swp_package_preview_token_id_seq CASCADE');
        $this->addSql('DROP TABLE swp_package_preview_token');
    }
}


src/SWP/Bundle/CoreBundle/Migrations/Version20180409113543.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20180409113543 extends AbstractMigration
{
    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('CREATE SEQUENCE swp_output_channel_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE TABLE swp_output_channel (id INT NOT NULL, tenant_id INT DEFAULT NULL, config TEXT NOT NULL, type VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE UNIQUE INDEX UNIQ_AFE4D08F9033212A ON swp_output_channel (tenant_id)');
        $this->addSql('COMMENT ON COLUMN swp_output_channel.config IS \'(DC2Type:array)\'');
        $this->addSql('ALTER TABLE swp_output_channel ADD CONSTRAINT FK_AFE4D08F9033212A FOREIGN KEY (tenant_id) REFERENCES swp_tenant (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
    }

    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('DROP SEQUENCE swp_output_channel_id_seq CASCADE');
        $this->addSql('DROP TABLE swp_output_channel');
    }
}


src/SWP/Bundle/CoreBundle/Migrations/Version20180608134715.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
final class Version20180608134715 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('ALTER TABLE swp_route DROP CONSTRAINT fk_5ce4ce5a79066886');
        $this->addSql('DROP INDEX idx_5ce4ce5a79066886');
        $this->addSql('ALTER TABLE swp_route DROP root_id');
    }

    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_route ADD root_id INT DEFAULT NULL');
        $this->addSql('ALTER TABLE swp_route ADD CONSTRAINT fk_5ce4ce5a79066886 FOREIGN KEY (root_id) REFERENCES swp_route (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('CREATE INDEX idx_5ce4ce5a79066886 ON swp_route (root_id)');
    }
}


src/SWP/Bundle/CoreBundle/Migrations/Version20180821140705.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
final class Version20180821140705 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('ALTER TABLE swp_article ALTER COLUMN paywall_secured SET DEFAULT FALSE');
        $this->addSql('ALTER TABLE swp_route ALTER COLUMN paywall_secured SET DEFAULT FALSE');
        $this->addSql('UPDATE swp_article SET paywall_secured = false WHERE paywall_secured IS NULL');
        $this->addSql('UPDATE swp_route SET paywall_secured = false WHERE paywall_secured IS NULL');
    }

    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 ALTER paywall_secured DROP DEFAULT');
        $this->addSql('ALTER TABLE swp_route ALTER paywall_secured DROP DEFAULT');
    }
}


		@@ 13-39 (lines=27) @@
10		/**
11		* Auto-generated Migration: Please modify to your needs!
12		*/
13		final class Version20180913090352 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('CREATE SEQUENCE refresh_tokens_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
21		$this->addSql('CREATE TABLE refresh_tokens (
22		id INT NOT NULL,
23		refresh_token VARCHAR(128) NOT NULL,
24		username VARCHAR(255) NOT NULL,
25		valid TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL,
26		PRIMARY KEY(id)
27		)');
28		$this->addSql('CREATE UNIQUE INDEX UNIQ_9BACE7E1C74F2195 ON refresh_tokens (refresh_token)');
29		}
30
31		public function down(Schema $schema): void
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('DROP SEQUENCE refresh_tokens_id_seq CASCADE');
37		$this->addSql('DROP TABLE refresh_tokens');
38		}
39		}
40

		@@ 13-34 (lines=22) @@
10		/**
11		* Auto-generated Migration: Please modify to your needs!
12		*/
13		final class Version20181116092734 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('ALTER TABLE swp_author ADD twitter VARCHAR(255) DEFAULT NULL');
21		$this->addSql('ALTER TABLE swp_author ADD facebook VARCHAR(255) DEFAULT NULL');
22		$this->addSql('ALTER TABLE swp_author ADD instagram VARCHAR(255) DEFAULT NULL');
23		}
24
25		public function down(Schema $schema): void
26		{
27		// this down() migration is auto-generated, please modify it to your needs
28		$this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
29
30		$this->addSql('ALTER TABLE swp_author DROP twitter');
31		$this->addSql('ALTER TABLE swp_author DROP facebook');
32		$this->addSql('ALTER TABLE swp_author DROP instagram');
33		}
34		}
35

		@@ 13-42 (lines=30) @@
10		/**
11		* Auto-generated Migration: Please modify to your needs!
12		*/
13		final class Version20190208103320 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('DROP SEQUENCE request_metrics_id_seq CASCADE');
21		$this->addSql('DROP TABLE request_metrics');
22		$this->addSql('ALTER TABLE swp_publish_destination ADD content_lists TEXT DEFAULT NULL');
23		$this->addSql('COMMENT ON COLUMN swp_publish_destination.content_lists IS \'(DC2Type:array)\'');
24		}
25
26		public function down(Schema $schema): void
27		{
28		// this down() migration is auto-generated, please modify it to your needs
29		$this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
30
31		$this->addSql('CREATE SEQUENCE request_metrics_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
32		$this->addSql('CREATE TABLE request_metrics (
33		id INT NOT NULL,
34		uri TEXT NOT NULL,
35		route VARCHAR(255) NOT NULL,
36		duration INT NOT NULL,
37		created TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL,
38		PRIMARY KEY(id)
39		)');
40		$this->addSql('ALTER TABLE swp_publish_destination DROP content_lists');
41		}
42		}
43

		@@ 10-46 (lines=37) @@
7		use Doctrine\DBAL\Schema\Schema;
8		use Doctrine\Migrations\AbstractMigration;
9
10		final class Version20190709090034 extends AbstractMigration
11		{
12		public function up(Schema $schema): void
13		{
14		$this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
15
16		$this->addSql('DROP INDEX swp_article_slug_idx');
17		$this->addSql('
18		CREATE UNIQUE INDEX swp_article_slug_not_null_deleted_at_idx
19		ON swp_article (
20		slug, tenant_code, organization_id,
21		deleted_at
22		)
23		WHERE deleted_at IS NOT NULL
24		');
25
26		$this->addSql('
27		CREATE UNIQUE INDEX swp_article_slug_null_deleted_at_idx
28		ON swp_article (
29		slug, tenant_code, organization_id
30		)
31		WHERE deleted_at IS NULL
32		');
33		}
34
35		public function down(Schema $schema): void
36		{
37		$this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
38
39		$this->addSql('DROP INDEX swp_article_slug_not_null_deleted_at_idx');
40		$this->addSql('DROP INDEX swp_article_slug_null_deleted_at_idx');
41		$this->addSql('CREATE UNIQUE INDEX swp_article_slug_idx ON swp_article (
42		slug, tenant_code, organization_id,
43		deleted_at
44		)');
45		}
46		}
47

		@@ 11-38 (lines=28) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20170207132939 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('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
20
21		$this->addSql('ALTER TABLE swp_article ADD feature_media INT DEFAULT NULL');
22		$this->addSql('ALTER TABLE swp_article ADD CONSTRAINT FK_FB21E858A372AB05 FOREIGN KEY (feature_media) REFERENCES swp_article_media (id) ON DELETE SET NULL NOT DEFERRABLE INITIALLY IMMEDIATE');
23		$this->addSql('CREATE INDEX IDX_FB21E858A372AB05 ON swp_article (feature_media)');
24		}
25
26		/**
27		* @param Schema $schema
28		*/
29		public function down(Schema $schema)
30		{
31		// this down() migration is auto-generated, please modify it to your needs
32		$this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
33
34		$this->addSql('ALTER TABLE swp_article DROP CONSTRAINT FK_FB21E858A372AB05');
35		$this->addSql('DROP INDEX IDX_FB21E858A372AB05');
36		$this->addSql('ALTER TABLE swp_article DROP feature_media');
37		}
38		}
39

		@@ 11-38 (lines=28) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20170510091222 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('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
20
21		$this->addSql('ALTER TABLE swp_item ADD source VARCHAR(255) DEFAULT NULL');
22		$this->addSql('ALTER TABLE swp_package ADD source VARCHAR(255) DEFAULT NULL');
23		$this->addSql('ALTER TABLE swp_article ADD source VARCHAR(255) DEFAULT NULL');
24		}
25
26		/**
27		* @param Schema $schema
28		*/
29		public function down(Schema $schema)
30		{
31		// this down() migration is auto-generated, please modify it to your needs
32		$this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
33
34		$this->addSql('ALTER TABLE swp_item DROP source');
35		$this->addSql('ALTER TABLE swp_package DROP source');
36		$this->addSql('ALTER TABLE swp_article DROP source');
37		}
38		}
39

		@@ 11-38 (lines=28) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20170512132743 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('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
20
21		$this->addSql('ALTER TABLE swp_user ADD first_name VARCHAR(255) DEFAULT NULL');
22		$this->addSql('ALTER TABLE swp_user ADD last_name VARCHAR(255) DEFAULT NULL');
23		$this->addSql('ALTER TABLE swp_user ADD about TEXT DEFAULT NULL');
24		}
25
26		/**
27		* @param Schema $schema
28		*/
29		public function down(Schema $schema)
30		{
31		// this down() migration is auto-generated, please modify it to your needs
32		$this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
33
34		$this->addSql('ALTER TABLE swp_user DROP first_name');
35		$this->addSql('ALTER TABLE swp_user DROP last_name');
36		$this->addSql('ALTER TABLE swp_user DROP about');
37		}
38		}
39

		@@ 11-38 (lines=28) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20170525105348 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('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
20
21		$this->addSql('ALTER TABLE swp_user ADD organization_id INT');
22		$this->addSql('ALTER TABLE swp_user ADD CONSTRAINT FK_7384FB3132C8A3DE FOREIGN KEY (organization_id) REFERENCES swp_organization (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
23		$this->addSql('CREATE INDEX IDX_7384FB3132C8A3DE ON swp_user (organization_id)');
24		}
25
26		/**
27		* @param Schema $schema
28		*/
29		public function down(Schema $schema)
30		{
31		// this down() migration is auto-generated, please modify it to your needs
32		$this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
33
34		$this->addSql('ALTER TABLE swp_user DROP CONSTRAINT FK_7384FB3132C8A3DE');
35		$this->addSql('DROP INDEX IDX_7384FB3132C8A3DE');
36		$this->addSql('ALTER TABLE swp_user DROP organization_id');
37		}
38		}
39

		@@ 11-39 (lines=29) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20170608091640 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('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

		@@ 11-34 (lines=24) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20170829142821 extends AbstractMigration
12		{
13		/**
14		* @param Schema $schema
15		*/
16		public function up(Schema $schema)
17		{
18		$this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
19		$this->addSql('ALTER TABLE swp_article_sources ADD id SERIAL NOT NULL');
20		$this->addSql('ALTER TABLE swp_article_sources DROP CONSTRAINT swp_article_sources_pkey');
21		$this->addSql('ALTER TABLE swp_article_sources ADD PRIMARY KEY (id)');
22		}
23
24		/**
25		* @param Schema $schema
26		*/
27		public function down(Schema $schema)
28		{
29		$this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
30		$this->addSql('ALTER TABLE swp_article_sources DROP CONSTRAINT swp_article_sources_pkey');
31		$this->addSql('ALTER TABLE swp_article_sources DROP id');
32		$this->addSql('ALTER TABLE swp_article_sources ADD PRIMARY KEY (article_id, source_id)');
33		}
34		}
35

		@@ 11-38 (lines=28) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20170831132632 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('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
20
21		$this->addSql('DROP INDEX uniq_ec6095fe5e237e06');
22		$this->addSql('DROP INDEX host_idx');
23		$this->addSql('CREATE UNIQUE INDEX host_idx ON swp_tenant (domain_name, subdomain, deleted_at)');
24		}
25
26		/**
27		* @param Schema $schema
28		*/
29		public function down(Schema $schema)
30		{
31		// this down() migration is auto-generated, please modify it to your needs
32		$this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
33
34		$this->addSql('DROP INDEX host_idx');
35		$this->addSql('CREATE UNIQUE INDEX uniq_ec6095fe5e237e06 ON swp_tenant (name)');
36		$this->addSql('CREATE UNIQUE INDEX host_idx ON swp_tenant (domain_name, subdomain)');
37		}
38		}
39

		@@ 13-34 (lines=22) @@
10		/**
11		* Auto-generated Migration: Please modify to your needs!
12		*/
13		class Version20180320081937 extends AbstractMigration
14		{
15		public function up(Schema $schema)
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('CREATE SEQUENCE swp_package_preview_token_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
21		$this->addSql('CREATE TABLE swp_package_preview_token (id INT NOT NULL, route_id INT DEFAULT NULL, token VARCHAR(255) NOT NULL, body TEXT NOT NULL, tenant_code VARCHAR(255) NOT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, PRIMARY KEY(id))');
22		$this->addSql('CREATE INDEX IDX_AD1CA87234ECB4E6 ON swp_package_preview_token (route_id)');
23		$this->addSql('ALTER TABLE swp_package_preview_token ADD CONSTRAINT FK_AD1CA87234ECB4E6 FOREIGN KEY (route_id) REFERENCES swp_route (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
24		}
25
26		public function down(Schema $schema)
27		{
28		// this down() migration is auto-generated, please modify it to your needs
29		$this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
30
31		$this->addSql('DROP SEQUENCE swp_package_preview_token_id_seq CASCADE');
32		$this->addSql('DROP TABLE swp_package_preview_token');
33		}
34		}
35

		@@ 13-35 (lines=23) @@
10		/**
11		* Auto-generated Migration: Please modify to your needs!
12		*/
13		class Version20180409113543 extends AbstractMigration
14		{
15		public function up(Schema $schema)
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('CREATE SEQUENCE swp_output_channel_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
21		$this->addSql('CREATE TABLE swp_output_channel (id INT NOT NULL, tenant_id INT DEFAULT NULL, config TEXT NOT NULL, type VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
22		$this->addSql('CREATE UNIQUE INDEX UNIQ_AFE4D08F9033212A ON swp_output_channel (tenant_id)');
23		$this->addSql('COMMENT ON COLUMN swp_output_channel.config IS \'(DC2Type:array)\'');
24		$this->addSql('ALTER TABLE swp_output_channel ADD CONSTRAINT FK_AFE4D08F9033212A FOREIGN KEY (tenant_id) REFERENCES swp_tenant (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
25		}
26
27		public function down(Schema $schema)
28		{
29		// this down() migration is auto-generated, please modify it to your needs
30		$this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
31
32		$this->addSql('DROP SEQUENCE swp_output_channel_id_seq CASCADE');
33		$this->addSql('DROP TABLE swp_output_channel');
34		}
35		}
36

		@@ 13-34 (lines=22) @@
10		/**
11		* Auto-generated Migration: Please modify to your needs!
12		*/
13		final class Version20180608134715 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('ALTER TABLE swp_route DROP CONSTRAINT fk_5ce4ce5a79066886');
21		$this->addSql('DROP INDEX idx_5ce4ce5a79066886');
22		$this->addSql('ALTER TABLE swp_route DROP root_id');
23		}
24
25		public function down(Schema $schema): void
26		{
27		// this down() migration is auto-generated, please modify it to your needs
28		$this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
29
30		$this->addSql('ALTER TABLE swp_route ADD root_id INT DEFAULT NULL');
31		$this->addSql('ALTER TABLE swp_route ADD CONSTRAINT fk_5ce4ce5a79066886 FOREIGN KEY (root_id) REFERENCES swp_route (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
32		$this->addSql('CREATE INDEX idx_5ce4ce5a79066886 ON swp_route (root_id)');
33		}
34		}
35

		@@ 13-34 (lines=22) @@
10		/**
11		* Auto-generated Migration: Please modify to your needs!
12		*/
13		final class Version20180821140705 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('ALTER TABLE swp_article ALTER COLUMN paywall_secured SET DEFAULT FALSE');
21		$this->addSql('ALTER TABLE swp_route ALTER COLUMN paywall_secured SET DEFAULT FALSE');
22		$this->addSql('UPDATE swp_article SET paywall_secured = false WHERE paywall_secured IS NULL');
23		$this->addSql('UPDATE swp_route SET paywall_secured = false WHERE paywall_secured IS NULL');
24		}
25
26		public function down(Schema $schema): void
27		{
28		// this down() migration is auto-generated, please modify it to your needs
29		$this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
30
31		$this->addSql('ALTER TABLE swp_article ALTER paywall_secured DROP DEFAULT');
32		$this->addSql('ALTER TABLE swp_route ALTER paywall_secured DROP DEFAULT');
33		}
34		}
35

superdesk / web-publisher

Code Duplication Length = 22-37 lines in 15 locations

src/SWP/Bundle/CoreBundle/Migrations/2018/09/Version20180913090352.php 1 location

src/SWP/Bundle/CoreBundle/Migrations/2018/11/Version20181116092734.php 1 location

src/SWP/Bundle/CoreBundle/Migrations/2019/02/Version20190208103320.php 1 location

src/SWP/Bundle/CoreBundle/Migrations/2019/07/Version20190709090034.php 1 location

src/SWP/Bundle/CoreBundle/Migrations/Version20170207132939.php 1 location

src/SWP/Bundle/CoreBundle/Migrations/Version20170510091222.php 1 location

src/SWP/Bundle/CoreBundle/Migrations/Version20170512132743.php 1 location

src/SWP/Bundle/CoreBundle/Migrations/Version20170525105348.php 1 location

src/SWP/Bundle/CoreBundle/Migrations/Version20170608091640.php 1 location

src/SWP/Bundle/CoreBundle/Migrations/Version20170829142821.php 1 location

src/SWP/Bundle/CoreBundle/Migrations/Version20170831132632.php 1 location

src/SWP/Bundle/CoreBundle/Migrations/Version20180320081937.php 1 location

src/SWP/Bundle/CoreBundle/Migrations/Version20180409113543.php 1 location

src/SWP/Bundle/CoreBundle/Migrations/Version20180608134715.php 1 location

src/SWP/Bundle/CoreBundle/Migrations/Version20180821140705.php 1 location