o լi @sddlZddlZddlZddlZddlmZddlmZee Z dZ ddZ de de d efd d Zde de d efd d Zde d edBfddZde d efddZdde dede ded ef ddZdS)N)datetime) get_db_configGoalskill_logincCstt}tjjdi|S)uGoalskill_login DB 연결N)rLOGIN_DBmysql connectorconnect)configrr4/home/air/goalskill_t/back/app/models/auth_module.py _get_login_dbsr user_idpasswordreturnc CsVt}|jdd}zze|d|f|r&ddddWW||St|dt d}d t j dd t t}|d |||f|td |d |d|ddWW||Sty}z&|td|dddt|dWYd}~W||Sd}~ww||w)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会員登録失敗: )r cursorexecutefetchoneclosebcrypthashpwencodegensaltdecodeuuiduuid4hexintrnow timestampcommitloggerinfo Exceptionrollbackerrorstr)r rconnr password_hashrerrr create_users:  ( "  r2c CsHt}|jdd}zzb|d|f|}|s(ddddWW||St|d|d dsFddd dWW||S|d |d f|t d |d|dddWW||St y}z"t d|dddt |dWYd}~W||Sd}~ww||w)ur 유저 인증을 수행합니다. Returns: {"success": bool, "session_id": str|None, "message": str} TrzBSELECT id, password_hash, session_id FROM login WHERE user_id = %sFNu存在しないIDです。rrr0u'パスワードが一致しません。z1UPDATE login SET last_login = NOW() WHERE id = %sidz[Auth] User logged in: ruログイン成功！z[Auth] Login error: uログイン失敗: )r rrrrrcheckpwrr(r)r*r+r-r.)r rr/ruserr1rrr authenticate_userFsD    "  r6rc Cst}|jdd}z:z|d|f|WW||StyC}ztd|WYd}~W||dSd}~ww||w)u.세션 ID로 유저 정보를 조회합니다.TrzWSELECT id, user_id, session_id, created_at, last_login FROM login WHERE session_id = %sz[Auth] Session lookup error: N)r rrrrr+r)r-rr/rr1rrr get_user_by_sessionps&      r8c Cst}|jdd}z;z|d|f|WW||StyD}ztd|gWYd}~W||Sd}~ww||w)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)r rrfetchallrr+r)r-r7rrr get_study_progresss&     r:item_idstatusscorec Cst}|jdd}z]z+|d||||f|td|d|d|dddWW||Styf}z%|t d |d d t |dWYd }~W||Sd }~ww||w) 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) r rrr(r)r*rr+r,r-r.)rr;r<r=r/rr1rrr update_study_progresss,        r>)r)mysql.connectorrrr"loggingrapp.core.configr getLogger__name__r)rr r.dictr2r6r8listr:r%r>rrrr s    ,*$