MongoDB欄位必須是陣列

目前我有一個包含以下檔案的集合：

[
    {
        "_id": ObjectId("628e6bd640643f97d6517c75"),
        "company": "bau",
        "current_version": 0,
        "form_name": "don't know",
        "history": [],
        "id": "23421123-24a9-4a45-a12f-27a330152ax3",
        "is_active": True,
        "user_id": "999",
    },
    {
        "_id": ObjectId("628eaffe4b8ae2ccdeb9305c"),
        "company": "vrau",
        "current_version": 0,
        "form_name": "exemplo",
        "history": [
            {
                "content": [
                    {
                        "field_id": 0,
                        "label": "insira um texto",
                        "placeholder": "qualquer texto",
                        "type": "text",
                    }
                ],
                "layout": [
                    {"field_id": 0, "h": 10, "type": "text", "w": 100, "x": 0, "y": 0}
                ],
                "responses": [
                    {
                        "client_id": 100,
                        "response_date": "2020-01-02",
                        "values": [{"field_id": 0, "value": "um texto"}],
                    },
                    {
                        "client_id": 2,
                        "response_date": "2020-01-01",
                        "values": [{"field_id": 0, "value": "roi"}],
                    },
                ],
                "version": 0,
            }
        ],
        "id": "33b66684-24a9-4a45-a12f-27a330152ac8",
        "is_active": True,
        "user_id": "1",
    },
]

我想client_id = '2'通過收到以下錯誤來更改回應：

pymongo.errors.WriteError: The field 'history.0.responses.1' must be an array but is of type object in document {_id: ObjectId('628eaffe4b8ae2ccdeb9305c')}, full error: {'index': 0, 'code': 2, 'errmsg': "The field 'history.0.responses.1' must be an array but is of type object in document {_id: ObjectId('628eaffe4b8ae2ccdeb9305c')}"}

我不知道我做錯了什么，這個錯誤對我來說沒有意義，因為回應是一個陣列。

我當前的查詢：

collection.update_many(
    {"id": "33b66684-24a9-4a45-a12f-27a330152ac8", "history.version": 0},
    {
        "$push": {
            "history.$[h].responses.$[r]": {
                "client_id": 2,
                "response_date": "2020-01-01",
                "values": [{"field_id": 0, "value": "roi"}],
            }
        }
    },
    array_filters=[{"h.version": 0}, {"r.client_id": "2"}],
)

有沒有別的可以做？

uj5u.com熱心網友回復：

這是因為您也在執行過濾器r，它已經決議為responses陣列中的物件級別。

r如果您只想推送到responses陣列，您可以簡單地放棄arrayFilter。

collection.update_many(
    {"id": "33b66684-24a9-4a45-a12f-27a330152ac8", "history.version": 0},
    {
        "$push": {
            "history.$[h].responses": {
                "client_id": 2,
                "response_date": "2020-01-01",
                "values": [{"field_id": 0, "value": "roi"}],
            }
        }
    },
    array_filters=[{"h.version": 0}],
)

這是Mongo游樂場供您參考。（在本機 js 語法中）

如果要更新條目而不是添加條目，則應使用$set而不是。$push在您給定的示例中，client_id是 int 而您的 arrayFilter 是字串。如果不是故意的，它可能會導致問題。

collection.update_many(
    {"id": "33b66684-24a9-4a45-a12f-27a330152ac8", "history.version": 0},
    {
        "$set": {
            "history.$[h].responses.$[r]": {
                "client_id": 2,
                "response_date": "2020-01-01",
                "values": [{"field_id": 0, "value": "roi"}],
            }
        }
    },
    array_filters=[{"h.version": 0}, {"r.client_id": 2}],
)

這是Mongo游樂場供您參考。（在本機 js 語法中）

標籤：mongodb mongodb查询 pymongo 烧瓶-pymongo

上一篇：應用程式沒有回應但沒有錯誤Discord.js

下一篇：返回列表