mysql_connect.js

'use strict';

var Sequelize = require('sequelize');
var sqlizr = require('sqlizr');
var config = require('./config/config');

exports.register = (plugin, options, next) => {
    
    // default directory for models
    options.models = options.models || './models/*.js';
    const sequelize = new Sequelize(config.db_schema, config.db_user, config.db_pass, {
        host: config.db_host,
        dialect: 'mysql',
        logging: false,
        pool: { max: 50, min: 0, idle: 10000 },
        define: {
            freezeTableName: true,
            timestamps: false // true by default
        }
    });
 
    // test the database connection
    sequelize.authenticate()
        .then(function() {
            console.log('DB ' + config.db_schema + ' connected');
        })
        .catch(function(err) {
            console.log(err);
        })
    sqlizr(sequelize, options.models);

    const db = { sequelize: sequelize, Sequelize: Sequelize };
    
    // make available in hapi application
    plugin.expose('db', db);
     
    next();
};

exports.register.attributes = {
    name: 'mysql_connect'
};