import sqlite3,json,subprocess,os
p='/opt/struktur/content-extraction/data/content_extraction.db'; c=sqlite3.connect('file:'+p+'?mode=ro',uri=True); c.row_factory=sqlite3.Row
out={'ce':dict(c.execute("select * from ce_sources where source_video_id=1247").fetchone()),'db_mtime':os.stat(p).st_mtime}; c.close()
for cmd in [['systemctl','list-timers','--all','--no-pager'],['journalctl','-u','content-extraction-sync.service','--since','2026-08-27 17:02:00','--no-pager'],['systemctl','status','content-extraction-sync.service','--no-pager']]: out[' '.join(cmd)]=subprocess.run(cmd,capture_output=True,text=True).stdout
print(json.dumps(out,ensure_ascii=False,default=str))