import supabase from './supabase';

interface Event {
	id: number;
	created_at: string;
	updated_at: string;
	title: string;
	description: string;
	group: number;
}

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

export const getEvents = async (group?: number) => {
	let data, error;

	if (group) [data, error] = await supabase.from('events').select('*').eq('group', group);
	else [data, error] = await supabase.from('events').select('*');

	if (error) return [];

	return data as Event[];
};

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

export const deleteEvent = async (id: number) =>
	await supabase.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 supabase.from('events').update(event).eq('id', id);
};