o ii+@s<ddlmZmZddlZddlmZmZddZddZ dS))ListDictN)get_db_connectionloggerc Cszz!t}|}d}|||||f|||WdSty<}ztd|WYd}~dSd}~ww)NzJINSERT INTO chat_history (session_id, sender, message) VALUES (%s, %s, %s)zChat DB Save Error: )rcursorexecutecommitclose Exceptionrerror) session_idmodesendermessageconnrsqler2/home/air/goalskill_t/back/app/models/db_module.py save_chat_logsrc Cs|z!t}|jdd}d}|||f|}|||WSty=}ztd|gWYd}~Sd}~ww)NT) dictionaryzNSELECT sender, message FROM chat_history WHERE session_id = %s ORDER BY id ASCzChat DB Load Error: )rrrfetchallr r rr )r r rrrrowsrrrrget_history_from_dbs r) typingrrmysql.connectormysqlapp.corerrrrrrrrs