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

db = TradeDB()
try:
    cols = [dict(r)["Field"] for r in db.conn.execute("SHOW COLUMNS FROM env_auth_config").fetchall()]
    print("[env_auth_config 컬럼]:", cols)
    
    # 최근 10행 조회
    rows = db.conn.execute("""
        SELECT id, created_at,
               KIS_APP_KEY_REAL, KIS_APP_SECRET_REAL,
               KIS_APP_KEY_OB_REAL, KIS_APP_SECRET_OB_REAL,
               KIS_APP_KEY, KIS_APP_SECRET
        FROM env_auth_config
        ORDER BY id DESC
        LIMIT 10
    """).fetchall()
    print("\n[최근 10행 (id DESC)]")
    for r in rows:
        d = dict(r)
        # 키는 앞 6자리만 표시
        for k in ['KIS_APP_KEY_REAL','KIS_APP_SECRET_REAL','KIS_APP_KEY_OB_REAL','KIS_APP_SECRET_OB_REAL','KIS_APP_KEY','KIS_APP_SECRET']:
            v = d.get(k)
            d[k] = (v[:6] + '...') if v else 'NULL'
        print(f"  id={d['id']} created_at={d['created_at']} KEY_REAL={d['KIS_APP_KEY_REAL']} OB_REAL={d['KIS_APP_KEY_OB_REAL']} KEY={d['KIS_APP_KEY']}")
finally:
    db.close()