Support for Multiple ON CONFLICT columns in SQLite

reposilite-playground / exposed-upsert

Upsert DSL extension for Exposed, Kotlin SQL framework

The Unlicense

34 stars 3 forks source link

Support for Multiple ON CONFLICT columns in SQLite #2

Open ghost opened 3 years ago

ghost commented 3 years ago

Adding support for multiple ON CONFLICT columns would be greatly appreciated.

dzikoysk commented 3 years ago

Indexes with PostgreSQL should work fine, for SQLite I was not able to support this functionality. I don't know it it does not support this or I did something wrong 🤔

You can create index with multiple columns using withUnique:

https://github.com/reposilite-playground/exposed-upsert/blob/4ed9ec5d8088d432f0269eb74f1441c078621168/src/test/kotlin/net/dzikoysk/exposed/upsert/spec/StatisticsRepository.kt#L57