mongodb如何批量修改内嵌文档的属性？

Question

{代码...} 如何用一条命令把message数组中2个对象元素中的status属性都改成false？ 是否只能在客户端做逻辑处理： {代码...} 请大家指正~~

滿天的星座 · Answer

You can also change it in the mongo shell.

天蓬老师 · Answer

var true_metadata = db.modulestore.find({"metadata.tabs": {$exists: true}})
var updated_tabs = [];

true_metadata.forEach(function(item){
    var tabs = item.metadata.tabs
    if (item && item.metadata && tabs ){
        tabs.forEach(function(item){
            if(item.type == "wiki") {
                item.name = "资料";
            }
        })

    db.modulestore.update({"_id": item._id}, {$set: {
            "metadata.tabs": tabs 
    }})

    updated_tabs.push(tabs)
 }
})

updated_tabs

I also encountered a similar problem. I checked the official documentation. My local solution is as above. I hope it can help you

迷茫 · Answer

Use the aggregation framework aggregate to do it. Unwind it first with unwind. Then update all status.

phpcn_u1582 · Answer

This can be done, mongodb provides a dollar sign "$" to update embedded data objects.
If you want the result, you can write the following statement:

    db.test.update({_id:ObjectId("52fb2ceb1e2f8622d4228a7a"), "message.status":true}, 
        {$set:{"message.$.status":false}})

But please note that your update conditional statement must include the condition of the object in the data. For example, {"messaage.status":true} above, you can also change it to something else.

Please refer to the mongodb documentation: http://docs.mongodb.org/manual/reference/operator/update/positional/#update-documents-in-an-array