CODEWITHSUNDEEP
rubyrethinkdbrethinkdb-ruby
PJK
PJK

Reputation: 2112

RethinkDB multiple queries in a single request

I'm trying to execute several RQL commands in a single request to server, without much success I may add. I have tried r.union, but it only works with sequences. What I really want:

[r.db(..).table(..).get(id1).delete(),
 r.db(..).table(..).get(id2).delete(),
 r.db(..).table(..).insert(...)].run_all_at_once

Is there any way to do this?

Thanks!

Upvotes: 8

Views: 1731

Answers (2)

Jens
Jens

Reputation: 5877

You can also use do

r.do(
  r.table('test').insert({value1: "Hey"}),
  r.table('test').insert({value2: "Ho"})
).run(conn);
  • The queries are evaluated from last to first
  • The response will be the last query's result

Upvotes: 11

neumino
neumino

Reputation: 4353

You can do

r.expr( [r.db(...).table(...).get(id1).delete(), 
r.db(...).table(...).get(id1).delete(), 
r.db(...).table(...).insert(...) ] ).run(conn)

Note that the method delete doesn't get an argument.

Upvotes: 10

Related Questions