o vi@sddlZddlmZmZddlZddlmZmZm Z edZ de de de fdd Z de d e d e fd d Zde fddZde de fddZde fddZde dede fddZde de fddZde fddZde de fddZdS)N) get_db_configlogger)ListDictOptional Sales_A_DB 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 connectorconnect A_DB_CONFIGcursorexecutecommit lastrowidclose Exceptionrerror)rr r 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 ) rrrrrrrrinforrrr4r r rsync_to_user_profile_summarys*  r:)mysql.connectorrapp.core.configrrjsontypingrrrrstrintrr r(r-r/floatr2r5r8r:r r r rs