Iji),ddlmZmZddlZddlmZddlmZddl m Z m Z m Z dZ ddZ dZd Zd Zd Zd Zd ZdZdedefdZdededefdZdedefdZdedefdZdS))ListDictN) B_DB_CONFIG)logger)datetimetimezone timedeltacr tjjdit}|}d}|||||f|||dS#t$r"}tj d|Yd}~dSd}~wwxYw)NzGINSERT INTO daily_log (session_id, sender, message) VALUES (%s, %s, %s)zDaily Log Save Error: ) mysql connectorconnectrcursorexecutecommitclose Exceptionrerror) session_idsendermessageconnrsqles #/app/app/models/report_db_module.pysave_daily_logr s 3&5555WsZ9:::   333 1a112222222223sBB B6B11B6c  tjjdit}|}d}||||||||f|||tj d|d|d|ddS#t$r"} tj d| Yd} ~ dSd} ~ wwxYw)Nz INSERT INTO daily_note (session_id, daily, date, learning, today_mindset, ai_comment) VALUES (%s, %s, %s, %s, %s, %s) zDaily Note Saved: z - z (day=)zDaily Note Save Error: r r r rrrrrrrinforr) rdatelearningmindset ai_commentdailyrrrrs rsave_structured_diaryr&s4&5555  sZhTUUU    LLL*LLELLLMMMMM 444 2q223333333334sB'B++ C5CCct tjjdit}|d}d}|||f|}|||S#t$r#}tj d|gcYd}~Sd}~wwxYw)NT dictionaryzWSELECT sender, message, created_at FROM daily_log WHERE session_id = %s ORDER BY id ASCzDaily Log Load Error: r r r rrrrfetchallrrrr)rrrrrowsrs rget_daily_log_from_dbr-0s &5555--gsZM***      1a11222 BB B7B2,B72B7c ttd}tj|d}t jjd it}| d}d}| |||f| }| | |S#t$r#}tjd|gcYd}~Sd}~wwxYw) 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 )rr rnowstrftimer r rrrrr+rrrr)rJST today_strrrrr,rs rget_today_daily_logr8>syq)))**L%%..z:: &5555--BsZ3444      7A77888 sC C C<C71C<7C<ct tjjdit}|d}d}|||f|}|||S#t$r#}tj d|gcYd}~Sd}~wwxYw)NTr(zz SELECT * FROM daily_note WHERE session_id = %s ORDER BY date DESC, id DESC zAll Daily Notes Load Error: r r*)rrrrresultsrs rget_all_daily_notesr;Rs&5555--  sZM***//##    7A77888 r.cr tjjdit}|d}d}|||f|}|||S#t$r"}tj d|Yd}~dSd}~wwxYw)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 rrrrfetchonerrrr)rrrrresultrs rget_yesterday_datar?hs&5555--  sZM***""    333444tttttsBB B6B11B6c ttd}tj|d}t jjdit}| d}d}| |||f| }| | |S#t$r"}tjd|Yd}~dSd}~wwxYw) Nr0r1r3Tr(zUSELECT * FROM daily_note WHERE session_id = %s AND date = %s ORDER BY id DESC LIMIT 1zToday Data Load Error: r )rr rr4r5r r rrrrr=rrrr)rr6r7rrrr>rs rget_today_datarAsyq)))**L%%..z:: &5555--esZ3444""    2q22333tttttsC C C;C66C;c tjjdit}|}d}|||||f|||tj d|dS#t$r"}tj d|Yd}~dSd}~wwxYw)Nz@UPDATE daily_note SET ai_comment = %s, advice = %s WHERE id = %szUpdated AI Feedback for ID: zAI Feedback Update Error: r r)rr$advicerrrrs rupdate_yesterday_ai_feedbackrDs7&5555QsZ<===    ?:??@@@@@ 777 5!556666666667sBB!! C +CC c tjjdit}|}d}|||||f||j}||tj d|d|d||dkS#t$r"}tj d|Yd}~dSd}~wwxYw) 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 rrrrrrowcountrrr rr)rr! boss_commentrrr row_countrs rupdate_boss_commentrIs&5555\s\:t<=== O    ] ]]]]R[]]^^^1}  6166777uuuuusB/B22 C<CCrreturncXd} ttd}tj|}|d}t jjdit}| }d}| |||f| }| | |duS#t$rL}tjd||r(|r| Yd}~dSd}~wwxYw)Nr0r1r3zESELECT id FROM daily_note WHERE session_id = %s AND date = %s LIMIT 1zCheck Today Log Error: Fr )rr rr4r5r r rrrrr=rrrr is_connected) rrr6r4r7rrrowrs rcheck_today_daily_log_existsrNs' Dyq)))**l3LL,, &5555UsZ3444oo  $  2q22333  D%%''  JJLLLuuuuu sCC D)AD$$D)r%cd} tjjdit}|}d}||||f|}|||duS#t$rL}tj d||r(| r|Yd}~dSd}~wwxYw)u@daily_note에 해당 day 번호의 레코드가 있는지 확인NzFSELECT id FROM daily_note WHERE session_id = %s AND daily = %s LIMIT 1z Check Daily Note For Day Error: Fr r r rrrrr=rrrrrLrr%rrrrMrs rcheck_daily_note_for_dayrRs D &5555VsZ/000oo  $  ;;;<<<  D%%''  JJLLLuuuuu sBB C#ACC#cd} tjjdit}|}d}||||f|}|||r|dndS#t$rL}tj d||r(| r|Yd}~dSd}~wwxYw)uCdaily_note에서 해당 day의 작성 날짜(date 컨럼)를 반환NzYSELECT date FROM daily_note WHERE session_id = %s AND daily = %s ORDER BY id DESC LIMIT 1rz#Get Daily Note Date For Day Error: r rPrQs rget_daily_note_date_for_dayrTs D &5555isZ/000oo  &s1vv$&  >1>>???  D%%''  JJLLLttttt sBB C+AC&&C+c ddlm}ddl}d}g} |jjdi|}|d}d}|||f|}|D]c}t|d dd dd } |d rd nd } | d| d|dd| dd} || |f|} | D]c}t|d dd dd } |d rd nd } | d| d|dd| d| | |sdSd |S#t$rL} tjd| |r(|r| Yd} ~ dSd} ~ wwxYw)zYFetches quiz and cert results for the session solved today to understand user's struggle.r) A_DB_CONFIGNTr(a- SELECT q.question_text, r.user_answer, r.is_correct FROM quiz_results r JOIN quiz_problems q ON r.problem_id = q.problem_id WHERE r.session_id = %s AND DATE(r.solved_at) = CURDATE() ORDER BY r.solved_at DESC LIMIT 10 question_text  d is_correctOXz[Python Quiz] Q: z ... | Ans: user_answerz | Result: a' SELECT q.question_text, r.user_answer, r.is_correct FROM cert_results r JOIN cert_questions q ON r.question_id = q.id WHERE r.session_id = %s AND DATE(r.solved_at) = CURDATE() ORDER BY r.solved_at DESC LIMIT 10 z[Cert Quiz] Q: uクイズ履歴なしzGet Quiz Logs Error: uクイズ履歴取得失敗r )app.core.configrVmysql.connectorr rrrr+strreplaceappendrjoinrrrrL)rrVr rquiz_strrsql_quiz rows_quizrq_textcorrsql_cert rows_certrs rget_daily_quiz_logsrmsh++++++ DH.-&u&5555--  x*///OO%%  h hA?+,,44T3??EFL/233sD OOfff1]CSff`dff g g g g  x*///OO%%  f fA?+,,44T3??EFL/233sD OOdfdd=AQdd^bdd e e e e   +**yy""" --- 0Q00111  D%%''  JJLLL,,,,,, -sE8F F G5)AG00G5)N)typingrrr`r r_rapp.corerrrr rr&r-r8r;r?rArDrIraboolrNintrRrTrmr rrss''''''2222222222 3 3 34444,   (,.(777&.ST6ST&C&4-C4-C4-4-4-4-4-4-rr