import { executeQuery } from "~/lib/db";
import { responseMessage } from "~/lib/db";

type iBody = {
	itemID: string | number;
};

async function getItems(itemType: string, fullsuitID: string) {
	const items = await executeQuery({
		query: `
			SELECT
				*
			FROM
				fullsuit_items
			WHERE
				itemType='${itemType}'
				and fullsuitID=${fullsuitID}
		`,
	});

	return items;
}

async function addItem(fullsuitID: string, itemType: string, itemID: string) {
	const result = await executeQuery({
		query: `
		INSERT INTO fullsuit_items (
			fullsuitID,
			itemID,
			itemType
		) VALUES (
			${fullsuitID},
			${itemID},
			'${itemType}'
		)
	`,
	});

	return responseMessage("add suit item", itemType, result);
}

async function deleteItem({
	fullsuitID,
	itemID,
}: {
	fullsuitID: string;
	itemID: string;
}) {
	const query = `
			DELETE
			FROM	fullsuit_items
			WHERE	fullsuitID=${fullsuitID}
					AND itemID=${itemID}
	`;

	const result = await executeQuery({ query });

	return result;
}

export default {
	getItems,
	addItem,
	deleteItem,
};