import { supabaseServiceRole } from '@/lib/supabase';
import type { APIRoute } from 'astro';

export const POST: APIRoute = async ({ request }) => {
  const headers = { 'Content-Type': 'application/json' };

  if (!supabaseServiceRole) {
    return new Response(JSON.stringify({ success: false, message: 'Service unavailable' }), {
      status: 503,
      headers,
    });
  }

  try {
    const { userId } = await request.json();

    if (!userId) {
      return new Response(JSON.stringify({ success: false, message: 'User ID required' }), {
        status: 400,
        headers,
      });
    }

    const { data: profile, error } = await supabaseServiceRole
      .from('profiles')
      .select('*')
      .eq('workos_user_id', userId)
      .single();

    if (error && error.code !== 'PGRST116') {
      return new Response(JSON.stringify({ success: false, message: 'Failed to fetch profile' }), {
        status: 500,
        headers,
      });
    }

    return new Response(JSON.stringify({ success: true, profile: profile || null }), {
      status: 200,
      headers,
    });
  } catch {
    return new Response(JSON.stringify({ success: false, message: 'Internal server error' }), {
      status: 500,
      headers,
    });
  }
};