Albert221\Validation\Rule\PDOUnique

Complexity

Total Complexity

2

Size/Duplication

Total Lines	29
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Test Coverage

Coverage

100%

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	6	1
A	test()	0	13	1

<?php

namespace Albert221\Validation\Rule;

use PDO;

class PDOUnique implements RuleInterface
{
    use RuleTrait;

    protected $table;
    protected $field;
    protected $pdo;

    public function __construct($table, $field, PDO $pdo)
    {
        $this->table = $table;
        $this->field = $field;
        $this->pdo = $pdo;
    }

    public function test($value)
    {
        $statement = $this->pdo->prepare(sprintf(
            'SELECT COUNT(`%s`) FROM `%s` WHERE `%1$s` = :value',
            $this->field,
            $this->table
        ));

        $statement->bindValue(':value', $value);
        $statement->execute();

        return $statement->fetchColumn() == 0;
    }
}