search

cashapp / sqldelight

SQLDelight - Generates typesafe Kotlin APIs from SQL
https://cashapp.github.io/sqldelight/
Apache License 2.0
6.02k stars 503 forks source link

Support ON CONFLICT in SQLite #5146

Open swankjesse opened 2 months ago

swankjesse commented 2 months ago

SQLDelight Version

2.0.1

SQLDelight Dialect

Android SDK 33

Describe the Bug

Fro the upsert docs, this syntax is valid:

CREATE TABLE vocabulary(word TEXT PRIMARY KEY, count INT DEFAULT 1);
INSERT INTO vocabulary(word) VALUES('jovial')
  ON CONFLICT(word) DO UPDATE SET count=count+1;

Stacktrace

No response

mahmed1987 commented 2 weeks ago

Any updates on this one ?