diff options
Diffstat (limited to 'src/lib/Database/Supabase/badges.ts')
| -rw-r--r-- | src/lib/Database/Supabase/badges.ts | 49 |
1 files changed, 0 insertions, 49 deletions
diff --git a/src/lib/Database/Supabase/badges.ts b/src/lib/Database/Supabase/badges.ts deleted file mode 100644 index 022d4d14..00000000 --- a/src/lib/Database/Supabase/badges.ts +++ /dev/null @@ -1,49 +0,0 @@ -import supabase from '../supabase'; - -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, error; - - if (getBy?.event) - [data, error] = await supabase.from('badges').select('*').eq('event', getBy.event); - else if (getBy?.group) - [data, error] = await supabase.from('badges').select('*').eq('group', getBy.group); - else [data, error] = await supabase.from('badges').select('*'); - - if (error) return []; - - return data as Badge[]; -}; - -export const createBadge = async (badge: NewBadge) => await supabase.from('badges').insert(badge); - -export const deleteBadge = async (id: number) => - await supabase.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 supabase.from('badges').update(badge).eq('id', id); -}; |