o Ji;#@szddlmZddlmZmZddlmZddlmZddl Z ddl Z ddl Z ddl mZeZejedgddgdgd ee d d d Zd dZGdddeZGdddeZGdddeZddZeddedefddZeddefddZed d!efd"d#Zed$d!efd%d&Zed'd!efd(d)Zed*d!efd+d,Z ed-d!efd.d/Z!dS)0)CORSMiddleware)FastAPI HTTPException) BaseModel) JSONResponseN) AsyncOpenAI*T) allow_originsallow_credentials allow_methods allow_headersOPENAI_API_KEYzsk-proj-A2OoRlPn5SZTMmEmErYgmIeZkS4C05ZcsAOBSv4tjWKV986Wubbubq264wsnoqttQtJZhSiciPT3BlbkFJn246PFIcpGAJ06ZbNsEnr8ocwpyDjpPSTsnOLQFm0R51CUCKUgZm6G_rUZYhvPOcPfyfMl4r8A)api_keycCstjjdddddS)N localhost GOALSkillzGOALSkill_99!@INPUT_DB)hostuserpassworddatabase)mysql connectorconnectrr'/home/air/goalskill_t/back/GOALSkill.pyget_db_connections rc@s*eZdZUeed<eed<dZeed<dS) ChatRequest session_idmessageOFFthinking_levelN)__name__ __module__ __qualname__str__annotations__r rrrrr(s rc@s.eZdZUeed<eed<eed<eed<dS) LogRequestrmodesenderrN)r!r"r#r$r%rrrrr&.s  r&c@seZdZUeeed<dS)JournalRequestanswersN)r!r"r#listr$r%rrrrr)5s r)c Cszz"t}|}d}||||||f|||WdSty<}ztd|WYd}~dSd}~ww)NzTINSERT INTO chat_history (session_id, mode, sender, message) VALUES (%s, %s, %s, %s)DB Save Error: )rcursorexecutecommitclose Exceptionprint)rr'r(rconnr-sqlerrr save_chat_log:sr6z-/goal-skill-t/api/history/{mode}/{session_id}r'rc stz$t}|jdd}d}||||f|}||d|iWSty9}ztdt|dd}~ww)NT) dictionaryz\SELECT sender, message FROM chat_history WHERE session_id = %s AND mode = %s ORDER BY id ASChistory status_codedetail)rr-r.fetchallr0r1rr$)r'rr3r-r4rowsr5rrr get_historyJs  r?z/goal-skill-t/api/logreqcs t|j|j|j|jddiS)Nstatusok)r6rr'r(r)r@rrr log_messageYsrCz/goal-skill-t/api/chatrequestc z4t|jdd|jtjjjddddd|jdgddIdH}|jd jj}t|jdd ||dd WSt yI}zt d t |d d}~ww)Nchatr gpt-4o-minisystemuP당신은 사용자의 목표 달성과 스킬 성장을 돕는 코치입니다.rolecontentffffff?modelmessages temperaturerbotanswerthinking_processr9r: r6rrclientrF completionscreatechoicesrKr1rr$rDresponserSr5rrr chat_basicbs&   r\z/goal-skill-t/api/MBTIc rE)NMBTIrrGrHu?당신은 사용자의 MBTI를 검사하는 선생님입니다.rIrLrMrrQrRr9r:rUrZrrr chat_mbti&   r^z/goal-skill-t/api/Pythonc rE)NPythonrrGrHuj당신은 사용자의 일본 코딩 사이트 Paiza에 B랭크를 취득하기 위한 선생님입니다.rIrLrMrrQrRr9r:rUrZrrr chat_pythonr_raz/goal-skill-t/api/Reportc rE)NReportrrGrHuk당신은 사용자의 오늘 하루 어떤 것을 했는지 일지 작성을 도와주는 역할입니다.rIrLrMrrQrRr9r:rUrZrrr chat_reports&   rcz!/goal-skill-t/api/GenerateJournalc sLzt|jdkrtddd|jd|jd|jd|jdf\}}}}d |d |d |d |d }tjjjddddd|dgddIdH}|jdjj }z"t }| } d} | | |||||f| | |Wnty} z td| WYd} ~ nd} ~ ww|ddWSty} ztdt| dd} ~ ww)Niu$답변이 충분하지 않습니다.r:ru 사용자의 학습 답변을 바탕으로 전문적이고 깔끔한 '오늘의 학습 일지'를 작성해주세요. [사용자 답변] 1. 배운 것: u 2. 학습 방법: u 3. 어려웠던 점: u 4. 해결 방법: u/ [출력 형식] # 📅 오늘의 학습 일지 ## 💡 핵심 배움 (내용 요약) ## 🛠️ 학습 과정 및 트러블 슈팅 (내용 요약) ## 🚀 내일의 다짐 (격려의 한마디) rGrHu*당신은 전문적인 에디터입니다.rIrrLrMzINSERT INTO learning_logs (what_learned, how_learned, difficulty, solution, final_report) VALUES (%s, %s, %s, %s, %s)r,zDB Saved & GeneratedrRr9)lenr*rrVrFrWrXrYrrKrr-r.r/r0r1r2r$) rDq1q2q3q4promptr[ final_reportr3r-r4db_errr5rrrgenerate_journalsR ,  rp)"fastapi.middleware.corsrfastapirrpydanticrfastapi.responsesr tracebackosmysql.connectorropenairappadd_middlewaregetenvrVrrr&r)r6getr$r?postrCr\r^rarcrprrrrsL