db: Migrate from prisma to drizzle

1 files changed, 13 insertions, 11 deletions

diff --git a/packages/web/server/api/routers/users.ts b/packages/web/server/api/routers/users.ts
index aecec1d4..032385ac 100644
--- a/packages/web/server/api/routers/users.ts
+++ b/packages/web/server/api/routers/users.ts
@@ -1,9 +1,10 @@
 import { zSignUpSchema } from "@/lib/types/api/users";
 import { publicProcedure, router } from "../trpc";
-import { Prisma, prisma } from "@hoarder/db";
+import { SqliteError, db } from "@hoarder/db";
 import { z } from "zod";
 import { hashPassword } from "@/server/auth";
 import { TRPCError } from "@trpc/server";
+import { users } from "@hoarder/db/schema";
 
 export const usersAppRouter = router({
   create: publicProcedure
@@ -16,20 +17,21 @@ export const usersAppRouter = router({
     )
     .mutation(async ({ input }) => {
       try {
-        return await prisma.user.create({
-          data: {
+        const result = await db
+          .insert(users)
+          .values({
             name: input.name,
             email: input.email,
             password: await hashPassword(input.password),
-          },
-          select: {
-            name: true,
-            email: true,
-          },
-        });
+          })
+          .returning({
+            name: users.name,
+            email: users.email,
+          });
+        return result[0];
       } catch (e) {
-        if (e instanceof Prisma.PrismaClientKnownRequestError) {
-          if (e.code === "P2002") {
+        if (e instanceof SqliteError) {
+          if (e.code == "SQLITE_CONSTRAINT_UNIQUE") {
             throw new TRPCError({
               code: "BAD_REQUEST",
               message: "Email is already taken",