import sys
import os
sys.path.append(os.path.dirname(os.path.abspath(__file__)) + '/..')
from database import TradeDB

db = TradeDB()
try:
    print("[Latest LS Candidates History]")
    lch_recent = db.conn.execute("""
        SELECT scan_time, code, name 
        FROM ls_candidates_history 
        ORDER BY scan_time DESC LIMIT 10
    """).fetchall()
    for row in lch_recent: print(dict(row))

    print("\n[Latest LS Universe History]")
    lu_recent = db.conn.execute("""
        SELECT scan_time, code, name 
        FROM ls_universe_history 
        ORDER BY scan_time DESC LIMIT 10
    """).fetchall()
    for row in lu_recent: print(dict(row))

finally:
    db.close()