import { env } from "@/lib/runtime-env";
import { ensureSchema } from "@/db/ensure-schema";

export async function isApprovedProfessional(email: string) {
  const normalized = email.trim().toLowerCase();
  if (!normalized || !normalized.includes("@")) return false;
  await ensureSchema();
  const row = await env.DB.prepare(`SELECT id FROM professional_applications
    WHERE lower(email) = ? AND status = 'approved' ORDER BY id DESC LIMIT 1`).bind(normalized).first();
  return Boolean(row);
}