<?php
/**
 * System - PHP Framework
 *
 * PHP Version 5.6
 *
 * @copyright   2016 Ulf Gebhardt (http://www.webcraft-media.de)
 * @license     http://www.opensource.org/licenses/mit-license.php MIT
 * @link        https://github.com/webcraftmedia/system
 * @package     SYSTEM\DB
 */
namespace SYSTEM\DB;

/**
 * QQ Class provided by System to execute quick query statements.
 */
class QQ {
    /**
     * Executes stored action and return Database Object
     *
     * @param DBINFO $dbinfo Database Info or Null for Default DB
     * @return Result Returns Database Result Object
     */
    public static function QQ($dbinfo = null){
        if(!$dbinfo){
            $dbinfo = \SYSTEM\system::getSystemDBInfo();}
        $con = new \SYSTEM\DB\Connection($dbinfo);
        
        try{
            if($dbinfo instanceof \SYSTEM\DB\DBInfoPG){
                if(!\is_callable(static::get_class().'::pgsql')){
                    throw new \SYSTEM\LOG\ERROR(static::get_class().' failed: no pgsql implementation present.');}
                return $con->query(static::pgsql());
            } else if ($dbinfo instanceof \SYSTEM\DB\DBInfoMYS){
                if(!\is_callable(static::get_class().'::mysql')){
                    throw new \SYSTEM\LOG\ERROR(static::get_class().' failed: no mysql implementation present.');}
                return $con->query(static::mysql());
            } else if ($dbinfo instanceof \SYSTEM\DB\DBInfoAMQP){
                if(!\is_callable(static::get_class().'::amqp')){
                    throw new \SYSTEM\LOG\ERROR(static::get_class().' failed: no amqp implementation present.');}
                return $con->query(static::amqp());
            } else if ($dbinfo instanceof \SYSTEM\DB\DBInfoSQLite){
                if(!\is_callable(static::get_class().'::sqlite')){
                    throw new \SYSTEM\LOG\ERROR(static::get_class().' failed: no sqlite implementation present.');}
                return $con->query(static::sqlite());
            }
        } catch (\Exception $e){
            throw new \SYSTEM\LOG\ERROR(static::get_class().' failed causing: '.$e->getMessage(),$e->getCode(),$e);}
        
        throw new \Exception('Could not understand Database Settings. Check ur Database Settings');
    }
    
    /**
     * Executes stored action and return all Data found
     *
     * @param DBINFO $dbinfo Database Info or Null for Default DB
     * @return array Returns array with all lines of Database Query
     */
    public static function QA($dbinfo = null){
        $res = self::QQ($dbinfo);
        $result = array();
        while($row = $res->next()){
            $result[] = $row;}
        return $result;
    }
    
    /**
     * Executes stored action and return one line of Data found
     *
     * @param DBINFO $dbinfo Database Info or Null for Default DB
     * @return array Returns array with all field of one lines of the Database Query
     */
    public static function Q1($dbinfo = null){
        return self::QQ($dbinfo)->next();}
        
    /**
     * Executes stored action and return Database Result Object.
     * Use this function if the Result is either true or false (update/delete/insert)
     *
     * @param DBINFO $dbinfo Database Info or Null for Default DB
     * @return bool Returns true or false (or Result if used incorrectly)
     */
    public static function QI($return_id = false,$dbinfo = null){
        return self::QQ($dbinfo);} // returns boolean no id can be returned
}