Ui"ddlZddlmZmZddlmZmZmZdde de de dee fdZ de d e d e d e d e d e de fdZ de d e d e de fdZde de fdZde de deefdZde deefdZde deefdZde fdZdS)N) A_DB_CONFIGlogger)ListDictOptional session_id question_idselected_option is_correctcd} tjjdit}|}d}||||||f||j|r)||SS#t$r}tj d||d}~wwxYw#|r)||wwxYw)u SPI 답변 저장 (spi_log 테이블) Args: session_id: 세션 ID question_id: 문제 ID selected_option: 선택한 답변 is_correct: 정답 여부 (능력검사만, 성격검사는 None) Nz INSERT INTO spi_log (session_id, question_id, selected_option, is_correct) VALUES (%s, %s, %s, %s) zSPI Answer Save Error: ) mysql connectorconnectrcursorexecutecommit lastrowidclose Exceptionrerror)rr r r connrsqles /app/app/models/spi_module.py save_answerr s D&5555  sZozRSSS    LLNNN JJLLLL   2q22333   LLNNN JJLLLL s$A%B B=B88B==C-C-language_scorelanguage_gradenonverbal_scorenonverbal_gradepersonality_scorepersonality_typec 4d} tjjdit}|}d} || |||||||f|tjd|t||||n+#t$r} tj d| | d} ~ wwxYw |r*| | dSdS#|r)| | wwxYw)u personality_score: 性格特性の個別スコアJSON文字列 personality_type: AI コメント（日本語テキスト） Nar INSERT INTO spi_Output (session_id, language_score, language_grade, nonverbal_score, nonverbal_grade, personality_score, personality_type) VALUES (%s, %s, %s, %s, %s, %s, %s) ON DUPLICATE KEY UPDATE language_score = VALUES(language_score), language_grade = VALUES(language_grade), nonverbal_score = VALUES(nonverbal_score), nonverbal_grade = VALUES(nonverbal_grade), personality_score = VALUES(personality_score), personality_type = VALUES(personality_type) zSPI Output saved for session: zSPI Output Save Error: r ) rrrrrrrrinfosync_to_user_profile_summaryrrr) rrrrr r!r"rrrrs rsave_or_update_outputr&1s] D'&5555   sZ+_-/?A B B B  AZAABBB %           2q22333    LLNNN JJLLLLL  4  LLNNN JJLLLL s*B BC* B8B33B88C**-Dcd} tjjdit}|}d}||||||f|tjd|n.#t$r!}tj d|Yd}~nd}~wwxYw|r*| | dSdS#|r)| | wwxYw)u=SPI 완료 시 user_profile_summary 테이블에도 동기화Na INSERT INTO user_profile_summary (session_id, spi_language, spi_nonverbal, spi_personality) VALUES (%s, %s, %s, %s) ON DUPLICATE KEY UPDATE spi_language = VALUES(spi_language), spi_nonverbal = VALUES(spi_nonverbal), spi_personality = VALUES(spi_personality), updated_at = NOW() z0SPI synced to user_profile_summary for session: zSPI Summary Sync Error: r rrrrrrrrr$rrr)rrr r"rrrrs rr%r%es$ D&5555   sZJZ[\\\  SzSSTTTT     333444    LLNNN JJLLLLL  4  LLNNN JJLLLL s0A6A;:C; B&B!C!B&&C-DreturncFd} tjjdit}|}d}|||f|}|r|dnd |r)||SS#t$rN}tj d|Yd}~|r*||dSdSd}~wwxYw#|r)||wwxYw)u"현재 답변한 문제 수 조회Nz2SELECT COUNT(*) FROM spi_log WHERE session_id = %srzSPI Answer Count Error: r rrrrrrfetchonerrrrrrrrresultrs rget_answer_countr/s; D&5555BsZM***""")vayy)   LLNNN JJLLLL   333444qqq   LLNNN JJLLLLL      LLNNN JJLLLL s*A'B C0"C+9C3+C00C33-D  question_typecd} tjjd it}|d}|dkrd\}}nE|dkrd\}}n9|dkrd \}}n-g|r)||SSd }|||||f|}||r)||SS#t$rN}tj d |gcYd}~|r)||SSd}~wwxYw#|r)||wwxYw) u 타입별 답변 조회 Args: session_id: 세션 ID question_type: 'language' (1-5), 'nonverbal' (6-10), 'personality' (11-20) Returns: 답변 리스트 NT dictionarylanguage) nonverbal) personality) z SELECT question_id, selected_option, is_correct FROM spi_log WHERE session_id = %s AND question_id BETWEEN %s AND %s ORDER BY question_id zSPI Answers by Type Error: r ) rrrrrrrfetchallrrr) rr0rrmin_idmax_idrresultsrs rget_answers_by_typerAs D &5555-- J & &!NFFF k ) )"NFFF m + +#NFFF$   LLNNN JJLLLL !  sZ8999//##   LLNNN JJLLLL   6166777   LLNNN JJLLLL     LLNNN JJLLLL s6AC"0C"" D:,D5D:D=5D::D==-E*c4d} tjjdit}|d}d}|||f|}||r)||SS#t$rN}tj d|gcYd}~|r)||SSd}~wwxYw#|r)||wwxYw)u전체 답변 조회NTr2z SELECT question_id, selected_option, is_correct FROM spi_log WHERE session_id = %s ORDER BY question_id zSPI All Answers Error: r ) rrrrrrr=rrrr)rrrrr@rs rget_all_answersrCs2 D&5555--  sZM***//##   LLNNN JJLLLL   2q22333   LLNNN JJLLLL     LLNNN JJLLLL s0AB C'C"1C'2C*"C''C**-Dc4d} tjjdit}|d}d}|||f|}||r)||SS#t$rN}tj d|Yd}~|r*||dSdSd}~wwxYw#|r)||wwxYw)uSPI 최종 결과 조회NTr2z.SELECT * FROM spi_Output WHERE session_id = %szSPI Output Get Error: r r+r-s r get_outputrEs1 D&5555-->sZM***""   LLNNN JJLLLL   1a11222ttt   LLNNN JJLLLLL      LLNNN JJLLLL s*AB C'C"0C*"C''C**-Dcd} tjjdit}|}d}|||f|tjd|n.#t$r!}tj d|Yd}~nd}~wwxYw|r*| | dSdS#|r)| | wwxYw)uE 테스트 시작 시 이전 기록 초기화 (재시작용) Nz)DELETE FROM spi_log WHERE session_id = %szSPI Session Cleared: zSPI Session Clear Error: r r()rrrrrs rclear_session_logsrGs D&5555:sZM***  8J889999 666 444555555556   LLNNN JJLLLLL  4  LLNNN JJLLLL s0A3A87C8 B#BCB##C-D)N)mysql.connectorrapp.core.configrrtypingrrrstrintboolrr&r%r/rArCrErGr rrOs////////''''''''''  C c C U]^bUc    L/c/3/PS/+./AD/-0/DG////hS#36JMH,,C,,T ,,,,^T 838D>03rN