"""Exact replication of agent_monitor candidate selection logic."""
import sys, csv, sqlite3, json, os
from pathlib import Path

BASE_DIR = Path(__file__).parent
sys.path.insert(0, str(BASE_DIR / "src"))
import aima_agent_monitor as m

print("DATASET from module:", m.DATASET)
print("DB:", m.DB)

used_leads, used_phones = m.collect_used()
print("used_leads:", len(used_leads), "used_phones:", len(used_phones))

conn = sqlite3.connect(str(m.DB))
cur = conn.cursor()
cur.execute(
    "SELECT lead_id, first_name, last_name, phone, registered_at, last_activity_at "
    "FROM aima_imported_contacts WHERE dataset=? ORDER BY row_index DESC",
    (m.DATASET,)
)
all_rows = cur.fetchall()
conn.close()

candidates = [r for r in all_rows if r[3] and str(r[0]) not in used_leads and r[3] not in used_phones]
print("all_rows:", len(all_rows), "candidates:", len(candidates))
print("First 3 candidates:", [(r[0], r[3][-4:]) for r in candidates[:3]])