How can I effectively utilize the knex db object across multiple files?
As an illustration
In my main index.js file:
const app = require("express")();
const cors = require("cors");
const bodyParser = require("body-parser");
const user = require("./routes/User");
const product = require("./routes/Product");
//-----------------
const db = require("knex")({
client: "pg",
connection: {
host: "127.0.0.1",
user: "postgres",
password: "",
database: "Razer"
}
});
//-----------------
app.use(cors());
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: false }));
//-----------------
app.use("/user", user);
app.use("/product", product);
//-----------------
module.exports = db;
//-----------------
app.listen(5000, () => {
console.log("App listening on PORT 5000 ");
});
In my User.js file:
const express = require("express");
const router = express.Router();
const db = require("../index");
router.get("/", async (req, res) => {
console.log(db);
});
module.exports = router;
However, when attempting to access the db object within User.js, it returns an empty object instead of the expected data.