frontend/app/api/admin/users/route.ts

export const revalidate = 10;

import { createClient } from '@supabase/supabase-js';
import { NextRequest, NextResponse } from "next/server";

// GET request to retrieve the users data from the database
export async function GET(request: NextRequest) {
    // Create a new Supabase client

    const supabase = createClient(
        process.env.SUPABASE_URL ?? '',
        process.env.SUPABASE_SERVICE_ROLE_KEY ?? '',
        { db: { schema: 'public' } },
    );

    const { data: usersData, error: usersError } = await supabase
        .from('users')
        .select(`
            id,
            name,
            email,
            admins (
                id
            )
        `);

    if (usersError) {
        console.error('Error fetching users data from database:', usersError.message);
        return NextResponse.json({ error: usersError.message }, { status: 500 });
    }

    // console.log('usersData:', usersData);

    return NextResponse.json({ users: usersData });
}