How can I add ON DUPLICATE KEY UPDATE to my query?

[cozyGalvinism]

I'm currently adding it via regex, but there's got to be a way with SqlKata, right?

[ahmad-moussawi]

@TeamGameRevolution could you please post the full query, and how you are handling it right now ?

[cozyGalvinism]

Had to switch away from regex because of some reasons.

datensaetze is a Dictionary<string, dynamic>

                    var query = new Query(quelle.Tabelle).AsInsert(datensaetze);
                    var compiler = new MySqlCompiler();
                    var qStr = compiler.Compile(query).Sql + " ON DUPLICATE KEY UPDATE " + string.Join(",", datensaetze.Select(d => $"{d.Key} = {(d.Value is string ? $"'{MySqlHelper.EscapeString(d.Value)}'" : d.Value)}"));

EDIT: Based on this: https://dev.mysql.com/doc/refman/5.7/en/insert-on-duplicate.html

[ahmad-moussawi]

closing, you can follow this feature on #103