feat(database): events implementation

3 files changed, 47 insertions, 6 deletions

diff --git a/src/lib/Database/badges.ts b/src/lib/Database/badges.ts
index afed09a4..8816ac40 100644
--- a/src/lib/Database/badges.ts
+++ b/src/lib/Database/badges.ts
@@ -1,5 +1,5 @@
 import { databaseTimeToDate } from '$lib/Utility/time';
-import { createClient } from '@supabase/supabase-js';
+import supabase from './supabase';
 
 export interface Badge {
 	post?: string;
@@ -10,11 +10,6 @@ export interface Badge {
 	category?: string;
 }
 
-const supabase = createClient(
-	process.env.SUPABASE_URL as string,
-	process.env.SUPABASE_ANON_KEY as string
-);
-
 export const getUserBadges = async (userId: number): Promise<Badge[]> => {
 	const { data, error } = await supabase.from('user_badges').select('*').eq('user_id', userId);
 
diff --git a/src/lib/Database/events.ts b/src/lib/Database/events.ts
new file mode 100644
index 00000000..714bd446
--- /dev/null
+++ b/src/lib/Database/events.ts
@@ -0,0 +1,38 @@
+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);
+};
diff --git a/src/lib/Database/supabase.ts b/src/lib/Database/supabase.ts
new file mode 100644
index 00000000..92bd515d
--- /dev/null
+++ b/src/lib/Database/supabase.ts
@@ -0,0 +1,8 @@
+import { createClient } from '@supabase/supabase-js';
+
+const supabase = createClient(
+	process.env.SUPABASE_URL as string,
+	process.env.SUPABASE_ANON_KEY as string
+);
+
+export default supabase;