Update array of objects in RethinkDB

Question

I have the following document representing a chat room, where the timestamp in the member objects represents that particular user's last activity in the room.

{
  "id":  "4ff130cc-3201-4a30-8a4c-5ce4303d28d0",
  "name": "General chat",
  "members": [
     {
       "timestamp": 1437074682224 ,
       "user_id": "bdb4c00c-0ce8-4e22-9331-38b5c4b083e4"
     },
     {
       "timestamp": 1437074693805 ,
       "user_id": "7708ebc6-915b-4bfd-b63e-849bacefa201"
     }
  ]
}

When the user e.g. joins the room, I would like to update the timestamp. It seems like a trivial operation, but I cannot get it to work.

I am using the official JavaScript driver. How do I update the timestamp with a given user_id?

Tholle · Accepted Answer · 2015-07-17 07:54:05Z

1

I ended up filtering out every member except the one I'm interested in, and appending a new object to it.

r.db("chat").table("rooms").get("room_id").update(function(room) {
  return {
    members: room("members").filter(function (member) {
      return member("user_id").ne("relevant_user_id");
    }).append({ user_id: "relevant_user_id", timestamp: 1337 })
  };
});

Not sure this is the "right way" to do it.

answered Jul 17, 2015 at 7:54

Tholle

113k22 gold badges209 silver badges198 bronze badges

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

Comments

Indiana Kernick · Accepted Answer · 2015-07-17 07:29:22Z

0

I may have misunderstood your question but try this

function updateTime(user_id) {
  for (var i = 0; i < members.length; i++) {
    if (members[i].user_id == user_id) {
      members[i].timestamp = /*current time*/
      break;
    }
  }
}

answered Jul 17, 2015 at 7:29

Indiana Kernick

5,3912 gold badges26 silver badges56 bronze badges

2 Comments

Tholle Over a year ago

Thank you for your reply, but that's not quite what I'm asking for. I'm asking for a query to RethinkDB, not how to do it in a regular JavaScript object.

Indiana Kernick Over a year ago

@Tholle I guess I did misunderstand your question

Collectives™ on Stack Overflow

Update array of objects in RethinkDB

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related