StefanoTree\NestedSet\Adapter\Pdo

Complexity

Total Complexity

14

Size/Duplication

Total Lines	101
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Test Coverage

Coverage

95.83%

Importance

Changes

0

12 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	5	1
A	getConnection()	0	4	1
A	getOptions()	0	4	1
A	beginTransaction()	0	5	1
A	commitTransaction()	0	5	1
A	rollbackTransaction()	0	5	1
A	isInTransaction()	0	5	1
A	quoteIdentifier()	0	4	1
A	executeSQL()	0	6	1
A	executeSelectSQL()	0	8	1
A	canHandleNestedTransaction()	0	4	1
A	executeInsertSQL()	0	19	3

<?php

declare(strict_types=1);

namespace StefanoTree\NestedSet\Adapter;

use StefanoTree\NestedSet\Options;

class Pdo implements AdapterInterface
{
    private $connection;
    private $options;

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

    /**
     * @return \PDO
     */
    private function getConnection(): \PDO
    {
        return $this->connection;
    }

    /**
     * @return Options
     */
    public function getOptions(): Options
    {
        return $this->options;
    }

    public function beginTransaction(): void
    {
        $this->getConnection()
             ->beginTransaction();
    }

    public function commitTransaction(): void
    {
        $this->getConnection()
             ->commit();
    }

    public function rollbackTransaction(): void
    {
        $this->getConnection()
             ->rollBack();
    }

    public function isInTransaction(): bool
    {
        return $this->getConnection()
                    ->inTransaction();
    }

    public function canHandleNestedTransaction(): bool
    {
        return false;
    }

    public function quoteIdentifier(string $columnName): string
    {
        return $columnName;
    }

    public function executeInsertSQL(string $sql, array $params = array())
    {
        $options = $this->getOptions();
        $this->executeSQL($sql, $params);

        if (array_key_exists($options->getIdColumnName(), $params)) {
            return $params[$options->getIdColumnName()];
        } else {
            if ('' != $options->getSequenceName()) {
                $lastGeneratedValue = $this->getConnection()
                                           ->lastInsertId($options->getSequenceName());
            } else {
                $lastGeneratedValue = $this->getConnection()
                                           ->lastInsertId();
            }

            return $lastGeneratedValue;
        }
    }

    public function executeSQL(string $sql, array $params = array()): void
    {
        $stm = $this->getConnection()
                    ->prepare($sql);
        $stm->execute($params);
    }

    public function executeSelectSQL(string $sql, array $params = array()): array
    {
        $stm = $this->getConnection()
                    ->prepare($sql);
        $stm->execute($params);

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