使用CBQ控制台更新couchbase文档中的对象

Question

我有一个类似的文档

{
"runs": {
"run1": {
"result": "pass",
"state": "success"
},
"run2": {
"result": "fail",
"state": "incomplete"
}
}
}

如何将对象添加到"；运行"；。使用cbq查询的对象如下所示？

"run3": {
"result": "pass",
"state": "complete"
}

Answer 1

您尝试过UPDATE ... SET ...N1QL查询吗？

我运行了这个查询：

UPDATE naveen
SET runs.run3 = { "result": "pass", "state" : "complete" }
WHERE META().id = 'doc1';

最终结果文件是：

{
"runs": {
"run1": {
"result": "pass",
"state": "success"
},
"run2": {
"result": "fail",
"state": "incomplete"
},
"run3": {
"result": "pass",
"state": "complete"
}
}
}