UiddlmZmZddlZddlmZmZddlm Z dZ dZ de de fd Zde d e fd Zde de fd Zde d e fdZdS))ListDictN)get_db_connectionlogger) A_DB_CONFIGcr tjjdit}|}d}|||||f|||dS#t$r"}tj d|Yd}~dSd}~wwxYw)NzJINSERT INTO chat_history (session_id, sender, message) VALUES (%s, %s, %s)zChat DB Save Error: ) mysql connectorconnectrcursorexecutecommitclose Exceptionrerror) session_idsendermessageconnr sqles !/app/app/models/general_module.py save_chat_logrs 1&5555ZsZ9:::   111 /A//0000000001sBB B6B11B6ct tjjdit}|d}d}|||f|}|||S#t$r#}tj d|gcYd}~Sd}~wwxYw)NT dictionaryzNSELECT sender, message FROM chat_history WHERE session_id = %s ORDER BY id ASCzChat DB Load Error: r ) r r r rr rfetchallrrrr)rrr rrowsrs rget_history_from_dbr s &5555--^sZM***      /A//000 sBB B7B2,B72B7rreturncd} tjjdit}|d}d}|||f|}|/ |r*||dSdS|ddpd |r)||SS#t$rI}td|Yd}~|r*||dSdSd}~wwxYw#|r)||wwxYw)NTrzr SELECT a_part_status FROM user_profile_summary WHERE session_id = %s r a_part_statuszGet A Part Status Error: r ) r r r rr rfetchonergetrprintrrr rrowrs rget_a_part_statusr)#s D&5555--  sZM***oo ;   LLNNN JJLLLLL   ww**/a/   LLNNN JJLLLL   -!--...qqq   LLNNN JJLLLLL      LLNNN JJLLLL s0A CC D*!D%3D-%D**D---Estatuscd} tjjdit}|}d}||||f|n)#t$r}td|Yd}~nd}~wwxYw|r*| | dSdS#|r)| | wwxYw)Nz INSERT INTO user_profile_summary (session_id, a_part_status) VALUES (%s, %s) ON DUPLICATE KEY UPDATE a_part_status = VALUES(a_part_status), updated_at = NOW() zUpdate A Part Status Error: r ) r r r rr rrrr&r)rr*rr rrs rupdate_a_part_statusr,;s D&5555  sZ0111 222 0Q00111111112   LLNNN JJLLLLL  4  LLNNN JJLLLL s0AA"!B9" B,B>B9BB99-C&cd} tjjdit}|d}d}|||f|}|rH|dr3|d|r)||SS |r*||dSdS#t$rN}tj d|Yd}~|r*||dSdSd}~wwxYw#|r)||wwxYw)u유저 이름 조회NTrzm SELECT username FROM user_profile_summary WHERE session_id = %s usernamezGet Username Error: r ) r r r rr rr$r%rrrrr's r get_usernamer/Ps D&5555--  sZM***oo  #377:&& #z?   LLNNN JJLLLL     LLNNN JJLLLLL    /A//000ttt   LLNNN JJLLLLL      LLNNN JJLLLL s*A" B ,BB>B  B>>-C+)typingrrmysql.connectorr app.corerrapp.core.configrrr strintr)r,r/r1r rr9s........'''''' 1 1 1   ##0S#*SS0cSr8