50 lines
1.3 KiB
JavaScript
50 lines
1.3 KiB
JavaScript
"use strict";
|
|
|
|
const fs = require("fs");
|
|
const path = require("path");
|
|
const Sequelize = require("sequelize");
|
|
const basename = path.basename(__filename);
|
|
const env = process.env.NODE_ENV || "development";
|
|
const config = require(__dirname + "/../config/config.json")[env];
|
|
const db = {};
|
|
|
|
config.username = process.env.DB_USERNAME || config.username;
|
|
config.password = process.env.DB_PASSWORD || config.password;
|
|
config.database = process.env.DB_NAME || config.database;
|
|
config.port = process.env.DB_PORT || config.port;
|
|
config.logging = parseInt(process.env.SEQUELIZE_LOGGING) ? console.log : false;
|
|
|
|
let sequelize;
|
|
if (config.use_env_variable) {
|
|
sequelize = new Sequelize(process.env[config.use_env_variable] + "?ssl=true", config);
|
|
} else {
|
|
sequelize = new Sequelize(
|
|
config.database,
|
|
config.username,
|
|
config.password,
|
|
config
|
|
);
|
|
}
|
|
|
|
fs.readdirSync(__dirname)
|
|
.filter(file => {
|
|
return (
|
|
file.indexOf(".") !== 0 && file !== basename && file.slice(-3) === ".js"
|
|
);
|
|
})
|
|
.forEach(file => {
|
|
const model = sequelize["import"](path.join(__dirname, file));
|
|
db[model.name] = model;
|
|
});
|
|
|
|
Object.keys(db).forEach(modelName => {
|
|
if (db[modelName].associate) {
|
|
db[modelName].associate(db);
|
|
}
|
|
});
|
|
|
|
db.sequelize = sequelize;
|
|
db.Sequelize = Sequelize;
|
|
|
|
module.exports = db;
|