Spiral\Database\Entities\Query\PDOResult

Complexity

Total Complexity

10

Size/Duplication

Total Lines	101
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Importance

Changes

0

8 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	bind()	0	11	2
A	countColumns()	0	4	1
A	queryString()	0	4	1
A	count()	0	4	1
A	close()	0	4	1
A	__debugInfo()	0	8	2
A	toArray()	0	4	1

<?php
/**
 * Spiral Framework.
 *
 * @license   MIT
 * @author    Anton Titov (Wolfy-J)
 */

namespace Spiral\Database\Entities\Query;

use PDOStatement;
use Spiral\Database\Helpers\QueryInterpolator;

/**
 * Works as prepared PDOStatement.
 */
class PDOResult extends PDOStatement
{
    /**
     * Limits after which no records will be dumped in __debugInfo.
     */
    const DUMP_LIMIT = 500;

    /**
     * @var array
     */
    private $parameters = [];

    /**
     * @param array $parameters
     */
    protected function __construct(array $parameters)
    {
        $this->parameters = $parameters;
    }

    /**
     * Bind a column value to a PHP variable. Aliased to bindParam.
     *
     * @param int|string $columnID Column number (0 - first column)
     * @param mixed      $variable
     *
     * @return self|$this
     */
    public function bind($columnID, &$variable): PDOResult
    {
        if (is_numeric($columnID)) {
            //PDO columns are 1-indexed
            $columnID = $columnID + 1;
        }

        $this->bindColumn($columnID, $variable);

        return $this;
    }

    /**
     * Just an alias.
     *
     * @return int
     */
    public function countColumns(): int
    {
        return $this->columnCount();
    }

    /**
     * {@inheritdoc}
     */
    public function queryString(): string
    {
        return QueryInterpolator::interpolate($this->queryString, $this->parameters);
    }

    /**
     * {@inheritdoc}
     *
     * Attention, this method will return 0 for SQLite databases.
     *
     * @link http://php.net/manual/en/pdostatement.rowcount.php
     * @link http://stackoverflow.com/questions/15003232/pdo-returns-wrong-rowcount-after-select-statement
     *
     * @return int
     */
    public function count(): int
    {
        return $this->rowCount();
    }

    /**
     * {@inheritdoc}
     */
    public function close()
    {
        $this->closeCursor();
    }

    /**
     * @return array
     */
    public function toArray(): array
    {
        return $this->fetchAll(\PDO::FETCH_ASSOC);
    }

    /**
     * @return array
     */
    public function __debugInfo()
    {
        return [
            'query' => $this->queryString(),
            'count' => $this->count(),
            'rows'  => $this->count() > static::DUMP_LIMIT ? '[TOO MANY ROWS]' : $this->fetchAll(\PDO::FETCH_ASSOC)
        ];
    }
}