TableMetadataStorage::updateMigratedVersionsFromV1orV2toV3() - Code Metrics - Inspection of "Handle migrated versions metadata table auto-updat..." - doctrine/migrations - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — master (#878)

by Asmir

created 2020-01-03 09:26 UTC

updateMigratedVersionsFromV1orV2toV3() A

↳ Parent: TableMetadataStorage

Complexity

Conditions	5
Paths	5

Size

Total Lines	25
Code Lines	13

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	14
CRAP Score	5

Importance

Changes

Metric	Value
cc	5
eloc	13
nc	5
nop	0
dl	0
loc	25
ccs	14
cts	14
cp	1
crap	5
rs	9.5222
c	0
b	0
f	0

<?php

declare(strict_types=1);

namespace Doctrine\Migrations\Metadata\Storage;

use DateTimeImmutable;
use Doctrine\DBAL\Connection;
use Doctrine\DBAL\Connections\MasterSlaveConnection;
use Doctrine\DBAL\Platforms\AbstractPlatform;
use Doctrine\DBAL\Schema\AbstractSchemaManager;
use Doctrine\DBAL\Schema\Comparator;
use Doctrine\DBAL\Schema\Table;
use Doctrine\DBAL\Schema\TableDiff;
use Doctrine\DBAL\Types\Type;
use Doctrine\Migrations\Exception\MetadataStorageError;
use Doctrine\Migrations\Metadata\AvailableMigration;
use Doctrine\Migrations\Metadata\ExecutedMigration;
use Doctrine\Migrations\Metadata\ExecutedMigrationsSet;
use Doctrine\Migrations\MigrationRepository;
use Doctrine\Migrations\Version\Direction;
use Doctrine\Migrations\Version\ExecutionResult;
use Doctrine\Migrations\Version\Version;
use InvalidArgumentException;
use const CASE_LOWER;
use function array_change_key_case;
use function floatval;
use function round;
use function sprintf;
use function strlen;
use function strpos;
use function strtolower;

final class TableMetadataStorage implements MetadataStorage
{
    /** @var Connection */
    private $connection;

    /** @var AbstractSchemaManager */
    private $schemaManager;

    /** @var AbstractPlatform */
    private $platform;

    /** @var TableMetadataStorageConfiguration */
    private $configuration;

    /** @var MigrationRepository|null */
    private $migrationRepository;

    public function __construct(
        Connection $connection,
        ?MetadataStorageConfiguration $configuration = null,
        ?MigrationRepository $migrationRepository = null
    ) {
        $this->migrationRepository = $migrationRepository;
        $this->connection          = $connection;
        $this->schemaManager       = $connection->getSchemaManager();
        $this->platform            = $connection->getDatabasePlatform();

        if ($configuration !== null && ! ($configuration instanceof TableMetadataStorageConfiguration)) {
            throw new InvalidArgumentException(sprintf('%s accepts only %s as configuration', self::class, TableMetadataStorageConfiguration::class));
        }
        $this->configuration = $configuration ?: new TableMetadataStorageConfiguration();

    }

    public function getExecutedMigrations() : ExecutedMigrationsSet
    {
        $this->checkInitialization();
        $rows = $this->connection->fetchAll(sprintf('SELECT * FROM %s', $this->configuration->getTableName()));

        $migrations = [];
        foreach ($rows as $row) {
            $row = array_change_key_case($row, CASE_LOWER);

            $version = new Version($row[strtolower($this->configuration->getVersionColumnName())]);

            $executedAt = $row[strtolower($this->configuration->getExecutedAtColumnName())] ?? '';
            $executedAt = $executedAt !== ''
                ? DateTimeImmutable::createFromFormat($this->platform->getDateTimeFormatString(), $executedAt)
                : null;

            $executionTime = isset($row[strtolower($this->configuration->getExecutionTimeColumnName())])
                ? floatval($row[strtolower($this->configuration->getExecutionTimeColumnName())]/1000)
                : null;

            $migration = new ExecutedMigration(
                $version,
                $executedAt instanceof DateTimeImmutable ? $executedAt : null,
                $executionTime
            );

            $migrations[(string) $version] = $migration;
        }

        return new ExecutedMigrationsSet($migrations);
    }

    public function reset() : void
    {
        $this->checkInitialization();

        $this->connection->executeUpdate(
            sprintf(
                'DELETE FROM %s WHERE 1 = 1',
                $this->platform->quoteIdentifier($this->configuration->getTableName())
            )
        );
    }

    public function complete(ExecutionResult $result) : void
    {
        $this->checkInitialization();

        if ($result->getDirection() === Direction::DOWN) {
            $this->connection->delete($this->configuration->getTableName(), [
                $this->configuration->getVersionColumnName() => (string) $result->getVersion(),
            ]);
        } else {
            $this->connection->insert($this->configuration->getTableName(), [
                $this->configuration->getVersionColumnName() => (string) $result->getVersion(),
                $this->configuration->getExecutedAtColumnName() => $result->getExecutedAt(),
                $this->configuration->getExecutionTimeColumnName() => $result->getTime() === null ? null : round($result->getTime()*1000),
            ], [
                Type::STRING,
                Type::DATETIME,
                Type::INTEGER,
            ]);
        }
    }

    public function ensureInitialized() : void
    {
        $expectedSchemaChangelog = $this->getExpectedTable();

        if (! $this->isInitialized($expectedSchemaChangelog)) {
            $this->schemaManager->createTable($expectedSchemaChangelog);

            return;
        }

        $diff = $this->needsUpdate($expectedSchemaChangelog);
        if ($diff === null) {
            return;
        }

        $this->schemaManager->alterTable($diff);
        $this->updateMigratedVersionsFromV1orV2toV3();
    }

    private function needsUpdate(Table $expectedTable) : ?TableDiff
    {
        $comparator   = new Comparator();
        $currentTable = $this->schemaManager->listTableDetails($this->configuration->getTableName());
        $diff         = $comparator->diffTable($currentTable, $expectedTable);

        return $diff instanceof TableDiff ? $diff : null;
    }

    private function isInitialized(Table $expectedTable) : bool
    {
        if ($this->connection instanceof MasterSlaveConnection) {
            $this->connection->connect('master');
        }

        return $this->schemaManager->tablesExist([$expectedTable->getName()]);
    }

    private function checkInitialization() : void
    {
        $expectedTable = $this->getExpectedTable();

        if (! $this->isInitialized($expectedTable)) {
            throw MetadataStorageError::notInitialized();
        }

        if ($this->needsUpdate($expectedTable)!== null) {
            throw MetadataStorageError::notUpToDate();
        }
    }

    private function getExpectedTable() : Table
    {
        $schemaChangelog = new Table($this->configuration->getTableName());

        $schemaChangelog->addColumn(
            $this->configuration->getVersionColumnName(),
            'string',
            ['notnull' => true, 'length' => $this->configuration->getVersionColumnLength()]
        );
        $schemaChangelog->addColumn($this->configuration->getExecutedAtColumnName(), 'datetime', ['notnull' => false]);
        $schemaChangelog->addColumn($this->configuration->getExecutionTimeColumnName(), 'integer', ['notnull' => false]);

        $schemaChangelog->setPrimaryKey([$this->configuration->getVersionColumnName()]);

        return $schemaChangelog;
    }

    private function updateMigratedVersionsFromV1orV2toV3() : void
    {
        if ($this->migrationRepository === null) {
            return;
        }

        $availableMigrations = $this->migrationRepository->getMigrations()->getItems();
        $executedMigrations  = $this->getExecutedMigrations()->getItems();

        foreach ($availableMigrations as $availableMigration) {
            foreach ($executedMigrations as $k => $executedMigration) {
                if ($this->isAlreadyV3Format($availableMigration, $executedMigration)) {
                    continue;
                }

                $this->connection->update(
                    $this->configuration->getTableName(),
                    [
                        $this->configuration->getVersionColumnName() => (string) $availableMigration->getVersion(),
                    ],
                    [
                        $this->configuration->getVersionColumnName() => (string) $executedMigration->getVersion(),
                    ]
                );
                unset($executedMigrations[$k]);
            }
        }
    }

    private function isAlreadyV3Format(AvailableMigration $availableMigration, ExecutedMigration $executedMigration) : bool
    {
        return strpos(
            (string) $availableMigration->getVersion(),
            (string) $executedMigration->getVersion()
        ) !== (
                strlen((string) $availableMigration->getVersion()) -
                strlen((string) $executedMigration->getVersion())
            );
    }
}


1		<?php
2
3		declare(strict_types=1);
4
5		namespace Doctrine\Migrations\Metadata\Storage;
6
7		use DateTimeImmutable;
8		use Doctrine\DBAL\Connection;
9		use Doctrine\DBAL\Connections\MasterSlaveConnection;
10		use Doctrine\DBAL\Platforms\AbstractPlatform;
11		use Doctrine\DBAL\Schema\AbstractSchemaManager;
12		use Doctrine\DBAL\Schema\Comparator;
13		use Doctrine\DBAL\Schema\Table;
14		use Doctrine\DBAL\Schema\TableDiff;
15		use Doctrine\DBAL\Types\Type;
16		use Doctrine\Migrations\Exception\MetadataStorageError;
17		use Doctrine\Migrations\Metadata\AvailableMigration;
18		use Doctrine\Migrations\Metadata\ExecutedMigration;
19		use Doctrine\Migrations\Metadata\ExecutedMigrationsSet;
20		use Doctrine\Migrations\MigrationRepository;
21		use Doctrine\Migrations\Version\Direction;
22		use Doctrine\Migrations\Version\ExecutionResult;
23		use Doctrine\Migrations\Version\Version;
24		use InvalidArgumentException;
25		use const CASE_LOWER;
26		use function array_change_key_case;
27		use function floatval;
28		use function round;
29		use function sprintf;
30		use function strlen;
31		use function strpos;
32		use function strtolower;
33
34		final class TableMetadataStorage implements MetadataStorage
35		{
36		/** @var Connection */
37		private $connection;
38
39		/** @var AbstractSchemaManager */
40		private $schemaManager;
41
42		/** @var AbstractPlatform */
43		private $platform;
44
45		/** @var TableMetadataStorageConfiguration */
46		private $configuration;
47
48		/** @var MigrationRepository\|null */
49		private $migrationRepository;
50
51	65	public function __construct(
52		Connection $connection,
53		?MetadataStorageConfiguration $configuration = null,
54		?MigrationRepository $migrationRepository = null
55		) {
56	65	$this->migrationRepository = $migrationRepository;
57	65	$this->connection = $connection;
58	65	$this->schemaManager = $connection->getSchemaManager();
59	65	$this->platform = $connection->getDatabasePlatform();
60
61	65	if ($configuration !== null && ! ($configuration instanceof TableMetadataStorageConfiguration)) {
62		throw new InvalidArgumentException(sprintf('%s accepts only %s as configuration', self::class, TableMetadataStorageConfiguration::class));
63		}
64	65	$this->configuration = $configuration ?: new TableMetadataStorageConfiguration();
		0 ignored issues – show introduced 2019-09-19 10:23 UTC by Report Bug Copy Issue Report `$configuration` is of type `null`, thus it always evaluated to `false`. Loading history...
65	65	}
66
67	53	public function getExecutedMigrations() : ExecutedMigrationsSet
68		{
69	53	$this->checkInitialization();
70	50	$rows = $this->connection->fetchAll(sprintf('SELECT * FROM %s', $this->configuration->getTableName()));
71
72	50	$migrations = [];
73	50	foreach ($rows as $row) {
74	32	$row = array_change_key_case($row, CASE_LOWER);
75
76	32	$version = new Version($row[strtolower($this->configuration->getVersionColumnName())]);
77
78	32	$executedAt = $row[strtolower($this->configuration->getExecutedAtColumnName())] ?? '';
79	32	$executedAt = $executedAt !== ''
80	3	? DateTimeImmutable::createFromFormat($this->platform->getDateTimeFormatString(), $executedAt)
81	32	: null;
82
83	32	$executionTime = isset($row[strtolower($this->configuration->getExecutionTimeColumnName())])
84	3	? floatval($row[strtolower($this->configuration->getExecutionTimeColumnName())]/1000)
85	32	: null;
86
87	32	$migration = new ExecutedMigration(
88	32	$version,
89	32	$executedAt instanceof DateTimeImmutable ? $executedAt : null,
90	32	$executionTime
91		);
92
93	32	$migrations[(string) $version] = $migration;
94		}
95
96	50	return new ExecutedMigrationsSet($migrations);
97		}
98
99	2	public function reset() : void
100		{
101	2	$this->checkInitialization();
102
103	2	$this->connection->executeUpdate(
104	2	sprintf(
105	2	'DELETE FROM %s WHERE 1 = 1',
106	2	$this->platform->quoteIdentifier($this->configuration->getTableName())
107		)
108		);
109	2	}
110
111	35	public function complete(ExecutionResult $result) : void
112		{
113	35	$this->checkInitialization();
114
115	35	if ($result->getDirection() === Direction::DOWN) {
116	5	$this->connection->delete($this->configuration->getTableName(), [
117	5	$this->configuration->getVersionColumnName() => (string) $result->getVersion(),
118		]);
119		} else {
120	35	$this->connection->insert($this->configuration->getTableName(), [
121	35	$this->configuration->getVersionColumnName() => (string) $result->getVersion(),
122	35	$this->configuration->getExecutedAtColumnName() => $result->getExecutedAt(),
123	35	$this->configuration->getExecutionTimeColumnName() => $result->getTime() === null ? null : round($result->getTime()*1000),
124		], [
125	35	Type::STRING,
126		Type::DATETIME,
127		Type::INTEGER,
128		]);
129		}
130	35	}
131
132	62	public function ensureInitialized() : void
133		{
134	62	$expectedSchemaChangelog = $this->getExpectedTable();
135
136	62	if (! $this->isInitialized($expectedSchemaChangelog)) {
137	60	$this->schemaManager->createTable($expectedSchemaChangelog);
138
139	60	return;
140		}
141
142	4	$diff = $this->needsUpdate($expectedSchemaChangelog);
143	4	if ($diff === null) {
144	2	return;
145		}
146
147	2	$this->schemaManager->alterTable($diff);
148	2	$this->updateMigratedVersionsFromV1orV2toV3();
149	2	}
150
151	57	private function needsUpdate(Table $expectedTable) : ?TableDiff
152		{
153	57	$comparator = new Comparator();
154	57	$currentTable = $this->schemaManager->listTableDetails($this->configuration->getTableName());
155	57	$diff = $comparator->diffTable($currentTable, $expectedTable);
156
157	57	return $diff instanceof TableDiff ? $diff : null;
158		}
159
160	64	private function isInitialized(Table $expectedTable) : bool
161		{
162	64	if ($this->connection instanceof MasterSlaveConnection) {
163		$this->connection->connect('master');
164		}
165
166	64	return $this->schemaManager->tablesExist([$expectedTable->getName()]);
167		}
168
169	58	private function checkInitialization() : void
170		{
171	58	$expectedTable = $this->getExpectedTable();
172
173	58	if (! $this->isInitialized($expectedTable)) {
174	2	throw MetadataStorageError::notInitialized();
175		}
176
177	56	if ($this->needsUpdate($expectedTable)!== null) {
178	1	throw MetadataStorageError::notUpToDate();
179		}
180	55	}
181
182	64	private function getExpectedTable() : Table
183		{
184	64	$schemaChangelog = new Table($this->configuration->getTableName());
185
186	64	$schemaChangelog->addColumn(
187	64	$this->configuration->getVersionColumnName(),
188	64	'string',
189	64	['notnull' => true, 'length' => $this->configuration->getVersionColumnLength()]
190		);
191	64	$schemaChangelog->addColumn($this->configuration->getExecutedAtColumnName(), 'datetime', ['notnull' => false]);
192	64	$schemaChangelog->addColumn($this->configuration->getExecutionTimeColumnName(), 'integer', ['notnull' => false]);
193
194	64	$schemaChangelog->setPrimaryKey([$this->configuration->getVersionColumnName()]);
195
196	64	return $schemaChangelog;
197		}
198
199	2	private function updateMigratedVersionsFromV1orV2toV3() : void
200		{
201	2	if ($this->migrationRepository === null) {
202	1	return;
203		}
204
205	1	$availableMigrations = $this->migrationRepository->getMigrations()->getItems();
206	1	$executedMigrations = $this->getExecutedMigrations()->getItems();
207
208	1	foreach ($availableMigrations as $availableMigration) {
209	1	foreach ($executedMigrations as $k => $executedMigration) {
210	1	if ($this->isAlreadyV3Format($availableMigration, $executedMigration)) {
211	1	continue;
212		}
213
214	1	$this->connection->update(
215	1	$this->configuration->getTableName(),
216		[
217	1	$this->configuration->getVersionColumnName() => (string) $availableMigration->getVersion(),
218		],
219		[
220	1	$this->configuration->getVersionColumnName() => (string) $executedMigration->getVersion(),
221		]
222		);
223	1	unset($executedMigrations[$k]);
224		}
225		}
226	1	}
227
228	1	private function isAlreadyV3Format(AvailableMigration $availableMigration, ExecutedMigration $executedMigration) : bool
229		{
230	1	return strpos(
231	1	(string) $availableMigration->getVersion(),
232	1	(string) $executedMigration->getVersion()
233		) !== (
234	1	strlen((string) $availableMigration->getVersion()) -
235	1	strlen((string) $executedMigration->getVersion())
236		);
237		}
238		}
239

doctrine / migrations

Pull Request — master (#878)

updateMigratedVersionsFromV1orV2toV3() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like