Node.js SQLite 3 Return Promise

Question

I am somewhat new to node.js and I figured out how to use it with SQLite but I would like to make wrapper functions so I don't have to have SQL statements all over my code. This code prints out the result of the query:

 Users.find_by_id = function(id){
  db.all("SELECT * from users WHERE id=" + id, function(err, row){
    console.log(row);
  });
};

I know that node.js is asynchronous so I can't return the values themselves but I was wondering if it was possible to return a promise with the values in question.

Which version you are using? If you are using node 5, take a look at this package github.com/kriasoft/node-sqlite — Fabio Antunes
– Fabio Antunes, Commented Feb 23, 2016 at 18:18
It says my version is v0.10.37. Is this very out of date/worth an update? — user5505266
– user5505266, Commented Feb 23, 2016 at 18:22
If you want to use promises there are a lot of packages you can use. I like Q. You can also take a callback function as a parameter and call that when you're done, passing the data to the function. — rgvassar
– rgvassar, Commented Feb 23, 2016 at 18:24
Well if are just learning you might just change to latest node version, so you can have some of es6 cool stuff — Fabio Antunes
– Fabio Antunes, Commented Feb 23, 2016 at 18:25
I honestly can't make heads or tails of how that package is used. — user5505266
– user5505266, Commented Feb 23, 2016 at 20:39

rgvassar · Accepted Answer · 2016-02-23 22:38:59Z

1

If you want to use promises there are a lot of packages you can use. I like Q. Without promises you can take a callback function as a parameter and call that when you're done, passing the data to the function.

answered Feb 23, 2016 at 22:38

rgvassar

5,8412 gold badges27 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

Node.js SQLite 3 Return Promise

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related