o j>i«ã@sšddlmZmZddlZddlmZddlmZddl m Z m Z m Z dd„Z dd „Z d d „Zd d „Zdd„Zdd„Zdd„Zdd„Zdedefdd„ZdS)é)ÚListÚDictN)Ú B_DB_CONFIG)Úlogger)ÚdatetimeÚtimezoneÚ timedeltac Cs†z'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Ú connectorÚconnectrÚcursorÚexecuteÚcommitÚcloseÚ ExceptionrÚerror)Ú session_idÚsenderÚmessageÚconnr ÚsqlÚer r ú9/home/air/goalskill_t/back/app/models/report_db_module.pyÚsave_daily_log s€ÿrc Cs z4tjjdit¤Ž}| ¡}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 rrrrÚinforr) rÚdateÚlearningÚmindsetÚ ai_commentrr rrr r rÚsave_structured_diarys€ÿr!c Cóˆz'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 rÚfetchallrrrr)rrr rÚrowsrr r rÚget_daily_log_from_db0s €þr(c 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 rÚresultsrr r rÚget_all_daily_notes@s €þr*c Cs†z'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 rÚfetchonerrrr)rrr rÚresultrr r rÚget_yesterday_dataVs €þr-c Cs¦z7ttddƒ}t |¡ d¡}tjjdit¤Ž}|j dd}d}|  |||f¡|  ¡}|  ¡|  ¡|WSt yR}zt d|›¡WYd}~dSd}~ww) Né ©Úhoursú%Y-%m-%dTr#zUSELECT * FROM daily_note WHERE session_id = %s AND date = %s ORDER BY id DESC LIMIT 1zToday Data Load Error: r )rrrÚnowÚstrftimer r r rr rr+rrrr)rÚJSTÚ today_strrr rr,rr r rÚget_today_datams  €þr6c Cs–z/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 rÚupdate_yesterday_ai_feedbacks€ÿr8c Cs¬z: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 rrÚrowcountrrrrr)rrÚ boss_commentrr rÚ row_countrr r rÚupdate_boss_comment”s  €þr<rÚreturnc CsÈd}zs