2021-12-24 mongo scripts

update nested fields, key is a variable
通过脚本, 更新的值和key都是动态变量传入的, 并且更新的嵌套的值

db.getCollection('collection').find({"filter": "fileter"}).forEach(function (data) {
        var actions = data.actions
        var update_ob = {}
        var keys = ['key']
        actions.forEach(function (action) {
            if (action.action == 'update') {
                var fields = action.fields
                for (var key in action.fields) {
                    if(key in data.eventFields){
                        continue
                    }
                    if (keys.indexOf(key) > -1) {
                        update_ob['map.' + key] = fields[key].new_value
                    }
                }
            }
        })
        if (Object.keys(update_ob).length !== 0) {
            db.getCollection('collection').updateOne({ "id":data.id }, { $set: update_ob })
        }
    })

另外, 推荐一个软件
https://www.nosqlbooster.com/
可以用来debugger, 非常好用