如果提供日期是Mongodb中使用NodeJS的数组的日期，则增加值

Question

如果provide courtId等于slotTracker中的courtId，并且provided date在dates数组中，我想将slotsAvailable减1并将slotsBooked增1

 {

"slotTracker" : [
    {
      "courtID" : 1,
      "dates" : [
        {
          "date": "2021-03-17T08:03:02.197Z",
          "slotsBooked": 0,
          "slotsAvailable": 10
        },
            
        {
          "date": "2021-04-17T08:03:02.197Z",
          "slotsBooked": 0,
          "slotsAvailable": 15
        },      
      ]
    },
    {
      "courtID" : 2,
      "dates" : [
        {
          "date": "2021-03-17T08:03:02.197Z",
          "slotsBooked": 0,
          "slotsAvailable": 15
        },
            
        {
          "date": "2021-04-17T08:03:02.197Z",
          "slotsBooked": 0,   //increase this by 1
          "slotsAvailable": 5   //decrease this by 1
        },      
      ]
    }
  ]

}

例如：提供courtId为1，提供日期为“2021-03-17T08:03:02.197Z”。所以它会改变slotAvailable couter

{
    "courtID" : 2,
     "dates":[{
          "date": "2021-04-17T08:03:02.197Z",
          "slotsBooked": 1,   //increase this by 1
          "slotsAvailable": 4   //decrease this by 1
      },
     {
          "date": "2021-03-17T08:03:02.197Z",
          "slotsBooked": 0,
          "slotsAvailable": 15
      },
      ]
}

Answer 1

db.sample.update({
    courtID: 2, 
    "dates.date" : "2021-04-17T08:03:02.197Z" 
   } , 
   {$inc : {
         "dates.$.slotsBooked" : 1, "dates.$.slotsAvailable" : -1} 
    });

请试用：）