Function fetchUserProfile

apps/cursor/src/data/queries.ts:33–67

(slug: string, userId?: string)

import { fetchAllPages } from "@/utils/supabase/pagination";

async function fetchUserProfile(slug: string, userId?: string) {
  const supabase = await createClient();

  const query = supabase
    .from("users")
    .select(
      "id, name, image, hero, status, bio, work, website, slug, social_x_link, created_at, public, follow_email, is_ambassador, is_following, follower_count, following_count",
    )
    .eq("slug", slug);

  if (userId) {
    query.eq("id", userId);
  } else {
    query.eq("public", true);
  }

  const { data } = await query.single();

  if (!data) {
    return {
      data: null,
    };
  }

  const isOwner = userId && data.id === userId;

  return {
    data: {
      ...data,
      follow_email: isOwner ? data.follow_email : undefined,
      following_count: data?.following_count || 0,
      followers_count: data?.follower_count || 0,
    },
  };
}

async function getPublicUserProfile(slug: string) {
  "use cache";