const Sequelize = require('sequelize');
require('dotenv').config();

const sequelize = new Sequelize(process.env.DB_NAME, process.env.DB_USER, process.env.DB_PASS, {
    host: process.env.SERVER_IP,
    dialect: process.env.DIALECT || 'mysql',
    logging: false,
    retry: {
        match: [
            Sequelize.ConnectionError,
            Sequelize.ConnectionTimedOutError,
            Sequelize.TimeoutError,
            /Deadlock/i,
            'SQLITE_BUSY'],
        max: 3
    }
});

sequelize.authenticate().then(() => {
    sequelize.sync().then(() => {
        console.log('Synced!');
    });
}).catch((err) => {
    console.error('Unable to connect to the database: ', err);
});

module.exports = sequelize;