JsonTable\Validate\ForeignKey\PostgresqlValidator::validate()

Complexity

Conditions	2
Paths	2

Size

Total Lines	22
Code Lines	12

Duplication

Lines	0
Ratio	0 %

Importance

Changes	8
Bugs	0	Features	1

<?php
    public function validate($rowHash, $referenceResource, array $referenceFields)
    {
        $referenceFields = implode(" || ', ' || ", $referenceFields);

        $validationSql =   "SELECT
                                    COUNT(*)
                                FROM
                                    $referenceResource
                                WHERE
                                    $referenceFields = :row_hash";

        $statement = Base::$pdoConnection->prepare($validationSql);
        $statement->bindParam(':row_hash', $rowHash);
        $results = $statement->execute();

        if (false === $results) {
            throw new \Exception("Could not validate the foreign key for $referenceResource
                fields $referenceFields with hash of $rowHash.");
        }

        return (0 !== $results[0]['count']);
    }
}