Knexjs Initialization

Establishing connection with Database, setting default time zone and verifying connection.

var knex = require('knex')({
  client: 'mysql',
  connection: {
    host: '127.0.0.1',
    user: 'xxx',
    password: 'xxx',
    database: 'xxx'
  },
  // after connection is made, set time zone to UTC
  pool: {
    afterCreate(connection, done) {
      connection.query('SET time_zone = "+00:00";', (err) => {
        done(err, connection);
      })
    }
  }
})

// Fetch MySql version to verify connection is successful
knex.raw("SELECT VERSION()")
  .then(() => {
    console.log('DB connection established')
  })
  .catch((err) => {
    console.log(err)
  })

module.exports = knex;

Posted on: Wed, 15 May 2019 03:11:46 GMT

Tags:

knexjs