0

This is my table in rethinkDB

[{"username": "row1", "some_key": ["str1", "str2"]}, {"username": "row2", "some_key": ["str3", "blah"]}, {"username": "row3", "some_key": ["blah", "blahblah"]}]

The field(column) name can be repeated. I have a list ['row1', 'row2'].

I want to run query and get all the documents(rows) where name is present in the list

So far i have this:

r.db(self.PROJECT_DB).table(self.PROJECT_TABLE_PICWIZ).filter(r.row['username'] == name for name in following).limit(5).run(self.db_connection)

following is the list here.

But this returns all the documents(rows)

compiler
  • 486
  • 1
  • 4
  • 14

1 Answers1

0

Assuming this is Python. I think from what I'm understanding is that you want something like this, considering following is just a list: 

picwiz = r.db(self.PROJECT_DB).table(self.PROJECT_TABLE_PICWIZ)
picwiz.filter(lambda doc: r.expr(following).contains(doc['username']))\
  .limit(5)\
  .run(self.db_connection)

Here is what is happening:

This filter takes an anonymous function which takes your list of strings called following and then for every document in the table, checks if the username field is in that list via the contains method and returns True if yes, and False if no, adding or removing it from the final results.

It is probably also possible to replace the lambda function with the following for maybe something a bit more Pythonic and less ReQL-ish.

lambda doc: doc['username'] in following
dalanmiller
  • 3,467
  • 5
  • 31
  • 38
  • `rethinkdb.errors.ReqlServerCompileError: Cannot use r.row in nested queries. Use functions instead in: r.db('picwiz').table('activity').filter(lambda var_2: r.expr(['d4N73', 'di']).contains(lambda var_1: r.row['username'])).limit(5)` – compiler Apr 13 '16 at 23:03
  • it gives me this error, yes following is just a list, and this python, thanks for the reply :) – compiler Apr 13 '16 at 23:05
  • its kinda complicated from me to understand. – compiler Apr 13 '16 at 23:16
  • I'll edit my answer to explain a bit more what's happening. – dalanmiller Apr 13 '16 at 23:19
  • yeah, i understand it now, though the syntax is quite confusing to remember. thanks a lot bro. :) – compiler Apr 13 '16 at 23:33