Skip to content
Snippets Groups Projects
Select Git revision
  • master
1 result

server.js

Blame
  • Forked from Dr.Pirmann / CI101Week56Lab
    Source project has a limited visibility.
    server.js 1.06 KiB
    const express = require("express");
    const app = express();
    
    const sqlite3 = require("sqlite3").verbose();
    
    app.use(express.static("."));
    app.use(express.json());
    
    app.get("/getBooks", function(req, res) {
      const db = new sqlite3.Database("./CLCBooks.db");
      console.log("recieved");
      let output = "";
      db.serialize(function() {
        db.each(
          "SELECT Books.ISBN, Books.Title, Books.Author, Availability.Available FROM Books, Availability WHERE Books.ISBN = Availability.ISBN",
          function(err, row) {
            if (row) {
              if (row.Available == "Y") {
                row.Available = "Yes";
              } else {
                row.Available = "No";
              }
              output += `<tr class="rows">
                  <td>${row.Title}</td>
                  <td>${row.Author}</td>
                  <td>${row.ISBN}</td>
                  <td>${row.Available}</td>
                </tr>`;
            }
          }
        );
      });
      setTimeout(function() {
        db.close();
        res.send(output);
      }, 500);
    });
    
    const port = "8080";
    app.listen(port, () => console.log(`Listening at 127.0.0.1:${port}...`));