如何在Try-Catch块中构造SQL错误。
try {
const event = await Event.findByPk(event_id);
if (!event) {
throw Error("Event not found");
}
await Event.update({ name:name, date:date }, {
where: {
id: event.id
}
});
}
catch(error) {
return res.status(400).json({status: "error", message: error.message});
}
return res.json({
status: "success"
});
如果Event.update查询失败,可以显示以下内容:
{
"status": "error",
"message": "column "name" does not exist"
}
我想展示这样的东西:
{
"status": "error",
"message": "Internal Server error"
}
这是catch块中应该有的内容。捕获块中不需要"返回":
try {
const event = await Event.findByPk(event_id);
if (!event) {
throw Error("Event not found");
}
await Event.update({ name:name, date:date }, {
where: {
id: event.id
}
});
}
catch(error) {
res.status(400).send({status: "error", message: error});
}