import sqlite3
conn = sqlite3.connect('/home/hmo/MoFin/data/mofin.db')
r = conn.execute("SELECT code, LENGTH(full_analysis), reassessed_at, timing_signal, stop_loss, take_profit FROM holding_strategies WHERE code='300308'").fetchone()
print(r)
# also show first 300 chars of the analysis
r2 = conn.execute("SELECT substr(full_analysis, 1, 400) FROM holding_strategies WHERE code='300308'").fetchone()
print(r2[0] if r2 else 'none')