Version::addQueryParams() - Code Metrics - Inspection of "Leave DBAL namespace" - doctrine/migrations - Measure and Improve Code Quality continuously with Scrutinizer

Failed Conditions

Pull Request — master (#632)

by Michael

created 2018-05-06 01:10 UTC

Version::addQueryParams() A

↳ Parent: Version

Complexity

Conditions	1
Paths	1

Size

Total Lines	5
Code Lines	3

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	4
CRAP Score	1

Importance

Changes

Metric	Value
cc	1
eloc	3
nc	1
nop	2
dl	0
loc	5
ccs	4
cts	4
cp	1
crap	1
rs	9.4285
c	0
b	0
f	0

<?php

declare(strict_types=1);

namespace Doctrine\Migrations;

use Doctrine\DBAL\Connection;
use Doctrine\DBAL\Types\Type;
use Doctrine\Migrations\Configuration\Configuration;
use Doctrine\Migrations\Event\MigrationsVersionEventArgs;
use Doctrine\Migrations\Provider\LazySchemaDiffProvider;
use Doctrine\Migrations\Provider\SchemaDiffProvider;
use Doctrine\Migrations\Provider\SchemaDiffProviderInterface;
use Throwable;
use function array_map;
use function count;
use function implode;
use function is_array;
use function is_bool;
use function is_int;
use function is_string;
use function microtime;
use function round;
use function rtrim;
use function sprintf;
use function ucfirst;

class Version
{
    public const STATE_NONE = 0;
    public const STATE_PRE  = 1;
    public const STATE_EXEC = 2;
    public const STATE_POST = 3;

    public const DIRECTION_UP   = 'up';
    public const DIRECTION_DOWN = 'down';

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

    /** @var OutputWriter */
    private $outputWriter;

    /** @var string */
    private $version;

    /** @var AbstractMigration */
    private $migration;

    /** @var Connection */
    private $connection;

    /** @var string */
    private $class;

    /** @var string[] */
    private $sql = [];

    /** @var mixed[] */
    private $params = [];

    /** @var mixed[] */
    private $types = [];

    /** @var float */
    private $time;

    /** @var int */
    private $state = self::STATE_NONE;

    /** @var SchemaDiffProviderInterface */
    private $schemaProvider;

    public function __construct(
        Configuration $configuration,
        string $version,
        string $class,
        ?SchemaDiffProviderInterface $schemaProvider = null
    ) {
        $this->configuration = $configuration;
        $this->outputWriter  = $configuration->getOutputWriter();
        $this->class         = $class;
        $this->connection    = $configuration->getConnection();
        $this->migration     = new $class($this);
        $this->version       = $version;

        if ($schemaProvider !== null) {
            $this->schemaProvider = $schemaProvider;
        }

        if ($schemaProvider !== null) {
            return;
        }

        $schemaProvider = new SchemaDiffProvider(
            $this->connection->getSchemaManager(),
            $this->connection->getDatabasePlatform()
        );

        $this->schemaProvider = LazySchemaDiffProvider::fromDefaultProxyFactoryConfiguration(
            $schemaProvider
        );
    }

    public function getVersion() : string
    {
        return $this->version;
    }

    public function getConfiguration() : Configuration
    {
        return $this->configuration;
    }

    public function isMigrated() : bool
    {
        return $this->configuration->hasVersionMigrated($this);
    }

    public function markMigrated() : void
    {
        $this->markVersion(self::DIRECTION_UP);
    }

    public function markNotMigrated() : void
    {
        $this->markVersion(self::DIRECTION_DOWN);
    }

    /**
     * @param string[]|string $sql
     * @param mixed[]         $params
     * @param mixed[]         $types
     */
    public function addSql($sql, array $params = [], array $types = []) : void
    {
        if (is_array($sql)) {
            foreach ($sql as $key => $query) {
                $this->sql[] = $query;

                if (empty($params[$key])) {
                    continue;
                }

                $queryTypes = $types[$key] ?? [];
                $this->addQueryParams($params[$key], $queryTypes);
            }
        } else {
            $this->sql[] = $sql;

            if (! empty($params)) {
                $this->addQueryParams($params, $types);
            }
        }
    }

    public function writeSqlFile(
        string $path,
        string $direction = self::DIRECTION_UP
    ) : bool {
        $queries = $this->execute($direction, true);

        if (! empty($this->params)) {
            throw MigrationException::migrationNotConvertibleToSql($this->class);
        }

        $this->outputWriter->write("\n-- Version " . $this->version . "\n");

        $sqlQueries = [$this->version => $queries];

        /*
         * Since the configuration object changes during the creation we cannot inject things
         * properly, so I had to violate LoD here (so please, let's find a way to solve it on v2).
         */
        return $this->configuration
            ->getQueryWriter()
            ->write($path, $direction, $sqlQueries);
    }

    public function getMigration() : AbstractMigration
    {
        return $this->migration;
    }

    /** @return string[] */
    public function execute(
        string $direction,
        bool $dryRun = false,
        bool $timeAllQueries = false
    ) : array {
        $this->dispatchEvent(Events::onMigrationsVersionExecuting, $direction, $dryRun);

        $this->sql = [];

        $transaction = $this->migration->isTransactional();
        if ($transaction) {
            //only start transaction if in transactional mode
            $this->connection->beginTransaction();
        }

        try {
            $migrationStart = microtime(true);

            $this->state = self::STATE_PRE;
            $fromSchema  = $this->schemaProvider->createFromSchema();

            $this->migration->{'pre' . ucfirst($direction)}($fromSchema);

            if ($direction === self::DIRECTION_UP) {
                $this->outputWriter->write("\n" . sprintf('  <info>++</info> migrating <comment>%s</comment>', $this->version) . "\n");
            } else {
                $this->outputWriter->write("\n" . sprintf('  <info>--</info> reverting <comment>%s</comment>', $this->version) . "\n");
            }

            $this->state = self::STATE_EXEC;

            $toSchema = $this->schemaProvider->createToSchema($fromSchema);
            $this->migration->$direction($toSchema);

            $this->addSql($this->schemaProvider->getSqlDiffToMigrate($fromSchema, $toSchema));

            $this->executeRegisteredSql($dryRun, $timeAllQueries);

            $this->state = self::STATE_POST;
            $this->migration->{'post' . ucfirst($direction)}($toSchema);

            if (! $dryRun) {
                if ($direction === self::DIRECTION_UP) {
                    $this->markMigrated();
                } else {
                    $this->markNotMigrated();
                }
            }

            $migrationEnd = microtime(true);
            $this->time   = round($migrationEnd - $migrationStart, 2);
            if ($direction === self::DIRECTION_UP) {
                $this->outputWriter->write(sprintf("\n  <info>++</info> migrated (%ss)", $this->time));
            } else {
                $this->outputWriter->write(sprintf("\n  <info>--</info> reverted (%ss)", $this->time));
            }

            if ($transaction) {
                //commit only if running in transactional mode
                $this->connection->commit();
            }

            $this->state = self::STATE_NONE;

            $this->dispatchEvent(Events::onMigrationsVersionExecuted, $direction, $dryRun);

            return $this->sql;
        } catch (SkipMigrationException $e) {
            if ($transaction) {
                //only rollback transaction if in transactional mode
                $this->connection->rollBack();
            }

            if ($dryRun === false) {
                // now mark it as migrated
                if ($direction === self::DIRECTION_UP) {
                    $this->markMigrated();
                } else {
                    $this->markNotMigrated();
                }
            }

            $this->outputWriter->write(sprintf("\n  <info>SS</info> skipped (Reason: %s)", $e->getMessage()));

            $this->state = self::STATE_NONE;

            $this->dispatchEvent(Events::onMigrationsVersionSkipped, $direction, $dryRun);

            return [];
        } catch (Throwable $e) {
            $this->outputWriter->write(sprintf(
                '<error>Migration %s failed during %s. Error %s</error>',
                $this->version,
                $this->getExecutionState(),
                $e->getMessage()
            ));

            if ($transaction) {
                //only rollback transaction if in transactional mode
                $this->connection->rollBack();
            }

            $this->state = self::STATE_NONE;

            throw $e;
        }
    }

    public function getExecutionState() : string
    {
        switch ($this->state) {
            case self::STATE_PRE:
                return 'Pre-Checks';

            case self::STATE_POST:
                return 'Post-Checks';

            case self::STATE_EXEC:
                return 'Execution';

            default:
                return 'No State';
        }
    }

    public function getTime() : ?float
    {
        return $this->time;
    }

    public function __toString() : string
    {
        return $this->version;
    }

    private function outputQueryTime(float $queryStart, bool $timeAllQueries = false) : void
    {
        if ($timeAllQueries === false) {
            return;
        }

        $queryEnd  = microtime(true);
        $queryTime = round($queryEnd - $queryStart, 4);

        $this->outputWriter->write(sprintf('  <info>%ss</info>', $queryTime));
    }

    private function markVersion(string $direction) : void
    {
        $this->configuration->createMigrationTable();

        $migrationsColumnName = $this->configuration
            ->getQuotedMigrationsColumnName();

        if ($direction === self::DIRECTION_UP) {
            $this->connection->insert(
                $this->configuration->getMigrationsTableName(),
                [
                    $migrationsColumnName => $this->version,
                ]
            );
        } else {
            $this->connection->delete(
                $this->configuration->getMigrationsTableName(),
                [
                    $migrationsColumnName => $this->version,
                ]
            );
        }
    }

    /**
     * @param mixed[]|int $params
     * @param mixed[]|int $types
     */
    private function addQueryParams($params, $types) : void
    {
        $index                = count($this->sql) - 1;
        $this->params[$index] = $params;
        $this->types[$index]  = $types;
    }

    private function executeRegisteredSql(
        bool $dryRun = false,
        bool $timeAllQueries = false
    ) : void {
        if (! $dryRun) {
            if (! empty($this->sql)) {
                foreach ($this->sql as $key => $query) {
                    $queryStart = microtime(true);

                    $this->outputSqlQuery($key, $query);
                    if (! isset($this->params[$key])) {
                        $this->connection->executeQuery($query);
                    } else {
                        $this->connection->executeQuery($query, $this->params[$key], $this->types[$key]);
                    }

                    $this->outputQueryTime($queryStart, $timeAllQueries);
                }
            } else {
                $this->outputWriter->write(sprintf(
                    '<error>Migration %s was executed but did not result in any SQL statements.</error>',
                    $this->version
                ));
            }
        } else {
            foreach ($this->sql as $idx => $query) {
                $this->outputSqlQuery($idx, $query);
            }
        }
    }

    private function outputSqlQuery(int $idx, string $query) : void
    {
        $params = $this->formatParamsForOutput(
            $this->params[$idx] ?? [],
            $this->types[$idx] ?? []
        );

        $this->outputWriter->write(rtrim(sprintf(
            '     <comment>-></comment> %s %s',
            $query,
            $params
        )));
    }

    /**
     * @param mixed[] $params
     * @param mixed[] $types
     */
    private function formatParamsForOutput(array $params, array $types) : string
    {
        if (empty($params)) {
            return '';
        }

        $out = [];
        foreach ($params as $key => $value) {
            $type   = $types[$key] ?? 'string';
            $outval = '[' . $this->formatParameter($value, $type) . ']';
            $out[]  = is_string($key) ? sprintf(':%s => %s', $key, $outval) : $outval;
        }

        return sprintf('with parameters (%s)', implode(', ', $out));
    }

    private function dispatchEvent(
        string $eventName,
        string $direction,
        bool $dryRun
    ) : void {
        $event = $this->createMigrationsVersionEventArgs(
            $this,
            $this->configuration,
            $direction,
            $dryRun
        );

        $this->configuration->dispatchEvent($eventName, $event);
    }

    private function createMigrationsVersionEventArgs(
        Version $version,
        Configuration $config,
        string $direction,
        bool $dryRun
    ) : MigrationsVersionEventArgs {
        return new MigrationsVersionEventArgs(
            $this,
            $this->configuration,
            $direction,
            $dryRun
        );
    }

    /**
     * @param string|int $value
     * @param string|int $type
     *
     * @return string|int
     */
    private function formatParameter($value, $type)
    {
        if (is_string($type) && Type::hasType($type)) {
            return Type::getType($type)->convertToDatabaseValue(
                $value,
                $this->connection->getDatabasePlatform()
            );
        }

        return $this->parameterToString($value);
    }

    /**
     * @param int[]|bool[]|string[]|array|int|string|bool $value
     */
    private function parameterToString($value) : string
    {
        if (is_array($value)) {
            return implode(', ', array_map([$this, 'parameterToString'], $value));
        }

        if (is_int($value) || is_string($value)) {
            return (string) $value;
        }

        if (is_bool($value)) {

            return $value === true ? 'true' : 'false';
        }

        return '?';
    }
}


1		<?php
2
3		declare(strict_types=1);
4
5		namespace Doctrine\Migrations;
6
7		use Doctrine\DBAL\Connection;
8		use Doctrine\DBAL\Types\Type;
9		use Doctrine\Migrations\Configuration\Configuration;
10		use Doctrine\Migrations\Event\MigrationsVersionEventArgs;
11		use Doctrine\Migrations\Provider\LazySchemaDiffProvider;
12		use Doctrine\Migrations\Provider\SchemaDiffProvider;
13		use Doctrine\Migrations\Provider\SchemaDiffProviderInterface;
14		use Throwable;
15		use function array_map;
16		use function count;
17		use function implode;
18		use function is_array;
19		use function is_bool;
20		use function is_int;
21		use function is_string;
22		use function microtime;
23		use function round;
24		use function rtrim;
25		use function sprintf;
26		use function ucfirst;
27
28		class Version
29		{
30		public const STATE_NONE = 0;
31		public const STATE_PRE = 1;
32		public const STATE_EXEC = 2;
33		public const STATE_POST = 3;
34
35		public const DIRECTION_UP = 'up';
36		public const DIRECTION_DOWN = 'down';
37
38		/** @var Configuration */
39		private $configuration;
40
41		/** @var OutputWriter */
42		private $outputWriter;
43
44		/** @var string */
45		private $version;
46
47		/** @var AbstractMigration */
48		private $migration;
49
50		/** @var Connection */
51		private $connection;
52
53		/** @var string */
54		private $class;
55
56		/** @var string[] */
57		private $sql = [];
58
59		/** @var mixed[] */
60		private $params = [];
61
62		/** @var mixed[] */
63		private $types = [];
64
65		/** @var float */
66		private $time;
67
68		/** @var int */
69		private $state = self::STATE_NONE;
70
71		/** @var SchemaDiffProviderInterface */
72		private $schemaProvider;
73
74	122	public function __construct(
75		Configuration $configuration,
76		string $version,
77		string $class,
78		?SchemaDiffProviderInterface $schemaProvider = null
79		) {
80	122	$this->configuration = $configuration;
81	122	$this->outputWriter = $configuration->getOutputWriter();
82	122	$this->class = $class;
83	122	$this->connection = $configuration->getConnection();
84	122	$this->migration = new $class($this);
85	122	$this->version = $version;
86
87	122	if ($schemaProvider !== null) {
88	1	$this->schemaProvider = $schemaProvider;
89		}
90
91	122	if ($schemaProvider !== null) {
92	1	return;
93		}
94
95	121	$schemaProvider = new SchemaDiffProvider(
96	121	$this->connection->getSchemaManager(),
97	121	$this->connection->getDatabasePlatform()
98		);
99
100	121	$this->schemaProvider = LazySchemaDiffProvider::fromDefaultProxyFactoryConfiguration(
101	121	$schemaProvider
102		);
103	121	}
104
105	79	public function getVersion() : string
106		{
107	79	return $this->version;
108		}
109
110	118	public function getConfiguration() : Configuration
111		{
112	118	return $this->configuration;
113		}
114
115	15	public function isMigrated() : bool
116		{
117	15	return $this->configuration->hasVersionMigrated($this);
118		}
119
120	43	public function markMigrated() : void
121		{
122	43	$this->markVersion(self::DIRECTION_UP);
123	43	}
124
125	9	public function markNotMigrated() : void
126		{
127	9	$this->markVersion(self::DIRECTION_DOWN);
128	9	}
129
130		/**
131		* @param string[]\|string $sql
132		* @param mixed[] $params
133		* @param mixed[] $types
134		*/
135	49	public function addSql($sql, array $params = [], array $types = []) : void
136		{
137	49	if (is_array($sql)) {
138	48	foreach ($sql as $key => $query) {
139	14	$this->sql[] = $query;
140
141	14	if (empty($params[$key])) {
142	14	continue;
143		}
144
145	1	$queryTypes = $types[$key] ?? [];
146	48	$this->addQueryParams($params[$key], $queryTypes);
147		}
148		} else {
149	30	$this->sql[] = $sql;
150
151	30	if (! empty($params)) {
152	18	$this->addQueryParams($params, $types);
153		}
154		}
155	49	}
156
157	9	public function writeSqlFile(
158		string $path,
159		string $direction = self::DIRECTION_UP
160		) : bool {
161	9	$queries = $this->execute($direction, true);
162
163	9	if (! empty($this->params)) {
164	1	throw MigrationException::migrationNotConvertibleToSql($this->class);
165		}
166
167	8	$this->outputWriter->write("\n-- Version " . $this->version . "\n");
168
169	8	$sqlQueries = [$this->version => $queries];
170
171		/*
172		* Since the configuration object changes during the creation we cannot inject things
173		* properly, so I had to violate LoD here (so please, let's find a way to solve it on v2).
174		*/
175	8	return $this->configuration
176	8	->getQueryWriter()
177	8	->write($path, $direction, $sqlQueries);
178		}
179
180	11	public function getMigration() : AbstractMigration
181		{
182	11	return $this->migration;
183		}
184
185		/** @return string[] */
186	50	public function execute(
187		string $direction,
188		bool $dryRun = false,
189		bool $timeAllQueries = false
190		) : array {
191	50	$this->dispatchEvent(Events::onMigrationsVersionExecuting, $direction, $dryRun);
192
193	50	$this->sql = [];
194
195	50	$transaction = $this->migration->isTransactional();
196	50	if ($transaction) {
197		//only start transaction if in transactional mode
198	50	$this->connection->beginTransaction();
199		}
200
201		try {
202	50	$migrationStart = microtime(true);
203
204	50	$this->state = self::STATE_PRE;
205	50	$fromSchema = $this->schemaProvider->createFromSchema();
206
207	50	$this->migration->{'pre' . ucfirst($direction)}($fromSchema);
208
209	48	if ($direction === self::DIRECTION_UP) {
210	46	$this->outputWriter->write("\n" . sprintf(' <info>++</info> migrating <comment>%s</comment>', $this->version) . "\n");
211		} else {
212	8	$this->outputWriter->write("\n" . sprintf(' <info>--</info> reverting <comment>%s</comment>', $this->version) . "\n");
213		}
214
215	48	$this->state = self::STATE_EXEC;
216
217	48	$toSchema = $this->schemaProvider->createToSchema($fromSchema);
218	48	$this->migration->$direction($toSchema);
219
220	47	$this->addSql($this->schemaProvider->getSqlDiffToMigrate($fromSchema, $toSchema));
221
222	47	$this->executeRegisteredSql($dryRun, $timeAllQueries);
223
224	47	$this->state = self::STATE_POST;
225	47	$this->migration->{'post' . ucfirst($direction)}($toSchema);
226
227	47	if (! $dryRun) {
228	30	if ($direction === self::DIRECTION_UP) {
229	30	$this->markMigrated();
230		} else {
231	6	$this->markNotMigrated();
232		}
233		}
234
235	47	$migrationEnd = microtime(true);
236	47	$this->time = round($migrationEnd - $migrationStart, 2);
237	47	if ($direction === self::DIRECTION_UP) {
238	45	$this->outputWriter->write(sprintf("\n <info>++</info> migrated (%ss)", $this->time));
239		} else {
240	8	$this->outputWriter->write(sprintf("\n <info>--</info> reverted (%ss)", $this->time));
241		}
242
243	47	if ($transaction) {
244		//commit only if running in transactional mode
245	47	$this->connection->commit();
246		}
247
248	47	$this->state = self::STATE_NONE;
249
250	47	$this->dispatchEvent(Events::onMigrationsVersionExecuted, $direction, $dryRun);
251
252	47	return $this->sql;
253	7	} catch (SkipMigrationException $e) {
254	6	if ($transaction) {
255		//only rollback transaction if in transactional mode
256	6	$this->connection->rollBack();
257		}
258
259	6	if ($dryRun === false) {
260		// now mark it as migrated
261	5	if ($direction === self::DIRECTION_UP) {
262	5	$this->markMigrated();
263		} else {
264	1	$this->markNotMigrated();
265		}
266		}
267
268	6	$this->outputWriter->write(sprintf("\n <info>SS</info> skipped (Reason: %s)", $e->getMessage()));
269
270	6	$this->state = self::STATE_NONE;
271
272	6	$this->dispatchEvent(Events::onMigrationsVersionSkipped, $direction, $dryRun);
273
274	6	return [];
275	1	} catch (Throwable $e) {
276	1	$this->outputWriter->write(sprintf(
277	1	'<error>Migration %s failed during %s. Error %s</error>',
278	1	$this->version,
279	1	$this->getExecutionState(),
280	1	$e->getMessage()
281		));
282
283	1	if ($transaction) {
284		//only rollback transaction if in transactional mode
285	1	$this->connection->rollBack();
286		}
287
288	1	$this->state = self::STATE_NONE;
289
290	1	throw $e;
291		}
292		}
293
294	8	public function getExecutionState() : string
295		{
296	8	switch ($this->state) {
297	8	case self::STATE_PRE:
298	1	return 'Pre-Checks';
299
300	7	case self::STATE_POST:
301	1	return 'Post-Checks';
302
303	6	case self::STATE_EXEC:
304	2	return 'Execution';
305
306		default:
307	4	return 'No State';
308		}
309		}
310
311	26	public function getTime() : ?float
312		{
313	26	return $this->time;
314		}
315
316	2	public function __toString() : string
317		{
318	2	return $this->version;
319		}
320
321	21	private function outputQueryTime(float $queryStart, bool $timeAllQueries = false) : void
322		{
323	21	if ($timeAllQueries === false) {
324	20	return;
325		}
326
327	1	$queryEnd = microtime(true);
328	1	$queryTime = round($queryEnd - $queryStart, 4);
329
330	1	$this->outputWriter->write(sprintf(' <info>%ss</info>', $queryTime));
331	1	}
332
333	43	private function markVersion(string $direction) : void
334		{
335	43	$this->configuration->createMigrationTable();
336
337	43	$migrationsColumnName = $this->configuration
338	43	->getQuotedMigrationsColumnName();
339
340	43	if ($direction === self::DIRECTION_UP) {
341	43	$this->connection->insert(
342	43	$this->configuration->getMigrationsTableName(),
343		[
344	43	$migrationsColumnName => $this->version,
345		]
346		);
347		} else {
348	9	$this->connection->delete(
349	9	$this->configuration->getMigrationsTableName(),
350		[
351	9	$migrationsColumnName => $this->version,
352		]
353		);
354		}
355	43	}
356
357		/**
358		* @param mixed[]\|int $params
359		* @param mixed[]\|int $types
360		*/
361	19	private function addQueryParams($params, $types) : void
362		{
363	19	$index = count($this->sql) - 1;
364	19	$this->params[$index] = $params;
365	19	$this->types[$index] = $types;
366	19	}
367
368	47	private function executeRegisteredSql(
369		bool $dryRun = false,
370		bool $timeAllQueries = false
371		) : void {
372	47	if (! $dryRun) {
373	30	if (! empty($this->sql)) {
374	19	foreach ($this->sql as $key => $query) {
375	19	$queryStart = microtime(true);
376
377	19	$this->outputSqlQuery($key, $query);
378	19	if (! isset($this->params[$key])) {
379	18	$this->connection->executeQuery($query);
380		} else {
381	8	$this->connection->executeQuery($query, $this->params[$key], $this->types[$key]);
382		}
383
384	19	$this->outputQueryTime($queryStart, $timeAllQueries);
385		}
386		} else {
387	11	$this->outputWriter->write(sprintf(
388	11	'<error>Migration %s was executed but did not result in any SQL statements.</error>',
389	30	$this->version
390		));
391		}
392		} else {
393	17	foreach ($this->sql as $idx => $query) {
394	17	$this->outputSqlQuery($idx, $query);
395		}
396		}
397	47	}
398
399	36	private function outputSqlQuery(int $idx, string $query) : void
400		{
401	36	$params = $this->formatParamsForOutput(
402	36	$this->params[$idx] ?? [],
403	36	$this->types[$idx] ?? []
404		);
405
406	36	$this->outputWriter->write(rtrim(sprintf(
407	36	' <comment>-></comment> %s %s',
408	36	$query,
409	36	$params
410		)));
411	36	}
412
413		/**
414		* @param mixed[] $params
415		* @param mixed[] $types
416		*/
417	36	private function formatParamsForOutput(array $params, array $types) : string
418		{
419	36	if (empty($params)) {
420	26	return '';
421		}
422
423	18	$out = [];
424	18	foreach ($params as $key => $value) {
425	18	$type = $types[$key] ?? 'string';
426	18	$outval = '[' . $this->formatParameter($value, $type) . ']';
427	18	$out[] = is_string($key) ? sprintf(':%s => %s', $key, $outval) : $outval;
428		}
429
430	18	return sprintf('with parameters (%s)', implode(', ', $out));
431		}
432
433	50	private function dispatchEvent(
434		string $eventName,
435		string $direction,
436		bool $dryRun
437		) : void {
438	50	$event = $this->createMigrationsVersionEventArgs(
439	50	$this,
440	50	$this->configuration,
441	50	$direction,
442	50	$dryRun
443		);
444
445	50	$this->configuration->dispatchEvent($eventName, $event);
446	50	}
447
448	50	private function createMigrationsVersionEventArgs(
449		Version $version,
450		Configuration $config,
451		string $direction,
452		bool $dryRun
453		) : MigrationsVersionEventArgs {
454	50	return new MigrationsVersionEventArgs(
455	50	$this,
456	50	$this->configuration,
457	50	$direction,
458	50	$dryRun
459		);
460		}
461
462		/**
463		* @param string\|int $value
464		* @param string\|int $type
465		*
466		* @return string\|int
467		*/
468	18	private function formatParameter($value, $type)
469		{
470	18	if (is_string($type) && Type::hasType($type)) {
471	13	return Type::getType($type)->convertToDatabaseValue(
472	13	$value,
473	13	$this->connection->getDatabasePlatform()
474		);
475		}
476
477	5	return $this->parameterToString($value);
478		}
479
480		/**
481		* @param int[]\|bool[]\|string[]\|array\|int\|string\|bool $value
482		*/
483	5	private function parameterToString($value) : string
484		{
485	5	if (is_array($value)) {
486	3	return implode(', ', array_map([$this, 'parameterToString'], $value));
487		}
488
489	5	if (is_int($value) \|\| is_string($value)) {
490	3	return (string) $value;
491		}
492
493	2	if (is_bool($value)) {
		0 ignored issues – show introduced 2018-05-05 20:17 UTC by Report Bug Copy Issue Report The condition `is_bool($value)` is always `true`. Loading history...
494	1	return $value === true ? 'true' : 'false';
495		}
496
497	1	return '?';
498		}
499		}
500

doctrine / migrations

Pull Request — master (#632)

Version::addQueryParams() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like