reports.ts

import { jsonError, jsonResponse } from "../../common.js";

export async function onRequestGet(context: RequestContext) {
  const {
    results,
    success,
  }: {
    results: { id: string }[];
    success: boolean;
  } = await context.env.D1.prepare(
    "SELECT created_at, id, open, target_usernames FROM reports WHERE json_extract(user, '$.id') = ? ORDER BY created_at LIMIT 50;",
  )
    .bind(context.data.current_user.id)
    .all();

  if (!success) return jsonError("Failed to retrieve reports", 500);

  return jsonResponse(JSON.stringify(results));
}