Code Coverage |
||||||||||
Classes and Traits |
Functions and Methods |
Lines |
||||||||
| Total | |
100.00% |
1 / 1 |
|
100.00% |
11 / 11 |
CRAP | |
100.00% |
55 / 55 |
| abstract_sgbd | |
100.00% |
1 / 1 |
|
100.00% |
11 / 11 |
23 | |
100.00% |
55 / 55 |
| _getInstance | |
100.00% |
1 / 1 |
2 | |
100.00% |
6 / 6 |
|||
| setClassRow | |
100.00% |
1 / 1 |
1 | |
100.00% |
2 / 2 |
|||
| chooseConfig | |
100.00% |
1 / 1 |
1 | |
100.00% |
2 / 2 |
|||
| setConfig | |
100.00% |
1 / 1 |
1 | |
100.00% |
2 / 2 |
|||
| getRequete | |
100.00% |
1 / 1 |
1 | |
100.00% |
1 / 1 |
|||
| bind | |
100.00% |
1 / 1 |
5 | |
100.00% |
15 / 15 |
|||
| getInsertFromTab | |
100.00% |
1 / 1 |
3 | |
100.00% |
9 / 9 |
|||
| getUpdateFromTab | |
100.00% |
1 / 1 |
3 | |
100.00% |
7 / 7 |
|||
| setId | |
100.00% |
1 / 1 |
1 | |
100.00% |
2 / 2 |
|||
| getWhereFromTab | |
100.00% |
1 / 1 |
4 | |
100.00% |
8 / 8 |
|||
| erreur | |
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/>. | |
| */ | |
| /** | |
| * classe abstract_sgbd | |
| * @author Mika | |
| * @link http://mkf.mkdevs.com/ | |
| */ | |
| abstract class abstract_sgbd{ | |
| protected $_tConfig; | |
| protected $_sConfig; | |
| protected $_sClassRow; | |
| protected $_pDb; | |
| protected $_sReq; | |
| protected $_tId; | |
| private static $_tInstance=array(); | |
| /** | |
| * @access public | |
| * @return une object | |
| */ | |
| protected static function _getInstance($class,$sConfig) { | |
| if ( !isset(self::$_tInstance[$class][$sConfig]) ){ | |
| $oSgbd = new $class(); | |
| $oSgbd->chooseConfig($sConfig); | |
| self::$_tInstance[$class][$sConfig]=$oSgbd; | |
| } | |
| return self::$_tInstance[$class][$sConfig]; | |
| } | |
| /** | |
| * force la classe row | |
| * @access public | |
| * @param string $sClassRow | |
| */ | |
| public function setClassRow($sClassRow){ | |
| $this->_sClassRow=$sClassRow; | |
| } | |
| /** | |
| * choisit le profile de connection | |
| * @param string $sConfig | |
| */ | |
| public function chooseConfig($sConfig){ | |
| $this->_sConfig=$sConfig; | |
| } | |
| /** | |
| * definir le tableau de connection | |
| * @param array $tConfig | |
| */ | |
| public function setConfig($tConfig){ | |
| $this->_tConfig=$tConfig; | |
| } | |
| /** | |
| * retourne la requete | |
| */ | |
| public function getRequete(){ | |
| return $this->_sReq; | |
| } | |
| /** | |
| * Fusionne la requete et ses parametres | |
| * @param array $tReq | |
| */ | |
| public function bind($tReq){ | |
| $sReq=''; | |
| if(is_array($tReq)){ | |
| $sReq=$tReq[0]; | |
| if(isset($tReq[1]) and is_array($tReq[1])){ | |
| $tParam=$tReq[1]; | |
| }else{ | |
| unset($tReq[0]); | |
| $tParam=array_values($tReq); | |
| } | |
| foreach($tParam as $sVal){ | |
| $sVal=$this->quote($sVal); | |
| $sReq=preg_replace('/[?]/',$sVal,$sReq,1); | |
| } | |
| }else{ | |
| return $tReq; | |
| } | |
| return $sReq; | |
| } | |
| public function getInsertFromTab($tProperty){ | |
| $sCols=''; | |
| $sVals=''; | |
| if($tProperty){ | |
| foreach($tProperty as $sVar => $sVal){ | |
| $sCols.=$sVar.','; | |
| $sVals.=$this->quote($sVal).','; | |
| } | |
| } | |
| return '('.substr($sCols,0,-1).') VALUES ('.substr($sVals,0,-1).') '; | |
| } | |
| public function getUpdateFromTab($tProperty){ | |
| $sReq=''; | |
| if($tProperty){ | |
| foreach($tProperty as $sVar => $sVal){ | |
| $sReq.=$sVar.'='.$this->quote($sVal).','; | |
| } | |
| } | |
| return substr($sReq,0,-1); | |
| } | |
| public function setId($tId){ | |
| $this->_tId=$tId; | |
| } | |
| public function getWhereFromTab($tId){ | |
| $sWhere=''; | |
| if(is_array($tId)){ | |
| foreach($tId as $sVar => $sVal){ | |
| if($sWhere!=''){ $sWhere.=' AND '; } | |
| $sWhere.=$sVar.'='.$this->quote($sVal); | |
| } | |
| } | |
| return $sWhere; | |
| } | |
| public function erreur($sErreur){ | |
| throw new Exception($sErreur); | |
| } | |
| } |