import mysql from "mysql";


const connection = mysql.createPool({
    host: "localhost",
    user: "root",
    password: "",
    database: "vacations_database"
})

function fetchVacations(sql: string): Promise<any> {

    return new Promise<any>((resolve, reject) => {
        connection.query(sql, (err, result) => {
            if(err) {
                reject(err);
                return;
            }
            resolve(result);
        });
    })

}

function fetchUsers(sql: string): Promise<any> { 

    return new Promise<any>((resolve, reject) => {
        connection.query(sql, (err, result) => {
            if(err) {
                reject(err);
                return;
            }
            resolve(result);
        });
    })

}


export default {
    fetchVacations,
    fetchUsers 
}