import { generatePageContent } from "./content";
import { getPriorityStaticParams, resolveSeoPage } from "./registry";
import type { SeoPageBulkRow } from "@/types/seoPage";

/** Monta payload para sincronizar páginas prioritárias com a tabela seo_pages. */
export function buildPriorityPagesForDb(limit = 200): SeoPageBulkRow[] {
  const rows: SeoPageBulkRow[] = [];

  for (const { slug } of getPriorityStaticParams().slice(0, limit)) {
    const ctx = resolveSeoPage(slug);
    if (!ctx) continue;

    const content = generatePageContent(ctx);
    rows.push({
      slug: ctx.slug,
      title: content.title,
      metaDescription: content.metaDescription,
      keywords: content.keywords.join(", "),
      city: ctx.city?.name ?? null,
      state: ctx.state?.name ?? null,
      segment: ctx.segment?.slug ?? null,
      service: ctx.service?.slug ?? null,
      canonicalUrl: content.canonicalPath,
      faq: content.faq,
      contentBlocks: content.blocks,
      active: true,
    });
  }

  return rows;
}