_archive_scripts/_diag.py

import sqlite3
conn = sqlite3.connect('paper_trading/trading.db')
cur = conn.cursor()

cur.execute('SELECT * FROM daily_run_log ORDER BY date DESC LIMIT 10')
runs = cur.fetchall()
print('=== DAILY RUN LOG ===')
for r in runs: print(r)

cur.execute('SELECT date, equity, cash, positions_count FROM daily_snapshots ORDER BY date DESC LIMIT 10')
snaps = cur.fetchall()
print('\n=== DAILY SNAPSHOTS ===')
for s in snaps: print(s)

cur.execute("SELECT key, value FROM state WHERE key LIKE '%predict%' OR key LIKE '%model%' OR key LIKE '%bootstrap%'")
preds = cur.fetchall()
print('\n=== PREDICTION STATE ===')
for p in preds: print(p)

cur.execute('SELECT id, symbol, side, entry_date, exit_date, is_closed, exit_reason, gross_pnl FROM trades ORDER BY id')
trades = cur.fetchall()
print('\n=== ALL TRADES ===')
for t in trades: print(t)

cur.execute('SELECT COUNT(*) FROM signals_log')
print('\n=== SIGNALS LOG COUNT:', cur.fetchone()[0], '===')
cur.execute('SELECT date, symbol, action, score FROM signals_log ORDER BY date DESC LIMIT 5')
for s in cur.fetchall(): print(s)

conn.close()