fetchQueryRecords method

Implementation

Future<Map<String,dynamic>> fetchQueryRecords({String fetchMode="LIST",String query="",Map<String,List<String>> formatColumns=const {}}) async{
    Map<String,dynamic> result={"status":"failure","message":"nothing executed","operation":"SELECT"};
    try{
        if(query!=""){
            Map<String,dynamic >response=await dbHandler!.fetchQueryRecords(query: query,fetchMode: fetchMode,formatColumns: formatColumns);
            if(response.getString("status").equalsIgnoreCase("success")){
                result["status"]="success";
                result["message"]="record(s) fetched successfully";
                result["records"]=response["records"];
            }
            else{
                result["message"]=response["message"];
            }
        }
        else{
            result["message"]="not specified distinct field";
        }
    }
    catch(ex,stack){
        result["message"]=Simplify.getExceptionMessage(ex,stack: stack);
    }
    return result;
}