How to return deleted rows using jdbi?

Viewed 442

How do I return the deleted rows using jdbi? For example, I'd like to do something like this:

public List<User> deleteAndReturnUsers() {
  return jdbi.withHandle(handle -> {
    return handle.createQuery("DELETE FROM mytable where id = :id")
      .bind("id", "someid")
      .map(new UserMapper())
      .list();
  });
}
1 Answers
Related