Version20200110182849::setDefaultValueForColumnInTable() - Code Metrics - Inspection of "Feature/avoid nulls" - shlinkio/shlink - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — develop (#612)

by Alejandro

created 2020-01-10 18:45 UTC

setDefaultValueForColumnInTable() A

↳ Parent: Version20200110182849

Complexity

Conditions	1
Paths	1

Size

Total Lines	8
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	6
c	1
b	0
f	0
nc	1
nop	2
dl	0
loc	8
rs	10

<?php

declare(strict_types=1);

namespace ShlinkMigrations;

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

use function Functional\each;
use function Functional\partial_left;

final class Version20200110182849 extends AbstractMigration
{
    private const DEFAULT_EMPTY_VALUE = '';
    private const COLUMN_DEFAULTS_MAP = [
        'visits' => [
            'referer',
            'user_agent',
        ],
        'visit_locations' => [
            'timezone',
            'country_code',
            'country_name',
            'region_name',
            'city_name',
        ],
    ];

    public function up(Schema $schema): void
    {
        each(
            self::COLUMN_DEFAULTS_MAP,
            fn (array $columns, string $tableName) =>
                each($columns, partial_left([$this, 'setDefaultValueForColumnInTable'], $tableName)),
        );
    }

    public function setDefaultValueForColumnInTable(string $tableName, string $columnName): void
    {
        $qb = $this->connection->createQueryBuilder();
        $qb->update($tableName)
           ->set($columnName, ':emptyValue')
           ->setParameter('emptyValue', self::DEFAULT_EMPTY_VALUE)
           ->where($qb->expr()->isNull($columnName))
           ->execute();
    }

    public function down(Schema $schema): void
    {
        // No need (and no way) to undo this migration
    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			namespace ShlinkMigrations;
6
7			use Doctrine\DBAL\Schema\Schema;
8			use Doctrine\Migrations\AbstractMigration;
9
10			use function Functional\each;
11			use function Functional\partial_left;
12
13			final class Version20200110182849 extends AbstractMigration
14			{
15			private const DEFAULT_EMPTY_VALUE = '';
16			private const COLUMN_DEFAULTS_MAP = [
17			'visits' => [
18			'referer',
19			'user_agent',
20			],
21			'visit_locations' => [
22			'timezone',
23			'country_code',
24			'country_name',
25			'region_name',
26			'city_name',
27			],
28			];
29
30			public function up(Schema $schema): void
31			{
32			each(
33			self::COLUMN_DEFAULTS_MAP,
34			fn (array $columns, string $tableName) =>
35			each($columns, partial_left([$this, 'setDefaultValueForColumnInTable'], $tableName)),
36			);
37			}
38
39			public function setDefaultValueForColumnInTable(string $tableName, string $columnName): void
40			{
41			$qb = $this->connection->createQueryBuilder();
42			$qb->update($tableName)
43			->set($columnName, ':emptyValue')
44			->setParameter('emptyValue', self::DEFAULT_EMPTY_VALUE)
45			->where($qb->expr()->isNull($columnName))
46			->execute();
47			}
48
49			public function down(Schema $schema): void
50			{
51			// No need (and no way) to undo this migration
52			}
53			}
54

shlinkio / shlink

Pull Request — develop (#612)

setDefaultValueForColumnInTable() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like