import sqlite3,json
c=sqlite3.connect('file:/opt/struktur/obsidian-graphiti-import/obsidian_graphiti_import.db?mode=ro',uri=True); c.row_factory=sqlite3.Row
rows=[dict(r) for r in c.execute("select id,relative_path,status,attempts,size,last_error,last_error_phase,graphiti_episode_uuid,content_hash,import_key from files where status in ('retry','failed') and id not in (11,184) and graphiti_episode_uuid is null order by size asc").fetchall()]
print('COUNT',len(rows))
for r in rows[:120]: print(json.dumps({k:r.get(k) for k in ['id','relative_path','status','attempts','size','last_error','last_error_phase']},ensure_ascii=False))