Ui#:ddlmZmZmZddlZddlmZmZddl m Z dde de dee dee d e f d Z de d eefd Zd e d eefd Zd e d efdZd e de d efdZ dde de de de dee d ee f dZdde dee dee fdZdS))OptionalListDictN)CHAT_LOG_DB_CONFIGlogger)get_current_daily session_idcategorytitledailyreturnc|A t|}n0#t$r#}tjd|d}Yd}~nd}~wwxYw|/dddddd d d d d ddddd}|||}d|d|}d} t jjdit}| }d} | | ||||f| |j } | tjd| d|| |r| SS#t$r}tjd|d}~wwxYw#|r| wwxYw)u= 새 채팅 세션 생성 → chat_session_id 반환 N![chat_log] Error fetching daily: ruコンディションu振り返り日記uカリキュラムu 目標探しu MBTI診断uIT学習u SPI対策u自己PRu 面接練習u クイズu 一般会話u サマリーu 学習計画u 会社情報) conditionjournal curriculumfindgoalmbtiitspiselfpr interviewquizgeneralsummary studyplan company_infozDay z - zx INSERT INTO chat_sessions (session_id, title, category, daily) VALUES (%s, %s, %s, %s) z[chat_log] Created session #: z&[chat_log] create_chat_session Error: )r Exceptionrerrorgetmysql connectorconnectrcursorexecutecommit lastrowidcloseinfo) r r r r ecategory_namescat_nameconnr&sqlchat_session_ids "/app/app/models/chat_log_module.pycreate_chat_sessionr3 s } %j11EE    L@Q@@ A A AEEEEEE  }1+.&  '%%'*   "%%h99+u++++ D&<<);<<  sZ%@AAA  *  M?MMeMMNNN   JJLLLL   AaAABBB    JJLLLL s7 A<A8BD%% E /EE  EE(cd} tjjdit}|d}d}|||f|}|||r|SS#t$r:}tj d|gcYd}~|r|SSd}~wwxYw#|r|wwxYw)u; 유저의 채팅 세션 목록 조회 (최신순) NT dictionaryz SELECT id, session_id, title, category, daily, started_at, last_message_at FROM chat_sessions WHERE session_id = %s ORDER BY last_message_at DESC z$[chat_log] get_chat_sessions Error: r r#r$r%rr&r'fetchallr*r rr!)r r/r&r0rowsr,s r2get_chat_sessionsr:As D&<<);<<--  sZM***      JJLLLL   ?A??@@@   JJLLLL     JJLLLL 0A3B CC1C2CCCC/r1cd} tjjdit}|d}d}|||f|}|||r|SS#t$r:}tj d|gcYd}~|r|SSd}~wwxYw#|r|wwxYw)u7 특정 세션의 메시지 조회 (시간순) NTr5z SELECT id, session_id, log, sender, daily, category, created_at FROM chat_messages WHERE chat_session_id = %s ORDER BY created_at ASC z'[chat_log] get_session_messages Error: rr7)r1r/r&r0r9r,s r2get_session_messagesr=[s D&<<);<<--  s_.///      JJLLLL   BqBBCCC   JJLLLL     JJLLLL r;c<d} tjjdit}|}|d|f|d|f||tj d| |r|dSdS#t$r:}tj d|Yd}~|r|dSdSd}~wwxYw#|r|wwxYw) u* 세션 + 해당 메시지 삭제 Nz4DELETE FROM chat_messages WHERE chat_session_id = %sz'DELETE FROM chat_sessions WHERE id = %sz[chat_log] Deleted session #Tz&[chat_log] delete_chat_session Error: Fr) r#r$r%rr&r'r(r*rr+r r!)r1r/r&r,s r2delete_chat_sessionr?usH D&<<);<<MP_Oabbb@?BTUUU   D?DDEEE   JJLLLLL    AaAABBBuuu   JJLLLLL      JJLLLL s*BB;; C?C:D:C??DDcd} tjjdit}|}d}||||f|| |r|dSdS#t$r:}tj d|Yd}~|r|dSdSd}~wwxYw#|r|wwxYw)u$ 세션 제목 업데이트 Nz1UPDATE chat_sessions SET title = %s WHERE id = %sTz'[chat_log] update_session_title Error: Fr) r#r$r%rr&r'r(r*r rr!)r1r r/r&r0r,s r2update_session_titlerAs D &<<);<<AsUO4555     JJLLLLL    BqBBCCCuuu   JJLLLLL      JJLLLL s*A1B CC1CCCC0logsenderc |[ t|}tjd|d|n0#t$r#}tjd|d}Yd}~nd}~wwxYwd} t jjd it}| } d} | | ||||||fnd#t jj $rM} dt| vr1dt| vr d } | | |||||fd}nYd} ~ nd} ~ wwxYw| |rS| } | d |f| | |n*#t$r}tjd |d}~wwxYw |r|dSdS#|r|wwxYw) u chat_messages 테이블에 대화 로그 저장 - session_id: 유저 세션 ID - log: 대화 내용 - sender: 발화자 (M=User, I=AI 등) - category: 카테고리 (condition, journal, curriculum, findgoal, mbti, it, spi 등) - daily: 일차 (optional, None이면 Goalskill_DB에서 가져옴) - chat_session_id: 소속 세션 ID (optional, 하위호환) Nz%[chat_log] Fetched current daily for rrrz INSERT INTO chat_messages (session_id, log, sender, daily, category, chat_session_id) VALUES (%s, %s, %s, %s, %s, %s) zUnknown columnr1z INSERT INTO chat_messages (session_id, log, sender, daily, category) VALUES (%s, %s, %s, %s, %s) z>UPDATE chat_sessions SET last_message_at = NOW() WHERE id = %sz [chat_log] save_chat_log Error: r)rrr+r r!r#r$r%rr&r'Errorstrr(r*) r rBrCr r r1r,r/r&r0pecursor2s r2 save_chat_logrIsc } %j11E KU UUeUU V V V V    L@Q@@ A A AEEEEEE  D*&<<);<< C NN3S&%? [ \ \ \ \$   3r77**/@CGG/K/KsZfeX$NOOO"&     kkmmG OOP "    KKMMM MMOOO   ;;;<<<     JJLLLLL  4  JJLLLL sj). AAA!/FB0/F0DAD F DBFG F9F44F99GG0cd} tjjd it}|d}d}dg}|g}|r*|d|||*|d|||dd |zz }|d z }||t|| }| ||r| SS#t$r:} tj d | gcYd} ~ |r| SSd} ~ wwxYw#|r| wwxYw) u chat_messages 테이블에서 대화 로그 조회 (기존 호환) - session_id: 유저 세션 ID - category: 카테고리 필터 (optional) - daily: 일차 필터 (optional) NTr5zRSELECT id, session_id, log, sender, daily, category, created_at FROM chat_messageszsession_id = %sz category = %sz daily = %sz WHERE z AND z ORDER BY created_at ASCz [chat_log] get_chat_logs Error: r)r#r$r%rr&appendjoinr'tupler8r*r rr!) r r r r/r&r0 conditionsparamsr9r,s r2 get_chat_logsrPs D&<<);<<--b'(   $   o . . . MM( # # #     l + + + MM%  y7<< 3333 ))sE&MM***      JJLLLL   ;;;<<<   JJLLLL     JJLLLL s0C=D E#E;E<E EE E9)NN)typingrrrmysql.connectorr#app.core.configrrapp.models.goalskill_modulerrFintr3r:r=boolr?rArIrPrr2rXs''''''''''6666666699999933C333x}3\deh\i3ux3333l#$t*4#$t*40#cd4QU>>c>>S>C>!#>@H >>>>B##c#Xc]#(SV-######rW