DbalUtils::generateArrayTypes() - Code Metrics - Inspection of "Merge pull request #204 from homersimpsons/feature..." - thecodingmachine/tdbm - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — 5.1 ( fe8887...07360b )

by David

created 2020-06-12 14:58 UTC

DbalUtils::generateArrayTypes() A

↳ Parent: DbalUtils

Complexity

Conditions	5
Paths	5

Size

Total Lines	16
Code Lines	9

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	9
c	1
b	0
f	0
dl	0
loc	16
rs	9.6111
cc	5
nc	5
nop	1

<?php


namespace TheCodingMachine\TDBM\Utils;

use Doctrine\DBAL\Connection;
use Doctrine\DBAL\ParameterType;
use function is_array;
use function is_int;

/**
 * Utility class to ease the use of DBAL types.
 */
class DbalUtils
{
    /**
     * If a parameter is an array (used in a "IN" statement), we need to tell Doctrine about it.
     * If it is an integer we have to tell DBAL (default is string)
     * @see https://www.doctrine-project.org/projects/doctrine-dbal/en/2.9/reference/data-retrieval-and-manipulation.html#list-of-parameters-conversion
     * @param array<string, mixed> $parameters
     * @return array<string, int>
     */
    public static function generateTypes(array $parameters): array
    {
        $types = [];
        foreach ($parameters as $key => $value) {
            if (is_array($value)) {
                foreach ($value as $val) {
                    if (!is_int($val)) {
                        $types[$key] = Connection::PARAM_STR_ARRAY;
                        continue 2;
                    }
                }
                $types[$key] = Connection::PARAM_INT_ARRAY;
            } elseif (is_int($value)) {
                $types[$key] = ParameterType::INTEGER;
            }
        }

        return $types;
    }
}


1			<?php
2
3
4			namespace TheCodingMachine\TDBM\Utils;
5
6			use Doctrine\DBAL\Connection;
7			use Doctrine\DBAL\ParameterType;
8			use function is_array;
9			use function is_int;
10
11			/**
12			* Utility class to ease the use of DBAL types.
13			*/
14			class DbalUtils
15			{
16			/**
17			* If a parameter is an array (used in a "IN" statement), we need to tell Doctrine about it.
18			* If it is an integer we have to tell DBAL (default is string)
19			* @see https://www.doctrine-project.org/projects/doctrine-dbal/en/2.9/reference/data-retrieval-and-manipulation.html#list-of-parameters-conversion
20			* @param array<string, mixed> $parameters
21			* @return array<string, int>
22			*/
23			public static function generateTypes(array $parameters): array
24			{
25			$types = [];
26			foreach ($parameters as $key => $value) {
27			if (is_array($value)) {
28			foreach ($value as $val) {
29			if (!is_int($val)) {
30			$types[$key] = Connection::PARAM_STR_ARRAY;
31			continue 2;
32			}
33			}
34			$types[$key] = Connection::PARAM_INT_ARRAY;
35			} elseif (is_int($value)) {
36			$types[$key] = ParameterType::INTEGER;
37			}
38			}
39
40			return $types;
41			}
42			}
43

thecodingmachine / tdbm

Push — 5.1 ( fe8887...07360b )

DbalUtils::generateArrayTypes() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like