import sqlite3
conn = sqlite3.connect('/home/hmo/MoFin/data/mofin.db')
conn.row_factory = sqlite3.Row

# candidates 表结构
cols = [r[1] for r in conn.execute("PRAGMA table_info(candidates)")]
print('candidates cols:', cols)
print()

codes = ['000711', '603766', '600617', '688271']
print('=== candidates 对应记录 ===')
for code in codes:
    r = conn.execute("SELECT * FROM candidates WHERE code=?", (code,)).fetchone()
    if r:
        d = dict(r)
        keys = [k for k in d.keys() if any(s in k.lower() for s in ['score', 'entry', 'stop', 'take', 'promot', 'created', 'name', 'code'])]
        print(f"  {code}: " + ' | '.join(f'{k}={d[k]}' for k in keys))
    else:
        print(f'  {code}: 无记录')
conn.close()