All files / mylog-api/models db.js

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
26
27
28
29
30
31
32
33
2x
2x
2x
2x
2x
2x
2x
2x
 
2x
 
 
 
 
 
 
 
 
 
 
 
 
 
 
2x
2x
 
 
 
 
 
 
2x
const mysql = require("mysql");
const dbConfig = require("../config/mylog.db.config.js");
const dotenv = require('dotenv')
dotenv.config({ path: './.env' });
console.log("DB_HOST: " + process.env.DB_HOST);
console.log("DB_USER: " + process.env.DB_USER);
console.log("DB_PASSWORD: " + process.env.DB_PASSWORD);
console.log("DB_NAME: " + process.env.DB_NAME);
// Create a connection to the database
const connection = mysql.createConnection({
  host: process.env.DB_HOST,
  user: process.env.DB_USER,
  password: process.env.DB_PASSWORD,
  database: process.env.DB_NAME,
  timezone: "utc",
  typeCast: function (field, next) {
    if (field.type == 'JSON') {
      return (JSON.parse(field.string()));
    }
    return next();
  },
});
 
// open the MySQL connection
connection.connect(error => {
  Iif (error) {
    console.log("Connection failed with info:\nhost: " + process.env.DB_HOST + "\nuser: " + process.env.DB_USER + "\npassword: " + process.env.DB_PASSWORD + "\ndatabase: " + process.env.DB_NAME);
    throw error;
  }
  // console.log("Successfully connected to the database (" + process.env.DB_NAME + ").");
});
 
module.exports = connection;