database.js

const mysql = require('mysql');
const util = require('util');

let database = {
    configuration:{
        host: 'localhost',
        user: 'root',
        password: 'David2005_',
        database: 'presents',
        multipleStatements: true
    },
    connected:false,
    mysqlConnection:null,
    query:null,
    connect() {
        if ( this.connected == false){
            this.connected = true;
            this.mysqlConnection = mysql.createConnection(this.configuration);
            this.query = util.promisify(this.mysqlConnection.query).bind(this.mysqlConnection);
        }
    },
    disConnect () {
        if ( this.connected == true){
            this.connected = false;
            this.mysqlConnection.end();
        } 
    }
}

module.exports=database