Server keeps getting old result

Question

After adding a user, the new user is not shown in the list. Everything works only after restarting the server. It looks like the server is downloading data from the cache memory. Maybe my code is not written properly. How to get current data from the database?

// addFile

const sqlite3 = require("sqlite3").verbose();
const db = new sqlite3.Database("./db/dbSqlite/app.db", sqlite3.OPEN_READWRITE);

const add = (user) => {
  return new Promise((res, rej) => {
    db.serialize(() => {
      let status = false;
      db.run(`INSERT INTO users(
        login,
        password,
        ) VALUES(?, ?)`, user, (err) => {
        if (err) rej(status);
        status = true;
        res(status);
      });
    })
  })
}
module.exports = add;

// getAll file

const sqlite3 = require("sqlite3").verbose();
const db = new sqlite3.Database("./db/dbSqlite/app.db");

const getAll = new Promise((res, rej) => {
  db.all(`SELECT * from users`, (err, row) => {
    if (row === undefined || err) {
      res("NO_TABLE_USERS");
    } else {
      const stringified = JSON.stringify(row)
      res(JSON.parse(stringified));
    }
  });
})

module.exports = getAll

// route

router.post("/add", helper.isLoggedIn, helper.isAdmin, (req, res) => {
  let msg = "User created successfully!";
  user.add(Object.values(req.body)
    .then((state) => {
      if (!state) msg = "Name already used!";
      user.getAll
        .then((result) => res.render("users", {
          name: req.user,
          users: result,
          msg: msg
        }));
    }));
});

Answer 1

getAll should be a function, like you did with add. Otherwise, getAll will be resolved once :

// addFile

const sqlite3 = require("sqlite3").verbose();
const db = new sqlite3.Database("./db/dbSqlite/app.db", sqlite3.OPEN_READWRITE);

const add = (user) => {
  return new Promise((res, rej) => {
    db.serialize(() => {
      let status = false;
      db.run(`INSERT INTO users(
        login,
        password,
        ) VALUES(?, ?)`, user, (err) => {
        if (err) rej(status);
        status = true;
        res(status);
      });
    })
  })
}
module.exports = add;

// getAll file

const sqlite3 = require("sqlite3").verbose();
const db = new sqlite3.Database("./db/dbSqlite/app.db");

const getAll = () => {
  return new Promise((res, rej) => {
    db.all(`SELECT * from users`, (err, row) => {
      if (row === undefined || err) {
        res("NO_TABLE_USERS");
      } else {
        const stringified = JSON.stringify(row)
        res(JSON.parse(stringified));
      }
    });
  });
}

module.exports = getAll

// route

router.post("/add", helper.isLoggedIn, helper.isAdmin, (req, res) => {
  let msg = "User created successfully!";
  user.add(Object.values(req.body)
    .then((state) => {
      if (!state) msg = "Name already used!";
      user.getAll()
        .then((result) => res.render("users", {
          name: req.user,
          users: result,
          msg: msg
        }));
    }));
});