From a4d58fa25d6053419506d6e7e5b53d8268845990 Mon Sep 17 00:00:00 2001 From: Fuwn Date: Mon, 5 Feb 2024 19:06:32 -0800 Subject: feat(badges): delete all --- src/lib/Database/badges.ts | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'src/lib/Database') diff --git a/src/lib/Database/badges.ts b/src/lib/Database/badges.ts index e7103185..6df9fd8e 100644 --- a/src/lib/Database/badges.ts +++ b/src/lib/Database/badges.ts @@ -57,3 +57,7 @@ export const updateUserBadge = async (userId: number, id: number, badge: Badge) export const renameCategory = async (userId: number, oldName: string, newName: string) => { await sql`UPDATE user_badges SET category = ${newName} WHERE category = ${oldName} AND user_id = ${userId};`; }; + +export const removeAllUserBadges = async (userId: number) => { + await sql`DELETE FROM user_badges WHERE user_id = ${userId};`; +}; -- cgit v1.2.3