--- a/backend/server.js
+++ b/backend/server.js
@@ -14,7 +14,7 @@
// Notification ===========================================
// config files
-var db = require('../config/db');
+var dbconfig = require('../config/db');
//Environment Variables
logger.info("Environment Variables:");
@@ -30,8 +30,11 @@
// set our port
var port = process.env.PORT || 8000;
+//using mysql connections pool
+var dbpool = mysql.createPool(dbconfig);
+
// connect to our MySQL database
-logger.info("MySQL Trying to connect...");
+/*logger.info("MySQL Trying to connect...");
try {
var con = mysql.createConnection({
host: db.host,
@@ -46,8 +49,10 @@
}catch(e){
logger.error("MySQL error: ", e.stack);
}
+*/
-exports = module.exports = con;
+//exports the mysql connections pool
+exports = module.exports = dbpool;
// get all data/stuff of the body (POST) parameters
// parse application/json