feat(badges): move badge operations to graphql

1 files changed, 72 insertions, 76 deletions

diff --git a/src/lib/Database/SB/User/badges.ts b/src/lib/Database/SB/User/badges.ts
index 14f848c5..bea8f3e3 100644
--- a/src/lib/Database/SB/User/badges.ts
+++ b/src/lib/Database/SB/User/badges.ts
@@ -2,105 +2,101 @@ import { databaseTimeToDate } from '$lib/Utility/time';
 import sb from '../../sb';
 
 export interface Badge {
-	post?: string;
-	image?: string;
-	description?: string | null;
-	id?: number;
-	time?: string;
-	category?: string | null;
-	hidden?: boolean;
-	source?: string | null;
-	designer?: string | null;
-	shadow_hidden?: boolean;
-	click_count?: number;
+  post?: string;
+  image?: string;
+  description?: string | null;
+  id?: number;
+  time?: string;
+  category?: string | null;
+  hidden?: boolean;
+  source?: string | null;
+  designer?: string | null;
+  shadow_hidden?: boolean;
+  click_count?: number;
 }
 
 export const getUserBadges = async (userId: number): Promise<Badge[]> => {
-	const { data, error } = await sb.from('user_badges').select('*').eq('user_id', userId);
+  const { data, error } = await sb.from('user_badges').select('*').eq('user_id', userId);
 
-	if (error) return [];
+  if (error) return [];
 
-	return data.sort((a, b) =>
-		databaseTimeToDate((a as Badge).time ?? '').getTime() >
-		databaseTimeToDate((b as Badge).time ?? '').getTime()
-			? -1
-			: 1
-	) as Badge[];
+  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, hidden, source, designer } = badge;
-
-	if (post === undefined || image === undefined) return;
-
-	if (time) {
-		await sb.from('user_badges').insert({
-			user_id: userId,
-			post,
-			image,
-			description,
-			time,
-			category,
-			hidden,
-			source,
-			designer
-		});
-	} else {
-		await sb
-			.from('user_badges')
-			.insert({ user_id: userId, post, image, description, category, hidden, source, designer });
-	}
+  const { post, image, description, time, category, hidden, source, designer } = badge;
+
+  if (post === undefined || image === undefined) return;
+
+  if (time) {
+    await sb.from('user_badges').insert({
+      user_id: userId,
+      post,
+      image,
+      description,
+      time,
+      category,
+      hidden,
+      source,
+      designer
+    });
+  } else {
+    await sb
+      .from('user_badges')
+      .insert({ user_id: userId, post, image, description, category, hidden, source, designer });
+  }
 };
 
 export const removeUserBadge = async (userId: number, id: number) => {
-	if (!isNaN(id)) await sb.from('user_badges').delete().eq('id', id).eq('user_id', userId);
+  if (!isNaN(id)) await sb.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 sb
-		.from('user_badges')
-		.update({
-			post: badge.post,
-			image: badge.image,
-			description: badge.description,
-			category: badge.category,
-			time: badge.time,
-			hidden: badge.hidden,
-			source: badge.source,
-			designer: badge.designer
-		})
-		.eq('id', id)
-		.eq('user_id', userId);
+  if (badge.post === undefined || badge.image === undefined) return;
+
+  await sb
+    .from('user_badges')
+    .update({
+      post: badge.post,
+      image: badge.image,
+      description: badge.description,
+      category: badge.category,
+      time: badge.time,
+      hidden: badge.hidden,
+      source: badge.source,
+      designer: badge.designer
+    })
+    .eq('id', id)
+    .eq('user_id', userId);
 };
 
 export const renameCategory = async (userId: number, oldName: string, newName: string) =>
-	await sb
-		.from('user_badges')
-		.update({ category: newName })
-		.eq('category', oldName)
-		.eq('user_id', userId);
+  await sb
+    .from('user_badges')
+    .update({ category: newName })
+    .eq('category', oldName)
+    .eq('user_id', userId);
 
 export const removeAllUserBadges = async (userId: number) =>
-	await sb.from('user_badges').delete().eq('user_id', userId);
+  await sb.from('user_badges').delete().eq('user_id', userId);
 
 export const migrateCategory = async (userId: number, oldName: string, newName: string) =>
-	await sb
-		.from('user_badges')
-		.update({ category: newName })
-		.eq('category', oldName)
-		.eq('user_id', userId);
+  await sb
+    .from('user_badges')
+    .update({ category: newName })
+    .eq('category', oldName)
+    .eq('user_id', userId);
 
 export const setShadowHidden = async (userId: number, shadowHide: boolean) =>
-	await sb.from('user_badges').update({ shadow_hidden: shadowHide }).eq('user_id', userId);
+  await sb.from('user_badges').update({ shadow_hidden: shadowHide }).eq('user_id', userId);
 
-export const setShadowHiddenBadge = async (userId: number, id: number, shadowHide: boolean) =>
-	await sb
-		.from('user_badges')
-		.update({ shadow_hidden: shadowHide })
-		.eq('id', id)
-		.eq('user_id', userId);
+export const setShadowHiddenBadge = async (id: number, shadowHide: boolean) =>
+  await sb.from('user_badges').update({ shadow_hidden: shadowHide }).eq('id', id);
 
 export const incrementClickCount = async (id: number) =>
-	await sb.rpc('user_badges_increment_click_count', { user_badge_id: id });
+  await sb.rpc('user_badges_increment_click_count', { user_badge_id: id });