executeActionQuery method

Implementation

Future<Map<String,dynamic>> executeActionQuery({required String query,required int action,List? values}) async{
  Map<String,dynamic> result = Simplify.getDefaultResult();
  try {
    Database? _db = await getConnectionObject();
    if(_db!=null){
      int actionResult=0;
      if(logQuery){
        _debug(query);
      }
      if(action==actionDelete){
        actionResult=await _db.rawDelete(query);
      }
      else if(action==actionInsert){
        actionResult=await _db.rawInsert(query,values);
        result["record_id"] = actionResult;
      }
      else if(action==actionUpdate){
        actionResult=await _db.rawUpdate(query,values);
      }
      result["message"] = "query executed successfully";
      result["query"] = query;
      result["records"] = actionResult;
      result["status"] = "success";
    }
  }
  catch(ex,stack){
    result["query"]=query;
    result["message"]=Simplify.getExceptionMessage(ex,stack: stack);
  }
  return result;
}