SQLDBResult.php

<?php

namespace MaxieSystems\DBAL;

class SQLDBResult extends DB\Result
{
    public function __construct(\PDOStatement $sth, ?array $params = null)
    {
        $this->sth = $sth;
        if ($params) {
            parent::__construct($params);
        }
    }

    public function __destruct()
    {
        $this->close();
    }

    final public function setFetchMode(int $mode, ...$args): DB\Result
    {
        if ($this->constructed()) {
            throw new \Exception('Fetch mode can not be set after fetching data from DB.');
        }
        $this->sth->setFetchMode($mode, ...$args);
        return $this;
    }

    final public function getQueryString(): string
    {
        if (null === $this->query_string) {
            $this->query_string = $this->sth->queryString;
        }
        return $this->query_string;
    }

    final protected function open(): void
    {
        if ($p = $this->getParams()) {
            SQLDB::bindValues($this->sth, $p);
        }
        $this->sth->execute();
        parent::open();
    }

    final protected function close(): void
    {
        $this->query_string = $this->sth->queryString;
        $this->sth->closeCursor();
        parent::close();
    }

    final protected function fetchRow()
    {
        return $this->sth->fetch();
    }

    private $sth;
    private $query_string = null;
}