Lagdo\DbAdmin\Driver\Sqlite\Db\Sqlite\Statement

Complexity

Total Complexity

7

Size/Duplication

Total Lines	74
Duplicated Lines	0 %

Importance

Changes	2
Bugs	0	Features	0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	3	1
A	fetchField()	0	6	1
A	fetchAssoc()	0	3	1
A	fetchRow()	0	3	1
A	rowCount()	0	10	2
A	__destruct()	0	3	1

<?php

namespace Lagdo\DbAdmin\Driver\Sqlite\Db\Sqlite;

use Lagdo\DbAdmin\Driver\Db\StatementInterface;
use Lagdo\DbAdmin\Driver\Entity\StatementFieldEntity;

use SQLite3Result;

class Statement implements StatementInterface
{
    /**
     * The query result
     *
     * @var SQLite3Result
     */
    protected $result = null;

    /**
     * Undocumented variable
     *
     * @var int
     */
    protected $offset = 0;

    /**
     * The constructor
     *
     * @param SQLite3Result $result
     */
    public function __construct(SQLite3Result $result)
    {
        $this->result = $result;
    }

    /**
     * @inheritDoc
     */
    public function rowCount()
    {
        // Todo: find a simpler way to count the rows.
        $rowCount = 0;
        $this->result->reset();
        while ($this->result->fetchArray()) {
            $rowCount++;
        }
        $this->result->reset();
        return $rowCount;
    }

    /**
     * @inheritDoc
     */
    public function fetchAssoc()
    {
        return $this->result->fetchArray(SQLITE3_ASSOC);
    }

    /**
     * @inheritDoc
     */
    public function fetchRow()
    {
        return $this->result->fetchArray(SQLITE3_NUM);
    }

    /**
     * @inheritDoc
     */
    public function fetchField()
    {
        $column = $this->offset++;
        $type = $this->result->columnType($column);
        $name = $this->result->columnName($column);
        return new StatementFieldEntity($type, $type === SQLITE3_BLOB, $name, $name);
    }

    /**
     * The destructor
     */
    public function __destruct()
    {
        $this->result->finalize();
    }
}