const mysql = require('mysql');
var billsSelectAllSQL = 'SELECT * FROM bills';

/* Start connection to MySQL */
var mysqlConnection = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: "password",
    database: "budget"
});

mysqlConnection.connect(function(err) {
    if(err) {
        throw err;
    }
    console.log("MySQL database connected!");
});

var mysqlQuery = function(query) {
    var queryResult;
    mysqlConnection.query(query, function(err, result, fields) {
        if(err) {
            throw err;
        }
        queryResult = result;
    });
    return queryResult;
};

var bills = mysqlQuery(billsSelectAllSQL);
console.log(bills);