getQueryStringFromJsonMultipleList method

String getQueryStringFromJsonMultipleList({ required dynamic model, required dynamic multipleDataList, })

Implementation

String getQueryStringFromJsonMultipleList({required dynamic model, required dynamic multipleDataList}) {

  StringBuffer query = StringBuffer();
  query.write("INSERT INTO " + model.runtimeType.toString() + " (");

  Map<String, String> fieldNameList = model.getDataTypeMap();

  int i = 0;
  fieldNameList.forEach((field, type) {
    if (i == fieldNameList.length - 1) {
      query.write("$field ) VALUES ");
    } else {
      query.write("$field, ");
    }
    i++;
  });


  StringBuffer multipleValue = StringBuffer();


  for (int i = 0; i < multipleDataList!.length; i++) {
    // Loof for All Object

    StringBuffer totalValue = StringBuffer();
    for (int j = 0; j < multipleDataList[i]!.length; j++) {
      StringBuffer singleModelTotalValue = StringBuffer();
      singleModelTotalValue.write("(");

      final Map<String, dynamic> data = multipleDataList[i][j];

      String fieldValue = "";
      int k = 0;
      //Map for Single Object
      fieldNameList.forEach((fieldName, type) {
        try {
          //Map for Single Field
          data.forEach((key, value) {
            if (fieldName == key) {
              fieldValue = value.toString();
              throw 'Break Map'; // Stop iteration when the key is Matched
            }
          });
        } catch (e) {}

        fieldValue = fieldValue.replaceAll("'", "''");
        if (k == fieldNameList.length - 1) {
          singleModelTotalValue.write("'$fieldValue')");
        } else {
          singleModelTotalValue.write("'$fieldValue',");
        }

        k++;
      });
      //totalValue.write("$singleModelTotalValue,");
      if (j == multipleDataList[i]!.length - 1) {
        totalValue.write("$singleModelTotalValue");
      } else {
        totalValue.write("$singleModelTotalValue,");
      }
    }
   // debugPrint("totalValue : "+totalValue.toString() );
    if (i == multipleDataList!.length - 1) {
      multipleValue.write("$totalValue");
    } else {
      multipleValue.write("$totalValue,");
    }
  }

  query.write(multipleValue);

  return query.toString();
}