var knex = require('knex')({
  client: 'mysql2',
  connection: {
    host:     process.env.DB_HOST,
    user:     process.env.DB_USER,
    password: process.env.DB_PASS,
    database: process.env.DB_NAME,
    // charset:  'utf8',
  },
  pool: {
//    ping: function(connection, callback) {
 //     connection.query({text: 'SELECT 1 = 1'}, [], callback);
  //  },
    min: 1,
    max: 4,
  }
})

var bookshelf = require('bookshelf')(knex)

module.exports = {
  bookshelf: bookshelf,
  knex: knex,
}