How do I upsert in sqlite using diesel?

Question

I am migrating rust application from Postgres to Sqlite. But I've got an issue with upsert

Following code

diesel::insert_into(dialogs_table)
            .values(dialog)
            .on_conflict(user_id_column)

gives me this:

error[E0599]: no method named `on_conflict` found for struct InsertStatement in the current scope

I find this strange because it was working for Postgres. What could be the possible solution to use upsert here?

Answer 1

What could be the possible solution to use upsert here?

Support for sqlite upserts was merged in early 2020 (after a very long and rather gruelling PR process), but it apparently includes breaking changes so my understanding's it'll only be available in Diesel 2.0.

Therefore your possibly solutions are:

1. don't use upserts

2. perform your query by hand

3. use git diesel