Surfnet\StepupGateway\Behat\Repository\InstitutionConfigurationRepository::configure()

Complexity

Conditions	4
Paths	4

Size

Total Lines	38
Code Lines	30

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php declare(strict_types=1);
    public function configure(string $institution, string $option, bool $value)
    {
        // Does the SP exist?
        $stmt = $this->connection->prepare('SELECT * FROM institution_configuration WHERE institution=:institution LIMIT 1');
        $stmt->bindParam('institution', $institution);
        $stmt->execute();
        if ($stmt->rowCount() === 0) {
            // If not, create new InstitutionConfiguration
            $data = [
                'institution' => $institution,
                'sso_on2fa_enabled' => $value,
            ];
            $sql = <<<SQL
                INSERT INTO institution_configuration (institution, sso_on2fa_enabled)
                VALUES (:institution, :sso_on2fa_enabled);
SQL;
            $stmt = $this->connection->prepare($sql);
            if ($stmt->execute($data)) {
                return $data;
            }
            throw new Exception(sprintf('Unable to insert the new institution_configuration (%s)', $stmt->queryString));
        } else {
            $data = [
                'institution' => $institution,
                'option' => $option,
                'value' => $value,
            ];
            $sql = <<<SQL
                update gateway.institution_configuration
                set :option = :value
                where institutiton = :institution
            );
SQL;
            $stmt = $this->connection->prepare($sql);
            if ($stmt->execute($data)) {
                return $data;
            }
            return $data;
        }