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

with engine.connect() as conn:
    alumni_sample = conn.execute(text("SELECT id, nim, nama, tahun_lulus, kode_prodi, email FROM alumni LIMIT 5;")).fetchall()
    print("Alumni sample:")
    for a in alumni_sample:
        print(" ", a)
        
    tracer_sample = conn.execute(text("SELECT id, alumni_id, kode_pt, email, status_saat_ini, nama_perusahaan, jabatan FROM tracer_responses LIMIT 5;")).fetchall()
    print("\nTracer responses sample:")
    for t in tracer_sample:
        print(" ", t)