node.js script with synchronous sqlite3 call

Question

i'm trying to use sqlite3 in node.js script, i'm using this library:

but i want that the call at the database is synchronous and not asynchronous, this is an example of the code i use:

var tests = [];

db.serialize(function() {

  db.each("SELECT lot_id, status FROM TestTable ORDER BY lot_id ASC", function(err, row) {
      tests.push(row.status);
      console.log("Read "+row.lot_id+" state: "+row.status);
  });
});

db.close();

for (i = 0; i < tests.length; i++) {
//Do something
}

when the execution arrives at the for loop, go over because the tests array is still empty, how i can perform this instruction sequentially?

thanks

helpermethod · Accepted Answer · 2014-09-04 11:09:15Z

4

Execute the for-loop in the complete callback

var tests = [];

db.serialize(function() {

  db.each("SELECT lot_id, status FROM TestTable ORDER BY lot_id ASC", function(err, row) {
      tests.push(row.status);
      console.log("Read "+row.lot_id+" state: "+row.status);
  }, function() { // this callback is executed when the query completed
     for (i = 0; i < tests.length; i++) {
     // Do something
     }
  });
});

db.close();

answered Sep 4, 2014 at 11:09

helpermethod

62.8k71 gold badges201 silver badges281 bronze badges

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

3 Comments

Piero Over a year ago

i have a very lot of code to execute after the for-loop, i can insert all this code in the serialize? there isn't a better solution?

helpermethod Over a year ago

You can put this code in a function and call that function from the complete callback.

menepet Over a year ago

Worked for me !!! I could not find any documentation from the npm sqlite3 wiki and this helped me!!!

Collectives™ on Stack Overflow

node.js script with synchronous sqlite3 call

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related