CODEWITHSUNDEEP
mongodb
thotheolh
thotheolh

Reputation: 7450

Search and replace a string in an array in Mongo

I have the following data structure in Mongo which I want to edit:

{
   "images" : [{
      "image_id" : 46456,
      "image_path" : "http://cdn.site.com/image.jpg",
      "image_thumbnail" : "http://cdn.site.com/image.jpg",
      "image_detailed" : "http://cdn.site.com/image.jpg",
      "image_type" : "0"
    }, {
      "image_id" : 46452,
      "image_path" : "http://cdn.site.com/image.jpg",
      "image_thumbnail" : "http://cdn.site.com/image.jpg",
      "image_detailed" : "http://cdn.site.com/image.jpg",
      "image_type" : "2"
    }, {
      "image_id" : 46453,
      "image_path" : "http://cdn.site.com/image.jpg",
      "image_thumbnail" : "http://cdn.site.com/image.jpg",
      "image_detailed" : "http://cdn.site.com/image.jpg",
      "image_type" : "0"
    }, {
      "image_id" : 46454,
      "image_path" : "http://cdn.site.com/image.jpg",
      "image_thumbnail" : "http://cdn.site.com/image.jpg",
      "image_detailed" : "http://cdn.site.com/image.jpg",
      "image_type" : "A"
    }]
}

I would like to replace all the 'http' in the entire array to 'https' regardless which field they are in.

How do I do so ?

Thanks.

Upvotes: 5

Views: 5265

Answers (1)

Parvin Gasimzade
Parvin Gasimzade

Reputation: 26012

There is no built-in functionality in MongoDB. You can replace all the http with https by looping all records. In the Mongo shell you can do it as follows : 

String.prototype.replaceAll=function(s1, s2) {return this.split(s1).join(s2)}

var cursor = db.myCollection.find({},{_id:0});
while(cursor.hasNext()) {
    var obj = cursor.next();
    var objStr = JSON.stringify(obj);
    var newObjStr = objStr.replaceAll("http","https");
    db.myCollection.update(obj,JSON.parse(newObjStr));
}

Upvotes: 7

Related Questions