How can I constumize SQL erros in a Try Catch block.
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"
});
If the Event.update query fails, can show something like:
{
"status": "error",
"message": "column \"name\" does not exist"
}
And I want to show something like this:
{
"status": "error",
"message": "Internal Server error"
}
This is what you should have in the catch block. There is no need for the 'return' in the catch block:
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});
}