Add multiple values to the postgresql using nodeJS Sequelize

Question

Is there any possible way to add multiple values to the column? Right now i have a comments column and I have this code .

app.put('/addComment/:id', (req, res) => {

Posts.update({
        comment: req.body.comment
    },
    {
        where: {
            id: req.params.id
        }
    }).then((post) => {
    res.send(post)
}).catch((err) => {
    console.log("err", err);
});
})

But instead of adding another value it just updates old one with new , any suggestions on method which will solve my issue?

What do you mean by multiple values? Is your column a text? Do you wish to concatenate an existing text in the column with a new one? — Anatoly
– Anatoly, Commented Jul 7, 2020 at 6:57
if you want to add another value why your using update method? update method used to change the value of existing. — CodeBug
– CodeBug, Commented Jul 7, 2020 at 6:59
the column data_type is text[],I know i should not use update but I'm new to sequelize and I could not find any other method which would suit my proble — Nika Roffy
– Nika Roffy, Commented Jul 7, 2020 at 7:00

xMayank · Accepted Answer · 2020-07-07 07:19:38Z

2

You can use concat function sequelize

It will append new value into the column.

const {fn, col } = models.sequelize

Posts.update({
 members: fn('CONCAT', col("comment"), req.body.comment)
}, {
 where: {
  id: req.params.id
 }
}).then(function() {
 console.log("Value Appended");
});

edited Jul 7, 2020 at 7:19

answered Jul 7, 2020 at 7:08

xMayank

1,9852 gold badges8 silver badges20 bronze badges

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

2 Comments

xMayank Over a year ago

import Sequelize

sumanth.js Over a year ago

Ya! it is saved in a single column but is it possible to display it separately in a card view?

Collectives™ on Stack Overflow

Add multiple values to the postgresql using nodeJS Sequelize

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related