refactor(Database): separate providers

1 files changed, 32 insertions, 0 deletions

diff --git a/src/lib/Database/Supabase/groups.ts b/src/lib/Database/Supabase/groups.ts
new file mode 100644
index 00000000..b2770e4a
--- /dev/null
+++ b/src/lib/Database/Supabase/groups.ts
@@ -0,0 +1,32 @@
+import supabase from '../supabase';
+
+export interface Group {
+	id: number;
+	created_at: string;
+	updated_at?: string;
+	members: number[];
+	avatar: string;
+	banner: string;
+	description?: string;
+	name: string;
+	anilist_id: number;
+	anilist_username: string;
+	badge?: string;
+	badge_description?: string;
+}
+
+export const getGroups = async () => {
+	const { data, error } = await supabase.from('groups').select('*');
+
+	if (error) return [];
+
+	return data as Group[];
+};
+
+export const getGroup = async (slug: string) => {
+	const { data, error } = await supabase.from('groups').select('*').eq('anilist_username', slug);
+
+	if (error || data.length === 0) return null;
+
+	return data[0] as Group;
+};