From 85cb9d270a0ca72498381aa5ed7eb4874c43ddb5 Mon Sep 17 00:00:00 2001
From: Ran <ran.guin@gmail.com>
Date: Thu, 17 Jun 2021 12:07:24 -0700
Subject: add db connection feedback

---
 db/index.js | 12 +++++++++++-
 1 file changed, 11 insertions(+), 1 deletion(-)

(limited to 'db')

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)
-- 
cgit v1.2.3