Application\Migrations\Version20170402155012

Complexity

Total Complexity

7

Size/Duplication

Total Lines	54
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	4

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	up()	0	7	1
A	postUp()	0	4	1
A	down()	0	7	1
A	setVenueSectorSlugs()	0	17	4

<?php

namespace Application\Migrations;

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

/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20170402155012 extends AbstractMigration
{
    protected $venue_sector_slugs = [
        'Партер' => 'parterre',
        'Балкон' => 'balcony',
        'Лоджия Левая' => 'loggia-left',
    	'Лоджия Правая' => 'loggia-right',
    ];

    /**
     * @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 `venue_sector` ADD `slug` VARCHAR(255) NOT NULL');
    }

    public function postUp(Schema $schema)
    {
        $this->setVenueSectorSlugs();
    }

    /**
     * @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 `venue_sector` DROP slug');
    }

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

        while ($row = $stmt->fetch()) {
            if (empty($row['title']) || empty($this->venue_sector_slugs[$row['title']])) {
                continue;
            }
            $this->connection->update(
                'venue_sector',
                ['slug' => $this->venue_sector_slugs[$row['title']]],
                ['id' => $row['id']]
            );
        }
    }
}