update not working

export async function PATCH(request: NextRequest) {
  const body = (await request.json()) as Partial<
    Omit<Profile, "uuid" | "stripeId">
  >;

  const supabase = supabaseApiClient();
  const { data, error } = await supabase.auth.getUser();

  if (error) {
    return NextResponse.json(error, { status: error.status });
  }

  const profileUpdate = await db.transaction(async (tx) => {
    await setTxAuthUUID(tx, data.user.id);
    await setTxAuthedRole(tx);

    try {
      await tx
        .update(profiles)
        .set({ ...body })
        .where(eq(profiles.uuid, data.user.id));

      return true;
    } catch (error) {
      return false;
    }
  });

  if (profileUpdate) {
    return NextResponse.json({}, { status: 201 });
  } else {
    return NextResponse.json({}, { status: 400 });
  }
}

export async function PATCH(request: NextRequest) {
  const body = (await request.json()) as Partial<
    Omit<Profile, "uuid" | "stripeId">
  >;

  const supabase = supabaseApiClient();
  const { data, error } = await supabase.auth.getUser();

  if (error) {
    return NextResponse.json(error, { status: error.status });
  }

  const profileUpdate = await db.transaction(async (tx) => {
    await setTxAuthUUID(tx, data.user.id);
    await setTxAuthedRole(tx);

    try {
      await tx
        .update(profiles)
        .set({ ...body })
        .where(eq(profiles.uuid, data.user.id));

      return true;
    } catch (error) {
      return false;
    }
  });

  if (profileUpdate) {
    return NextResponse.json({}, { status: 201 });
  } else {
    return NextResponse.json({}, { status: 400 });
  }
}