import re, sys; sys.path.insert(0,"/app")
from collections import Counter
from app.database import SessionLocal
from sqlalchemy import text as sa_text
db = SessionLocal()
rows = db.execute(sa_text("SELECT id, question_text, explanation FROM questions")).fetchall()
pats = {"<_": r"<_\s*\d", ">_": r">_\s*\d", "<=": r"<=\s*\d", "≤": r"≤\s*\d", "≥": r"≥"}
for lab, p in pats.items():
    c=0; ids=set()
    for qid,s,e in rows:
        for t in (s or "",):
            if re.search(p,t): c+=1; ids.add(qid)
    print(f"{lab:4s} stems={c} ids={sorted(ids)[:8]}")
t = db.execute(sa_text("SELECT question_text FROM questions WHERE id=2170")).scalar()
print("\n2170:", repr(t[-700:]))