diff options
| author | Fuwn <[email protected]> | 2024-01-24 22:33:52 -0800 |
|---|---|---|
| committer | Fuwn <[email protected]> | 2024-01-24 22:33:52 -0800 |
| commit | ce7d8decaeb722115fabdfc3f16b3a4a42adcc34 (patch) | |
| tree | 0ccc1718fd7bf579c5a504c243e8b8428102a37c /src/lib/Database | |
| parent | feat(settings): hard localise feedback (diff) | |
| download | due.moe-ce7d8decaeb722115fabdfc3f16b3a4a42adcc34.tar.xz due.moe-ce7d8decaeb722115fabdfc3f16b3a4a42adcc34.zip | |
feat(database): add rename category server implementation
Diffstat (limited to 'src/lib/Database')
| -rw-r--r-- | src/lib/Database/badges.ts | 4 |
1 files changed, 4 insertions, 0 deletions
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};`; +}; |