import { guarded } from "@/lib/api";
import { sql } from "@/lib/db";

export const GET = guarded(async (req) => {
  const rows = await sql`SELECT id, category, content, source, status, confidence, project_id, source_conversation_id, created_at, updated_at FROM memories ORDER BY created_at`;
  if (req.nextUrl.searchParams.get("format") === "md") {
    const md = [`# Mémoire — Chat SPBoucher AI`, `_${rows.length} éléments, exporté le ${new Date().toLocaleString("fr-CA")}_`, "", ...rows.map(r => `- **[${r.category}]** ${r.content} _(${r.status}, ${r.source})_`)].join("\n");
    return new Response(md, { headers: { "content-type": "text/markdown; charset=utf-8", "content-disposition": 'attachment; filename="memoire.md"' } });
  }
  return new Response(JSON.stringify(rows, null, 2), { headers: { "content-type": "application/json", "content-disposition": 'attachment; filename="memoire.json"' } });
});