根据对象值中的off键更新mongoose中的对象数组

const mongoose = require('mongoose');
const Schema = mongoose.Schema;

const itemSchema = new Schema({
  name: String,
  off: Boolean
});

const listSchema = new Schema({
  items: [itemSchema]
});

const List = mongoose.model('List', listSchema);

const mongoose = require('mongoose');
const Schema = mongoose.Schema;

const itemSchema = new Schema({
  name: String,
  off: Boolean
});

const listSchema = new Schema({
  items: [itemSchema]
});

const List = mongoose.model('List', listSchema);

// 连接到 MongoDB 数据库
mongoose.connect('mongodb://localhost:27017/test', { useNewUrlParser: true, useUnifiedTopology: true });

// 更新清单中所有 off 为 true 的商品
async function updateItemsOff(listId) {
  const filter = { _id: listId };
  const update = { $set: { 'items.$[elem].off': true } };
  const arrayFilters = [{ 'elem.off': true }];

  try {
    const result = await List.findOneAndUpdate(filter, update, { arrayFilters });
    console.log('Updated list:', result);
  } catch (error) {
    console.error('Error updating list:', error);
  }
}

// 示例调用
updateItemsOff('your_list_id_here');