delete.ts

import { Command, Flags } from "@oclif/core";
import axios from "axios";
import chalk from "chalk";
import inquirer from "inquirer";

import { getProject, getProjects, type Database } from "../../../utils/shared.js";
import { readAuthConfig } from "../../../utils/utils.js";
import { readLocalConfig } from "../../../utils/local-config.js";

export default class DatabaseMariadbDelete extends Command {
	static description = "Delete a MariaDB database from a project.";
	static examples = [
		"$ <%= config.bin %> mariadb delete",
		"$ <%= config.bin %> mariadb delete -p <projectId>",
	];
	static flags = {
		projectId: Flags.string({
			char: "p",
			description: "ID of the project",
			required: false,
		}),
		environmentId: Flags.string({
			char: "e",
			description: "ID of the environment",
			required: false,
		}),
		mariadbId: Flags.string({
			char: "m",
			description: "ID of the MariaDB instance to delete",
			required: false,
		}),
		skipConfirm: Flags.boolean({
			char: "y",
			description: "Skip confirmation prompt",
			default: false,
		}),
	};

	public async run(): Promise<void> {
		const auth = await readAuthConfig(this);
		const { flags } = await this.parse(DatabaseMariadbDelete);
		let { projectId, environmentId, mariadbId } = flags;

		const localConfig = readLocalConfig();
		if (!projectId && localConfig.projectId) projectId = localConfig.projectId;
		if (!environmentId && localConfig.environmentId) environmentId = localConfig.environmentId;

		if (!projectId || !environmentId || !mariadbId) {
			console.log(chalk.blue.bold("\n  Listing all Projects \n"));
			const projects = await getProjects(auth, this);

			let selectedProject;
			let selectedEnvironment;

			// 1. Seleccionar proyecto
			if (!projectId) {
				const answers = await inquirer.prompt([
					{
						choices: projects.map((project) => ({
							name: project.name,
							value: project.projectId,
						})),
						message: "Select a project to delete the MariaDB instance from:",
						name: "selectedProject",
						type: "list",
					},
				]);
				selectedProject = projects.find(p => p.projectId === answers.selectedProject);
				projectId = answers.selectedProject;
			} else {
				selectedProject = projects.find(p => p.projectId === projectId);
			}

			// 2. Seleccionar environment del proyecto
			if (!environmentId) {
				if (!selectedProject?.environments || selectedProject.environments.length === 0) {
					this.error(chalk.yellow("No environments found in this project."));
				}

				const { environment } = await inquirer.prompt([
						{
							choices: selectedProject.environments.map((env) => ({
								name: `${env.name} (${env.description})`,
								value: env,
							})),
							message: "Select an environment:",
							name: "environment",
							type: "list",
						},
					]);
					selectedEnvironment = environment;
					environmentId = environment.environmentId;
				} else {
					selectedEnvironment = selectedProject?.environments?.find(e => e.environmentId === environmentId);
				}

			// 3. Seleccionar MariaDB del environment
			if (!mariadbId) {
				if (!selectedEnvironment?.mariadb || selectedEnvironment.mariadb.length === 0) {
					this.error(chalk.yellow("No MariaDB instances found in this environment."));
				}

				const dbAnswers = await inquirer.prompt([
						{
							choices: selectedEnvironment.mariadb.map((db: Database) => ({
								name: db.name,
								value: db.mariadbId,
							})),
							message: "Select the MariaDB instance to delete:",
							name: "selectedDb",
							type: "list",
						},
					]);
					mariadbId = dbAnswers.selectedDb;
				}
		}

		if (!flags.skipConfirm) {
			const confirmAnswers = await inquirer.prompt([
				{
					default: false,
					message: "Are you sure you want to delete this MariaDB instance?",
					name: "confirmDelete",
					type: "confirm",
				},
			]);

			if (!confirmAnswers.confirmDelete) {
				this.error(chalk.yellow("MariaDB deletion cancelled."));
			}
		}

		try {
			const response = await axios.post(
				`${auth.url}/api/trpc/mariadb.remove`,
				{
					json: {
						mariadbId,
					},
				},
				{
					headers: {
						"x-api-key": auth.token,
						"Content-Type": "application/json",
					},
				},
			);

			if (!response.data.result.data.json) {
				this.error(chalk.red("Error deleting MariaDB instance"));
			}
			this.log(chalk.green("MariaDB instance deleted successfully."));
		} catch (error: any) {
			this.error(chalk.red(`Error deleting MariaDB instance: ${error.message}`));
		}
	}
}