I have a database with PostgreSQL that includes a table called events. My goal is to enable a user to update any column or multiple columns in this table through input. The issue I am facing with the current code is that when a user updates, for instance, the wedding_name column and leaves the others blank, the row gets successfully updated with the new value only on the specified column. However, the remaining columns become empty because they did not receive any input. Ideally, I would like to be able to update individual columns without affecting the untouched ones in a single query. Thank you.
modifyEvent:async(req, res)=>{
try {
const eventId= req.params.eventId
const {weddingName,groom,bride,location,date,}=req.body
const updatedEvent=pool.query('UPDATE events SET wedding_name=$1,bride_name=$2,groom_name=$3,wedding_location=$4,wedding_date=$5 WHERE wedding_id=$6',[
weddingName,bride,groom,location,date,eventId
])
res.json(updatedEvent)
}
catch (error) {
console.log(error.message)
}
}