take id from select query in pg promise

Question

when i log data.id the result is undefined when i log data the result is

[ anonymous {

id: 23, username: 'vvv', password: '1', description: null, cutprice: null, salname: null, image: null, counter: 0 } ]

app.post('/api/hairdresser/signin', (req, res) => {
 console.log(req.body)
  connection.connect();
 var name = req.body.name;
 var password = req.body.password
  db.any('SELECT * FROM hairdressers where username = $1 ', 
 name).then(function(data) {
     console.log(data);
    console.log(data.id);
   }).catch(function(error) {

console.log(error);

 });
})

Try data[0].id, I think data is an array – Patrick Hund Jan 06 '18 at 20:21 — Patrick Hund, Jan 06 '18 at 20:21
Glad to help, make sure you accept Vitaly's answer – Patrick Hund Jan 07 '18 at 18:48 — Patrick Hund, Jan 07 '18 at 18:48

vitaly-t · Accepted Answer · 2018-06-22T09:46:55.277

Method any is documented to resolve with an array of rows, so data[0].id is the value you are looking for.

Most likely what you need in this scenario though, is method oneOrNone, which resolves with the row-object, or null when none returned:

db.oneOrNone('SELECT * FROM hairdressers where username = $1', name)
  .then(data => {
     // data = row object, or null when user not found;
     console.log(data && data.id);
  })
  .catch(error => {
      // more than 1 user found, or a different error
  });

take id from select query in pg promise

1 Answers1