for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?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');
$visitLocations->getColumn($columnName)->setType(Type::getType(Types::FLOAT));
public function down(Schema $schema): void
$visitLocations->getColumn($columnName)->setType(Type::getType(Types::STRING));
shlinkio /
shlink
