JS操作MongoDB

JavaScript处理MongoDB，更新数据：

#!/bin/bash
mongo=/home/zhangzhenghai/cluster/mongodb/bin/mongo
if true; then
OUT=$0.out
cat <<EOF | $mongo 2>&1 | tee $OUT
use information;
db.roki.find({spch_hotwords_zh:{"$exists": true}}).forEach(function(doc){
    var s=doc.spch_hotwords_zh["com@ro:dotrokid@ro:dothomebase:tag"];
    try {
        var json = JSON.parse(s);
        json.pop("大爷");
        var result = JSON.stringify(json);
        print(result);
        db.roki.update({"_id": doc._id}, {"$set": {"spch_hotwords_zh.com@ro:dotrokid@ro:dothomebase:tag":result}});

    }
    catch(err) {
    }
});
EOF
fi

替换的源格式为：

{
  "_id": "xxx123",
  "basic_info": {
    "id": "xxx123",
"cmiit": "nil",
    "cy": "cn",
    "lng": "zh",
"region": "CN",
    "signLink": "true",
  },
  "spch_hotwords_zh": {
    "com@ro:dotrokid@ro:dothomebase:tag": "["书房开关","书房开关 L1","开关","书房开关 L2","书房开关 L3","客厅开关","面板","客厅开关 L1","客厅开关 L2","客厅开关 L3","阳光茶室","灯","阳光茶室 L1","阳光茶室 L2","阳光茶室 L3","厨房开关","厨房开关 L1","琴房","琴房 L1","琴房 L2","琴房 L3","餐厅开关","餐厅开关 L1","餐厅开关 L2","餐厅开关 L3","包厢开关","包厢开关 L1","包厢开关 L2","包厢开关 L3","卫生间开关","卫生间开关 L1","卫生间开关 L2","玄关开关","玄关开关 L1","玄关开关 L2","存茶室开关","存茶室开关 L1","存茶室开关 L2","存茶室开关 L3","大爷"]",
    "com@ro:dotrokid@ro:dotsystem@ro:dotexecuter:trigger": "["早上好","晚上好"]"
  },
  "PUSH-MESSAGE": {
    "device_type": "ANDROID"
  },
  "voice_trigger_zh": {
    "1499247475884": "{"rid":"1499247475884","triggers":["晚上好"],"enable":true,"executions":[{"voice":"tts 晚上好","delay":0},{"voice":"播放舒缓音乐","delay":1200},{"voice":"关机","delay":0}]}",
    "1499247476350": "{"rid":"1499247476350","triggers":["早上好"],"enable":true,"executions":[{"voice":"tts 早上好","delay":0},{"voice":"播报天气","delay":0},{"voice":"播放新闻","delay":1200},{"voice":"关机","delay":0}]}"
  },
  "LOCATION": {
    "country": "中国"
  }
}

程序执行完后：

{
  "_id": "xxx123",
  "basic_info": {
    "id": "xxx123",
"cmiit": "nil",
    "cy": "cn",
    "lng": "zh",
"region": "CN",
    "signLink": "true",
  },
  "spch_hotwords_zh": {
    "com@ro:dotrokid@ro:dothomebase:tag": "["书房开关","书房开关 L1","开关","书房开关 L2","书房开关 L3","客厅开关","面板","客厅开关 L1","客厅开关 L2","客厅开关 L3","阳光茶室","灯","阳光茶室 L1","阳光茶室 L2","阳光茶室 L3","厨房开关","厨房开关 L1","琴房","琴房 L1","琴房 L2","琴房 L3","餐厅开关","餐厅开关 L1","餐厅开关 L2","餐厅开关 L3","包厢开关","包厢开关 L1","包厢开关 L2","包厢开关 L3","卫生间开关","卫生间开关 L1","卫生间开关 L2","玄关开关","玄关开关 L1","玄关开关 L2","存茶室开关","存茶室开关 L1","存茶室开关 L2","存茶室开关 L3"]",
    "com@ro:dotrokid@ro:dotsystem@ro:dotexecuter:trigger": "["早上好","晚上好"]"
  },
  "PUSH-MESSAGE": {
    "device_type": "ANDROID"
  },
  "voice_trigger_zh": {
    "1499247475884": "{"rid":"1499247475884","triggers":["晚上好"],"enable":true,"executions":[{"voice":"tts 晚上好","delay":0},{"voice":"播放舒缓音乐","delay":1200},{"voice":"关机","delay":0}]}",
    "1499247476350": "{"rid":"1499247476350","triggers":["早上好"],"enable":true,"executions":[{"voice":"tts 早上好","delay":0},{"voice":"播报天气","delay":0},{"voice":"播放新闻","delay":1200},{"voice":"关机","delay":0}]}"
  },
  "LOCATION": {
    "country": "中国"
  }
}

待续。。。