Update multiple columns for a user - postgresql and nodejs

Question

I appreciate that this questions has been covered many times but cannot seem to get it to work for my scenario, I'm just not getting the syntax nor implementation right.

Right now I have a very simple update method that updates 1 column, finding that user by it's id

User.update = (id, value) => {
  pool.query('UPDATE users SET membership_expiry_date = $2 where id = $1', [id, value], (err) => {
    if (err) {
      return console.error(err);
    }
    return console.log('User Updated');
  });
};

await User.update(req.body.user_id, "value");

I have multiple columns that I would like to update and not sure how to set this up. Each time I update i could have a different number of columns to update, depending on what information is being updated

Ayush Gupta · Accepted Answer · 2018-10-15 15:49:49Z

3

You can pass the columns you want to pass as an object and build the query dynamically.

User.update = (id, values) => {
      let columns = Object.keys(values);
      let params = [id];
      let query = "UPDATE users SET ";
      for(let i = 0; i < columns.length; i++) {
        query = `${query}${columns[i]} = $${params.length + 1},`
        params.push(values[columns[i]]);
      }
      query = `${query.substring(0, query.length-1)} WHERE id = $1`
      console.log(query);
      console.log(params)
    };

await User.update("req.body.user_id", {columnToUpdate: "newValue"});

answered Oct 15, 2018 at 15:49

Ayush Gupta

9,36511 gold badges63 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Richlewis Over a year ago

Thank you for your answer, I will give this a go

Collectives™ on Stack Overflow

Update multiple columns for a user - postgresql and nodejs

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related