Postgres UPDATE inserted value instead of all columns

Question

imagine we have 10 columns in a table, and we want to update our table columns with input just 1 value and doesn't change remain values.

So just our new value will update and unnecessary values will not be Null ...?

i ASK this because i'm using This code and i want to send put requests depends on my edited content ...

i'm using this query to put request from body(react) into node postgres ...

router.put("/user/:nationalcode", (req, res) => { const cols = [ req.body.nationalcode, req.body.stockcode, req.body.firstname, req.body.lastname, req.body.isenable, req.body.isonline, req.body.detail, req.body.birthdate, req.body.archive, req.body.offlineusername ]; db.query( `UPDATE users SET nationalcode=$1, stockcode=$2, firstname=$3, lastname=$4, isenable=$5, isonline=$6, detail=$7, birthdate=$8, archive=$9, offlineusername = $10 WHERE nationalcode = ${req.params.nationalcode}`, cols, function(err, result) { if (err) { console.log("Error. Updating : %s ", err); } } ); console.log(req.body); });

Just use a normal UPDATE query. Like UPDATE table SET column = value WHERE x = y — iJamesPHP2
– iJamesPHP2, Commented Feb 22, 2020 at 2:44
@iJamesPHP2 i Updated my question with code , can u please check and solve it ? — tafhim
– tafhim, Commented Feb 22, 2020 at 2:53

iJamesPHP2 · Accepted Answer · 2020-02-22 03:04:37Z

0

You want to strip out null values from your req.body object, use this function to strip it before you build the cols array:

function strip(obj) { for (var prop in obj) { if (obj[prop] === null || obj[prop] === undefined) { delete obj[prop]; } } }

So, define the function and use this as the first line of your code:

var cols = Object.values(strip(req.body));

edited Feb 22, 2020 at 3:04

answered Feb 22, 2020 at 2:59

iJamesPHP2

5444 silver badges14 bronze badges

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

6 Comments

iJamesPHP2 Over a year ago

There was an error in my code, I didn't see you are using req.body and not just req to access the columns, please use my latest edit

iJamesPHP2 Over a year ago

@tafhim Oh, I've just realised your query is hardcoded, you'd then need to build the query dynamically from the array in a loop

tafhim Over a year ago

what is the query? =)

tafhim Over a year ago

confused ... sry xD

tafhim Over a year ago

can we just make two variables like : column : requested col```` and value : req.body ``` ? this simple?

|

Collectives™ on Stack Overflow

Postgres UPDATE inserted value instead of all columns

1 Answer 1

6 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Linked

Related