Ivan Morgillo
Reputation: 3844
How can I do INSERT with SQLITE with ON CONFLICT REPLACE strategy?
I'm experimenting with Prisma, and I'm liking it so far. The only thing I can't figure out is how to specify a on conflict strategy.
I'm using Sqlite, but I can't find any documentation for Prisma to allow me to insert data with a more resilient strategy against duplicates.
How can apply IGNORE/REPLACE/etc. from the ON CONFLICT DOC?
Upvotes: 1
Views: 459
Answers (1)
Austin Crim
Reputation: 1277
Prisma doesn't have built-in support for ON CONFLICT. The upsert method might help here, otherwise, you can use $queryRaw.
Upvotes: 1
Related Questions
- How to get ON CONFLICT IGNORE working in sqlite
- Alternative to SQLite INSERT ... ON CONFLICT ... WHERE ... DO UPDATE SET
- How do I get "insert or update" behaviour without using CONFLICT_REPLACE?
- SQLiteException "cannot commit - no transaction is active" while inserting with CONFLICT_REPLACE
- SQLite INSERT OR REPLACE with condition
- Sqlite - smart insert or replace query
- How to On Conflict Replace with Condition (for SQLite)?
- SQLite Insert and Replace with condition
- SQLite INSERT OR REPLACE query
- SQLite conditional insert or replace