import sys
sys.path.insert(0, '/home/hmo/.hermes/profiles/position-analyst/scripts')
sys.path.insert(0, '/home/hmo/MoFin')
from mofin_db import get_conn, write_price_event

c = get_conn()
ok = write_price_event(c, code='TEST99', name='测试股', event_type='entry_zone',
                       price=12.34, trigger_value='12.0~12.5', event_label='加仓区间')
print('write_price_event returned:', ok)
r = c.execute("SELECT code,created_at FROM price_events WHERE code='TEST99'").fetchone()
print('row:', r)
c.execute("DELETE FROM price_events WHERE code='TEST99'")
c.commit()
c.close()
print('done')