refactor(Data): rename database references

1 files changed, 45 insertions, 0 deletions

diff --git a/src/lib/Database/SB/events.ts b/src/lib/Database/SB/events.ts
new file mode 100644
index 00000000..4691f158
--- /dev/null
+++ b/src/lib/Database/SB/events.ts
@@ -0,0 +1,45 @@
+import type Group from '$lib/Events/Group.svelte';
+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);
+};