davidmoten / davidmoten/rxjava-jdbc

Help: Example of returnGeneratedKeys within a transaction

Open
#57 11 comments 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.