Phuria\SQLBuilder\Connection\PDOConnection

Complexity

Total Complexity

12

Size/Duplication

Total Lines	96
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Test Coverage

Coverage

63.33%

Importance

Changes

0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	prepareStatement()	0	4	1
A	getExecutedStatement()	0	12	2
A	fetchScalar()	0	10	2
A	fetchRow()	0	10	2
A	fetchAll()	0	10	2
A	rowCount()	0	6	2

<?php

/**
 * This file is part of Phuria SQL Builder package.
 *
 * Copyright (c) 2016 Beniamin Jonatan Šimko
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

namespace Phuria\SQLBuilder\Connection;

use Phuria\SQLBuilder\Parameter\QueryParameterInterface;

/**
 * @author Beniamin Jonatan Šimko <spam@simko.it>
 */
class PDOConnection implements ConnectionInterface
{
    /**
     * @var \PDO $wrappedConnection
     */
    private $wrappedConnection;

    /**
     * @param \PDO $connection
     */
    public function __construct(\PDO $connection)
    {
        $this->wrappedConnection = $connection;
    }

    /**
     * @param $SQL
     *
     * @return \PDOStatement
     */
    private function prepareStatement($SQL)
    {
        return $this->wrappedConnection->prepare($SQL);
    }

    /**
     * @param string                    $SQL
     * @param QueryParameterInterface[] $parameters
     *
     * @return \PDOStatement
     */
    private function getExecutedStatement($SQL, array $parameters = [])
    {
        $preparedStmt = $this->prepareStatement($SQL);

        foreach ($parameters as $parameter) {
            $preparedStmt->bindValue($parameter->getName(), $parameter->getValue());
        }

        $preparedStmt->execute();

        return $preparedStmt;
    }

    /**
     * @inheritdoc
     */
    public function fetchScalar($SQL, array $parameters = [])
    {
        $stmt = $this->getExecutedStatement($SQL, $parameters);

        if (0 < $stmt->rowCount()) {
            return $stmt->fetch(\PDO::FETCH_COLUMN);
        }

        return null;
    }

    /**
     * @inheritdoc
     */
    public function fetchRow($SQL, array $parameters = [])
    {
        $stmt = $this->getExecutedStatement($SQL, $parameters);

        if (0 < $stmt->rowCount()) {
            return $stmt->fetch(\PDO::FETCH_ASSOC);
        }

        return [];
    }

    /**
     * @inheritdoc
     */
    public function fetchAll($SQL, array $parameters = [])
    {
        $stmt = $this->getExecutedStatement($SQL, $parameters);

        if (0 < $stmt->rowCount()) {
            return $stmt->fetchAll(\PDO::FETCH_ASSOC);
        }

        return [];
    }

    /**
     * @inheritdoc
     */
    public function rowCount($SQL, array $parameters = [])
    {
        $stmt = $this->getExecutedStatement($SQL, $parameters);

        return $stmt->rowCount() ?: 0;
    }
}