chore: update translations

apps/web/src/views/board/components/UpdateBoardSlugForm.tsx

@@ -167,8 +167,7 @@ export function UpdateBoardSlugForm({
               !isDirty ||
               updateBoardSlug.isPending ||
               errors.slug?.message !== undefined ||
-              isBoardSlugAvailable?.isReserved ||
-              checkBoardSlugAvailability.isLoading
+              isBoardSlugAvailable?.isReserved
             }
           >
             {t`Update`}

packages/api/src/routers/board.ts

@@ -276,21 +276,6 @@ export const boardRouter = createTRPCRouter({
 
       await assertUserInWorkspace(ctx.db, userId, board.workspaceId);
 
-      if (input.slug) {
-        const isBoardSlugAvailable = await boardRepo.isBoardSlugAvailable(
-          ctx.db,
-          input.slug,
-          board.workspaceId,
-        );
-
-        if (!isBoardSlugAvailable) {
-          throw new TRPCError({
-            message: `Board slug ${input.slug} is not available`,
-            code: "BAD_REQUEST",
-          });
-        }
-      }
-
       const result = await boardRepo.update(ctx.db, {
         name: input.name,
         slug: input.slug,
@@ -422,23 +407,11 @@ export const boardRouter = createTRPCRouter({
       }),
     )
     .query(async ({ ctx, input }) => {
-      const board = await boardRepo.getWorkspaceAndBoardIdByBoardPublicId(
-        ctx.db,
-        input.boardPublicId,
-      );
-
-      if (!board)
-        throw new TRPCError({
-          message: `Board with public ID ${input.boardPublicId} not found`,
-          code: "NOT_FOUND",
-        });
-
       const isBoardSlugAvailable = await boardRepo.isBoardSlugAvailable(
         ctx.db,
         input.boardSlug,
-        board.workspaceId,
+        input.boardPublicId,
       );
-
       return {
         isReserved: !isBoardSlugAvailable,
       };

packages/auth/src/auth.ts

@@ -166,19 +166,9 @@ export const initAuth = (db: dbClient) => {
     databaseHooks: {
       user: {
         create: {
-          async before(user) {
+          before() {
             if (env("NEXT_PUBLIC_DISABLE_SIGN_UP")?.toLowerCase() === "true") {
-              const pendingInvitation = await memberRepo.getByEmailAndStatus(
-                db,
-                user.email,
-                "invited",
-              );
-
-              if (!pendingInvitation) {
-                return Promise.resolve(false);
-              }
-
-              return Promise.resolve(true);
+              return Promise.resolve(false);
             }
             return Promise.resolve(true);
           },

packages/db/src/repository/board.repo.ts

@@ -1,4 +1,4 @@
-import { and, asc, desc, eq, inArray, isNull, or } from "drizzle-orm";
+import { and, asc, desc, eq, exists, inArray, isNull, or, sql } from "drizzle-orm";
 
 import type { dbClient } from "@kan/db/client";
 import type { BoardVisibilityStatus } from "@kan/db/schema";
@@ -481,18 +481,30 @@ export const getWorkspaceAndBoardIdByBoardPublicId = async (
 export const isBoardSlugAvailable = async (
   db: dbClient,
   boardSlug: string,
-  workspaceId: number,
+  boardPublicId: string,
 ) => {
-  const result = await db.query.boards.findFirst({
-    columns: {
-      id: true,
-    },
-    where: and(
-      eq(boards.slug, boardSlug),
-      eq(boards.workspaceId, workspaceId),
-      isNull(boards.deletedAt),
-    ),
-  });
+  const result = await db
+    .select({ id: boards.id })
+    .from(boards)
+    .where(
+      and(
+        eq(boards.publicId, boardPublicId),
+        exists(
+          db
+            .select({ id: boards.id })
+            .from(boards)
+            .where(
+              and(
+                eq(boards.slug, boardSlug),
+                eq(boards.workspaceId, sql`${boards.workspaceId}`), // Reference outer query's workspaceId
+                isNull(boards.deletedAt),
+              ),
+            )
+            .limit(1),
+        ),
+      ),
+    )
+    .limit(1);
 
-  return result === undefined;
+  return result.length === 0;
 };

packages/db/src/repository/member.repo.ts

@@ -41,20 +41,6 @@ export const getByPublicId = async (db: dbClient, publicId: string) => {
   });
 };
 
-export const getByEmailAndStatus = async (
-  db: dbClient,
-  email: string,
-  status: MemberStatus,
-) => {
-  return db.query.workspaceMembers.findFirst({
-    where: and(
-      eq(workspaceMembers.email, email),
-      eq(workspaceMembers.status, status),
-      isNull(workspaceMembers.deletedAt),
-    ),
-  });
-};
-
 export const acceptInvite = async (
   db: dbClient,
   args: { memberId: number; userId: string },