15 lines
495 B
Python
15 lines
495 B
Python
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)
|