fetchQueryRecords method

Future<Map<String, dynamic>> fetchQueryRecords({
  1. String fetchMode = "LIST",
  2. String query = "",
  3. Map<String, List<String>> formatColumns = const {},
})

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;
}