add db connection feedback

1 files changed, 11 insertions, 1 deletions

diff --git a/db/index.js b/db/index.js
index e612987b..981938c7 100644
--- a/db/index.js
+++ b/db/index.js
@@ -4,12 +4,22 @@ const debug = require('debug')('debug');
 const dbOptions = require('./../config/knexfile.js')[process.env.NODE_ENV || "development"]
 
 db = new Sequelize(dbOptions.connection.database, dbOptions.connection.user, dbOptions.connection.password, {
-  host: dbOptions.connection.host,
+  host: "localhost",
   dialect: "mariadb",
   logging: false,
   dialectOptions: { "multipleStatements": true, "timezone": "Etc/GMT+7" }
 });
 
+db.authenticate()
+.then (response => {
+  console.log('DB Connection established');
+})
+.catch (err => {
+  console.debug('Error connecting to database: ' + err.message);
+  console.log(dbOptions.connection.database + '.' + dbOptions.connection.user);
+})
+
+console.log("DB: " + JSON.stringify(dbOptions))
 debug('knex dbOptions: ' + JSON.stringify(dbOptions))
 
 knex = require('knex')(dbOptions)