executeActionQuery method

Implementation

Future<Map<String,dynamic>> executeActionQuery(
    {required String query, required int action, List? values}) async {
  Map<String,dynamic> result = Simplify.getDefaultResult();
  try {
    if (mySqlConnection != null) {
      int actionResult = 0;
      if (logQuery) {
        //  _debug(query);
      }
      if (action == actionDelete) {
        var data = await mySqlConnection?.query(query);
        actionResult = data?.affectedRows ?? 0;
      } else if (action == actionInsert) {
        var data = await mySqlConnection?.query(query);
        actionResult = data?.affectedRows ?? 0;
        result["record_id"] = actionResult;
      } else if (action == actionUpdate) {
        var data = await mySqlConnection?.query(query);
        actionResult = data?.affectedRows ?? 0;
      }
      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;
}