import sqlite3
from pathlib import Path
p=Path('/root/workspace/shorts_data/shorts.db')
with sqlite3.connect(p) as db:
 print(dict(db.execute('select key,value from settings')))
 print([dict(zip(['id','title','status','score','source_url'],r)) for r in db.execute('select id,title,status,score,source_url from candidates')])