如何在貓鼬的訊息陣列中設定“seen：true”

我是 mongodb 世界的新手，我被困在 Mongoose 查詢中。

基本上我正在為我的網站開發一個聊天應用程式。我的網站的聊天模式如下所示

const LiveChat = mongoose.Schema({
    
    members: [String],
    messages: [{
        sender: String,
        reciever: String,
        text: String,
        seen: {
            type: Boolean,
            default: false
        },
        date: {
            type: Date,
            default: Date.now
        }
    }],
}, { timestamps: true });

例如集合看起來像這樣

[   
    {
     
      "_id":"627749f8dc5927d660f76172",
      "members":[
         "626a250d11ed1b096883aed1",
         "626a234611ed1b096883ae13"
      ],
      "messages":[
         {
            "sender":"626a250d11ed1b096883aed1",
            "reciever":"626a234611ed1b096883ae13",
            "text":"hello there!.",
            "seen":false,
            "_id":"6278b0c38031894a9ceefeae",
            "date":"2022-05-09T06:12:19.857Z"
         },
         {
            "sender":"626a250d11ed1b096883aed1",
            "reciever":"626a234611ed1b096883ae13",
            "text":"how are you?.",
            "seen":false,
            "_id":"6278b0e18031894a9ceefede",
            "date":"2022-05-09T06:12:49.680Z"
         },
         {
            "sender":"626a234611ed1b096883ae13",
            "reciever":"626a250d11ed1b096883aed1",
            "text":"hello Rupesh",
            "seen":false,
            "_id":"6278b1438031894a9ceeff98",
            "date":"2022-05-09T06:14:27.388Z"
         },
         {
            "sender":"626a234611ed1b096883ae13",
            "reciever":"626a250d11ed1b096883aed1",
            "text":"we are doing well",
            "seen":false,
            "_id":"6278b1588031894a9ceeffe0",
            "date":"2022-05-09T06:14:48.203Z"
         },
         {
            "sender":"626a250d11ed1b096883aed1",
            "reciever":"626a234611ed1b096883ae13",
            "text":"okay",
            "seen":false,
            "_id":"6278b1ed8031894a9cef0099",
            "date":"2022-05-09T06:17:17.421Z"
         }
      ],
      "createdAt":"2022-05-08T04:41:28.416Z",
      "updatedAt":"2022-05-09T06:17:17.420Z",
      "__v":0
   },
   {
      
      "_id":"62762021be68a5e2de8dc2d2",
       members: ["626a250d11ed1b096883aed1", "6273bc879ff276ac89f9c4f8"]
      "messages":[
         {
            "sender":"626a250d11ed1b096883aed1",
            "reciever":"6273bc879ff276ac89f9c4f8",
            "text":"hello there!",
            "seen":false,
            "_id":"6277ac0ba5fe501f98e1421e",
            "date":"2022-05-08T11:39:55.263Z"
         },
         {
            "sender":"626a250d11ed1b096883aed1",
            "reciever":"6273bc879ff276ac89f9c4f8",
            "text":"can you please tell me what is the date of start a project task",
            "seen":false,
            "_id":"6277ac30a5fe501f98e1424c",
            "date":"2022-05-08T11:40:32.472Z"
         },
         
    
      ],
      "createdAt":"2022-05-07T07:30:41.447Z",
      "updatedAt":"2022-05-08T12:24:31.400Z",
      "__v":0
   }
   
]

現在我想將seen:true所有訊息設定到messages陣列中sender == "626a250d11ed1b096883aed1"（ sender_id 和 conversation_id 是從 req.body 提供給 API 的）。對于messages陣列中的所有訊息： seen:false表示訊息未被接收者看到 seen:true 意味著訊息被接收者看到

我正在嘗試按照我的快速 API 的方式進行操作，但它沒有作業......

cosnt {conversation_id, sender_id} = req.body;
LiveChat.findByIdAndUpdate({ _id: conversation_id },
            [{
                $set: {
                    'messages.seen': { $cond: [{ $eq: ['messages.sender', sender_id] }, true, false] }
                }
            }]
            ,
            {
                new: true,
                useFindAndModify: true,
            }

請幫我寫這個查詢...

uj5u.com熱心網友回復：

這是您可以使用"arrayFilters".

db.collection.update({
  "_id": "627749f8dc5927d660f76172"  // given _id
},
{
  "$set": {
    "messages.$[x].seen": true
  }
},
{
  "arrayFilters": [
    {
      "x.sender": "626a250d11ed1b096883aed1"  // given sender
    }
  ]
})

在mongoplayground.net上試試。

標籤：节点.js 数据库 mongodb 猫鼬 nosql

上一篇：獲取最近X天的記錄

下一篇：來自另一個檔案的Mongoose模型回傳未定義