import { config } from "dotenv";
config({ path: ".env.local" });
import { getDb } from "../lib/mongodb";

async function inspectSessions() {
  const db = await getDb();
  const sessions = await db.collection("admin_sessions").find({}).toArray();
  console.log("Total sessions in DB:", sessions.length);

  const now = new Date().toISOString();
  console.log("\nSessions summary:");
  sessions.forEach((s, i) => {
    console.log(`[${i + 1}] ID: ${s.id}, userId: ${s.userId}, revoked: ${s.revoked}, status: ${s.status}, expiresAt: ${s.expiresAt}, created: ${s.createdAt}, lastActive: ${s.lastActiveAt}, browser: ${s.browser}, device: ${s.device}`);
  });

  const unrevoked = sessions.filter((s) => !s.revoked);
  console.log("\nTotal unrevoked sessions:", unrevoked.length);

  const unexpiredAndUnrevoked = sessions.filter((s) => !s.revoked && s.expiresAt > now);
  console.log("Unexpired and unrevoked (standard check):", unexpiredAndUnrevoked.length);

  process.exit(0);
}

inspectSessions().catch(console.error);