import sys
sys.path.append('Backend')
from app.config.database import engine
from sqlalchemy import text
from app.parsers.converters import konversi_jawaban

with engine.connect() as conn:
    row = conn.execute(text("""
        SELECT a.nim, a.nama, tr.rata_pendapatan, tr.nama_perusahaan, tr.jabatan_wiraswasta 
        FROM alumni a 
        JOIN tracer_responses tr ON a.id = tr.alumni_id 
        WHERE a.nim = 'E41171725';
    """)).fetchone()
    print("Khosnol tracer data in DB:", row)