// Snapshots every published entry from the database back into
// `src/data/problems.json` - the curated seed baseline and the repo's
// disaster-recovery copy of the catalog.
//
// The database is the source of truth (community edits and imports live
// there), so without periodic exports a fresh `db:seed` could only rebuild
// the original launch set. Run `npm run db:export` after significant catalog
// changes and commit the result.
//
// Round-trip safety: the seed upserts curated content by slug and never
// touches votes, comments, status or submitter linkage, so exporting and
// re-seeding a live database is a no-op for user state. On a FRESH database,
// community-submitted entries are recreated as curator entries (the
// submitter accounts don't exist there) - acceptable for recovery.

import { writeFileSync } from "fs";
import { join } from "path";
import { PrismaClient } from "@prisma/client";

const prisma = new PrismaClient();

async function main() {
  const rows = await prisma.problem.findMany({
    where: { status: "published" },
    orderBy: { slug: "asc" },
    include: {
      links: { select: { label: true, url: true }, orderBy: { position: "asc" } },
      relationsFrom: {
        select: { kind: true, note: true, to: { select: { slug: true } } },
        orderBy: { position: "asc" },
      },
    },
  });

  const out = rows.map((p) => {
    const entry: Record<string, unknown> = {
      slug: p.slug,
      name: p.name,
      shortName: p.shortName,
      problemNumber: p.problemNumber,
      field: p.field,
      fieldGroup: p.fieldGroup,
      resolution: p.resolution,
      statement: p.statement,
      posedBy: p.posedBy,
      yearPosed: p.yearPosed,
      solveType: p.solveType,
      solveDate: p.solveDate,
      model: p.model,
      modelMaker: p.modelMaker,
      humanCollaborators: p.humanCollaborators,
      aiRole: p.aiRole,
      verification: p.verification,
      verificationNote: p.verificationNote,
      publication: p.publication,
      resolutionMethod: p.resolutionMethod,
      citations: p.citations,
      citationsPaper: p.citationsPaper,
      citationsSource: p.citationsSource,
      citationsUrl: p.citationsUrl,
      renownLangs: p.renownLangs,
      sourceUrl: p.sourceUrl,
      sourceName: p.sourceName,
    };
    // Optional caveat fields are present only on entries that need them,
    // matching the documented JSON shape.
    if (p.renownNote !== null) entry.renownNote = p.renownNote;
    if (p.resultNote !== null) entry.resultNote = p.resultNote;
    if (p.ageNote !== null) entry.ageNote = p.ageNote;
    if (p.claimIssueNote !== null) entry.claimIssueNote = p.claimIssueNote;
    if (p.aiContribution !== null) entry.aiContribution = p.aiContribution;
    if (p.significance !== null) entry.significance = p.significance;
    if (p.significanceNote !== null) entry.significanceNote = p.significanceNote;
    if (Array.isArray(p.links) && p.links.length > 0) entry.links = p.links;
    if (p.relationsFrom.length > 0) {
      entry.relations = p.relationsFrom.map((r) => ({ to: r.to.slug, kind: r.kind, note: r.note }));
    }
    return entry;
  });

  const path = join(__dirname, "..", "src", "data", "problems.json");
  writeFileSync(path, JSON.stringify(out, null, 2) + "\n");
  console.log(`Exported ${out.length} published entries to src/data/problems.json`);
}

main()
  .catch((error) => {
    console.error(error);
    process.exit(1);
  })
  .finally(() => prisma.$disconnect());