import sqlite3,json,datetime
DB='/opt/struktur/youtube-research/knowledge.db'; c=sqlite3.connect('file:'+DB+'?mode=ro',uri=True); c.row_factory=sqlite3.Row
rows=c.execute("SELECT e.job_id,e.video_id,e.youtube_id,e.status,e.step,e.attempts,e.reserved_at,e.started_at,e.updated_at,e.error_code,e.error_message,v.title,v.channel,v.created_at video_created_at,v.transcript_status,v.transcript_source,length(trim(coalesce(v.transcript,''))) transcript_len FROM e2e_jobs e JOIN videos v ON v.id=e.video_id WHERE e.job_id IN (274,275)").fetchall()
print(json.dumps([dict(x) for x in rows],ensure_ascii=False,indent=2))
print('counts',dict(c.execute("select status,count(*) n from e2e_jobs group by status").fetchall()))