aboutsummaryrefslogtreecommitdiff
path: root/src/lib/Database/badges.ts
diff options
context:
space:
mode:
Diffstat (limited to 'src/lib/Database/badges.ts')
-rw-r--r--src/lib/Database/badges.ts69
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);