<?php
class DriverORACLE extends PDO {
    private $host;
    private $user;
    private $pass;
    private $dbname;

    function __construct($host = 'localhost', $user = 'tusupertienda', $pass  = '123', $dbname  = 'tusupertienda') {
        $this->host = $host;
        $this->user = $user;
        $this->pass = $pass;
        $this->dbname = $dbname;
        try{
            parent::__construct("oci:dbname=//$this->host:1521/xe", $this->user, $this->pass);
            parent::setAttribute(PDO:: ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        } catch (Exception $ex) {
            die('Error de conexion: '.$ex->getMessage());
        }
    }

    public function processQuery($query){
        try {
            $driver = new DriverORACLE();
            $object = $driver->query($query);

            return $object;
        } catch (Exception $ex) {
            echo $ex->getTraceAsString();
        }
    }

    public function insertQuery($query){
        try {
            $driver = new DriverORACLE();
            echo $query;
            $result = $driver->exec($query);

            return $result;
        } catch (Exception $ex) {
            echo $ex->getMessage();
        }
    }

    public function getSingleColumnFromConsult(PDOStatement $result){
        try{
            $result->setFetchMode(parent::FETCH_ASSOC);
            return $result->fetch();
        } catch (Exception $ex) {
            echo $ex->getTraceAsString();
        }
    }

    public function getArrayFromConsult(PDOStatement $result){
        try {
            if (isset($result)) {
                if($result != false){
                    $result->setFetchMode(parent::FETCH_ASSOC);
                    return $result->fetchAll();
                }else{
                    throw new Exception("Busqueda sin resultado");
                }
            }else{
                throw new Exception("Error desconocido");
            }
        } catch (Exception $ex) {
            echo $ex->getMessage();
        }
    }
}