setup.js

////////////////////////////////////////////////
//     DO YOU WANT TO RESET THE DATABASE?     //
//        OR SETUP FOR THE FIRST TIME?        //
////////////////////////////////////////////////
let reset = true;
////////////////////////////////////////////////

const mysql = require('mysql');
const log = require('leekslazylogger');
const services = require('./services.json');
const database = require('./database');

const db = mysql.createConnection({
    host: database.host,
    // port: database.port,
    user: database.user,
    password: database.password,
    database: database.name
});

log.setup({
    logToFile: false,
    timestamp: 'DD/MM/YY hh:mm:ss',
    custom: {
        db: {
            title: 'MySQL',
            colour: 'cyanBright'
        }
    }
});

db.connect((err) => {
    if (err) { // if connection fails
        log.warn('Could not connect to database');
        log.warn(log.colour.bgYellowBright(log.color.black('CRITICAL: NO DATABASE CONNECTION')) + log.colour.bgBlack(''));
        return log.error(err);
    };

    log.success(`Connected to database (${database.name}@${database.host})`);

    if (reset) {
        db.query(`DROP TABLE minecraft;`, (err, result) => {
            if (err) return log.error(err);
            // log.debug(result);
            log.info(`Deleted 'minecraft' table`);
        });
        
        db.query(`DROP TABLE websites;`, (err, result) => {
            if (err) return log.error(err);
            // log.debug(result);
            log.info(`Deleted 'websites' table`);
        });
    }

    db.query('CREATE TABLE `' + database.name + '`.`minecraft` ( `id` VARCHAR(128) NOT NULL , `name` VARCHAR(128) NOT NULL , `status` VARCHAR(128) NULL , `player_count` SMALLINT NOT NULL , `players` LONGTEXT NOT NULL , `tps` DECIMAL(4,2) NOT NULL , `last_online` VARCHAR(32) NULL  , `expires` VARCHAR(32) NULL );', (err, result) => {
        if (err) return log.error(err);
        // log.debug(result);
        log.success(`Created 'minecraft' table`);
    });

    db.query('CREATE TABLE `' + database.name + '`.`websites` ( `id` VARCHAR(128) NOT NULL , `name` VARCHAR(128) NOT NULL , `status` VARCHAR(128) NULL , `last_online` VARCHAR(32) NULL );', (err, result) => {
        if (err) return log.error(err);
        // log.debug(result);
        log.success(`Created 'websites' table`);
    });

    // add minecraft servers to table
    let servers = services.minecraft.servers;
    log.info(servers);
    for (server in servers) {
        db.query(`INSERT INTO minecraft (id, name, player_count, players, tps) VALUES ('${server}', '${servers[server].name}', 0, '[]', 0);`, (err, result) => {
            if (err) return log.error(err);
            // log.debug(result);
            log.console(`Added '${servers[server].name}' server to the 'minecraft' table`);
        }); 
    }

    // add websites
    let sites = services.websites;
    for (site in sites) {
        db.query(`INSERT INTO websites (id, name) VALUES ('${site}', '${sites[site].name}');`, (err, result) => {
            if (err) return log.error(err);
            // log.debug(result);
            log.console(`Added '${sites[site].name}' website to the 'websites' table`);
        }); 
    };

    // add external
    let external = services.external;
    for (api in external) {
        db.query(`INSERT INTO websites (id, name) VALUES ('${api}', '${external[api].name}');`, (err, result) => {
            if (err) return log.error(err);
            // log.debug(result);
            log.console(`Added '${external[api].name}' external API to the 'websites' table`);
        }); 
    };
    log.info('Setup process does not automatically exit after it is finished (Ctrl+C)', 'yellowBright');
});