mongojs: pushing elements into fields of arrays

Question

I searched a lot on this topic, but I'm just totally lost. Here is my problem (I'm using node.js with mongojs):

I'd like to have this kind of documents:

{ 
    "_id" : ObjectId("50ce2f7f98fa09b20d000001"), 
    "beginTime" : 1355689855016, 
    "tags" : {
        "primary": [ 29, 12, 16], 
        "secondary": [6, 8, 9]
    },
    "user" : "50bdddc601de4681d666835f"
}

But if I try to push new tags for example under "primary" (note that this fields come from variables) like so

tags = {};
tags[request.body.relevance] = request.body.tag;
return db.activities.update({
  '_id': db.ObjectId(request.body.activity),
  'user': request.session.user.id
}, {
  $push: {
    tags: tags
  }
});

then I get

{ "_id" : ObjectId("50ce2f7f98fa09b20d000001"), "beginTime" : 1355689855016, "tags" : [ { "primary" : 29 }, { "primary" : "24" }, { "primary" : "1" } ], "user" : "50bdddc601de4681d666835f" }

I tried many other variations, including nesting the $push (witch tranformed it into a field o.o). Anyway, I always failed. Also at this point I'm really starving T_T

Please help me. Thanks.

This looks correct to me. How are you querying the document? Mongo separates your arrays to make them searchable. — Patrick Gunderson, Dec 16 '12 at 21:04
I'm sorry, what do you mean by "How are you querying the document"? (What's the data that I forgot to mention?) — Sovos, Dec 16 '12 at 22:42

JohnnyHK · Accepted Answer · 2012-12-16T23:40:17.543

1

The value of a $push operator needs to be the array field you want pushed to, not the parent.

Try this instead:

...
return db.activities.update({
  '_id': db.ObjectId(request.body.activity),
  'user': request.session.user.id
}, {
  $push: {
    'tags.primary': tags.primary,
    'tags.secondary': tags.secondary
  }
});

UPDATE

To do this dynamically you need to do something like this:

...
var push = {};
push['tags.' + request.body.relevance] = request.body.tag;
return db.activities.update({
  '_id': db.ObjectId(request.body.activity),
  'user': request.session.user.id
}, {
  $push: push
});

edited Dec 16 '12 at 23:40

answered Dec 16 '12 at 21:22

JohnnyHK

305,182
66
621
471

The problem thou is that "primary" and "secondary" are stored into variables (that could have any value): that's where the problem came from. Could you please show me how to use your solution considering the tags property being stored into variables? – Sovos Dec 16 '12 at 22:40
@user1662546 OK, I updated the result with what I assume you're looking for. – JohnnyHK Dec 16 '12 at 23:41

mongojs: pushing elements into fields of arrays

1 Answers1