feature: Allow users to delete all unused tags in one go

2 files changed, 38 insertions, 2 deletions

diff --git a/packages/shared-react/hooks/tags.ts b/packages/shared-react/hooks/tags.ts
index d3129fed..6ce0f0c9 100644
--- a/packages/shared-react/hooks/tags.ts
+++ b/packages/shared-react/hooks/tags.ts
@@ -53,3 +53,17 @@ export function useDeleteTag(
     },
   });
 }
+
+export function useDeleteUnusedTags(
+  ...opts: Parameters<typeof api.tags.deleteUnused.useMutation>
+) {
+  const apiUtils = api.useUtils();
+
+  return api.tags.deleteUnused.useMutation({
+    ...opts[0],
+    onSuccess: (res, req, meta) => {
+      apiUtils.tags.list.invalidate();
+      return opts[0]?.onSuccess?.(res, req, meta);
+    },
+  });
+}
diff --git a/packages/trpc/routers/tags.ts b/packages/trpc/routers/tags.ts
index b95570ae..dc70b068 100644
--- a/packages/trpc/routers/tags.ts
+++ b/packages/trpc/routers/tags.ts
@@ -1,5 +1,5 @@
 import { experimental_trpcMiddleware, TRPCError } from "@trpc/server";
-import { and, eq, inArray } from "drizzle-orm";
+import { and, eq, inArray, notExists } from "drizzle-orm";
 import { z } from "zod";
 
 import type { ZAttachedByEnum } from "@hoarder/shared/types/tags";
@@ -115,6 +115,28 @@ export const tagsAppRouter = router({
       }
       // TODO: Update affected bookmarks in search index
     }),
+  deleteUnused: authedProcedure
+    .output(
+      z.object({
+        deletedTags: z.number(),
+      }),
+    )
+    .mutation(async ({ ctx }) => {
+      const res = await ctx.db
+        .delete(bookmarkTags)
+        .where(
+          and(
+            eq(bookmarkTags.userId, ctx.user.id),
+            notExists(
+              ctx.db
+                .select({ id: tagsOnBookmarks.tagId })
+                .from(tagsOnBookmarks)
+                .where(eq(tagsOnBookmarks.tagId, bookmarkTags.id)),
+            ),
+          ),
+        );
+      return { deletedTags: res.changes };
+    }),
   update: authedProcedure
     .input(
       z.object({
@@ -261,7 +283,7 @@ export const tagsAppRouter = router({
                   tagId: input.intoTagId,
                 })),
               )
-              .onConflictDoNothing()
+              .onConflictDoNothing();
           }
 
           // Delete the old tags