"""Create read-only server verification receipts for already downloaded examples; never enqueue cleanup."""
import hashlib,json,pathlib,sqlite3
root=pathlib.Path(__file__).resolve().parent.parent
with sqlite3.connect((root/'huobao-data/huobao.sqlite3').as_uri()+'?mode=ro',uri=True) as db:
 db.row_factory=sqlite3.Row;items=[]
 for task in db.execute('select * from sys_task where id in (262,273) order by id'):
  file=root/'huobao-data'/task['local_path'];parts=task['result_url'].split('/media/',1)[1].split('/')
  items.append({'id':task['task_id'],'index':int(parts[1]),'sha256':hashlib.sha256(file.read_bytes()).hexdigest(),'bytes':file.stat().st_size,'localTask':task['id']})
(root/'integration-work/cleanup-readonly-probes.json').write_text(json.dumps(items),'utf-8')
print('Read-only verification examples:',[i['localTask'] for i in items])