Getting variable outside of query block in Nodejs with sqlLite

Question

I want to store all the rows from table to array(arr), I need to get the stored array outside of the defined query section. Is there a way I can get all the rows outside db.each such that I can manipulate them further.

var arr=[];
db.each("SELECT * FROM login", function(err, row) {
    var title=row.title;
    var context=row.context;
    var newItem = {
        'user': user,
        'pwd': pwd
    };
    arr.push(newItem);
});     
console.log(arr); //Outputs []

Typical case for a promise!

marekful
– marekful

2015-07-25 15:00:04 +00:00
Commented Jul 25, 2015 at 15:00 — marekful
– marekful, Commented Jul 25, 2015 at 15:00
I need to prepare JSON from database

Adarsh Nair
– Adarsh Nair

2015-07-25 15:01:41 +00:00
Commented Jul 25, 2015 at 15:01 — Adarsh Nair
– Adarsh Nair, Commented Jul 25, 2015 at 15:01

jshawl · Accepted Answer · 2015-07-25 15:06:39Z

2

Because db.each is an asynchronous function, you need to use another function as a callback, like:

var arr=[];
db.each("SELECT * FROM login", function(err, row) {
    var title=row.title;
    var context=row.context;
    var newItem = {
        'user': user,
        'pwd': pwd
    };
    arr.push(newItem);
}, function(){
  console.log(arr)
});

Reference: https://github.com/mapbox/node-sqlite3/wiki/API#databaseeachsql-param--callback-complete

answered Jul 25, 2015 at 15:06

jshawl

3,5032 gold badges25 silver badges34 bronze badges

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

1 Comment

Adarsh Nair Over a year ago

Thanks for this quick reply.

Collectives™ on Stack Overflow

Getting variable outside of query block in Nodejs with sqlLite

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