36 lines
962 B
Python
36 lines
962 B
Python
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()
|