sequelize-index.js

'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];

let sequelize = new Sequelize(
  config.database,
  config.username,
  config.password,
  config
);

if (config.use_env_variable) {
  sequelize = new Sequelize(process.env[config.use_env_variable], config);
}

const db = fs
  .readdirSync(__dirname)
  .filter(
    file =>
      file.indexOf('.') !== 0 && file !== basename && file.slice(-3) === '.js'
  )
  .reduce((acc, file) => {
    const model = sequelize['import'](path.join(__dirname, file));

    return { ...acc, [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;