import pymysql

conn = pymysql.connect(host='localhost', user='root', password='', database='tracerstudy_db', port=3306, charset='utf8mb4')
cursor = conn.cursor()

# Cek 5 data pertama dari tracer_responses
cursor.execute('''
    SELECT alumni_id, email, nama_perusahaan, jabatan, jenis_perusahaan_full
    FROM tracer_responses
    LIMIT 10
''')

print('=== SAMPLE DATA di tracer_responses ===')
for row in cursor.fetchall():
    alumni_id, email, np, jab, jp = row
    print(f'ID {alumni_id}:')
    print(f'  email: {email}')
    print(f'  nama_perusahaan: {np}')
    print(f'  jabatan: {jab}')
    print(f'  jenis_perusahaan_full: {jp}')
    print()

# Cek apakah mapping sudah benar
cursor.execute('''
    SELECT DISTINCT status_saat_ini, COUNT(*) as cnt
    FROM tracer_responses
    GROUP BY status_saat_ini
''')

print('=== DISTINCT status_saat_ini ===')
for row in cursor.fetchall():
    status, cnt = row
    print(f'  "{status}": {cnt}')

conn.close()