Ui FddlZddlmZmZdZdZdedefdZdefdZ dS) N) A_DB_CONFIGloggerc\d} tjjdit}|}d}|||||f|n#t$r}|d}~wwxYw |r|dSdS#|r|wwxYw)NFINSERT INTO mbti_log (session_id, sender, message) VALUES (%s, %s, %s)) mysql connectorconnectrcursorexecutecommit Exceptionclose) session_idsendermessageconnr sqles /app/app/models/mbti_module.pyinsert_chat_logrs D &5555VsZ9:::     JJLLLLL  4  JJLLLL s*AA#"B# A4-A//A44BB+cd} tjjdit}||}d}|||d|fd}||||||f|t||n*#t$r} |r| | d} ~ wwxYw |r| dSdS#|r| wwxYw)Nrsystema% INSERT INTO mbti_Output (session_id, result, scores, description) VALUES (%s, %s, %s, %s) ON DUPLICATE KEY UPDATE result = VALUES(result), scores = VALUES(scores), description = VALUES(description) r) rr r rstart_transactionr r r sync_to_user_profile_summaryrrollbackr) r system_msg mbti_type scores_json descriptionrr sql_chat sql_resultrs rsave_mbti_result_transactionr#s0 D &5555    \x*h !CDDD  zJ ; #TUUU  %Z;;;;    MMOOO <   JJLLLLL  4  JJLLLL s*BB#"C(# C -CC  C((Drrc d} tjjdit}|}d}||||f|tjd|n.#t$r!}tj d|Yd}~nd}~wwxYw|r*| | dSdS#|r)| | wwxYw)u>MBTI 완료 시 user_profile_summary 테이블에도 동기화Nz INSERT INTO user_profile_summary (session_id, mbti) VALUES (%s, %s) ON DUPLICATE KEY UPDATE mbti = VALUES(mbti), updated_at = NOW() z1MBTI synced to user_profile_summary for session: zMBTI Summary Sync Error: r) rr r rr r r rinforerrorr)rrrr rrs rrr:s D&5555  sZ3444  T TTUUUU     444555    LLNNN JJLLLLL  4  LLNNN JJLLLL s0A4A98C9 B$BCB$$C-Dc4d} tjjdit}|d}d}|||f|}||r)||SS#t$rN}tj d|Yd}~|r*||dSdSd}~wwxYw#|r)||wwxYw)uMBTI 최종 결과 조회NT) dictionaryz/SELECT * FROM mbti_Output WHERE session_id = %szMBTI Output Get Error: r) rr r rr r fetchonerrrr&)rrr rresultrs r get_outputr+Ws1 D&5555--?sZM***""   LLNNN JJLLLL   2q22333ttt   LLNNN JJLLLLL      LLNNN JJLLLL s*AB C'C"0C*"C''C**-D) mysql.connectorrapp.core.configrrrr#strrr+rrr0s//////// """HSS:3r/