Code Coverage |
||||||||||
Classes and Traits |
Functions and Methods |
Lines |
||||||||
| Total | |
0.00% |
0 / 1 |
|
87.50% |
7 / 8 |
CRAP | |
95.56% |
43 / 45 |
| sgbd_pdo_mysql | |
0.00% |
0 / 1 |
|
87.50% |
7 / 8 |
17 | |
95.56% |
43 / 45 |
| getInstance | |
100.00% |
1 / 1 |
1 | |
100.00% |
1 / 1 |
|||
| getListColumn | |
100.00% |
1 / 1 |
3 | |
100.00% |
8 / 8 |
|||
| getListTable | |
100.00% |
1 / 1 |
3 | |
100.00% |
8 / 8 |
|||
| getInsertFromTab | |
100.00% |
1 / 1 |
3 | |
100.00% |
10 / 10 |
|||
| getUpdateFromTab | |
100.00% |
1 / 1 |
3 | |
100.00% |
8 / 8 |
|||
| connect | |
0.00% |
0 / 1 |
2.06 | |
75.00% |
6 / 8 |
|||
| getLastInsertId | |
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_pdo_mysql extends abstract_sgbd_pdo{ | |
| public static function getInstance($sConfig){ | |
| return self::_getInstance(__CLASS__,$sConfig); | |
| } | |
| public function getListColumn($sTable){ | |
| $pRs=$this->query(sgbd_syntax_mysql::getListColumn($sTable)); | |
| $tObj=array(); | |
| if(empty($pRs)){ | |
| return null; | |
| } | |
| while($tRow=$pRs->fetch(PDO::FETCH_NUM)){ | |
| $tObj[]=$tRow[0]; | |
| } | |
| return $tObj; | |
| } | |
| public function getListTable(){ | |
| $pRs=$this->query(sgbd_syntax_mysql::getListTable()); | |
| if(empty($pRs)){ | |
| return null; | |
| } | |
| $tObj=array(); | |
| while($tRow=$pRs->fetch(PDO::FETCH_NUM)){ | |
| $tObj[]=$tRow[0]; | |
| } | |
| return $tObj; | |
| } | |
| public function getInsertFromTab($tProperty){ | |
| $sCols=''; | |
| $sVals=''; | |
| if($tProperty){ | |
| $tKey=array_keys($tProperty); | |
| foreach($tKey as $sVar){ | |
| $sCols.='`'.$sVar.'`,'; | |
| $sVals.='?,'; | |
| } | |
| } | |
| return '('.substr($sCols,0,-1).') VALUES ('.substr($sVals,0,-1).') '; | |
| } | |
| public function getUpdateFromTab($tProperty){ | |
| $sReq=''; | |
| if($tProperty){ | |
| $tKey=array_keys($tProperty); | |
| foreach($tKey as $sVar){ | |
| $sReq.='`'.$sVar.'`'.'=?,'; | |
| } | |
| } | |
| return substr($sReq,0,-1); | |
| } | |
| protected function connect(){ | |
| if(empty($this->_pDb)){ | |
| $this->_pDb=new PDO( | |
| $this->_tConfig[$this->_sConfig.'.dsn'], | |
| $this->_tConfig[$this->_sConfig.'.username'], | |
| $this->_tConfig[$this->_sConfig.'.password'] | |
| ); | |
| } | |
| } | |
| public function getLastInsertId(){ | |
| return $this->_pDb->lastInsertId(); | |
| } | |
| public function getWhereAll(){ | |
| return '1=1'; | |
| } | |
| } |