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);
};