import sqlite3,json
p='/opt/struktur/content-extraction/data/content_extraction.db'; c=sqlite3.connect('file:'+p+'?mode=ro',uri=True); c.row_factory=sqlite3.Row
print(json.dumps({'schema':c.execute("select sql from sqlite_master where type='table' and name='ce_sources'").fetchone()[0],'statuses':[dict(r) for r in c.execute("select transcript_status,count(*) n from ce_sources where source_system='youtube-research' group by transcript_status")],'rows':[dict(r) for r in c.execute("select id,source_video_id,youtube_id,transcript_status,obsidian_artifact_path,length(transcript) n from ce_sources where source_system='youtube-research' and source_video_id=1246")]} ,ensure_ascii=False,default=str))