import { createClient } from "@supabase/supabase-js";
import { requirePermission } from "@/lib/authz";

export async function GET() {
    await requirePermission("canViewSettings");
    
    const supabase = createClient(
        process.env.NEXT_PUBLIC_SUPABASE_URL!,
        process.env.SUPABASE_SERVICE_ROLE_KEY!
    );

    // Seed brands
    for (const brand of BRANDS) {
        const { data: existing } = await supabase
            .from('brands')
            .select('id')
            .eq('slug', brand.slug)
            .maybeSingle();

        if (!existing) {
            await supabase.from('brands').insert({
                name: brand.name,
                slug: brand.slug
            });
        }
    }

    // Seed locations linked to brands
    for (const loc of LOCATIONS) {
        const brandId = allBrands.find(b => b.slug === loc.brand_slug)?.id;
        
        const { data: existingLoc } = await supabase
            .from('locations')
            .select('id')
            .eq('name', loc.name)
            .maybeSingle();

        if (!existingLoc) {
            await supabase.from('locations').insert({
                name: loc.name,
                city: loc.city,
                address: loc.address,
                brand_id: brandId
            });
        }
    }
}