export const prerender = false;

import type { APIRoute } from "astro";
import { eq } from "drizzle-orm";
import { createDb } from "@/db";
import { events, profiles } from "@/db/schema";

export const GET: APIRoute = async ({ locals }) => {
  const runtime = locals.runtime as { env: { DATABASE_URL: string } };
  const db = createDb(runtime.env.DATABASE_URL);

  const [allEvents, allProfiles] = await Promise.all([
    db.select({ slug: events.slug, updatedAt: events.updatedAt }).from(events).where(eq(events.active, true)),
    db.select({ username: profiles.username, updatedAt: profiles.updatedAt }).from(profiles).where(eq(profiles.active, true)),
  ]);

  const base = "https://palacefate.com";

  const urls = [
    `<url><loc>${base}/</loc><changefreq>daily</changefreq><priority>1.0</priority></url>`,
    `<url><loc>${base}/f</loc><changefreq>daily</changefreq><priority>0.9</priority></url>`,
    ...allEvents.map(
      (e) =>
        `<url><loc>${base}/f/${e.slug}</loc><lastmod>${e.updatedAt.toISOString().split("T")[0]}</lastmod><changefreq>daily</changefreq><priority>0.8</priority></url>`,
    ),
    ...allProfiles.map(
      (p) =>
        `<url><loc>${base}/p/${p.username}</loc><lastmod>${p.updatedAt.toISOString().split("T")[0]}</lastmod><changefreq>weekly</changefreq><priority>0.6</priority></url>`,
    ),
  ];

  const xml = `<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
${urls.join("\n")}
</urlset>`;

  return new Response(xml, {
    headers: { "Content-Type": "application/xml" },
  });
};