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

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;
};