var Sequelize = require('sequelize')

var _host = 'mysql'
var _user = 'root'
var _password = 'root'
var _db = 'area'
var _dialect = 'mysql'


const db = {}

const prequelize = new Sequelize("", _user, _password, {host: _host, dialect: _dialect, operatorsAliases: false,
    pool: {
        max: 5,
        min: 0,
        acquire: 30000,
        idle: 10000
        }
    })
    prequelize.query("CREATE DATABASE IF NOT EXISTS area").then(data => {
        console.log("DATABASE CREATION?\n", data)
           }).catch(err => {
        console.log("DB CONNECTION ERROR WHILE TRYING TO CREATE DATABSE LOOK AFTER THAT TO SEE WHATSUP MY DUDE", err)
    })

prequelize.sync()

const sequelize = new Sequelize(_db, _user, _password, {host: _host, dialect: _dialect, operatorsAliases: false,
    pool: {
        max: 5,
        min: 0,
        acquire: 30000,
        idle: 10000
        }
    })


    db.Sequelize = Sequelize
    db.sequelize = sequelize
    sequelize
    .authenticate()
    .then(() => {
        console.log("Connection established to db.")
    })
    .catch(err => {
        console.log("Failed connection to database.")
        console.log(err)
    })
    db.users = require('./models/usersM')(sequelize, Sequelize)
    db.mail = require('./models/mailM')(sequelize, Sequelize)
    db.auth = require('./models/authM')(sequelize, Sequelize)
    db.action = require('./models/actionM')(sequelize, Sequelize)
    db.reaction = require('./models/reactionM')(sequelize, Sequelize)

    db.users.sync({alter: true}).then(err => {
        if (err)
            console.log("Error: syncing Users table\n", err)
        else
        console.log("Users table synced successfully")
    })

    db.mail.sync({alter: true}).then(err => {
        if (err)
            console.log("Error syncing Mail table\n", err)
        else
        console.log("Table users created successfuly")
    })

    db.auth.sync({alter: true}).then(err => {
        if (err)
            console.log("Error syncing Auth table\n", err)
        else
        console.log("Auth table synced successfully")
    })

    db.reaction.sync({alter: true}).then(err => {
        if (err)
            console.log("Error syncing Reaction table\n", err)
        else
        console.log("Reaction table synced successfully")
    })

    db.action.sync({alter: true}).then(err => {
        if (err)
            console.log("Error syncing Action table\n", err)
        else
        console.log("Action table created successfuly")
    })

//c'est un test pour tenter de creer la db a l'export du module
module.exports = function() {
    const sequelize = new Sequelize("", _user, _password, {host: _host, dialect: _dialect, operatorsAliases: false,
        pool: {
            max: 5,
            min: 0,
            acquire: 30000,
            idle: 10000
            }
        })
        sequelize.query("CREATE DATABASE IF NOT EXISTS area").then(data => {
            console.log("DATABASE CREATION?\n", data)
        }).catch(err => {
            console.log("DB CONNECTION ERROR WHILE TRYING TO CREATE DATABSE LOOK AFTER THAT TO SEE WHATSUP MY DUDE", err)
        })

}

module.exports = db;