<?php
/*
This file is part of Mkframework.

Mkframework is free software: you can redistribute it and/or modify
it under the terms of the GNU Lesser General Public License as published by
the Free Software Foundation, either version 3 of the License.

Mkframework is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU Lesser General Public License for more details.

You should have received a copy of the GNU Lesser General Public License
along with Mkframework.  If not, see <http://www.gnu.org/licenses/>.

*/
class sgbd_oracle extends abstract_sgbd{

	public static function getInstance($sConfig){
		return self::_getInstance(__CLASS__,$sConfig);
	}

	public function findMany($tSql,$sClassRow){
		$pRs=$this->query($this->bind($tSql));

		if(empty($pRs)){
			return null;
		}

		$tObj=array();
		while($tRow=oci_fetch_assoc($pRs)){
			$oRow=new $sClassRow($tRow);
			$tObj[]=$oRow;
		}
		return $tObj;
	}
	public function findManySimple($tSql,$sClassRow){
		$pRs=$this->query($this->bind($tSql));

		if(empty($pRs)){
			return null;
		}

		$tObj=array();
		while($oRow=oci_fetch_object($pRs)){
			$tObj[]=$oRow;
		}
		return $tObj;
	}
	public function findOne($tSql,$sClassRow){
		$pRs=$this->query($this->bind($tSql));

		if(empty($pRs)){
			return null;
		}

		$tRow=oci_fetch_assoc($pRs);
		$oRow=new $sClassRow($tRow);

		return $oRow;
	}
	public function findOneSimple($tSql,$sClassRow){
		$pRs=$this->query($this->bind($tSql));

		if(empty($pRs)){
			return null;
		}

		$oRow=oci_fetch_object($pRs);

		return $oRow;
	}
	public function execute($tSql){
		return $this->query($this->bind($tSql));
	}

	public function update($sTable,$tProperty,$twhere){
		$this->query('UPDATE '.$sTable.' SET '.$this->getUpdateFromTab($tProperty).' WHERE '.$this->getWhereFromTab($twhere));
	}
	public function insert($sTable,$tProperty){
		$this->query('INSERT INTO '.$sTable.' '.$this->getInsertFromTab($tProperty));
	}

	public function delete($sTable,$twhere){
		$this->query('DELETE FROM '.$sTable.' WHERE '.$this->getWhereFromTab($twhere));
	}

	public function getListColumn($sTable){
		$pRs=$this->query(sgbd_syntax_oracle::getListColumn($sTable));
		$tCol=array();

		if(empty($pRs)){
			return $tCol;
		}

		while($tRow=oci_fetch_row($pRs)){
			$tCol[]=$tRow[0];
		}

		return $tCol;
	}
	public function getListTable(){
		$pRs=$this->query(sgbd_syntax_oracle::getListTable());
		$tCol=array();

		if(empty($pRs)){
			return $tCol;
		}

		while($tRow=oci_fetch_row($pRs)){
			$tCol[]=$tRow[0];
		}
		return $tCol;
	}

	private function connect(){
		if(empty($this->_pDb)){
			if( ($this->_pDb=oci_connect(

					$this->_tConfig[$this->_sConfig.'.username'],
					$this->_tConfig[$this->_sConfig.'.password'],
					$this->_tConfig[$this->_sConfig.'.hostname'].'/'.$this->_tConfig[$this->_sConfig.'.database']
			))==false ){
				$e = oci_error();
				throw new Exception('Probleme connexion sql : '.$e['message']);
			}


		}
	}
	public function getLastInsertId(){
		return null;
	}

	private function query($sReq){
		$this->connect();
		$this->sReq=$sReq;
		// return oci_parse($this->_pDb,$sReq);

		 $query = oci_parse($this->_pDb,$sReq);
		 oci_execute($query);
	    return $query;

	}
	public function quote($sVal){
		return str_replace("\\",'', str_replace("'",'\'',"'".$sVal."'"));
	}
	public function getWhereAll(){
		return '1=1';
	}


}