我正在用Node.js和Sequelize.js撰寫一個簡單的 CMS 。我想從像Wordpress這樣的用戶那里獲取資料庫資訊并創建資料庫連接。我為此撰寫了下面的代碼，但我的問題是應用程式在資料庫連接之前沒有啟動。
控制器
// Get Database Setup Page
exports.getSetup = (req, res) => {
return res.render("pages/account/setup");
};
// Post Database Information
exports.postSetup = (req, res) => {
// Set posted values as ENV Variable
setEnvValue("DB_NAME", req.body.name);
setEnvValue("DB_USERNAME", req.body.username);
setEnvValue("DB_PASSWORD", req.body.password);
setEnvValue("DB_HOST", req.body.host);
return res.redirect("/login");
};
// Error occurs here. Application don't start before database connection.
exports.getLogin = async (req, res) => {
const general = await Models.General.findByPk(1);
// Check Authenticate
if (req.session.isAuth) return res.redirect("/admin");
// Render Page
return res.render("pages/account/login", {
title: "Login",
general: general,
});
};
發布后的 .env 檔案
DB_NAME="db-name"
DB_USERNAME="root"
DB_PASSWORD="password"
DB_HOST="localhost"
資料庫連接檔案
我在幾個地方使用它，比如定義模型。
const Sequelize = require("sequelize");
const sequelize = new Sequelize(
process.env.DB_NAME,
process.env.DB_USERNAME,
process.env.DB_PASSWORD,
{
dialect: "mysql",
host: process.env.DB_HOST,
}
);
module.exports = sequelize;
uj5u.com熱心網友回復：
您可以將創建 Sequelize 實體包裝到一個函式中并將其匯出以在login路由中使用，如下所示：
const Sequelize = require("sequelize");
let sequelize = null;
function initializeConnection() {
sequelize = new Sequelize(
process.env.DB_NAME,
process.env.DB_USERNAME,
process.env.DB_PASSWORD,
{
dialect: "MySQL",
host: process.env.DB_HOST,
}
);
// here should be model and their associations' registration
...
}
function getConnection() {
return sequelize;
}
module.exports = {
initializeConnection,
getConnection
}
// Error Occurs here. Application don't start before database connection.
exports.getLogin = async (req, res) => {
if (req.session.isAuth) {
return res.redirect("/admin");
}
try {
await intializeConnection();
catch (err) {
res.status(500).send('Internal server error')
return;
}
const general = await Models.General.findByPk(1)
res.render("pages/account/login", {
title: "Login",
general: general,
});
};
不要忘記在注銷時斷開與資料庫的連接
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/417871.html
標籤：