Mongodb array manipulation

Question

I've problem with array manipulation in mongodb. I will show on example what I need.

My collection structure:

{ id: "user1", items: [ { id: "1", quantity: 1 }, { id: "2", quantity: 3 } ] }

{ id: "user2", items: [ { id: "1", quantity: 1 }, { id: "3", quantity: 3 } ] }

I would like add some items for user1.

If items with id exist already in user array I would like to just increment quantity. If not I would like add it to items list.

In example:

I would like to add items [ { id: "1", quantity: 1 }, { id: "3", quantity: 1 } ] for user1

After this operation structure of collection should look like:

{ id: "user1", items: [ { id: "1", **quantity: 2** }, { id: "2", quantity: 3 }, **{ id: "3", quantity: 1 }**  ] }

{ id: "user2", items: [ { id: "1", quantity: 1 }, { id: "3", quantity: 3 } ] }

How to do it? Aggregation? Map reduce? I don't want to make query for each of added element.

Thanks for answer. I can use pushAll to add everything by one query to array. But then it will look like: { id: "user1", items: [ { id: "1", quantity: 1 }, { id: "2", quantity: 3 }, { id: "3", quantity: 1 }, { id: "1", quantity: 1 } ] }. That's not that I need. — user1855877
– user1855877, Commented Dec 10, 2013 at 10:25

Norbert Pisz · Accepted Answer · 2013-12-10 10:53:34Z

2

To change object value use $set:

'$set':{quantity: 1}

For increment you can use $inc

$inc: { quantity: 5 }

To add new item in array use $push:

$push: { quantity: 0 }

Chek all array operations here: Array Update Operators

answered Dec 10, 2013 at 10:53

Norbert Pisz

3,4403 gold badges30 silver badges43 bronze badges

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

1 Comment

user1855877 Over a year ago

Ye, thanks. I know that I can do it from N [just inc] to 2*N [checking if can inc - if not already in array then push] queries (where N is length of pushed array). Just wonder if I can do it by less work.

Collectives™ on Stack Overflow

Mongodb array manipulation

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related