Application\Migration\Version20200208064342

Complexity

Total Complexity

1

Size/Duplication

Total Lines	17
Duplicated Lines	0 %

Test Coverage

Coverage

0%

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
A	up()	0	15	1

<?php

declare(strict_types=1);

namespace Application\Migration;

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

class Version20200208064342 extends AbstractMigration
{
    public function up(Schema $schema): void
    {
        $this->addSql('DROP INDEX institution_longitude_idx ON institution');
        $this->addSql('DROP INDEX institution_latitude_idx ON institution');
        $this->addSql('ALTER TABLE institution ADD location POINT DEFAULT NULL COMMENT \'(DC2Type:point)\'');
        $this->addSql('UPDATE institution SET longitude = NULL, latitude = NULL WHERE longitude = 0 OR latitude = 0');
        $this->addSql('UPDATE institution SET location = ST_PointFromText(CONCAT(\'POINT(\', longitude ,\' \', latitude,\')\')) WHERE longitude IS NOT NULL AND latitude IS NOT NULL');
        $this->addSql('ALTER TABLE institution DROP latitude, DROP longitude');

        $this->addSql('DROP INDEX card_latitude_idx ON card');
        $this->addSql('DROP INDEX card_longitude_idx ON card');
        $this->addSql('ALTER TABLE card ADD location POINT DEFAULT NULL COMMENT \'(DC2Type:point)\'');
        $this->addSql('UPDATE card SET longitude = NULL, latitude = NULL WHERE longitude = 0 OR latitude = 0');
        $this->addSql('UPDATE card SET location = ST_PointFromText(CONCAT(\'POINT(\', longitude ,\' \', latitude,\')\')) WHERE longitude IS NOT NULL AND latitude IS NOT NULL');
        $this->addSql('ALTER TABLE card DROP latitude, DROP longitude');
    }
}