selectBasic static method

Implementation

static Map<String,dynamic> selectBasic(SimpleWebRR webRR){
    Map<String,dynamic> result={"status":"failure","message":"nothing executed"};
    try{
        String fetchMode="LIST",limitCondition="";
        int fetchCountMode=0;
        if(webRR.hasRequest("fetch_mode")){
            fetchMode=webRR.requestString("fetch_mode").toUpperCase();
            if(fetchMode.equalsIgnoreCase("LIST_WITH_TOTAL_COUNT")){
                fetchMode="LIST";
                fetchCountMode=1;
            }
        }
        if(webRR.hasRequest("order_by")){
            limitCondition=" ORDER BY "+webRR.requestString("order_by");
        }
        if(!fetchMode.equalsIgnoreCase("COUNT")&&!fetchMode.equalsIgnoreCase("ALL")){
            int startIndex=1,recordCount=50;
            if(webRR.hasRequest("start_index")){
                startIndex=webRR.requestInt("start_index");
            }
            if(webRR.hasRequest("page")){
                startIndex=webRR.requestInt("page");
            }
            if(webRR.hasRequest("record_count")){
                recordCount=webRR.requestInt("record_count");
            }
            int offset=recordCount*(startIndex-1);
            limitCondition=limitCondition+" LIMIT "+offset.toString()+","+recordCount.toString();
            result["start_index"]=startIndex;
            result["record_count"]=recordCount;
        }
        if(fetchMode.equalsIgnoreCase("ALL")){
            fetchMode="LIST";
        }
        result["status"]="success";
        result["limit_condition"]=limitCondition;
        result["fetch_count_mode"]=fetchCountMode;
        result["fetch_mode"]=fetchMode;
    }
    catch (ex,stack) {
        result["message"]=Simplify.getExceptionMessage(ex,stack: stack);
    }
    return result;
}