MongoDB: Update nested array fields in all documents in a collection

Question

Here is my example document:

{
    "isUpdated": false,
    "isDeleted": false,
    "customer": {
        "name": "John Doe",
        "address": [{
            "houseNum": 5,
            "streetName": "Example Avenue",
            "postalCode": "90210"
        }, {
            "houseNum": 15,
            "streetName": "Second Example Avenue",
            "postalCode": "91210"
        }]
    }
}

I have several similar documents. I want to update all documents in my collection by adding another key-value pair to all customer.addresses. How would I do this? I am having trouble accessing the objects inside address.

I want to add this key-value pair to all addresses: "country": "USA". So, now that example document will look like this:

{
    "isUpdated": false,
    "isDeleted": false,
    "customer": {
        "name": "John Doe",
        "address": [{
            "houseNum": 5,
            "streetName": "Example Avenue",
            "postalCode": "90210",
            "country": "USA"
        }, {
            "houseNum": 15,
            "streetName": "Second Example Avenue",
            "postalCode": "91210",
            "country": "USA"
        }]
    }
}

Does this help: stackoverflow.com/questions/27874469/…

Lalit Agarwal
– Lalit Agarwal

2015-07-30 20:26:36 +00:00
Commented Jul 30, 2015 at 20:26 — Lalit Agarwal
– Lalit Agarwal, Commented Jul 30, 2015 at 20:26

Sede · Accepted Answer · 2015-07-31 07:15:34Z

6

If I understand you want to update all you document and add "country": "USA" to every sub-document in the customer.address. You can do this using the Bulk() API

var bulk = db.collection.initializeOrderedBulkOp();
var count = 0;

db.collection.find().forEach(function(doc){
    var addr = doc["customer"]["address"]; 
    for (var i = 0; i < addr.length; i++) {
        bulk.find({ 
            "_id": doc._id, 
            "customer.address": { "$elemMatch": {
                "houseNum": addr[i][ "houseNum" ], 
                "streetName": addr[i][ "streetName" ]}}
        }).update({
            "$set": { "customer.address.$.country": "USA" }
        })} 
    count++;
    if ( count % 1000 == 0 ) {
        // Execute per 1000 operations and re-init.
        bulk.execute();
        bulk = db.collection.initializeOrderedBulkOp();
    }
})

// Clean up queues
if ( count % 1000 != 0 ){
    bulk.execute();
}

edited Jul 31, 2015 at 7:15

answered Jul 30, 2015 at 21:01

Sede

61.5k20 gold badges158 silver badges162 bronze badges

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

Collectives™ on Stack Overflow

MongoDB: Update nested array fields in all documents in a collection

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related