o l"i@s@ddlmZddlmZdededefddZdefdd Zd S) ) HTTPException) database_demo session_idrolecontentc sRzd}tj||||ddIdHWdSty(}ztdt|dd}~ww)u 로봇의 대화(user 또는 ai)를 'chat_history' 테이블에 저장합니다. (기존 save_chat_message 함수와 유사) z INSERT INTO chat_history (session_id, role, content, created_at) VALUES (:session_id, :role, :content, NOW()) )rrr)valuesN status_codedetail)rexecute Exceptionrstr)rrrqueryer./home/air/sanwanet/gpt-api-backup/db_module.pysave_robot_chat_message src sHzd}t|d|iIdHWSty#}ztdt|dd}~ww)u 특정 'session_id'의 모든 대화 기록을 시간순으로 가져옵니다. (기존 get_chat_history 함수와 유사) z SELECT role, content FROM chat_history WHERE session_id = :session_id ORDER BY created_at ASC rNrr )r fetch_allr rr)rrrrrrget_robot_chat_historysrN)fastapirdbrrrrrrrrs