Surfnet\StepupGateway\Behat\Repository\WhitelistRepository::whitelist()

Complexity

Conditions	3
Paths	3

Size

Total Lines

19

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function whitelist($institution)
    {
        // Does the whitelist entry exist?
        $stmt = $this->connection->prepare('SELECT * FROM whitelist_entry WHERE institution=:institution LIMIT 1');
        $stmt->bindParam('institution', $institution, PDO::PARAM_STR);
        $stmt->execute();
        if ($stmt->rowCount() === 0) {
            $sql = "INSERT INTO whitelist_entry (`institution`) VALUES (:institution);";
            $stmt = $this->connection->prepare($sql);
            $data = ['institution' => $institution];
            if ($stmt->execute($data)) {
                return $data;
            }
            throw new Exception('Unable add the institution to the whitelist');
        } else {
            // Return the existing whitelist data
            return reset($stmt->fetchAll());

$stmt->fetchAll() cannot be passed to reset() as the parameter $array expects a reference.

        }
    }
}