var mysql = require('mysql')
var db = require('./db')

var conn = mysql.createConnection({
    host: db.host,
    user: db.user,
    password: db.password
});

conn.connect(function (err) {
    if (err) throw err;
    console.log("Connected to db");
});

module.exports = conn;

var sql = require('./db_slave')

sql.query("select 2", function (err, result) {
    if (err) console.log(err)
    console.log(result)
});

var mysql = require('mysql-promise')
var db = require('./db')

module.exports = mysql.createConnection({
    host: db.host,
    user: db.user,
    password: db.password
}).then(conn => {
    console.log("connected to the DB");
    return conn;
}).catch(err => {
    console.log("error connecting to the DB", err);
    throw err;
});

require('./db_slave').then(conn => {
    return conn.query("select 2").then(result => {
        console.log(result);
    });
}).catch(err => {
    // handle error here
});