insertRecords method

Implementation

Future<Map<String,dynamic>> insertRecords(
    {required String table,
    required Map<String,dynamic >values,
    Map<String,dynamic> userDefinedFunctions = const{}}) async {
  Map<String,dynamic> result = Simplify.getDefaultResult();
  String query = "";
  try {
    List<dynamic> fieldValues = [];
    String valuesString = "", fieldsString = "";
    values.forEach((fieldName, fieldValue) {
      if (valuesString != "") {
        fieldsString += ",";
        valuesString += ",";
      }
      fieldsString += fieldName;
      valuesString += "?";
      fieldValues.add(fieldValue);
    });
    if (userDefinedFunctions != null) {
      userDefinedFunctions.forEach((fieldName, function) {
        if (valuesString != "") {
          fieldsString += ",";
          valuesString += ",";
        }
        fieldsString += fieldName;
        valuesString += function["field_value"];
      });
    }
    if (fieldsString != "") {
      fieldsString += ",";
      valuesString += ",";
    }
    fieldsString += "created_on,modified_on";
    valuesString += "date('now'),date('now')";
    query = "INSERT INTO " +
        table +
        "(" +
        fieldsString +
        ") VALUES(" +
        valuesString +
        ");";
    if (logQuery) {
      _debug(query);
    }
    result = await executeActionQuery(
        query: query, action: actionInsert, values: fieldValues);
  } catch (ex, stack) {
    result["query"] = query;
    result["message"] = Simplify.getExceptionMessage(ex, stack: stack);
  }
  return result;
}