search

kysely-org / kysely

A type-safe typescript SQL query builder
https://kysely.dev
MIT License
9.82k stars 250 forks source link

SQLite's OR CONFLICT clause for inserts #976

Open vincentiusvin opened 2 months ago

vincentiusvin commented 2 months ago

Hello, I saw the good first issue tag and was interested in giving this a shot.

I implemented the orAbort, orFail, orIgnore, etc methods as discussed in #916, alongside making the SQLite override for ignore().

510 might be of interest too, since this effectively does what was asked there.

Adding support for update or X should be trivial, but I hope that you won't mind if I keep this PR's scope small.

Still got a few design related questions that you can find downstairs, so I'm drafting this.

Closes #916

vercel[bot] commented 2 months ago

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name Status Preview Comments Updated (UTC)
kysely ✅ Ready (Inspect) Visit Preview 💬 Add feedback May 4, 2024 3:56am
igalklebanov commented 2 months ago

Adding support for update or X should be trivial, but I hope that you won't mind if I keep this PR's scope small.

Good idea. Let's get insert or X out the door first.