import sqlite3,json
db='/tmp/ev-23548/head-home/userdata/statev2.sqlite'
c=sqlite3.connect(db)
c.execute("update projection_projects set title=?,workspace_root=?",('Evidence checks','/tmp/ev-23548/fixture-repo'))
for tid,payload in c.execute('select thread_id,payload_json from orchestration_v2_projection_threads').fetchall():
 p=json.loads(payload)
 p['title']='Progressing PR checks'
 p['branch']='fixture'
 p['pullRequests']=[dict(host='github.com',repository='evidence/check-counts',number=1,url='https://github.com/evidence/check-counts/pull/1',source='manual',linkedAt='2026-10-22T00:00:00Z',snapshot=dict(state='open',title='Fixture: progressing checks',headBranch='fixture',baseBranch='main',isDraft=False,updatedAt='2026-10-22T00:00:00Z',syncedAt='2026-10-22T00:00:00Z'),stack=None)]
 c.execute('update orchestration_v2_projection_threads set title=?,payload_json=? where thread_id=?',(p['title'],json.dumps(p),tid))
c.commit()
print('Seeded synthetic projection state only:',db)