Code Coverage
 
Classes and Traits
Functions and Methods
Lines
Total
100.00% covered (success)
100.00%
1 / 1
100.00% covered (success)
100.00%
5 / 5
CRAP
100.00% covered (success)
100.00%
5 / 5
sgbd_syntax_pgsql
100.00% covered (success)
100.00%
1 / 1
100.00% covered (success)
100.00%
5 / 5
5
100.00% covered (success)
100.00%
5 / 5
 getListColumn
100.00% covered (success)
100.00%
1 / 1
1
100.00% covered (success)
100.00%
1 / 1
 getStructure
100.00% covered (success)
100.00%
1 / 1
1
100.00% covered (success)
100.00%
1 / 1
 getListTable
100.00% covered (success)
100.00%
1 / 1
1
100.00% covered (success)
100.00%
1 / 1
 getLimit
100.00% covered (success)
100.00%
1 / 1
1
100.00% covered (success)
100.00%
1 / 1
 getLastInsertId
100.00% covered (success)
100.00%
1 / 1
1
100.00% covered (success)
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_syntax_pgsql{
    
    public static function getListColumn($sTable){
        return 'SELECT column_name FROM information_schema.columns WHERE table_name =\''.$sTable.'\'';
    }
    public static function getStructure($sTable){
        return 'SELECT column_name,data_type,is_identity FROM information_schema.columns WHERE table_name =\''.$sTable.'\'';
    }
    public static function getListTable(){
        return 'SELECT table_name FROM information_schema.tables WHERE table_schema = \'public\'';
    }
    public static function getLimit($sRequete,$iOffset,$iLimit){
        return $sRequete.' LIMIT '.$iOffset.' OFFSET '.$iLimit;
    }
    public static function getLastInsertId(){
        return 'SELECT lastval()';
    }
}