Code Coverage |
||||||||||
Classes and Traits |
Functions and Methods |
Lines |
||||||||
| Total | |
0.00% |
0 / 1 |
|
0.00% |
0 / 16 |
CRAP | |
0.00% |
0 / 89 |
| sgbd_oracle | |
0.00% |
0 / 1 |
|
0.00% |
0 / 16 |
812 | |
0.00% |
0 / 89 |
| getInstance | |
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 2 |
|||
| findMany | |
0.00% |
0 / 1 |
12 | |
0.00% |
0 / 11 |
|||
| findManySimple | |
0.00% |
0 / 1 |
12 | |
0.00% |
0 / 10 |
|||
| findOne | |
0.00% |
0 / 1 |
6 | |
0.00% |
0 / 8 |
|||
| findOneSimple | |
0.00% |
0 / 1 |
6 | |
0.00% |
0 / 7 |
|||
| execute | |
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 2 |
|||
| update | |
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 2 |
|||
| insert | |
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 2 |
|||
| delete | |
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 2 |
|||
| getListColumn | |
0.00% |
0 / 1 |
12 | |
0.00% |
0 / 10 |
|||
| getListTable | |
0.00% |
0 / 1 |
12 | |
0.00% |
0 / 10 |
|||
| connect | |
0.00% |
0 / 1 |
12 | |
0.00% |
0 / 11 |
|||
| getLastInsertId | |
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 2 |
|||
| query | |
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 6 |
|||
| quote | |
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 2 |
|||
| getWhereAll | |
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 2 |
|||
| <?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'; | |
| } | |
| } |