o լi@sddlmZmZddlZddlmZddlmZddl m Z m Z m Z ddZ dd Z d d Zd d ZddZddZddZddZddZdedefddZdS))ListDictN) B_DB_CONFIG)logger)datetimetimezone timedeltac Csz'tjjdit}|}d}|||||f|||WdStyB}zt d|WYd}~dSd}~ww)NzGINSERT INTO daily_log (session_id, sender, message) VALUES (%s, %s, %s)zDaily Log Save Error: ) mysql connectorconnectrcursorexecutecommitclose Exceptionrerror) session_idsendermessageconnr sqler r 9/home/air/goalskill_t/back/app/models/report_db_module.pysave_daily_log src Csz4tjjdit}|}d}|||||||f|||t d|d|WdSt yO}zt d|WYd}~dSd}~ww)Nz INSERT INTO daily_note (session_id, date, learning, today_mindset, ai_comment) VALUES (%s, %s, %s, %s, %s) zDaily Note Saved: z - zDaily Note Save Error: r r r r rr rrrrinforr) rdatelearningmindset ai_commentrr rrr r rsave_structured_diarysr!c Cz'tjjdit}|jdd}d}|||f|}|||WStyC}zt d|gWYd}~Sd}~ww)NT dictionaryzWSELECT sender, message, created_at FROM daily_log WHERE session_id = %s ORDER BY id ASCzDaily Log Load Error: r r r r rr rfetchallrrrr)rrr rrowsrr r rget_daily_log_from_db0s r(c Csz7ttdd}t|d}tjjd it}|j dd}d}| |||f| }| | |WSt yS}ztd|gWYd}~Sd}~ww) uX오늘의 daily_log만 가져오기 (A' 파트용: 과거 대화를 참조하지 않음) hours%Y-%m-%dTr#zqSELECT sender, message, created_at FROM daily_log WHERE session_id = %s AND DATE(created_at) = %s ORDER BY id ASCzToday Daily Log Load Error: Nr )rrrnowstrftimer r r rr rr&rrrr)rJST today_strrr rr'rr r rget_today_daily_log>s  r1c Cr")NTr#zz SELECT * FROM daily_note WHERE session_id = %s ORDER BY date DESC, id DESC zAll Daily Notes Load Error: r r%)rrr rresultsrr r rget_all_daily_notesRs r3c Csz'tjjdit}|jdd}d}|||f|}|||WStyB}zt d|WYd}~dSd}~ww)NTr#z SELECT * FROM daily_note WHERE session_id = %s ORDER BY date DESC, id DESC LIMIT 1 zLatest Data Load Error: r ) r r r rr rfetchonerrrr)rrr rresultrr r rget_yesterday_datahs r6c Csz7ttdd}t|d}tjjdit}|j dd}d}| |||f| }| | |WSt yR}ztd|WYd}~dSd}~ww) Nr)r*r,Tr#zUSELECT * FROM daily_note WHERE session_id = %s AND date = %s ORDER BY id DESC LIMIT 1zToday Data Load Error: r )rrrr-r.r r r rr rr4rrrr)rr/r0rr rr5rr r rget_today_datas  r7c Csz/tjjdit}|}d}|||||f|||t d|WdSt yJ}zt d|WYd}~dSd}~ww)Nz@UPDATE daily_note SET ai_comment = %s, advice = %s WHERE id = %szUpdated AI Feedback for ID: zAI Feedback Update Error: r r)rr advicerr rrr r rupdate_yesterday_ai_feedbacksr9c Csz:tjjdit}|}d}|||||f||j}||t d|d|d||dkWSt yU}zt d|WYd}~dSd}~ww) NzKUPDATE daily_note SET boss_comment = %s WHERE session_id = %s AND date = %szUpdated Boss Comment for z on z . Affected: rzBoss Comment Update Error: Fr ) r r r rr rrrowcountrrrrr)rr boss_commentrr r row_countrr r rupdate_boss_comments  r=rreturnc Csd}zs