From aa600b666ae733de8662f1c15cfcaebaa13dca06 Mon Sep 17 00:00:00 2001 From: Fuwn Date: Fri, 1 Mar 2024 04:17:12 -0800 Subject: feat(badges): migrate category mode --- src/lib/Database/userBadges.ts | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'src/lib/Database') diff --git a/src/lib/Database/userBadges.ts b/src/lib/Database/userBadges.ts index 1f4b5b5b..4ee47685 100644 --- a/src/lib/Database/userBadges.ts +++ b/src/lib/Database/userBadges.ts @@ -68,3 +68,10 @@ export const renameCategory = async (userId: number, oldName: string, newName: s export const removeAllUserBadges = async (userId: number) => await supabase.from('user_badges').delete().eq('user_id', userId); + +export const migrateCategory = async (userId: number, oldName: string, newName: string) => + await supabase + .from('user_badges') + .update({ category: newName }) + .eq('category', oldName) + .eq('user_id', userId); -- cgit v1.2.3