From ce7d8decaeb722115fabdfc3f16b3a4a42adcc34 Mon Sep 17 00:00:00 2001
From: Fuwn <contact@fuwn.me>
Date: Wed, 24 Jan 2024 22:33:52 -0800
Subject: feat(database): add rename category server implementation

---
 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 162d6c6f..e7103185 100644
--- a/src/lib/Database/badges.ts
+++ b/src/lib/Database/badges.ts
@@ -53,3 +53,7 @@ export const updateUserBadge = async (userId: number, id: number, badge: Badge)
 		badge.category || null
 	} WHERE id = ${id} AND user_id = ${userId};`;
 };
+
+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};`;
+};
-- 
cgit v1.2.3