UtilTest::dataConvertPositionalToNamedParameters() - Code Metrics - Inspection of "Added Codecov uploader to Travis CI configuration" - doctrine/dbal - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — master (#3610)

by Sergei

created 2019-12-20 07:46 UTC

UtilTest::dataConvertPositionalToNamedParameters() B

↳ Parent: UtilTest

Complexity

Conditions	1
Paths	1

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	55
rs	8.9818
c	0
b	0
f	0
cc	1
nc	1
nop	0

How to fix Long Method

<?php

declare(strict_types=1);

namespace Doctrine\Tests\DBAL;

use Doctrine\DBAL\Driver\OCI8\OCI8Statement;
use Doctrine\Tests\DbalTestCase;

class UtilTest extends DbalTestCase
{
    /**
     * @return mixed[][]
     */
    public static function dataConvertPositionalToNamedParameters() : iterable
    {
        return [
            [
                'SELECT name FROM users WHERE id = ?',
                'SELECT name FROM users WHERE id = :param1',
                [1 => ':param1'],
            ],
            [
                'SELECT name FROM users WHERE id = ? AND status = ?',
                'SELECT name FROM users WHERE id = :param1 AND status = :param2',
                [1 => ':param1', 2 => ':param2'],
            ],
            [
                "UPDATE users SET name = '???', status = ?",
                "UPDATE users SET name = '???', status = :param1",
                [1 => ':param1'],
            ],
            [
                "UPDATE users SET status = ?, name = '???'",
                "UPDATE users SET status = :param1, name = '???'",
                [1 => ':param1'],
            ],
            [
                "UPDATE users SET foo = ?, name = '???', status = ?",
                "UPDATE users SET foo = :param1, name = '???', status = :param2",
                [1 => ':param1', 2 => ':param2'],
            ],
            [
                'UPDATE users SET name = "???", status = ?',
                'UPDATE users SET name = "???", status = :param1',
                [1 => ':param1'],
            ],
            [
                'UPDATE users SET status = ?, name = "???"',
                'UPDATE users SET status = :param1, name = "???"',
                [1 => ':param1'],
            ],
            [
                'UPDATE users SET foo = ?, name = "???", status = ?',
                'UPDATE users SET foo = :param1, name = "???", status = :param2',
                [1 => ':param1', 2 => ':param2'],
            ],
            [
                'SELECT * FROM users WHERE id = ? AND name = "" AND status = ?',
                'SELECT * FROM users WHERE id = :param1 AND name = "" AND status = :param2',
                [1 => ':param1', 2 => ':param2'],
            ],
            [
                "SELECT * FROM users WHERE id = ? AND name = '' AND status = ?",
                "SELECT * FROM users WHERE id = :param1 AND name = '' AND status = :param2",
                [1 => ':param1', 2 => ':param2'],
            ],
        ];
    }

    /**
     * @param mixed[] $expectedOutputParamsMap
     *
     * @dataProvider dataConvertPositionalToNamedParameters
     */
    public function testConvertPositionalToNamedParameters(string $inputSQL, string $expectedOutputSQL, array $expectedOutputParamsMap) : void
    {
        [$statement, $params] = OCI8Statement::convertPositionalToNamedPlaceholders($inputSQL);


        self::assertEquals($expectedOutputSQL, $statement);
        self::assertEquals($expectedOutputParamsMap, $params);

    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			namespace Doctrine\Tests\DBAL;
6
7			use Doctrine\DBAL\Driver\OCI8\OCI8Statement;
8			use Doctrine\Tests\DbalTestCase;
9
10			class UtilTest extends DbalTestCase
11			{
12			/**
13			* @return mixed[][]
14			*/
15			public static function dataConvertPositionalToNamedParameters() : iterable
16			{
17			return [
18			[
19			'SELECT name FROM users WHERE id = ?',
20			'SELECT name FROM users WHERE id = :param1',
21			[1 => ':param1'],
22			],
23			[
24			'SELECT name FROM users WHERE id = ? AND status = ?',
25			'SELECT name FROM users WHERE id = :param1 AND status = :param2',
26			[1 => ':param1', 2 => ':param2'],
27			],
28			[
29			"UPDATE users SET name = '???', status = ?",
30			"UPDATE users SET name = '???', status = :param1",
31			[1 => ':param1'],
32			],
33			[
34			"UPDATE users SET status = ?, name = '???'",
35			"UPDATE users SET status = :param1, name = '???'",
36			[1 => ':param1'],
37			],
38			[
39			"UPDATE users SET foo = ?, name = '???', status = ?",
40			"UPDATE users SET foo = :param1, name = '???', status = :param2",
41			[1 => ':param1', 2 => ':param2'],
42			],
43			[
44			'UPDATE users SET name = "???", status = ?',
45			'UPDATE users SET name = "???", status = :param1',
46			[1 => ':param1'],
47			],
48			[
49			'UPDATE users SET status = ?, name = "???"',
50			'UPDATE users SET status = :param1, name = "???"',
51			[1 => ':param1'],
52			],
53			[
54			'UPDATE users SET foo = ?, name = "???", status = ?',
55			'UPDATE users SET foo = :param1, name = "???", status = :param2',
56			[1 => ':param1', 2 => ':param2'],
57			],
58			[
59			'SELECT * FROM users WHERE id = ? AND name = "" AND status = ?',
60			'SELECT * FROM users WHERE id = :param1 AND name = "" AND status = :param2',
61			[1 => ':param1', 2 => ':param2'],
62			],
63			[
64			"SELECT * FROM users WHERE id = ? AND name = '' AND status = ?",
65			"SELECT * FROM users WHERE id = :param1 AND name = '' AND status = :param2",
66			[1 => ':param1', 2 => ':param2'],
67			],
68			];
69			}
70
71			/**
72			* @param mixed[] $expectedOutputParamsMap
73			*
74			* @dataProvider dataConvertPositionalToNamedParameters
75			*/
76			public function testConvertPositionalToNamedParameters(string $inputSQL, string $expectedOutputSQL, array $expectedOutputParamsMap) : void
77			{
78			[$statement, $params] = OCI8Statement::convertPositionalToNamedPlaceholders($inputSQL);
			0 ignored issues – show Bug introduced 2019-06-16 23:45 UTC by Report Bug Copy Issue Report The variable `$statement` does not exist. Did you forget to declare it? This check marks access to variables or properties that have not been declared yet. While PHP has no explicit notion of declaring a variable, accessing it before a value is assigned to it is most likely a bug. Loading history... Bug introduced 2019-06-16 23:45 UTC by Report Bug Copy Issue Report The variable `$params` does not exist. Did you mean `$expectedOutputParamsMap`? This check looks for variables that are accessed but have not been defined. It raises an issue if it finds another variable that has a similar name. The variable may have been renamed without also renaming all references. Loading history...
79
80			self::assertEquals($expectedOutputSQL, $statement);
81			self::assertEquals($expectedOutputParamsMap, $params);
			0 ignored issues – show Bug introduced 2019-06-16 23:45 UTC by Report Bug Copy Issue Report The variable `$params` does not exist. Did you mean `$expectedOutputParamsMap`? This check looks for variables that are accessed but have not been defined. It raises an issue if it finds another variable that has a similar name. The variable may have been renamed without also renaming all references. Loading history...
82			}
83			}
84

doctrine / dbal

Pull Request — master (#3610)

UtilTest::dataConvertPositionalToNamedParameters() B

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like