Crossjoin\Browscap\Parser\Sqlite\Adapter\Sqlite3PreparedStatement

Complexity

Total Complexity

7

Size/Duplication

Total Lines	54
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	0

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	getStatement()	0	4	1
A	setStatement()	0	4	1
A	execute()	0	15	4

<?php
declare(strict_types=1);

namespace Crossjoin\Browscap\Parser\Sqlite\Adapter;

/**
 * Class Sqlite3PreparedStatement
 *
 * @package Crossjoin\Browscap\Parser\Sqlite\Adapter
 * @author Christoph Ziegenberg <ziegenberg@crossjoin.com>
 * @link https://github.com/crossjoin/browscap
 */
class Sqlite3PreparedStatement implements PreparedStatementInterface
{
    /**
     * @var \SQLite3Stmt
     */
    protected $statement;

    /**
     * Sqlite3PreparedStatement constructor.
     *
     * @param \SQLite3Stmt $statement
     */
    public function __construct(\SQLite3Stmt $statement)
    {
        $this->setStatement($statement);
    }

    /**
     * @return \SQLite3Stmt
     */
    protected function getStatement() : \SQLite3Stmt
    {
        return $this->statement;
    }

    /**
     * @param \SQLite3Stmt $statement
     */
    protected function setStatement(\SQLite3Stmt $statement)
    {
        $this->statement = $statement;
    }

    /**
     * @param array $params
     *
     * @return array
     */
    public function execute(array $params = []) : array
    {
        foreach ($params as $paramName => $paramValue) {
            $type = is_int($paramValue) ? \SQLITE3_INTEGER : \SQLITE3_TEXT;
            $this->getStatement()->bindValue($paramName, $paramValue, $type);
        }
        $result = $this->getStatement()->execute();

        $results = [];
        while ($row = $result->fetchArray(\SQLITE3_ASSOC)) {
            $results[] = $row;
        }

        return $results;
    }
}