8vS7M2VG

1var sqlite3 = require("sqlite3").verbose();
2var db = new sqlite3.Database("db");
3
4db.serialize(function() {
5  db.run(
6    "CREATE TABLE IF NOT EXISTS users (name TEXT, password TEXT, role TEXT)"
7  );
8  db.run(
9    "INSERT INTO users (name, password, role) VALUES (?, ?, ?)",
10    "admin",
11    "admin",
12    "ADMIN"
13  );
14  db.run(
15    "INSERT INTO users (name, password, role) VALUES (?, ?, ?)",
16    "user",
17    "user",
18    "USER"
19  );
20});
21
22var express = require("express");
23var app = express();
24
25app.get("/", function(req, res) {
26  res.send("Hello World!");
27});
28
29app.get("/users", function(req, res) {
30  db.all("SELECT * FROM users", function(err, row) {
31    res.json(row);
32  });
33});
34
35app.post("/users", function(req, res) {});
36
37app.listen(3000, function() {
38  console.log("Now listening on port: 3000");
39});