import dotenv from 'dotenv';
import Sequelize from 'sequelize';

const env = dotenv.config();

const sequelize = new Sequelize(process.env.DATABASE, process.env.DATABASE_USER, process.env.DATABASE_PASS, {
  host: 'localhost',
  dialect: 'postgres',
  pool: {
    max: 10,
    min: 0,
    acquire: 30000,
    idle: 10000
  }
});

const db = {};

db.Sequelize = Sequelize;
db.sequelize = sequelize;

//Models/tables this needs to be in an es6 format
db.books = require('../model/book.model.js')(sequelize, Sequelize);


module.exports = db;