refactor(Data): rename database references

1 files changed, 32 insertions, 0 deletions

diff --git a/src/lib/Database/SB/groups.ts b/src/lib/Database/SB/groups.ts
new file mode 100644
index 00000000..90bee45f
--- /dev/null
+++ b/src/lib/Database/SB/groups.ts
@@ -0,0 +1,32 @@
+import sb from '../sb';
+
+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;
+};