RethinkDB - delete a nested object

Question

I am trying to delete a nested object, but instead of disappearing it is being replaced by an empty object.

Here's the structure of my documents:

[
    {
      "id":  "0" ,
      "name":  "Employee 1" ,
      "schedules": [
                     {"Weekdays": "yes"},
                     {"Weekends": "no"}
                   ]
     } ,

    {
      "id":  "1" ,
      "name":  "Employee 2" ,
      "schedules": [
                     {"Weekdays": "no"},
                     {"Weekends": "yes"}
                   ]
    }

]

Let's say I want to delete "Weekends". Here's my code:

r.db('shank').table('teachers').replace(r.row.without({'schedules': 'Weekends'})).run(connection, function(err, result) {
    if (err) throw err;
    ;
    //confirmation stuff
        });
});

Now if I look at my table, the documents have this:

"schedules": [
                    {"Weekdays": "yes"},
                    {}
             ]

I also tried changing it to follow the syntax described here, by making it:

r.row.without({'schedules': {'Weekends'}})

but I got an error of an unexpected token '}'. Any idea what's up?

neumino · Accepted Answer · 2014-09-02 04:57:13Z

1

This should work:

 r.db('test').table('test').get('0').update(function(doc) {
   return doc.merge({
     schedules: doc("schedules").filter(function(schedule) {
       return schedule.hasFields('Weekends').not()
     })
   })
 })

The field schedules is an array, is that expected? Is there a reason why it's not just an object with two fields Weekends and Weekdays? That would make things way easier.

edited Sep 2, 2014 at 4:57

answered Sep 2, 2014 at 4:38

neumino

4,3531 gold badge21 silver badges17 bronze badges

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

2 Comments

BarthesSimpson Over a year ago

Both of those still leave the empty object inside the "schedules" array

BarthesSimpson Over a year ago

There was no good reason why schedules was an array. I changed it to an object and your original answer worked.

Matt Dodge · Accepted Answer · 2017-05-24 16:25:06Z

0

Your last one is close to what worked for me, just need to add a true to the nested JSON object:

r.row.without({'schedules': {'Weekends': true}})

answered May 24, 2017 at 16:25

Matt Dodge

11.3k7 gold badges42 silver badges58 bronze badges

Collectives™ on Stack Overflow

RethinkDB - delete a nested object

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related