davidmoten / davidmoten/rxjava-jdbc
Help: Example of returnGeneratedKeys within a transaction
Open
- Dominant language
- Java
- Stars
- 801
- Forks
- 114
- Avg merge
- 1m
- Merged PRs (30d)
- 3
Description
Hello,
I'm trying to chain two queries, an `insert` followed by a `select` using the generated id of the first query as a parameter of the second query.
Can you provide an example to achieve that ? Thank you.
Here is my code so far :
``` java
Observable begin = db.beginTransaction();
Observable query = db.update("insert into users...").dependsOn(begin).parameters(...).returnGeneratedKeys().getAs(Long.class).first();
Observable commit = db.commit(query);
db.select("select from users where id = ?").dependsOn(commit).getAs(String.class);
```
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.