ShlinkMigrations\Version20200323190014

Complexity

Total Complexity

3

Size/Duplication

Total Lines	32
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	up()	0	6	1
A	down()	0	6	1
A	postUp()	0	14	1

<?php

declare(strict_types=1);

namespace ShlinkMigrations;

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

final class Version20200323190014 extends AbstractMigration
{
    public function up(Schema $schema): void
    {
        $visitLocations = $schema->getTable('visit_locations');
        $this->skipIf($visitLocations->hasColumn('is_empty'));

        $visitLocations->addColumn('is_empty', Types::BOOLEAN, ['default' => false]);
    }

    public function postUp(Schema $schema): void
    {
        $qb = $this->connection->createQueryBuilder();
        $qb->update('visit_locations')
           ->set('is_empty', true)

true of type true is incompatible with the type string expected by parameter $value of Doctrine\DBAL\Query\QueryBuilder::set().

           ->where($qb->expr()->eq('country_code', ':empty'))
           ->andWhere($qb->expr()->eq('country_name', ':empty'))
           ->andWhere($qb->expr()->eq('region_name', ':empty'))
           ->andWhere($qb->expr()->eq('city_name', ':empty'))
           ->andWhere($qb->expr()->eq('timezone', ':empty'))
           ->andWhere($qb->expr()->eq('lat', 0))
           ->andWhere($qb->expr()->eq('lon', 0))
           ->setParameter('empty', '')
           ->execute();
    }

    public function down(Schema $schema): void
    {
        $visitLocations = $schema->getTable('visit_locations');
        $this->skipIf(!$visitLocations->hasColumn('is_empty'));

        $visitLocations->dropColumn('is_empty');
    }
}