import sqlite3,glob,os,json
c=sqlite3.connect('file:/opt/struktur/youtube-research/knowledge.db?mode=ro',uri=True)
out=[]
for jid in range(129,144):
 r=c.execute('SELECT e.job_id,e.video_id,e.youtube_id,e.status,v.transcript_status FROM e2e_jobs e JOIN videos v ON v.id=e.video_id WHERE e.job_id=?',(jid,)).fetchone(); vid=r[1]
 out.append({'job':jid,'video':vid,'status':r[3],'transcript_status':r[4],'extraction':c.execute('SELECT count(*) FROM e2e_extractions WHERE video_id=?',(vid,)).fetchone()[0],'queue':c.execute('SELECT count(*) FROM graphiti_import_queue WHERE video_id=?',(vid,)).fetchone()[0],'segments':c.execute('SELECT count(*) FROM transcript_segments WHERE video_id=?',(vid,)).fetchone()[0]})
print(json.dumps({'rows':out,'queue_total':c.execute('select count(*) from graphiti_import_queue').fetchone()[0]},default=str)); c.close()