import type { Group } from "$lib/Database/SB/groups";
import sb from "../sb";

export interface Event {
	id: number;
	created_at: string;
	updated_at: string;
	title: string;
	description: string;
	group: Group;
	banner: string;
	anilist_url: string;
}

interface NewEvent {
	updated_at?: string;
	title: string;
	description: string;
}

export const getEvents = async () => {
	const { data, error } = await sb.from("events").select("*, group:groups(*)");

	if (error) return [];

	return data as Event[];
};

export const getGroupEvents = async (group: string) => {
	const { data, error } = await sb
		.from("events")
		.select("*")
		.eq("group", group);

	if (error) return [];

	return data as Event[];
};

export const createEvent = async (event: NewEvent) =>
	await sb.from("events").insert(event);

export const deleteEvent = async (id: number) =>
	await sb.from("events").delete().eq("id", id);

export const updateEvent = async (id: number, event: NewEvent) => {
	if (!event.updated_at) event.updated_at = new Date().toISOString();

	return await sb.from("events").update(event).eq("id", id);
};