Version20170321184028::addVenues() - Code Metrics - Inspection of "Merge pull request #140 from geekhub-php/add_migra..." - geekhub-php/CheTheatre - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 043479...c08e23 )

by Serhii

created 2017-03-26 15:36 UTC

Version20170321184028::addVenues() B

↳ Parent: Version20170321184028

Complexity

Conditions	1
Paths	1

Size

Total Lines	221
Code Lines	142

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
eloc	142
nc	1
nop	0
dl	0
loc	221
rs	8.2857
c	0
b	0
f	0

How to fix Long Method

<?php

namespace Application\Migrations;

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

/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20170321184028 extends AbstractMigration
{
    protected $venues = [
        'venue-philharmonic' => 1,
        'venue-kilic-house' => 2,
        'venue-theatre' => 3,
        'venue-salut' => 4,
        'venue-palac_molodi' => 5,
        'venue-center_of_kids_arts' => 6,
        'venue-cherkasy-art-museum' => 7,
    ];

    /**
     * @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 venue (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(255) NOT NULL, address VARCHAR(255) NOT NULL, hallTemplate LONGTEXT DEFAULT NULL, createdAt DATETIME NOT NULL, updatedAt DATETIME DEFAULT NULL, deletedAt DATETIME DEFAULT NULL, deletedBy VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE venue_sector (id INT AUTO_INCREMENT NOT NULL, venue_id INT DEFAULT NULL, title VARCHAR(255) NOT NULL, INDEX IDX_53CC259240A73EBA (venue_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE seat_translation (id INT AUTO_INCREMENT NOT NULL, object_id INT DEFAULT NULL, locale VARCHAR(8) NOT NULL, field VARCHAR(32) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX IDX_9132FE65232D562B (object_id), UNIQUE INDEX lookup_unique_seat_translation_idx (locale, object_id, field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE venue_sector_translation (id INT AUTO_INCREMENT NOT NULL, object_id INT DEFAULT NULL, locale VARCHAR(8) NOT NULL, field VARCHAR(32) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX IDX_B4A75B1B232D562B (object_id), UNIQUE INDEX lookup_unique_venue_sector_translation_idx (locale, object_id, field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE venue_translation (id INT AUTO_INCREMENT NOT NULL, object_id INT DEFAULT NULL, locale VARCHAR(8) NOT NULL, field VARCHAR(32) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX IDX_A2B005A232D562B (object_id), UNIQUE INDEX lookup_unique_venue_translation_idx (locale, object_id, field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE price_category_translation (id INT AUTO_INCREMENT NOT NULL, object_id INT DEFAULT NULL, locale VARCHAR(8) NOT NULL, field VARCHAR(32) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX IDX_81449D73232D562B (object_id), UNIQUE INDEX lookup_unique_price_category_translation_idx (locale, object_id, field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE seat (id INT AUTO_INCREMENT NOT NULL, row INT NOT NULL, place INT NOT NULL, venueSector_id INT DEFAULT NULL, priceCategory_id INT DEFAULT NULL, INDEX IDX_3D5C3666137F3880 (venueSector_id), INDEX IDX_3D5C36664319ED49 (priceCategory_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE price_category (id INT AUTO_INCREMENT NOT NULL, venue_id INT DEFAULT NULL, title VARCHAR(255) NOT NULL, color VARCHAR(255) NOT NULL, INDEX IDX_64FA22D640A73EBA (venue_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
        $this->addSql('ALTER TABLE venue_sector ADD CONSTRAINT FK_53CC259240A73EBA FOREIGN KEY (venue_id) REFERENCES venue (id)');
        $this->addSql('ALTER TABLE seat_translation ADD CONSTRAINT FK_9132FE65232D562B FOREIGN KEY (object_id) REFERENCES seat (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE venue_sector_translation ADD CONSTRAINT FK_B4A75B1B232D562B FOREIGN KEY (object_id) REFERENCES venue_sector (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE venue_translation ADD CONSTRAINT FK_A2B005A232D562B FOREIGN KEY (object_id) REFERENCES venue (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE price_category_translation ADD CONSTRAINT FK_81449D73232D562B FOREIGN KEY (object_id) REFERENCES price_category (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE seat ADD CONSTRAINT FK_3D5C3666137F3880 FOREIGN KEY (venueSector_id) REFERENCES venue_sector (id)');
        $this->addSql('ALTER TABLE seat ADD CONSTRAINT FK_3D5C36664319ED49 FOREIGN KEY (priceCategory_id) REFERENCES price_category (id)');
        $this->addSql('ALTER TABLE price_category ADD CONSTRAINT FK_64FA22D640A73EBA FOREIGN KEY (venue_id) REFERENCES venue (id)');
        $this->addSql('ALTER TABLE performance_schedule ADD venue_id INT DEFAULT NULL');
        $this->addSql('ALTER TABLE performance_schedule ADD CONSTRAINT FK_D12575F940A73EBA FOREIGN KEY (venue_id) REFERENCES venue (id)');
        $this->addSql('CREATE INDEX IDX_D12575F940A73EBA ON performance_schedule (venue_id)');
    }

    public function postUp(Schema $schema)
    {
        $this->addVenues();
        $this->setVenueIdForPerformanceShedule();
        $this->connection->executeQuery('ALTER TABLE performance_schedule DROP venue');
    }

    /**
     * @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 performance_schedule DROP FOREIGN KEY FK_D12575F940A73EBA');
        $this->addSql('ALTER TABLE venue_sector DROP FOREIGN KEY FK_53CC259240A73EBA');
        $this->addSql('ALTER TABLE venue_translation DROP FOREIGN KEY FK_A2B005A232D562B');
        $this->addSql('ALTER TABLE price_category DROP FOREIGN KEY FK_64FA22D640A73EBA');
        $this->addSql('ALTER TABLE venue_sector_translation DROP FOREIGN KEY FK_B4A75B1B232D562B');
        $this->addSql('ALTER TABLE seat DROP FOREIGN KEY FK_3D5C3666137F3880');
        $this->addSql('ALTER TABLE seat_translation DROP FOREIGN KEY FK_9132FE65232D562B');
        $this->addSql('ALTER TABLE price_category_translation DROP FOREIGN KEY FK_81449D73232D562B');
        $this->addSql('ALTER TABLE seat DROP FOREIGN KEY FK_3D5C36664319ED49');
        $this->addSql('DROP TABLE venue');
        $this->addSql('DROP TABLE venue_sector');
        $this->addSql('DROP TABLE seat_translation');
        $this->addSql('DROP TABLE venue_sector_translation');
        $this->addSql('DROP TABLE venue_translation');
        $this->addSql('DROP TABLE price_category_translation');
        $this->addSql('DROP TABLE seat');
        $this->addSql('DROP TABLE price_category');
        $this->addSql('DROP INDEX IDX_D12575F940A73EBA ON performance_schedule');
        $this->addSql('ALTER TABLE performance_schedule ADD venue VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, DROP venue_id');
    }

    private function addVenues()
    {
        $now = new \DateTime();

        // --------- Cherkasy Philharmonic --------------//
        $this->connection->insert(
            'venue',
            [
                'title' => 'Черкаська Філармонія',
                'address' => 'вулиця Хрещатик, 196, Черкаси, Черкаська область, Україна, 18000',
                'hallTemplate' => '<div></div>',
                'createdAt' => $now->format('Y-m-d H:i:s'),
            ]
        );
        $id = $this->connection->lastInsertId();
        $this->venues['venue-philharmonic'] = $id;
        $this->connection->insert(
            'venue_translation',
            [
                'object_id' => $id,
                'locale' => 'en',
                'field' => 'title',
                'content' => 'Cherkasy Philharmonic',
            ]
        );
        $this->connection->insert(
            'venue_translation',
            [
                'object_id' => $id,
                'locale' => 'en',
                'field' => 'address',
                'content' => 'Khreshchatyk Street, 196, Cherkasy region, Ukraine, 18000',
            ]
        );

        // --------- Kulik's House of Culture --------------//
        $this->connection->insert(
            'venue',
            [
                'title' => 'Будинок культури ім. Кулика',
                'address' => 'вулиця Благовісна, 170, Черкаси, Черкаська область, Україна, 18000',
                'hallTemplate' => '<div></div>',
                'createdAt' => $now->format('Y-m-d H:i:s'),
            ]
        );
        $id = $this->connection->lastInsertId();
        $this->venues['venue-kilic-house'] = $id;
        $this->connection->insert(
            'venue_translation',
            [
                'object_id' => $id,
                'locale' => 'en',
                'field' => 'title',
                'content' => 'Kulik\'s House of Culture',
            ]
        );
        $this->connection->insert(
            'venue_translation',
            [
                'object_id' => $id,
                'locale' => 'en',
                'field' => 'address',
                'content' => 'Blahovisna Street 170, Cherkasy region, Ukraine, 18000',
            ]
        );

        // --------- Cherkasy Theatre --------------//
        $this->connection->insert(
            'venue',
            [
                'title' => 'Черкаський Театр',
                'address' => 'бульвар Шевченка, 234, Черкаси, Черкаська, Україна, 18000',
                'hallTemplate' => '<div></div>',
                'createdAt' => $now->format('Y-m-d H:i:s'),
            ]
        );
        $id = $this->connection->lastInsertId();
        $this->venues['venue-theatre'] = $id;
        $this->connection->insert(
            'venue_translation',
            [
                'object_id' => $id,
                'locale' => 'en',
                'field' => 'title',
                'content' => 'Cherkasy Theatre',
            ]
        );
        $this->connection->insert(
            'venue_translation',
            [
                'object_id' => $id,
                'locale' => 'en',
                'field' => 'address',
                'content' => 'Boulevard Shevchenko, 234 Cherkasy, Ukraine, 18000',
            ]
        );

        // --------- Cinema "Salute" --------------//
        $this->connection->insert(
            'venue',
            [
                'title' => 'Кінотеатр "Салют"',
                'address' => 'вулиця Хрещатик, 170, Черкаси, Черкаська область, Україна, 18000',
                'hallTemplate' => '<div></div>',
                'createdAt' => $now->format('Y-m-d H:i:s'),
            ]
        );
        $id = $this->connection->lastInsertId();
        $this->venues['venue-salut'] = $id;
        $this->connection->insert(
            'venue_translation',
            [
                'object_id' => $id,
                'locale' => 'en',
                'field' => 'title',
                'content' => 'Cinema "Salute"',
            ]
        );
        $this->connection->insert(
            'venue_translation',
            [
                'object_id' => $id,
                'locale' => 'en',
                'field' => 'address',
                'content' => 'Khreshchatyk Street, 170, Cherkasy region, Ukraine, 18000',
            ]
        );

        // --------- Cherkasky City Palace of Youth --------------//
        $this->connection->insert(
            'venue',
            [
                'title' => 'Черкаський міський Палац молоді',
                'address' => 'вулиця Сумгаїтська, 12, Черкаси, Черкаська область, Україна, 18000',
                'hallTemplate' => '<div></div>',
                'createdAt' => $now->format('Y-m-d H:i:s'),
            ]
        );
        $id = $this->connection->lastInsertId();
        $this->venues['venue-palac_molodi'] = $id;
        $this->connection->insert(
            'venue_translation',
            [
                'object_id' => $id,
                'locale' => 'en',
                'field' => 'title',
                'content' => 'Cherkasky City Palace of Youth',
            ]
        );
        $this->connection->insert(
            'venue_translation',
            [
                'object_id' => $id,
                'locale' => 'en',
                'field' => 'address',
                'content' => 'Street Sumgait, 12, Cherkasy region, Ukraine, 18000',
            ]
        );

        // --------- Center for Children and Youth --------------//
        $this->connection->insert(
            'venue',
            [
                'title' => 'Центр дитячої та юнацької творчості',
                'address' => 'вулиця Смілянська, 33, Черкаси, Черкаська область, Україна, 18000',
                'hallTemplate' => '<div></div>',
                'createdAt' => $now->format('Y-m-d H:i:s'),
            ]
        );
        $id = $this->connection->lastInsertId();
        $this->venues['venue-center_of_kids_arts'] = $id;
        $this->connection->insert(
            'venue_translation',
            [
                'object_id' => $id,
                'locale' => 'en',
                'field' => 'title',
                'content' => 'Center for Children and Youth',
            ]
        );
        $this->connection->insert(
            'venue_translation',
            [
                'object_id' => $id,
                'locale' => 'en',
                'field' => 'address',
                'content' => 'Smilians\'ka Street, 33, Cherkasy region, Ukraine, 18000',
            ]
        );

        // --------- Cherkassy Regional Art Museum --------------//
        $this->connection->insert(
            'venue',
            [
                'title' => 'Черкаський обласний художній музей',
                'address' => 'вулиця Хрещатик, 259, Черкаси, Черкаська область, Україна, 18000',
                'hallTemplate' => '<div></div>',
                'createdAt' => $now->format('Y-m-d H:i:s'),
            ]
        );
        $id = $this->connection->lastInsertId();
        $this->venues['venue-cherkasy-art-museum'] = $id;
        $this->connection->insert(
            'venue_translation',
            [
                'object_id' => $id,
                'locale' => 'en',
                'field' => 'title',
                'content' => 'Cherkassy Regional Art Museum',
            ]
        );
        $this->connection->insert(
            'venue_translation',
            [
                'object_id' => $id,
                'locale' => 'en',
                'field' => 'address',
                'content' => 'Khreshchatyk Street, 259, Cherkasy region, Ukraine, 18000',
            ]
        );
    }

    private function setVenueIdForPerformanceShedule():void
    {
        $query = "SELECT * FROM performance_schedule";
        $stmt = $this->connection->prepare($query);
        $stmt->execute();

        while ($row = $stmt->fetch()) {
            if (empty($row['venue'])) {
                continue;
            }
            $this->connection->update(
                'performance_schedule',
                ['venue_id' => $this->venues[$row['venue']]],
                ['id' => $row['id']]
            );
        }
    }
}


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		class Version20170321184028 extends AbstractMigration
12		{
13		protected $venues = [
14		'venue-philharmonic' => 1,
15		'venue-kilic-house' => 2,
16		'venue-theatre' => 3,
17		'venue-salut' => 4,
18		'venue-palac_molodi' => 5,
19		'venue-center_of_kids_arts' => 6,
20		'venue-cherkasy-art-museum' => 7,
21		];
22
23		/**
24		* @param Schema $schema
25		*/
26	View Code Duplication	public function up(Schema $schema)
		0 ignored issues – show Duplication introduced 2017-03-21 19:13 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...
27		{
28		// this up() migration is auto-generated, please modify it to your needs
29		$this->abortIf(
30		$this->connection->getDatabasePlatform()->getName() !== 'mysql',
31		'Migration can only be executed safely on "mysql".'
32		);
33
34		$this->addSql('CREATE TABLE venue (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(255) NOT NULL, address VARCHAR(255) NOT NULL, hallTemplate LONGTEXT DEFAULT NULL, createdAt DATETIME NOT NULL, updatedAt DATETIME DEFAULT NULL, deletedAt DATETIME DEFAULT NULL, deletedBy VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
35		$this->addSql('CREATE TABLE venue_sector (id INT AUTO_INCREMENT NOT NULL, venue_id INT DEFAULT NULL, title VARCHAR(255) NOT NULL, INDEX IDX_53CC259240A73EBA (venue_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
36		$this->addSql('CREATE TABLE seat_translation (id INT AUTO_INCREMENT NOT NULL, object_id INT DEFAULT NULL, locale VARCHAR(8) NOT NULL, field VARCHAR(32) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX IDX_9132FE65232D562B (object_id), UNIQUE INDEX lookup_unique_seat_translation_idx (locale, object_id, field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
37		$this->addSql('CREATE TABLE venue_sector_translation (id INT AUTO_INCREMENT NOT NULL, object_id INT DEFAULT NULL, locale VARCHAR(8) NOT NULL, field VARCHAR(32) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX IDX_B4A75B1B232D562B (object_id), UNIQUE INDEX lookup_unique_venue_sector_translation_idx (locale, object_id, field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
38		$this->addSql('CREATE TABLE venue_translation (id INT AUTO_INCREMENT NOT NULL, object_id INT DEFAULT NULL, locale VARCHAR(8) NOT NULL, field VARCHAR(32) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX IDX_A2B005A232D562B (object_id), UNIQUE INDEX lookup_unique_venue_translation_idx (locale, object_id, field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
39		$this->addSql('CREATE TABLE price_category_translation (id INT AUTO_INCREMENT NOT NULL, object_id INT DEFAULT NULL, locale VARCHAR(8) NOT NULL, field VARCHAR(32) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX IDX_81449D73232D562B (object_id), UNIQUE INDEX lookup_unique_price_category_translation_idx (locale, object_id, field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
40		$this->addSql('CREATE TABLE seat (id INT AUTO_INCREMENT NOT NULL, row INT NOT NULL, place INT NOT NULL, venueSector_id INT DEFAULT NULL, priceCategory_id INT DEFAULT NULL, INDEX IDX_3D5C3666137F3880 (venueSector_id), INDEX IDX_3D5C36664319ED49 (priceCategory_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
41		$this->addSql('CREATE TABLE price_category (id INT AUTO_INCREMENT NOT NULL, venue_id INT DEFAULT NULL, title VARCHAR(255) NOT NULL, color VARCHAR(255) NOT NULL, INDEX IDX_64FA22D640A73EBA (venue_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
42		$this->addSql('ALTER TABLE venue_sector ADD CONSTRAINT FK_53CC259240A73EBA FOREIGN KEY (venue_id) REFERENCES venue (id)');
43		$this->addSql('ALTER TABLE seat_translation ADD CONSTRAINT FK_9132FE65232D562B FOREIGN KEY (object_id) REFERENCES seat (id) ON DELETE CASCADE');
44		$this->addSql('ALTER TABLE venue_sector_translation ADD CONSTRAINT FK_B4A75B1B232D562B FOREIGN KEY (object_id) REFERENCES venue_sector (id) ON DELETE CASCADE');
45		$this->addSql('ALTER TABLE venue_translation ADD CONSTRAINT FK_A2B005A232D562B FOREIGN KEY (object_id) REFERENCES venue (id) ON DELETE CASCADE');
46		$this->addSql('ALTER TABLE price_category_translation ADD CONSTRAINT FK_81449D73232D562B FOREIGN KEY (object_id) REFERENCES price_category (id) ON DELETE CASCADE');
47		$this->addSql('ALTER TABLE seat ADD CONSTRAINT FK_3D5C3666137F3880 FOREIGN KEY (venueSector_id) REFERENCES venue_sector (id)');
48		$this->addSql('ALTER TABLE seat ADD CONSTRAINT FK_3D5C36664319ED49 FOREIGN KEY (priceCategory_id) REFERENCES price_category (id)');
49		$this->addSql('ALTER TABLE price_category ADD CONSTRAINT FK_64FA22D640A73EBA FOREIGN KEY (venue_id) REFERENCES venue (id)');
50		$this->addSql('ALTER TABLE performance_schedule ADD venue_id INT DEFAULT NULL');
51		$this->addSql('ALTER TABLE performance_schedule ADD CONSTRAINT FK_D12575F940A73EBA FOREIGN KEY (venue_id) REFERENCES venue (id)');
52		$this->addSql('CREATE INDEX IDX_D12575F940A73EBA ON performance_schedule (venue_id)');
53		}
54
55		public function postUp(Schema $schema)
56		{
57		$this->addVenues();
58		$this->setVenueIdForPerformanceShedule();
59		$this->connection->executeQuery('ALTER TABLE performance_schedule DROP venue');
60		}
61
62		/**
63		* @param Schema $schema
64		*/
65	View Code Duplication	public function down(Schema $schema)
		0 ignored issues – show Duplication introduced 2017-03-21 19:13 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...
66		{
67		// this down() migration is auto-generated, please modify it to your needs
68		$this->abortIf(
69		$this->connection->getDatabasePlatform()->getName() !== 'mysql',
70		'Migration can only be executed safely on "mysql".'
71		);
72
73		$this->addSql('ALTER TABLE performance_schedule DROP FOREIGN KEY FK_D12575F940A73EBA');
74		$this->addSql('ALTER TABLE venue_sector DROP FOREIGN KEY FK_53CC259240A73EBA');
75		$this->addSql('ALTER TABLE venue_translation DROP FOREIGN KEY FK_A2B005A232D562B');
76		$this->addSql('ALTER TABLE price_category DROP FOREIGN KEY FK_64FA22D640A73EBA');
77		$this->addSql('ALTER TABLE venue_sector_translation DROP FOREIGN KEY FK_B4A75B1B232D562B');
78		$this->addSql('ALTER TABLE seat DROP FOREIGN KEY FK_3D5C3666137F3880');
79		$this->addSql('ALTER TABLE seat_translation DROP FOREIGN KEY FK_9132FE65232D562B');
80		$this->addSql('ALTER TABLE price_category_translation DROP FOREIGN KEY FK_81449D73232D562B');
81		$this->addSql('ALTER TABLE seat DROP FOREIGN KEY FK_3D5C36664319ED49');
82		$this->addSql('DROP TABLE venue');
83		$this->addSql('DROP TABLE venue_sector');
84		$this->addSql('DROP TABLE seat_translation');
85		$this->addSql('DROP TABLE venue_sector_translation');
86		$this->addSql('DROP TABLE venue_translation');
87		$this->addSql('DROP TABLE price_category_translation');
88		$this->addSql('DROP TABLE seat');
89		$this->addSql('DROP TABLE price_category');
90		$this->addSql('DROP INDEX IDX_D12575F940A73EBA ON performance_schedule');
91		$this->addSql('ALTER TABLE performance_schedule ADD venue VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, DROP venue_id');
92		}
93
94		private function addVenues()
95		{
96		$now = new \DateTime();
97
98		// --------- Cherkasy Philharmonic --------------//
99		$this->connection->insert(
100		'venue',
101		[
102		'title' => 'Черкаська Філармонія',
103		'address' => 'вулиця Хрещатик, 196, Черкаси, Черкаська область, Україна, 18000',
104		'hallTemplate' => '<div></div>',
105		'createdAt' => $now->format('Y-m-d H:i:s'),
106		]
107		);
108		$id = $this->connection->lastInsertId();
109		$this->venues['venue-philharmonic'] = $id;
110		$this->connection->insert(
111		'venue_translation',
112		[
113		'object_id' => $id,
114		'locale' => 'en',
115		'field' => 'title',
116		'content' => 'Cherkasy Philharmonic',
117		]
118		);
119		$this->connection->insert(
120		'venue_translation',
121		[
122		'object_id' => $id,
123		'locale' => 'en',
124		'field' => 'address',
125		'content' => 'Khreshchatyk Street, 196, Cherkasy region, Ukraine, 18000',
126		]
127		);
128
129		// --------- Kulik's House of Culture --------------//
130		$this->connection->insert(
131		'venue',
132		[
133		'title' => 'Будинок культури ім. Кулика',
134		'address' => 'вулиця Благовісна, 170, Черкаси, Черкаська область, Україна, 18000',
135		'hallTemplate' => '<div></div>',
136		'createdAt' => $now->format('Y-m-d H:i:s'),
137		]
138		);
139		$id = $this->connection->lastInsertId();
140		$this->venues['venue-kilic-house'] = $id;
141		$this->connection->insert(
142		'venue_translation',
143		[
144		'object_id' => $id,
145		'locale' => 'en',
146		'field' => 'title',
147		'content' => 'Kulik\'s House of Culture',
148		]
149		);
150		$this->connection->insert(
151		'venue_translation',
152		[
153		'object_id' => $id,
154		'locale' => 'en',
155		'field' => 'address',
156		'content' => 'Blahovisna Street 170, Cherkasy region, Ukraine, 18000',
157		]
158		);
159
160		// --------- Cherkasy Theatre --------------//
161		$this->connection->insert(
162		'venue',
163		[
164		'title' => 'Черкаський Театр',
165		'address' => 'бульвар Шевченка, 234, Черкаси, Черкаська, Україна, 18000',
166		'hallTemplate' => '<div></div>',
167		'createdAt' => $now->format('Y-m-d H:i:s'),
168		]
169		);
170		$id = $this->connection->lastInsertId();
171		$this->venues['venue-theatre'] = $id;
172		$this->connection->insert(
173		'venue_translation',
174		[
175		'object_id' => $id,
176		'locale' => 'en',
177		'field' => 'title',
178		'content' => 'Cherkasy Theatre',
179		]
180		);
181		$this->connection->insert(
182		'venue_translation',
183		[
184		'object_id' => $id,
185		'locale' => 'en',
186		'field' => 'address',
187		'content' => 'Boulevard Shevchenko, 234 Cherkasy, Ukraine, 18000',
188		]
189		);
190
191		// --------- Cinema "Salute" --------------//
192		$this->connection->insert(
193		'venue',
194		[
195		'title' => 'Кінотеатр "Салют"',
196		'address' => 'вулиця Хрещатик, 170, Черкаси, Черкаська область, Україна, 18000',
197		'hallTemplate' => '<div></div>',
198		'createdAt' => $now->format('Y-m-d H:i:s'),
199		]
200		);
201		$id = $this->connection->lastInsertId();
202		$this->venues['venue-salut'] = $id;
203		$this->connection->insert(
204		'venue_translation',
205		[
206		'object_id' => $id,
207		'locale' => 'en',
208		'field' => 'title',
209		'content' => 'Cinema "Salute"',
210		]
211		);
212		$this->connection->insert(
213		'venue_translation',
214		[
215		'object_id' => $id,
216		'locale' => 'en',
217		'field' => 'address',
218		'content' => 'Khreshchatyk Street, 170, Cherkasy region, Ukraine, 18000',
219		]
220		);
221
222		// --------- Cherkasky City Palace of Youth --------------//
223		$this->connection->insert(
224		'venue',
225		[
226		'title' => 'Черкаський міський Палац молоді',
227		'address' => 'вулиця Сумгаїтська, 12, Черкаси, Черкаська область, Україна, 18000',
228		'hallTemplate' => '<div></div>',
229		'createdAt' => $now->format('Y-m-d H:i:s'),
230		]
231		);
232		$id = $this->connection->lastInsertId();
233		$this->venues['venue-palac_molodi'] = $id;
234		$this->connection->insert(
235		'venue_translation',
236		[
237		'object_id' => $id,
238		'locale' => 'en',
239		'field' => 'title',
240		'content' => 'Cherkasky City Palace of Youth',
241		]
242		);
243		$this->connection->insert(
244		'venue_translation',
245		[
246		'object_id' => $id,
247		'locale' => 'en',
248		'field' => 'address',
249		'content' => 'Street Sumgait, 12, Cherkasy region, Ukraine, 18000',
250		]
251		);
252
253		// --------- Center for Children and Youth --------------//
254		$this->connection->insert(
255		'venue',
256		[
257		'title' => 'Центр дитячої та юнацької творчості',
258		'address' => 'вулиця Смілянська, 33, Черкаси, Черкаська область, Україна, 18000',
259		'hallTemplate' => '<div></div>',
260		'createdAt' => $now->format('Y-m-d H:i:s'),
261		]
262		);
263		$id = $this->connection->lastInsertId();
264		$this->venues['venue-center_of_kids_arts'] = $id;
265		$this->connection->insert(
266		'venue_translation',
267		[
268		'object_id' => $id,
269		'locale' => 'en',
270		'field' => 'title',
271		'content' => 'Center for Children and Youth',
272		]
273		);
274		$this->connection->insert(
275		'venue_translation',
276		[
277		'object_id' => $id,
278		'locale' => 'en',
279		'field' => 'address',
280		'content' => 'Smilians\'ka Street, 33, Cherkasy region, Ukraine, 18000',
281		]
282		);
283
284		// --------- Cherkassy Regional Art Museum --------------//
285		$this->connection->insert(
286		'venue',
287		[
288		'title' => 'Черкаський обласний художній музей',
289		'address' => 'вулиця Хрещатик, 259, Черкаси, Черкаська область, Україна, 18000',
290		'hallTemplate' => '<div></div>',
291		'createdAt' => $now->format('Y-m-d H:i:s'),
292		]
293		);
294		$id = $this->connection->lastInsertId();
295		$this->venues['venue-cherkasy-art-museum'] = $id;
296		$this->connection->insert(
297		'venue_translation',
298		[
299		'object_id' => $id,
300		'locale' => 'en',
301		'field' => 'title',
302		'content' => 'Cherkassy Regional Art Museum',
303		]
304		);
305		$this->connection->insert(
306		'venue_translation',
307		[
308		'object_id' => $id,
309		'locale' => 'en',
310		'field' => 'address',
311		'content' => 'Khreshchatyk Street, 259, Cherkasy region, Ukraine, 18000',
312		]
313		);
314		}
315
316		private function setVenueIdForPerformanceShedule():void
317		{
318		$query = "SELECT * FROM performance_schedule";
319		$stmt = $this->connection->prepare($query);
320		$stmt->execute();
321
322		while ($row = $stmt->fetch()) {
323		if (empty($row['venue'])) {
324		continue;
325		}
326		$this->connection->update(
327		'performance_schedule',
328		['venue_id' => $this->venues[$row['venue']]],
329		['id' => $row['id']]
330		);
331		}
332		}
333		}
334

geekhub-php / CheTheatre

Push — master ( 043479...c08e23 )

Version20170321184028::addVenues() B

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like