sqlite from node js not returning result

Question

i am kinda new to this node js and sqlite thing but i have create a simple function to get 1 results from my sqlite db

getOne: function() {
 sql.get(`SELECT * FROM currency_list order by rowid desc limit 1`).then(row => {
  if (!row) {
    return console.log("no data");
  } else {
    return row;
  }
});
},

and then my caller something like this

 module.exports = {
  run : (args, Client, msg, isOwner) => {
  let results = db.getOne();
  console.log("test result =>"+JSON.stringify(results));
 }
 };

i dont get any results as my console log will show Undefined from the function. Can i know how to make the function return values?

Titus · Accepted Answer · 2018-04-19 06:56:46Z

2

You're returning the result from the callback function you've passed to then not from the getOne function.

To fix that, you could do something like this:

getOne: function() {
    return sql.get(`SELECT * FROM currency_list order by rowid desc limit 1`).then(row => {
                if (!row) {
                    return console.log("no data");
                } else {
                    return row;
                }
           });
}

And get the result like this:

getOne().then(result => console.log(result));

Or, since you're doing this in nodejs you can also do this:

async function something(){
    let result = await getOne();
    console.log(result);
}
something();

edited Apr 19, 2018 at 6:56

answered Apr 19, 2018 at 6:51

Titus

22.6k1 gold badge26 silver badges36 bronze badges

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

1 Comment

user1897151 Over a year ago

thanks for the help. Now i understand why is it not working earlier.

Collectives™ on Stack Overflow

sqlite from node js not returning result

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