Code Coverage |
||||||||||
Classes and Traits |
Functions and Methods |
Lines |
||||||||
| Total | |
0.00% |
0 / 1 |
|
93.75% |
15 / 16 |
CRAP | |
98.39% |
61 / 62 |
| sgbd_mysql | |
0.00% |
0 / 1 |
|
93.75% |
15 / 16 |
24 | |
98.39% |
61 / 62 |
| getInstance | |
100.00% |
1 / 1 |
1 | |
100.00% |
1 / 1 |
|||
| findMany | |
100.00% |
1 / 1 |
2 | |
100.00% |
7 / 7 |
|||
| findManySimple | |
100.00% |
1 / 1 |
2 | |
100.00% |
6 / 6 |
|||
| findOne | |
100.00% |
1 / 1 |
1 | |
100.00% |
4 / 4 |
|||
| findOneSimple | |
100.00% |
1 / 1 |
1 | |
100.00% |
3 / 3 |
|||
| execute | |
100.00% |
1 / 1 |
1 | |
100.00% |
1 / 1 |
|||
| update | |
100.00% |
1 / 1 |
1 | |
100.00% |
2 / 2 |
|||
| insert | |
100.00% |
1 / 1 |
1 | |
100.00% |
2 / 2 |
|||
| delete | |
100.00% |
1 / 1 |
1 | |
100.00% |
2 / 2 |
|||
| getListColumn | |
100.00% |
1 / 1 |
3 | |
100.00% |
8 / 8 |
|||
| getListTable | |
100.00% |
1 / 1 |
2 | |
100.00% |
6 / 6 |
|||
| connect | |
0.00% |
0 / 1 |
4.01 | |
91.67% |
11 / 12 |
|||
| getLastInsertId | |
100.00% |
1 / 1 |
1 | |
100.00% |
3 / 3 |
|||
| query | |
100.00% |
1 / 1 |
1 | |
100.00% |
3 / 3 |
|||
| quote | |
100.00% |
1 / 1 |
1 | |
100.00% |
1 / 1 |
|||
| getWhereAll | |
100.00% |
1 / 1 |
1 | |
100.00% |
1 / 1 |
|||
| <?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_mysql extends abstract_sgbd{ | |
| public static function getInstance($sConfig){ | |
| return self::_getInstance(__CLASS__,$sConfig); | |
| } | |
| public function findMany($tSql,$sClassRow){ | |
| $pRs=$this->query($this->bind($tSql)); | |
| $tObj=array(); | |
| while($tRow=mysql_fetch_assoc($pRs)){ | |
| $oRow=new $sClassRow($tRow); | |
| $tObj[]=$oRow; | |
| } | |
| return $tObj; | |
| } | |
| public function findManySimple($tSql,$sClassRow){ | |
| $pRs=$this->query($this->bind($tSql)); | |
| $tObj=array(); | |
| while($oRow=mysql_fetch_object($pRs)){ | |
| $tObj[]=$oRow; | |
| } | |
| return $tObj; | |
| } | |
| public function findOne($tSql,$sClassRow){ | |
| $pRs=$this->query($this->bind($tSql)); | |
| $tRow=mysql_fetch_assoc($pRs); | |
| $oRow=new $sClassRow($tRow); | |
| return $oRow; | |
| } | |
| public function findOneSimple($tSql,$sClassRow){ | |
| $pRs=$this->query($this->bind($tSql)); | |
| $oRow=mysql_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_mysql::getListColumn($sTable)); | |
| $tCol=array(); | |
| if(empty($pRs)){ | |
| return $tCol; | |
| } | |
| while($tRow=mysql_fetch_row($pRs)){ | |
| $tCol[]=$tRow[0]; | |
| } | |
| return $tCol; | |
| } | |
| public function getListTable(){ | |
| $pRs=$this->query(sgbd_syntax_mysql::getListTable()); | |
| $tCol=array(); | |
| while($tRow=mysql_fetch_row($pRs)){ | |
| $tCol[]=$tRow[0]; | |
| } | |
| return $tCol; | |
| } | |
| private function connect(){ | |
| if(empty($this->_pDb)){ | |
| if( ($this->_pDb=mysql_connect( | |
| $this->_tConfig[$this->_sConfig.'.hostname'], | |
| $this->_tConfig[$this->_sConfig.'.username'], | |
| $this->_tConfig[$this->_sConfig.'.password'] | |
| ))==false ){ | |
| throw new Exception('Probleme connexion sql : '.mysql_error()); | |
| } | |
| if( mysql_select_db($this->_tConfig[$this->_sConfig.'.database'],$this->_pDb) ==false){ | |
| $sMsg='Probleme selection de la base : '.$this->_tConfig[$this->_sConfig.'.database'].' '.mysql_error(); | |
| throw new Exception($sMsg); | |
| } | |
| } | |
| } | |
| public function getLastInsertId(){ | |
| $pRs=$this->query(sgbd_syntax_mysql::getLastInsertId()); | |
| $tRow=mysql_fetch_row($pRs); | |
| return (int)$tRow[0]; | |
| } | |
| private function query($sReq){ | |
| $this->connect(); | |
| $this->sReq=$sReq; | |
| return mysql_query($sReq); | |
| } | |
| public function quote($sVal){ | |
| return str_replace("\\",'', str_replace("'",'\'',"'".$sVal."'")); | |
| } | |
| public function getWhereAll(){ | |
| return '1=1'; | |
| } | |
| } |