diff options
| author | Fuwn <[email protected]> | 2024-02-11 13:01:09 -0800 |
|---|---|---|
| committer | Fuwn <[email protected]> | 2024-02-11 13:01:09 -0800 |
| commit | 72ba3a33d8a989ded2bc96b0dbd0e4fd8553d07f (patch) | |
| tree | 96ad6d59e0cee3b8dd7470339fe3f79055a2deba /src/lib/Database/badges.ts | |
| parent | feat(database): implement event badges database (diff) | |
| download | due.moe-72ba3a33d8a989ded2bc96b0dbd0e4fd8553d07f.tar.xz due.moe-72ba3a33d8a989ded2bc96b0dbd0e4fd8553d07f.zip | |
refactor(database): rename badges
Diffstat (limited to 'src/lib/Database/badges.ts')
| -rw-r--r-- | src/lib/Database/badges.ts | 69 |
1 files changed, 0 insertions, 69 deletions
diff --git a/src/lib/Database/badges.ts b/src/lib/Database/badges.ts deleted file mode 100644 index 8816ac40..00000000 --- a/src/lib/Database/badges.ts +++ /dev/null @@ -1,69 +0,0 @@ -import { databaseTimeToDate } from '$lib/Utility/time'; -import supabase from './supabase'; - -export interface Badge { - post?: string; - image?: string; - description?: string; - id?: number; - time?: string; - category?: string; -} - -export const getUserBadges = async (userId: number): Promise<Badge[]> => { - const { data, error } = await supabase.from('user_badges').select('*').eq('user_id', userId); - - if (error) return []; - - return data.sort((a, b) => - databaseTimeToDate((a as Badge).time ?? '').getTime() > - databaseTimeToDate((b as Badge).time ?? '').getTime() - ? -1 - : 1 - ) as Badge[]; -}; - -export const addUserBadge = async (userId: number, badge: Badge) => { - const { post, image, description, time, category } = badge; - - if (post === undefined || image === undefined) return; - - if (time) { - await supabase - .from('user_badges') - .insert({ user_id: userId, post, image, description, time, category }); - } else { - await supabase - .from('user_badges') - .insert({ user_id: userId, post, image, description, category }); - } -}; - -export const removeUserBadge = async (userId: number, id: number) => { - if (!isNaN(id)) await supabase.from('user_badges').delete().eq('id', id).eq('user_id', userId); -}; - -export const updateUserBadge = async (userId: number, id: number, badge: Badge) => { - if (badge.post === undefined || badge.image === undefined) return; - - await supabase - .from('user_badges') - .update({ - post: badge.post, - image: badge.image, - description: badge.description, - category: badge.category - }) - .eq('id', id) - .eq('user_id', userId); -}; - -export const renameCategory = async (userId: number, oldName: string, newName: string) => - await supabase - .from('user_badges') - .update({ category: newName }) - .eq('category', oldName) - .eq('user_id', userId); - -export const removeAllUserBadges = async (userId: number) => - await supabase.from('user_badges').delete().eq('user_id', userId); |