Ui$ ddlZddlZddlZddlZddlmZddlmZddlm Z ej e Z dZ dZdeded efd Zd efd Zgd Zd efdZdeded efdZd ed edzfdZd ed efdZdd edededed ef dZdS)N)datetime) get_db_config)create_result_rowGoalskill_logincVtt}tjjdi|S)uGoalskill_login DB 연결)rLOGIN_DBmysql connectorconnect)configs /app/app/models/auth_module.py _get_login_dbrs( 8 $ $F ? " , ,V , ,,user_idpasswordreturnct}|d} |d|f|r.dddd||St j|dt j d}d tj j dd ttj}|d |||f|t$d |d |t)|t+|dt-|d|dd||S#t.$ry}|t$d|dddt5|dcYd}~||Sd}~wwxYw#||wxYw)uo 새 유저를 등록합니다. Returns: {"success": bool, "session_id": str|None, "message": str} T dictionaryz'SELECT id FROM login WHERE user_id = %sFNu すでに存在するIDです。success session_idmessageutf-8sess_z INSERT INTO login (user_id, password_hash, session_id, created_at) VALUES (%s, %s, %s, NOW()) z[Auth] User registered: z , session: u会員登録成功！zuth] Registration error: u会員登録失敗: )rcursorexecutefetchoneclosebcrypthashpwencodegensaltdecodeuuiduuid4hexintrnow timestampcommitloggerinfo_create_user_curriculumr_init_category_progress Exceptionrollbackerrorstr)rrconnr password_hashres r create_userr:sc ??D [[D[ ) )F'@7*MMM ??   i$DEghhD   A hoog&>&>@P@PQQXXY`aa VTZ\\-crc2UC 8P8P8R8R4S4SUU   mZ 0      OwOO:OOPPP +++*a((( +++zF]^^   bbb  6166777 A`X[\]X^X^A`A`aaaaaaa  b   s70G ?D!G I AII II  I*I9rcZtd}tjjdi|}|} |d|f||j}t d|d|nH#t$r;}| t d|Yd}~nd}~wwxYw| | dS#| | wxYw)uImaster_items(C_DB)의 커리큘럼을 user_curriculum에 복사합니다.C_DBa* INSERT INTO user_curriculum (session_id, item_id, block_id, sort_order, status, category, weight_pct) SELECT %s, item_id, block_id, sort_order, 'NOT_STARTED', category, weight_pct FROM master_items ORDER BY block_id, sort_order, item_id z#[Auth] Curriculum created: session=z, items=z"[Auth] Curriculum creation error: Nr)rr r r rr r.rowcountr/r0r3r4r5r")rr r7rcountr9s rr1r1Ls/ 6 " "F ? " , ,V , ,D [[]]F  M     U*UUeUUVVVV ???  =!==>>>>>>>>?      s0AB D C1C DCD*D*)!u CERT_第1章u CERT_第2章u CERT_第3章u CERT_第4章u CERT_第5章u CERT_第6章u CERT_第7章u CERT_第8章u CERT_第9章u CERT_第10章u CERT_第11章u CERT_第12章u CERT_第13章u CERT_第14章u CERT_第15章u CERT_第16章u CERT_第17章u CERT_第18章u CERT_第19章u CERT_第20章u CERT_第21章u CERT_第22章Python JavaScriptMySQLFastAPIu外部API連携AWSMCPu PJT企画u PJT設計u PJT開発u テストctd}tjjdi|}|} d}fdt D}||||t ddt|nH#t$r;}| t d|Yd}~nd}~wwxYw||dS#||wxYw) ua회원 가입 시 카테고리별 진행 상황의 초기 행(12행, total%).을 생성합니다. Goalskill_DBz INSERT INTO user_category_progress (session_id, category, total_pct) VALUES (%s, %s, 0.0) ON DUPLICATE KEY UPDATE total_pct = total_pct cg|]}|fSrr).0catrs r z+_init_category_progress..|s===cS!===rz.[Auth] Category progress initialized: session=z , categories=z%[Auth] Category progress init error: Nr)rr r r r_ALL_CATEGORIES executemanyr.r/r0lenr3r4r5r")rr r7rsqlrowsr9s` rr2r2qsK > * *F ? " , ,V , ,D [[]]F  >===_===3%%%  iZii^abf^g^giijjjj BBB  @Q@@AAAAAAAAB      s0A,B)(D) C.31C)$D)C..D*Ec"t}|d} |d|f|}|s.dddd||St j|d|d ds.ddd d||S|d |d f|t d |d|ddd||S#t$re}t d|dddt|dcYd}~||Sd}~wwxYw#||wxYw)ur 유저 인증을 수행합니다. Returns: {"success": bool, "session_id": str|None, "message": str} TrzBSELECT id, password_hash, session_id FROM login WHERE user_id = %sFNu存在しないIDです。rrr8u'パスワードが一致しません。z1UPDATE login SET last_login = NOW() WHERE id = %sidz[Auth] User logged in: ruログイン成功！z[Auth] Login error: uログイン失敗: )rrr r!r"r#checkpwr%r.r/r0r3r5r6)rrr7ruserr9s rauthenticate_userrTs ??D [[D[ ) )F P J      c$DEabb(   %~hoog66_8M8T8TU\8]8]^^ p$DEnoo     ? $ZM     7g77888tL/ANeff   bbb /A//000 A`X[\]X^X^A`A`aaaaaaa  b   s=2E2AE20AE22 G!<2G.G!/G$G!!G$$*Hct}|d} |d|f|||S#t $rP}t d|Yd}~||dSd}~wwxYw#||wxYw)u.세션 ID로 유저 정보를 조회합니다.TrzWSELECT id, user_id, session_id, created_at, last_login FROM login WHERE session_id = %sz[Auth] Session lookup error: N)rrr r!r"r3r/r5rr7rr9s rget_user_by_sessionrWs ??D [[D[ ) )F  e M        8Q88999ttt     s)*A99 CC CCC*Dct}|d} |d|f|||S#t $rQ}t d|gcYd}~||Sd}~wwxYw#||wxYw)u5유저의 학습 진행도 목록을 조회합니다.Trz SELECT id, session_id, item_id, status, score, updated_at FROM user_study_progress WHERE session_id = %s ORDER BY item_id z[Auth] Progress fetch error: N)rrr fetchallr"r3r/r5rVs rget_study_progressrZs ??D [[D[ ) )F  M        8Q88999      s/*A99 CC!C"CCC*Ditem_idstatusscorect}|d} |d||||f|td|d|d|ddd||S#t$rx}|t d |d d t|dcYd }~||Sd }~wwxYw#||wxYw) u3학습 진행도를 업데이트합니다 (UPSERT).Tra INSERT INTO user_study_progress (session_id, item_id, status, score) VALUES (%s, %s, %s, %s) ON DUPLICATE KEY UPDATE status = VALUES(status), score = VALUES(score), updated_at = NOW() z![Auth] Progress updated: session=z, item=z , status=u進捗更新完了)rrz[Auth] Progress update error: Fu更新失敗: N) rrr r.r/r0r"r3r4r5r6)rr[r\r]r7rr9s rupdate_study_progressr_se ??D [[D[ ) )F &% 0   e ee7ee]ceefff,@AA   HHH  9a99::: -Fc!ff-F-FGGGGGGG  H   s1AB$$ D&.AD!3D&4D)!D&&D))*E)r)mysql.connectorr r#r(loggingrapp.core.configrapp.models.goalskill_moduler getLogger__name__r/r rr6dictr:r1rKr2rTrWlistrZr+r_rrrrhs  ))))))999999  8 $ $ ---.......b64$s$c$d$$$$TCD4K*34.cCSY]r