我创建了一个API来更新与外键相关联的记录
如果我只是给项赋值，所以我想让它返回，那么删除其他我没有赋值的值
如果我编辑项目中的一些值，所以我希望它返回我编辑的值
如果我把价值放在物品的价值上，所以我想让它返回物品的旧价值和我放在上面的价值
example: const record = {id:1,name:"abc",items:[{id:1,name:"abc",recordId:1},{id:2,name:"abcd",recordId:1}]}
const update = await dbRecord.update({id,name},{where: {id: req.params.id},include:[model:'items',id:[1,2]});
const update = await dbRecord.update({id,name},{where: {id: req.params.id}});
//array get from body
ex: array = [{id:1,name:"abc",recordId:1},{id:2,name:"abcd",recordId:1}]
const itemId = array.map((arr) => arr.id);
// result = [1,2]
await dbItems.bulkCreate(array, {
updateOnDuplicate: ['name'],
});
for (var i = 0; i < update.items.length; i++) {
const item = update.items[i];
if (!itemId.includes(container.id)) {
await container.destroy();
}
}
so it create update delete in once time.