setup.js

let inquirer = require("inquirer");
let fs = require("fs");
let chalk = require("chalk");
const ora = require("ora");

let mysql = require("mysql");
console.log(chalk.blueBright("Thanks for picking VukkyBot! Let's get started..."));

let sql;

async function isTokenValid(token) {
	console.log(chalk.blueBright("\nValidating your token..."));
	const spinner = ora("Connecting to the Discord API").start();
	try {
		const Discord = require("discord.js");
		const client = new Discord.Client();
		await client.login(token);
		client.destroy();
		spinner.succeed("Token is valid");
		return true;
	} catch {
		spinner.fail("Token appears to be invalid");
		return false;
	}
}

let questions = [
	{
		type: "confirm",
		name: "launch",
		message: "Start VukkyBot after setup is complete?"
	},
	{
		type: "input",
		name: "prefix",
		message: "What's the prefix for your VukkyBot going to be?",
		default: "v!",
	},
	{
		type: "checkbox",
		name: "extrafeatures",
		message: "What extra features would you like?",
		choices: [
			{ name: "MySQL features (MySQL database required)", value: "mysql" },
			{ name: "Invalid command reminders", value: "invalidcmd" },
			{ name: "Prefix reminders", value: "prefixremind" },
			{ name: "Update checks", value: "updates" },
			{ name: "Message reporting", value: "msgreporting" },
		]
	},
	{
		type: "checkbox",
		name: "mysqlfeatures",
		message: "What MySQL features would you like? Warns are always on.",
		choices: [
			{ name: "Counting", value: "counting" }
		],
		when: function (answers) {
			return answers.extrafeatures !== undefined && answers.extrafeatures.includes("mysql");
		},
	},
	{
		type: "password",
		name: "token",
		message: "What's your bot token?",
		validate: isTokenValid,
		mask: true
	},
	{
		type: "confirm",
		name: "multipleowners",
		message: "Should your VukkyBot have multiple owners?"
	},
	{
		type: "input",
		name: "discordid",
		message: "What's the Discord ID of the person who'll be owning this VukkyBot?",
		when: function (answers) {
			return answers.multipleowners !== true;
		}
	},
	{
		type: "input",
		name: "discordidmulti",
		message: "What are the Discord IDs of the people who'll be owning this VukkyBot, split with commas (id1, id2, id3)?",
		when: function (answers) {
			return answers.multipleowners !== false;
		}
	},
	{
		type: "confirm",
		name: "updateDms",
		message: "Should your VukkyBot DM the owners when an update is found?",
		when: function (answers) {
			return answers.extrafeatures !== undefined && answers.extrafeatures.includes("updates");
		}
	},
	{
		type: "input",
		name: "countingchannel",
		message: "What is the name of the channel you would like VukkyBot to count in?",
		default: "counting",
		when: function (answers) {
			return answers.mysqlfeatures !== undefined && answers.mysqlfeatures.includes("counting");
		}
	},
	{
		type: "confirm",
		name: "msgReportingPosting",
		message: "What's the name of the channel reports should be posted in?",
		when: function (answers) {
			return answers.extrafeatures !== undefined && answers.extrafeatures.includes("msgReporting");
		}
	},
	{
		type: "confirm",
		name: "msgReportingRole",
		message: "What's the name of the role that should be pinged when a message is reported?",
		when: function (answers) {
			return answers.extrafeatures !== undefined && answers.extrafeatures.includes("msgReporting");
		}
	},
	{
		type: "input",
		name: "sqlhost",
		message: "What's your SQL hostname?",
		when: function (answers) {
			return answers.extrafeatures !== undefined && answers.extrafeatures.includes("mysql");
		},
	},
	{
		type: "password",
		name: "sqlpass",
		message: "What's your SQL password?",
		when: function (answers) {
			return answers.extrafeatures !== undefined && answers.extrafeatures.includes("mysql");
		},
	},
	{
		type: "input",
		name: "sqluser",
		message: "What's your SQL username?",
		when: function (answers) {
			return answers.extrafeatures !== undefined && answers.extrafeatures.includes("mysql");
		},
	},
	{
		type: "input",
		name: "sqldb",
		message: "What's your SQL database name?",
		when: function (answers) {
			return answers.extrafeatures !== undefined && answers.extrafeatures.includes("mysql");
		},
	}
];
  
inquirer.prompt(questions).then((answers) => {
	saveToEnv();

	function saveToEnv() {
		const spinner1 = ora("Saving credentials to .env").start();
		try {
			fs.writeFile(".env", `BOT_TOKEN=${answers.token}\nPREFIX=${answers.prefix}\nSQL_HOST=${answers.sqlhost}\nSQL_PASS=${answers.sqlpass}\nSQL_USER=${answers.sqluser}\nSQL_DB=${answers.sqldb}`, function (err) {
				if (err) {
					spinner1.fail("Saving credentials to .env failed");
					console.log(err);
					process.exit(1);
				} else {
					spinner1.succeed("Saved credentials to .env"); 
					saveToConfig();
				}
			});
		} catch (err) {
			spinner1.fail("Saving credentials to .env failed");
			console.log(err);
			process.exit(1);
		}
	}

	function saveToConfig() {
		const spinner2 = ora("Saving configuration to config.json").start();
		try {
			const config = require("./config.json");
			if (answers.multipleowners !== true) { config.misc.owner = [answers.discordid]; } else { config.misc.owner = answers.discordidmulti.split(", "); }
			config.misc.invalidCmdReminder = answers.extrafeatures !== undefined && answers.extrafeatures.includes("invalidcmd");
			config.misc.prefixReminder = answers.extrafeatures !== undefined && answers.extrafeatures.includes("prefixremind");
			config.misc.mysql = answers.extrafeatures !== undefined && answers.extrafeatures.includes("mysql");
			if (answers.mysqlfeatures !== undefined && answers.mysqlfeatures.includes("counting")) { config.counting.enabled = answers.mysqlfeatures.counting !== null; } else { config.counting.enabled = false; }
			if (answers.mysqlfeatures !== undefined && answers.mysqlfeatures.includes("counting")) { config.counting.channelName = answers.countingchannel; }
			if (answers.extrafeatures !== undefined && answers.extrafeatures.includes("updates")) {
				config.updateChecker.enabled = true;
				if (answers.updateDms == true) config.updateChecker.dmOwner = true;
			} else {
				config.updateChecker.enabled = false;
			}
			if (answers.extrafeatures !== undefined && answers.extrafeatures.includes("msgreporting")) {
				config.reports.enabled = true;
				config.reports.channelName = answers.msgReportingPosting;
				config.reports.staffRoleName = answers.msgReportingRole;
			} else {
				config.reports.enabled = false;
			}
			fs.writeFile("config.json", JSON.stringify(config, null, 4), function (err) {
				if (err) {
					spinner2.fail("Saving configuration to config.json failed");
					console.log(err);
					process.exit(1);
				} else {
					spinner2.succeed("Saved configuration to config.json");
					startMySQL();
				}
			});
		} catch (err) {
			spinner2.fail("Saving configuration to config.json failed");
			console.log(err);
			process.exit(1);
		}
	}

	function startMySQL() {
		if(answers.extrafeatures !== undefined && answers.extrafeatures.includes("mysql")) {
			const spinner4 = ora("Connecting to the database").start();
		
			let con = mysql.createConnection({
				host: answers.sqlhost,
				user: answers.sqluser,
				password: answers.sqlpass,
				database: answers.sqldb
			});
			con.connect(function (err) {
				if (err) {
					spinner4.fail("Failed to connect to the database");
					console.log(err);
					process.exit(1);
				} else {
					spinner4.succeed("Connected to the database");
					const spinner5 = ora("Creating table in the database").start();
					sql = "CREATE TABLE warnings (username VARCHAR(255), serverid VARCHAR(255), uid VARCHAR(255), reason VARCHAR(255), id INT AUTO_INCREMENT PRIMARY KEY)";
					con.query(sql, function (err, result) {
						if (err) {
							if (err.code == "ER_TABLE_EXISTS_ERROR") {
								spinner5.warn("Table already exists in the database");
							} else {
								spinner5.fail("Failed to create table in the database");
								console.log(err);
							}
						} else {
							spinner5.succeed("Created table in the database");
						}
						
						
					});
					sql = "DROP TABLE counting";
					con.query(sql, function (err, result) {
						launchyBotty();
					});
				}
			});
		} else {
			launchyBotty();
		}
	}

	// eslint-disable-next-line no-inner-declarations
	function launchyBotty() {
		if (answers.launch) {
			const spinner3 = ora("Starting VukkyBot").start();
			try {
				const npm = require("npm");
				npm.load(() => {
					npm.run("start");
				});
				spinner3.succeed("VukkyBot should start now");
			} catch (err) {
				spinner3.fail("Couldn't start VukkyBot");
				console.log(err);
			}
		} else {
			process.exit(0);
		}
	}
});