JetBrains / JetBrains/Exposed

Support of batch update

Open
#943 3 comments 3 reactions 0 assignees View on GitHub
enhancement
Dominant language
Kotlin
Stars
9.3k
Forks
798
Avg merge
4d 2h
Merged PRs (30d)
26

Description

Is there any way to update multiple records in just one batched query with the library? I know that you can do this with raw SQL in PostgreSQL easily:
```
update tmp set age = data_table.age
from
(select unnest(array['keith', 'leslie', 'bexley', 'casey']) as name,
unnest(array[44, 50, 10, 12]) as age) as data_table
where tmp.name = data_table.name;
```
But can we do the same thing(or similar) using the library with less effort?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.