o R9h*@sddlZddlmZmZmZddlZddlmZm Z ddlZddl Z ddl m Z ddl mZddlmZddlmZddlmZeed Zed Zejd d gd ddZddZejdd gd ddZejddgd eddZejddgd eddZdS)N)requestjsonifysession)check_password_hashgenerate_password_hashwraps)api_bp)get_db_connection) load_dotenv)CORS JWT_SECRET JWT_ALGORITHMz/loginPOST)methodsc CsLt}|d}|d}|r|stddidfSt}|}z{zR|d|f|}|rct|d|rct j |d|d t j t j d d d ttd }t||d dfWW||StddidfWW||Sty}ztddt|idfWYd}~W||Sd}~ww||w)Nusernamepassworderroru0아이디와 비밀번호를 입력해주세요.z6SELECT id, email, password FROM users WHERE email = %sr)hours)user_idrexp) algorithm)tokenru;아이디 또는 비밀번호가 올바르지 않습니다.u,로그인 중 오류가 발생했습니다: )rget_jsongetrr cursorexecutefetchonerjwtencodedatetimeutcnow timedeltar rclose Exceptionstr)datarrconncuruserrer17/home/skpark/git/infrasmart_work/infrasmart/api/auth.py api_logins@    &  r3cstfdd}|S)Ncstjd}|stddidfSztj|ttgd}|dtd<|dtd<Wn#tj y9tdd idfYStj yJtdd idfYSw|i|S) N Authorizationru토큰이 필요합니다.r) algorithmsrremailu 토큰이 만료되었습니다.u$유효하지 않은 토큰입니다.) rheadersr rr$decoder rrExpiredSignatureErrorInvalidTokenError)argskwargsrr,fr1r2 decorated;s  z!token_required..decoratedr)r>r?r1r=r2token_required:sr@z /registerc CsFt}|d}|d}|d}|d}|r |r |r |s(tddidfSt|}t}|}zfz=|d|f|rRtdd idfWW| | S|d ||||f| td d id fWW| | St y}ztddt |idfWYd}~W| | Sd}~ww| | w)Nnamecompanyr6rru$모든 필드를 입력해주세요.rz%SELECT id FROM users WHERE email = %su$이미 등록된 이메일입니다.zt INSERT INTO users (username, company, email, password) VALUES (%s, %s, %s, %s) messageu&회원가입이 완료되었습니다.u/회원가입 중 오류가 발생했습니다: r) rrr rrr r!r"r#r)commitr*r+) r,rArBr6rhashed_passwordr-r.r0r1r1r2 api_registerOs@       &  rGz/delete_accountDELETEc Cszfz=td}|stddidfWW||St}|}|d|f|tddidfWW||Styf}ztdd t |id fWYd}~W||Sd}~ww||w) Nrr$사용자 인증이 필요합니다.rzDELETE FROM users WHERE id = %srCu'회원 탈퇴가 완료되었습니다.ru0회원 탈퇴 중 오류가 발생했습니다: r) rr rr)r r!r"rEr*r+)rr.r-r0r1r1r2delete_accountxs*   &  rJz/update_accountPUTc CsBt}|d}|d}|d}|d}td}|s'tddidfS|r-|r-|s5tdd id fSt}|}z[z2|rPt|}|d |||||fn |d ||||f| td didfWW| | St y} ztddt | idfWYd} ~ W| | Sd} ~ ww| | w)NrArBr6rrrrIru7이름, 회사명, 이메일은 필수 항목입니다.rz UPDATE users SET username = %s, company = %s, email = %s, password = %s WHERE id = %s z UPDATE users SET username = %s, company = %s, email = %s WHERE id = %s rCu6회원정보가 성공적으로 수정되었습니다.ru6회원정보 수정 중 오류가 발생했습니다: r) rrr rrr r!rr"rEr)r*r+) r,rArBr6rrr-r.rFr0r1r1r2update_accountsF           &  rL)osflaskrrrjwt.jwks_clientr$werkzeug.securityrrr& functoolsrapir utils.commonr dotenvr flask_corsr getenvr rrouter3r@rGrJrLr1r1r1r2s2        " (