RethinkDB - how to filter arrays in nested objects when updating?

Question

With RethinkDB, how do I update arrays in nested objects so that certain values are filtered out?

Consider the following program, I would like to know how to write an update query that filters out the value 2 from arrays contained in votes sub objects in documents from the 'dinners' table:

import rethinkdb as r
from pprint import pprint


with r.connect(db='mydb') as conn:
    pprint(r.table('dinners').get('xxx').run(conn))
    r.table('dinners').insert({
        'id': 'xxx',
        'votes': {
            '1': [1, 2, ],
        },
    }, conflict='replace').run(conn)

# How can I update the 'xxx' document so that the value 2 is
# filtered out from all arrays contained in the 'votes' sub object?

aknuds1 · Accepted Answer · 2017-03-29 15:47:35Z

3

You can use the usual filter method together with object coersion:

def update_dinner(dinner):
    return {
        'votes': dinner['votes']
        .keys()
        .map(lambda key: [
            key,
            dinner['votes'][key].filter(lambda vote_val: vote_val.ne(2)),
       ])
        .coerce_to('object')
    }

r.table('dinners').update(update_dinner).run(conn)

edited Mar 29, 2017 at 15:47

aknuds1

68.5k69 gold badges211 silver badges321 bronze badges

answered Mar 28, 2017 at 12:12

RonZ

4673 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

RethinkDB - how to filter arrays in nested objects when updating?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related