dayline_read_api.js

router.post('/api/read', function (req, res, next) {
  var connection = mysql.createConnection(dbconfig);
  connection.connect();
  connection.query("SELECT id, line, created FROM dayline2.lines ORDER BY id DESC limit 1000;",  function (error, results, fields) {
    if (error) {
      console.log(error);
      res.send({
        status: "ERR",
        reason: error
      })
    } else {
      res.send({
        status: "OK",
        data : results
      })
    }
  }
  );
  connection.end();
});