import { Hono } from "hono";
import type { Bindings } from "../types";

const records = new Hono<{ Bindings: Bindings }>();

records.get("/:did", async (c) => {
  try {
    const db = c.env.DB;
    const did = c.req.param("did");
    const limit = Number(c.req.query("limit")) || 20;
    const offset = Number(c.req.query("offset")) || 0;

    const { results } = await db
      .prepare(
        `SELECT * FROM repo_records
         WHERE did = ? AND collection = 'site.standard.document'
         ORDER BY rkey DESC
         LIMIT ? OFFSET ?`
      )
      .bind(did, limit, offset)
      .all();

    return c.json({
      did,
      count: results?.length || 0,
      limit,
      offset,
      records: results || [],
    });
  } catch (error) {
    return c.json(
      { error: "Failed to fetch records", details: String(error) },
      500
    );
  }
});

export default records;