pymongo 查詢
mycol.update(
{
"unique_report_id": 330665,
"structure.name": "sommememe",
"structure.values.unique_report_name": "areatest"
},
{
"$set": {
"structure.$.values.$.report_data": {
data
}
}
},
{
"multi": True
}
)
資料
[
{
"structure": [
{
"name": "sommememe",
"values": [
{
"report_name": "area test",
"report_heading": "area test",
"background": "#f0f2f5",
"grid": false,
"report_data": {
"slslsllsls": {
"datasource": "alias",
"source": "3",
"title": "slslsllsls",
"chartColor": "#00D88A",
"area": {
"x": 10,
"y": 10,
"width": 360,
"height": 360
}
}
},
"unique_report_name": "areatest"
}
],
"type": 1
}
],
"unique_report_id": 330665
}
]
我想用來自 api 的資料替換 report_data 鍵我在上面的查詢中嘗試但它不起作用，
請看看我該如何解決它。
謝謝
我再次添加資料。請檢查
Traceback (most recent call last):
File "/Users/soubhagyapradhan/Desktop/upwork/report/backend/env/lib/python3.8/site-packages/django/core/handlers/exception.py", line 47, in inner
response = get_response(request)
File "/Users/soubhagyapradhan/Desktop/upwork/report/backend/env/lib/python3.8/site-packages/django/core/handlers/base.py", line 181, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/Users/soubhagyapradhan/Desktop/upwork/report/backend/api/views.py", line 314, in create_report
"structure.$.values.$.report_data": {
TypeError: unhashable type: 'dict'
當我在 pymongo 上運行上述查詢時，我遇到了上述錯誤。請檢查這里有什么問題。
uj5u.com熱心網友回復：
db.collection.update({
"structure.values.unique_report_name": "areatest"
},
{
"$set": {
"structure.$[].values.$[ele].report_data": {
"slslsllsls": {
"datasource": "aliasqqqqqq",
"source": "3333333",
"title": "slslsllslsqqqqqq",
"chartColor": "#00D88A",
"area": {
"x": 10000,
"y": 10000,
"width": 9999,
"height": 9999
}
}
}
}
},
{
arrayFilters: [
{
"ele.unique_report_name": "areatest"
}
]
})
mongoplayground
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/432880.html
上一篇：如何按月計算新值？