From e234d3535c363664902dffe89a2c61ddbc037da4 Mon Sep 17 00:00:00 2001
From: MohamedBassem <me@mbassem.com>
Date: Fri, 23 Feb 2024 19:27:31 +0000
Subject: db: Migrate from prisma to drizzle

---
 packages/web/server/api/routers/apiKeys.ts | 23 ++++++++++-------------
 1 file changed, 10 insertions(+), 13 deletions(-)

(limited to 'packages/web/server/api/routers/apiKeys.ts')

diff --git a/packages/web/server/api/routers/apiKeys.ts b/packages/web/server/api/routers/apiKeys.ts
index 620ca223..eade5eec 100644
--- a/packages/web/server/api/routers/apiKeys.ts
+++ b/packages/web/server/api/routers/apiKeys.ts
@@ -1,7 +1,9 @@
 import { generateApiKey } from "@/server/auth";
 import { authedProcedure, router } from "../trpc";
-import { prisma } from "@hoarder/db";
+import { db } from "@hoarder/db";
 import { z } from "zod";
+import { apiKeys } from "@hoarder/db/schema";
+import { eq, and } from "drizzle-orm";
 
 export const apiKeysAppRouter = router({
   create: authedProcedure
@@ -29,13 +31,10 @@ export const apiKeysAppRouter = router({
     )
     .output(z.object({}))
     .mutation(async ({ input, ctx }) => {
-      const resp = await prisma.apiKey.delete({
-        where: {
-          id: input.id,
-          userId: ctx.user.id,
-        },
-      });
-      return resp;
+      await db
+        .delete(apiKeys)
+        .where(and(eq(apiKeys.id, input.id), eq(apiKeys.userId, ctx.user.id)))
+        .returning();
     }),
   list: authedProcedure
     .output(
@@ -51,11 +50,9 @@ export const apiKeysAppRouter = router({
       }),
     )
     .query(async ({ ctx }) => {
-      const resp = await prisma.apiKey.findMany({
-        where: {
-          userId: ctx.user.id,
-        },
-        select: {
+      const resp = await db.query.apiKeys.findMany({
+        where: eq(apiKeys.userId, ctx.user.id),
+        columns: {
           id: true,
           name: true,
           createdAt: true,
-- 
cgit v1.2.3-70-g09d2