PDODbAdapter::executeParameterisedQuery() - Code Metrics - Agares/MicroORM - Measure and Improve Code Quality continuously with Scrutinizer

PDODbAdapter::executeParameterisedQuery() A
last analyzed 2017-03-12 15:41 UTC

↳ Parent: PDODbAdapter

Complexity

Conditions	2
Paths	2

Size

Total Lines	12
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	12
rs	9.4285
c	0
b	0
f	0
cc	2
eloc	6
nc	2
nop	2

<?php
declare(strict_types = 1);

namespace Agares\MicroORM;

final class PDODbAdapter implements DatabaseAdapterInterface
{
    /** @var \PDO */
    private $pdo;

    public function __construct(\PDO $pdo)
    {
        $this->pdo = $pdo;
        $this->pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
    }

    /**
     * {@inheritdoc}
    */
    public function executeCommand(string $command, array $parameters = array())
    {
        $this->executeParameterisedQuery($command, $parameters);
    }

    /**
     * {@inheritdoc}
     */
    public function executeQuery(string $query, array $parameters = array()) : array
    {
        $statement = $this->executeParameterisedQuery($query, $parameters);

        return $statement->fetchAll(\PDO::FETCH_ASSOC);
    }

    private function executeParameterisedQuery($query, array $parameters) : \PDOStatement
    {
        $statement = $this->pdo->prepare($query);

        foreach ($parameters as $name => $value) {
            $statement->bindValue($name, $value);
        }

        $statement->execute();

        return $statement;
    }
}

1			<?php
2			declare(strict_types = 1);
3
4			namespace Agares\MicroORM;
5
6			final class PDODbAdapter implements DatabaseAdapterInterface
7			{
8			/** @var \PDO */
9			private $pdo;
10
11			public function __construct(\PDO $pdo)
12			{
13			$this->pdo = $pdo;
14			$this->pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
15			}
16
17			/**
18			* {@inheritdoc}
19			*/
20			public function executeCommand(string $command, array $parameters = array())
21			{
22			$this->executeParameterisedQuery($command, $parameters);
23			}
24
25			/**
26			* {@inheritdoc}
27			*/
28			public function executeQuery(string $query, array $parameters = array()) : array
29			{
30			$statement = $this->executeParameterisedQuery($query, $parameters);
31
32			return $statement->fetchAll(\PDO::FETCH_ASSOC);
33			}
34
35			private function executeParameterisedQuery($query, array $parameters) : \PDOStatement
36			{
37			$statement = $this->pdo->prepare($query);
38
39			foreach ($parameters as $name => $value) {
40			$statement->bindValue($name, $value);
41			}
42
43			$statement->execute();
44
45			return $statement;
46			}
47			}

Agares / MicroORM

PDODbAdapter::executeParameterisedQuery() A last analyzed 2017-03-12 15:41 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

PDODbAdapter::executeParameterisedQuery() A
last analyzed 2017-03-12 15:41 UTC