fetchRecords method

Implementation

Future<Map<String,dynamic>> fetchRecords({String condition = "",String fetchMode = "LIST",String limitCondition = ""}) async {
  Map<String,dynamic> result = {
    "status": "failure",
    "message": "nothing executed",
    "operation": "SELECT"
  };
  try {
    String query = "SELECT * FROM " + getSelectQuery();
    if (condition != "") {
      query += " WHERE $condition";
    }
    if (limitCondition != "") {
      query += " " + limitCondition;
    }
    Map<String,dynamic >response = await dbHandler.fetchQueryRecords(
        query: query, fetchMode: fetchMode, formatColumns: getFieldFormats());
    if (response.getString("status").equalsIgnoreCase("success")) {
      result["status"] = "success";
      result["message"] = "record(s) fetched successfully";
      result["records"] = response["records"];
    } else {
      result["message"] = response["message"];
    }
  } catch (ex, stack) {
    result["message"] = Simplify.getExceptionMessage(ex, stack: stack);
  }
  return result;
}