BaseCommandPDOProvider::bindParamsNonWhere() - Code Metrics - Inspection of "Remove `src\TestSupport\TestCommandTrait::class` f..." - yiisoft/db - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — master (#398)

by Wilmer

created 2022-11-29 10:36 UTC

BaseCommandPDOProvider::bindParamsNonWhere() A

↳ Parent: BaseCommandPDOProvider

Complexity

Conditions	1
Paths	1

Size

Total Lines	15
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	10
nc	1
nop	0
dl	0
loc	15
rs	9.9332
c	1
b	0
f	0

<?php

declare(strict_types=1);

namespace Yiisoft\Db\Tests\Provider;

use PDO;

final class BaseCommandPDOProvider
{
    public function bindParam(): array
    {
        return [
            [
                'id',
                ':id',
                1,
                PDO::PARAM_STR,
                null,
                null,
                [
                    'id' => '1',
                    'email' => '[email protected]',
                    'name' => 'user1',
                    'address' => 'address1',
                    'status' => '1',
                    'profile_id' => '1',
                ],
            ],
        ];
    }

    public function bindParamsNonWhere(): array
    {
        return [
            [
                <<<SQL
                SELECT SUBSTR(name, :len) FROM [[customer]] WHERE [[email]] = :email GROUP BY SUBSTR(name, :len)
                SQL,
            ],
            [
                <<<SQL
                SELECT SUBSTR(name, :len) FROM [[customer]] WHERE [[email]] = :email ORDER BY SUBSTR(name, :len)
                SQL,
            ],
            [
                <<<SQL
                SELECT SUBSTR(name, :len) FROM [[customer]] WHERE [[email]] = :email
                SQL,
            ],
        ];
    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			namespace Yiisoft\Db\Tests\Provider;
6
7			use PDO;
8
9			final class BaseCommandPDOProvider
10			{
11			public function bindParam(): array
12			{
13			return [
14			[
15			'id',
16			':id',
17			1,
18			PDO::PARAM_STR,
19			null,
20			null,
21			[
22			'id' => '1',
23			'email' => '[email protected]',
24			'name' => 'user1',
25			'address' => 'address1',
26			'status' => '1',
27			'profile_id' => '1',
28			],
29			],
30			];
31			}
32
33			public function bindParamsNonWhere(): array
34			{
35			return [
36			[
37			<<<SQL
38			SELECT SUBSTR(name, :len) FROM [[customer]] WHERE [[email]] = :email GROUP BY SUBSTR(name, :len)
39			SQL,
40			],
41			[
42			<<<SQL
43			SELECT SUBSTR(name, :len) FROM [[customer]] WHERE [[email]] = :email ORDER BY SUBSTR(name, :len)
44			SQL,
45			],
46			[
47			<<<SQL
48			SELECT SUBSTR(name, :len) FROM [[customer]] WHERE [[email]] = :email
49			SQL,
50			],
51			];
52			}
53			}
54

yiisoft / db

Pull Request — master (#398)

BaseCommandPDOProvider::bindParamsNonWhere() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like