import { NextResponse } from 'next/server';
import { db, sql } from '@/lib/db';

export const dynamic = 'force-dynamic';

export async function GET() {
  let dbOk = false;
  try {
    await db().execute(sql`SELECT 1`);
    dbOk = true;
  } catch {
    dbOk = false;
  }
  return NextResponse.json({ ok: dbOk, db: dbOk, service: 'cancerindex-web', time: new Date().toISOString() }, { status: dbOk ? 200 : 503, headers: { 'Cache-Control': 'no-store' } });
}