"""Read-only board verification of the observed Operator trial."""
import hashlib
import json
from pathlib import Path
import sqlite3

def main():
    here=Path(__file__).resolve().parent
    path='/home/smlflg/.hermes/kanban/boards/agenten-uebergaben/kanban.db'
    checks={};tasks={}
    with sqlite3.connect('file:'+path+'?mode=ro',uri=True) as c:
        c.row_factory=sqlite3.Row
        for tid,profile,state in [('t_599ec1c2','wggesucht','blocked'),('t_e52c3df1','verifier','review')]:
            t=dict(c.execute('SELECT id,status,assignee FROM tasks WHERE id=?',(tid,)).fetchone());tasks[tid]=t
            event=json.loads(c.execute("SELECT payload FROM task_events WHERE task_id=? AND kind='operator_routed' ORDER BY id DESC LIMIT 1",(tid,)).fetchone()[0])
            checks[tid+'_assigned']=t['assignee']=='hai:'+profile
            checks[tid+'_state']=t['status']==state
            checks[tid+'_operator_selected']=event['profile']==profile and bool(event['operator_pid'])
            checks[tid+'_operator_comment']=bool(c.execute("SELECT 1 FROM task_comments WHERE task_id=? AND author='operator'",(tid,)).fetchone())
        checks['result_followed']=bool(c.execute("SELECT 1 FROM task_comments WHERE task_id='t_e52c3df1' AND author='operator' AND body LIKE '%meldet review%'").fetchone())
        checks['no_notifications']=c.execute('SELECT count(*) FROM kanban_notify_subs').fetchone()[0]==0
    job=json.loads((here/'evidence/t_e52c3df1/11/job.json').read_text())
    result=json.loads((here/'evidence/t_e52c3df1/11/result.json').read_text())
    checks['existing_verifier_profile']=job['grant']['worker_profile']=='verifier'
    checks['source_read']=any(a['operation']=='read' and a['ok'] for a in result['actions'])
    checks['actual_result']=result['ok'] and '139' in result['answer']
    report={'passed':all(checks.values()),'checks':checks,'tasks':tasks,'worker_lease':job['lease'],
        'limits':['Bounded current mission; no permanent service or global profile changes.',
            'WG-Gesucht is assigned but not solved: its execution grant is absent.',
            'External reviewer acceptance is separate from builder checks.'],
        'code_sha256':{p.name:hashlib.sha256(p.read_bytes()).hexdigest() for p in here.glob('*.py')}}
    (here/'evidence/OPERATOR_VERIFICATION.json').write_text(json.dumps(report,ensure_ascii=False,indent=2))
    print(json.dumps({'passed':report['passed'],'checks':len(checks),'tasks':tasks}))
    assert report['passed']

if __name__=='__main__':main()