o ]ij@sddlZddlmZmZddlmZmZmZde de de de fdd Z de d e d e fd d Z de de fddZde deefddZde fddZde d e fddZdS)N) A_DB_CONFIGlogger)ListDictOptional session_id question_idselected_answer is_correctc Csd}zDz-tjjdit}|}d}||||||f||jWW|r0||SSt yF}z t d||d}~ww|rR||ww)u IT 테스트 답변 저장 (it_log 테이블) Args: session_id: 세션 ID question_id: 문제 ID selected_answer: 선택한 답변 is_correct: 정답 여부 Nz INSERT INTO it_log (session_id, question_id, selected_answer, is_correct) VALUES (%s, %s, %s, %s) zIT Answer Save Error: ) mysql connectorconnectrcursorexecutecommit lastrowidclose Exceptionrerror)rrr r connrsqler r 6/home/air/goalskill_sales/back/app/models/it_module.py save_answer s*   r total_scorelevelc Csd}zQz+tjjdit}|}d}|||||f|td|t ||Wnt yD}z t d||d}~wwW|rR| | dSdS|r_| | ww)u IT 테스트 최종 결과 저장 (it_Output 테이블) Args: session_id: 세션 ID total_score: 맞힌 문제 수 (0~20) level: 레벨 (上級/中級/初級/入門) Nz INSERT INTO it_Output (session_id, total_score, level) VALUES (%s, %s, %s) ON DUPLICATE KEY UPDATE total_score = VALUES(total_score), level = VALUES(level) zIT Output saved for session: zIT Output Save Error: r ) r r rrrrrrinfosync_to_user_profile_summaryrrr)rrrrrrrr r rsave_or_update_output1s,    rreturnc Csd}zTz+tjjdit}|}d}|||f|d}|WW|r.||SStyV}zt d|WYd}~W|rP||dSdSd}~ww|rb||ww)u답변한 문제 수 조회Nz1SELECT COUNT(*) FROM it_log WHERE session_id = %srzIT Answer Count Error: r ) r r rrrrfetchonerrrr)rrrrcountrr r rget_answer_count\s2     r#c Csd}zTz+tjjdit}|jdd}d}|||f|}|WW|r.||SStyV}zt d|gWYd}~W|rQ||SSd}~ww|rb||ww)u모든 답변 조회NT) dictionaryz SELECT question_id, selected_answer, is_correct FROM it_log WHERE session_id = %s ORDER BY question_id zIT Get Answers Error: r ) r r rrrrfetchallrrrr)rrrrresultsrr r rget_all_answersrs2    r'c Csd}zNz$tjjdit}|}d}|||f|td|Wnt yA}zt d|WYd}~nd}~wwW|rO| | dSdS|r\| | ww)um IT 테스트 재시작 시 이전 답변 기록 삭제 Args: session_id: 세션 ID Nz(DELETE FROM it_log WHERE session_id = %szIT logs cleared for session: zIT Clear Logs Error: r r r rrrrrrrrrr)rrrrrr r rclear_session_logss(  r)c Csd}zRz(tjjdit}|}d}||||f|td|d|Wnt yE}zt d|WYd}~nd}~wwW|rS| | dSdS|r`| | ww)u it_Output의 level을 user_profile_summary.it_level에 저장 Args: session_id: 세션 ID level: 레벨 (上級/中級/初級/入門) Nz INSERT INTO user_profile_summary (session_id, it_level) VALUES (%s, %s) ON DUPLICATE KEY UPDATE it_level = VALUES(it_level) z)IT level synced to user_profile_summary: z -> zIT Sync to Summary Error: r r()rrrrrrr r rrs(  r)mysql.connectorr app.core.configrrtypingrrrstrintboolrrr#r'r)rr r r rs&+