o }i@sddlZddlmZmZddlZddlmZmZm Z de de de fddZ de d e d e fd d Z de fd dZde dede fddZde de fddZde fddZde de fddZdS)N) A_DB_CONFIGlogger)ListDictOptional session_id step_order question_textc Cd}zCz,tjjdit}|}d}|||||f||jWW|r/||SSt yE}z t d||d}~ww|rQ||ww)u!질문 저장 (user_id 제거됨)Nz INSERT INTO findgoal_Q (session_id, step_order, question_text) VALUES (%s, %s, %s) zFindGoal Q Save Error: mysql connectorconnectrcursorexecutecommit lastrowidclose Exceptionrerror)rrr connrsqler r }z t d||d}~wwW|rL| | dSdS|rY| | ww)uBFindGoal 완료 시 user_profile_summary 테이블에도 동기화Nz INSERT INTO user_profile_summary (session_id, final_goal) VALUES (%s, %s) ON DUPLICATE KEY UPDATE final_goal = VALUES(final_goal), updated_at = NOW() z5FindGoal synced to user_profile_summary for session: zFindGoal Summary Sync Error: r ) r rrrrrrrinforrrr(r r rsync_to_user_profile_summarys*  r.)mysql.connectorr app.core.configrrjsontypingrrrstrintrrr#floatr&r)r,r.r r r rs