ShlinkMigrations\Version20200105165647

Complexity

Total Complexity

6

Size/Duplication

Total Lines	37
Duplicated Lines	0 %

Importance

Changes	2
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	down()	0	6	2
A	preUp()	0	9	2
A	up()	0	6	2

<?php

declare(strict_types=1);

namespace ShlinkMigrations;

use Doctrine\DBAL\DBALException;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\DBAL\Types\Type;
use Doctrine\DBAL\Types\Types;
use Doctrine\Migrations\AbstractMigration;

final class Version20200105165647 extends AbstractMigration
{
    private const COLUMNS = ['latitude', 'longitude'];

    public function preUp(Schema $schema): void
    {
        foreach (self::COLUMNS as $columnName) {
            $qb = $this->connection->createQueryBuilder();
            $qb->update('visit_locations')
               ->set($columnName, '"0"')
               ->where($columnName . '=""')
               ->orWhere($columnName . ' IS NULL')
               ->execute();
        }
    }

    /**
     * @throws DBALException
     */
    public function up(Schema $schema): void
    {
        $visitLocations = $schema->getTable('visit_locations');

        foreach (self::COLUMNS as $columnName) {
            $visitLocations->getColumn($columnName)->setType(Type::getType(Types::FLOAT));
        }
    }

    /**
     * @throws DBALException
     */
    public function down(Schema $schema): void
    {
        $visitLocations = $schema->getTable('visit_locations');

        foreach (self::COLUMNS as $columnName) {
            $visitLocations->getColumn($columnName)->setType(Type::getType(Types::STRING));
        }
    }
}