mquery.class

Ir para a documentação deste ficheiro.

<?php
class Oracle8Query extends MQuery
{
    function __construct()
    {
        parent::__construct();
    }
 
    function _querystmt($stmt)
    {
        $this->statement = $stmt;
        $this->fetched = true;
        $exec = oci_execute($this->statement);
 
        if (!$exec)
            throw new EDatabaseQueryException($this->_error());
 
        $this->rowCount = oci_fetch_all($this->statement, $this->result, $this->offset, $this->maxrows,
                                        OCI_NUM + OCI_FETCHSTATEMENT_BY_ROW);
 
        if ($this->rowCount === false)
            throw new EDatabaseQueryException($this->_error());
 
        $this->colCount = ocinumcols($this->statement);
    }
 
    function _query()
    {
        $stmt = oci_parse($this->conn->id, $this->sql);
 
        if (!$stmt)
            throw new EDatabaseQueryException();
 
        $this->_querystmt($stmt);
    }
 
    function _error()
    {
        $err = oci_error($this->statement);
        return ($err ? $err['message'] : false);
    }
 
    function _close()
    {
        ocifreestatement ($this->statement);
    }
 
    function _setmetadata()
    {
        $numCols = $this->colCount;
        $this->metadata = array
            (
            );
 
        for ($i = 0; $i < $numCols; $i++)
        {
            $name = strtoupper(OCIColumnName($this->statement, $i + 1));
            $this->metadata['fieldname'][$i] = $name;
            $this->metadata['fieldtype'][$name] = $this->_getmetatype(OCIColumnType($this->statement, $i + 1));
            $this->metadata['fieldlength'][$name] = OCIColumnSize($this->statement, $i + 1);
            $this->metadata['fieldpos'][$name] = $i;
        }
    }
 
    function _getmetatype($type)
    {
        $rType = 'N';
 
        if ($type == "VARCHAR")
        {
            $rType = 'C';
        }
        elseif ($type == "CHAR")
        {
            $rType = 'C';
        }
        elseif ($type == "NUMBER")
        {
            $rType = 'N';
        }
        elseif ($type == "DATE")
        {
            $rType = 'T';
        }
 
        return $rType;
    }
}
?>