JavaScript处理MongoDB，更新数据：

#!/bin/bashmongo=/home/zhangzhenghai/cluster/mongodb/bin/mongoif true; thenOUT=$0.outcat <
     
      &1 | tee $OUTuse 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) {    }});EOFfi
     

替换的源格式为：

{  "_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": "中国"  }}

 

待续。。。