src/lib/Database/groups.ts


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
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;
};