UiddlZddlmZmZddlmZmZmZde de de de fdZ de d e d e d e fd Z de d e fdZde d eefdZde fdZde d e fdZde fdZdS)N) A_DB_CONFIGlogger)ListDictOptional session_id question_idselected_answer is_correctcd} tjjdit}|}d}||||||f||j|r)||SS#t$r}tj d||d}~wwxYw#|r)||wwxYw)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)rr r r connrsqles /app/app/models/it_module.py save_answerr s D&5555  sZozRSSS    LLNNN JJLLLL   1a11222   LLNNN JJLLLL s$A%B B=B88B==C-C- total_scorelevel descriptionc*d} tjjdit}|}d}||||||f|tjd|t||n+#t$r}tj d||d}~wwxYw |r*| | dSdS#|r)| | wwxYw)u IT 테스트 최종 결과 저장 (it_Output 테이블) Args: session_id: 세션 ID total_score: 맞힌 문제 수 (0~20) level: 레벨 (上級/中級/初級/入門) Na: INSERT INTO it_Output (session_id, total_score, level, description) VALUES (%s, %s, %s, %s) ON DUPLICATE KEY UPDATE total_score = VALUES(total_score), level = VALUES(level), description = VALUES(description) zIT Output saved for session: zIT Output Save Error: r ) rrrrrrrrinfosync_to_user_profile_summaryrrr)rrrrrrrrs rsave_or_update_outputr#1s4 D&5555  sZe[IJJJ  @J@@AAA %Z7777  1a11222 8   LLNNN JJLLLLL  4  LLNNN JJLLLL s*BB C% B3B..B33C%%-Dreturnc<d} tjjdit}|}d}|||f|d}||r)||SS#t$rN}tj d|Yd}~|r*||dSdSd}~wwxYw#|r)||wwxYw)u답변한 문제 수 조회Nz1SELECT COUNT(*) FROM it_log WHERE session_id = %srzIT Answer Count Error: r rrrrrrfetchonerrrr)rrrrcountrs rget_answer_countr)]s0 D&5555AsZM***!!!$   LLNNN JJLLLL   2q22333qqq   LLNNN JJLLLLL      LLNNN JJLLLL s*A#B C+C&4C.&C++C..-Dc4d} tjjdit}|d}d}|||f|}||r)||SS#t$rN}tj d|gcYd}~|r)||SSd}~wwxYw#|r)||wwxYw)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 ) rrrrrrfetchallrrrr)rrrrresultsrs rget_all_answersr/ss2 D&5555--  sZM***//##   LLNNN JJLLLL   1a11222   LLNNN JJLLLL     LLNNN JJLLLL s0AB C'C"1C'2C*"C''C**-Dcd} tjjdit}|}d}|||f|tjd|n.#t$r!}tj d|Yd}~nd}~wwxYw|r*| | dSdS#|r)| | wwxYw)um IT 테스트 재시작 시 이전 답변 기록 삭제 Args: session_id: 세션 ID Nz(DELETE FROM it_log WHERE session_id = %szIT logs cleared for session: zIT Clear Logs Error: r rrrrrrrrr!rrr)rrrrrs rclear_session_logsr2s D&55558sZM***  @J@@AAAA 222 0Q00111111112   LLNNN JJLLLLL  4  LLNNN JJLLLL s0A3A87C8 B#BCB##C-Dcd} tjjdit}|}d}||||f|tjd|d|n.#t$r!}tj d|Yd}~nd}~wwxYw|r*| | dSdS#|r)| | wwxYw)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 r1)rrrrrrs rr"r"s, D&5555  sZ/000  W WWPUWWXXXX 777 5!55666666667   LLNNN JJLLLLL  4  LLNNN JJLLLL s0A7A<;C< B'B"C"B''C-Dc4d} tjjdit}|d}d}|||f|}||r)||SS#t$rN}tj d|Yd}~|r*||dSdSd}~wwxYw#|r)||wwxYw)uIT 최종 결과 조회NTr+z-SELECT * FROM it_Output WHERE session_id = %szIT Output Get Error: r r&)rrrrresultrs r get_outputr6s1 D&5555--=sZM***""   LLNNN JJLLLL   0Q00111ttt   LLNNN JJLLLLL      LLNNN JJLLLL s*AB C'C"0C*"C''C**-D)mysql.connectorrapp.core.configrrtypingrrrstrintboolrr#r)r/r2r"r6r rr>sX////////'''''''''' C c C UY    L&c&&C&WZ&&&&X,T <3<SB3r=