src/lib/Database/SB/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
33
34
35

import sb from "../sb.server";

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 sb.from("groups").select("*");

	if (error) return [];

	return data as Group[];
};

export const getGroup = async (slug: string) => {
	const { data, error } = await sb
		.from("groups")
		.select("*")
		.eq("anilist_username", slug);

	if (error || data.length === 0) return null;

	return data[0] as Group;
};