src/lib/Database/SB/badges.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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57

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

interface Badge {
	id: number;
	created_at: string;
	updated_at: string;
	image_url: string;
	image_artist: string;
	description: string;
	event: number;
	group: number;
}

interface NewBadge {
	updated_at?: string;
	image_url: string;
	image_artist: string;
	description: string;
}

interface GetBy {
	event?: number;
	group?: number;
}

export const getBadges = async (getBy?: GetBy) => {
	let data: unknown[] | null = null;
	let error: unknown = null;

	if (getBy?.event)
		[data, error] = await sb
			.from("badges")
			.select("*")
			.eq("event", getBy.event);
	else if (getBy?.group)
		[data, error] = await sb
			.from("badges")
			.select("*")
			.eq("group", getBy.group);
	else [data, error] = await sb.from("badges").select("*");

	if (error) return [];

	return data as Badge[];
};

export const createBadge = async (badge: NewBadge) =>
	await sb.from("badges").insert(badge);

export const deleteBadge = async (id: number) =>
	await sb.from("badges").delete().eq("id", id);

export const updateBadge = async (id: number, badge: NewBadge) => {
	if (!badge.updated_at) badge.updated_at = new Date().toISOString();

	return await sb.from("badges").update(badge).eq("id", id);
};