Yiisoft\Db\Tests\Provider\BaseCommandPDOProvider

Complexity

Total Complexity

2

Size/Duplication

Total Lines	39
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	bindParam()	0	17	1
A	bindParamsNonWhere()	0	15	1

<?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' => 'user1@example.com',
                    '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,
            ],
        ];
    }
}