Send all data from SQLite in Node.js

Question

I'm new with SQLite and Node.js and so far the application is able to send some data to the front-end. The problem is that it sends only the first row from the table and it should send all the data.

This is the code so far:

var express = require('express');
var router = express.Router();
var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database('./db/my_db.db');

router.get('/', function (req, res, next) {
  db.serialize(function () {
    db.each('SELECT id, name, surname FROM Customers', function (
      err,
      row
    ) {
      res.send(row);
    });
  });

  db.close();
});

module.exports = router;

It seems that isn't enough to insert res.send() inside db.each() because it does the sending only for the first column.

How can it be done for all the data from that table?

Leo Messi · Accepted Answer · 2020-07-12 21:51:38Z

3

The problem is related to db.each() and res.send() because the later one is called only once, sends the response and closes, doesn't go in a loop for all the rows.

The simplest solution in this case is to use db.all() instead.

var express = require('express');
var router = express.Router();
var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database('./db/my_db.db');

router.get('/', function (req, res, next) {
  db.serialize(function () {
    db.all('SELECT id, name, surname FROM Customers', function (
      err,
      row
    ) {
      res.send(row);
    });
  });

  db.close();
});

module.exports = router;

answered Jul 12, 2020 at 21:51

Leo Messi

6,36022 gold badges84 silver badges159 bronze badges

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

Collectives™ on Stack Overflow

Send all data from SQLite in Node.js

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