RethinkDB update and replace-without in one line

Question

Can anyone think if an elegant way to do update and replace in one line?

I want to use the r.row.without to remove fields and update at the same query.

Something like:

r.db('db').table('table').get('item_id')
          .update({ field_a:'value_a'})
          .replace(r.row.without(r.args(['field_b'])))`

simply chaining would be nice but this won't work (update returns a change result).

score 3 · Answer 1 · answered Apr 12 '16 at 19:57

3

You can also write .update({field_a: 'value_a', field_b: r.literal()}) to change one field and remove another field at the same time.

answered Apr 12 '16 at 19:57

mlucy

5,249
1
17
21

thanks @mlucy, thats great to know, although I think the previous is more declarative ! – Sagivf Apr 17 '16 at 15:29
This answer is easier/readable/straight-forward than the currently selected correct answer – evilReiko Mar 15 '17 at 09:34

score 2 · Accepted Answer · answered Apr 12 '16 at 15:38

2

r.db('db').table('table').get('item_id')
    .replace(
        r.row.merge(
            function(doc){ 
                return {field_a: 'newval'}
            }
        ).without('field_b')
    )

Should do the trick

answered Apr 12 '16 at 15:38

Neil Hanlon

81
3

2

Thanks @Neil, works like a chame! I think you can do it without the anonymous function as well. `r.row.merge({field_a: 'newval'}).without('field_b')` – Sagivf Apr 12 '16 at 15:52

RethinkDB update and replace-without in one line

2 Answers2