summaryrefslogtreecommitdiff
path: root/bucky/db/bookshelf.js
blob: 47a9636f7d615bcb9dad3099981313ca78c4084a (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
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)
bookshelf.plugin('registry');

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