rql get multiple documents from list of keys rethinkdb in javascript

Question

I have a table of "person" data, which has a unique key "id". I have a list of id's that I want to get the data for which I'll be sending as a JSON array from the client to the server. The serve recieves that data as a JSON array.

Now is there a way to run a query that will get the documents for each of those ids?

Or is my only option to parse the ids myself and build an array of results, then send that array back.

So far I've tried using...

getAll - but I cannot get this to work because it accepts a dynamic amount of parameters, and I don't know how to change my array of values into a dynamic amount of parameters.

(example... I want to be able to do whats shown below, but I can't)
```
r.db('vp').table('user').getAll(["0", "0", "99"])
```
I can only do this...
```
r.db('vp').table('user').getAll("0", "0", "99")
```

expr and forEach - as seen below, but I don't think this can work.

var arr = [];
r.expr(["0", "0", "99"]).forEach(function(id) {

})

neumino · Answer 1 · 2014-09-04T07:20:53.203

19

You can also use getAll with a dynamic array. You have to resort to apply

var ids = [1,2,3];
var table = r.table("person");
table.getAll.apply(table, ids).run( connection, callback);

Note that now since 1.12, you can just do

var ids = [1,2,3];
r.table("person").getAll(r.args(ids)).run(connection, callback)

edited Sep 04 '14 at 07:20

answered Dec 04 '13 at 03:33

neumino

4,342
1
18
17

this doesn't work for me... If you could edit it to make it work I would be interested in the soultion. – CamHart Dec 04 '13 at 22:18
Sorry, typo, the first argument to apply is `table`, not `getAll`. – neumino Dec 04 '13 at 23:33
Can you think of a way to get the result ordered the same way as the IDs? – Juan Campa Jan 21 '16 at 07:19
Are you able to do `.getAll(r.args(ids), {index:'x'})`? – rclai Mar 17 '16 at 21:07
Yes, you can do `.getAll(r.args(ids), {index:'x'})` – neumino Mar 19 '16 at 02:24

score 7 · Accepted Answer · answered Dec 03 '13 at 11:01

short answer:

r.expr([id1, id2, id3]).eqJoin(function(doc) { return doc; }, r.table("person"))

Longer answer:

There are a couple of ways to do this. The above is what I'd call the canonical way. Let's breakdown what's happening:

First with r.expr([id1, id2, id3]) we're packaging up the array to send it over to the server.

Then we call eqJoin what it does is take a stream of values and dispatch and indexed get for each one. The function(doc) { return doc; } is a slightly ugly hack because eqJoin requires a mapping function.

So in the end the above code becomes equivalent to:

[r.table("person").get(id1), r.table("person").get(id2), r.table("person).get(id3)]

score 4 · Answer 3 · answered May 05 '17 at 15:41

4

Update for 2017. Use the ES6 spread operator '...'

r.db('vp').table('user').getAll(...["0", "0", "99"])

answered May 05 '17 at 15:41

Visualize

590
5
12

score 0 · Answer 4 · answered Jun 30 '17 at 00:28

0

You can use .expr with .map for a cleaner alternative to .eqJoin

r.expr(array).map(function(id) {
  return r.table('user').get(id);
});

answered Jun 30 '17 at 00:28

aleclarson

18,087
14
64
91

rql get multiple documents from list of keys rethinkdb in javascript

4 Answers4

Linked