o ¿Ôi:ã@s„ddlmZmZddlmZmZmZmZddlmZddl m Z ddl m Z ddl m Z e e ƒZdd„Zd d „Zd d „Zd d„ZdS)é)ÚrequestÚjsonify)Ú generate_otpÚsend_otp_emailÚsave_otp_to_dbÚgenerate_token)Údatetime)ÚBcrypt)Úapp)Úconnect_to_databasec Cs¨tƒ}|stdddœƒdfS|jdd}tj}| d¡}|s'tdddœƒd fSz£z{| d |f¡| ¡}|sItd ddœƒd fWW| ¡| ¡S| d |f¡| ¡}|r}|d}|t   ¡}td|  d¡t |ƒ|dddœƒdfWW| ¡| ¡St ƒ}tƒ} t||| ||ƒt||ƒtd| ddœƒdfWW| ¡| ¡StyÊ} ztd| ›ddœƒdfWYd} ~ W| ¡| ¡Sd} ~ ww| ¡| ¡w)NúDatabase connection errorÚtrue©ÚmessageÚerroréôT©Ú dictionaryÚemailzEmail is requiredéú%SELECT id FROM users WHERE email = %súEmail not foundé”zŸ SELECT otp, otp_expiry, token FROM password_reset_tokens WHERE email = %s AND otp_expiry > NOW() AND is_used = 0 Ú otp_expiryz9OTP already sent. Please try again after the expiry time.z%Y-%m-%d %H:%M:%SÚtokenÚfalse)rrÚtime_remainingrréÈzOTP sent to your email)rrrúAn unexpected error occurred: )r rÚcursorrÚjsonÚgetÚexecuteÚfetchoneÚcloserÚnowÚstrftimeÚstrrrrrÚ Exception) Ú connectionrÚdatarÚuserZexisting_otp_recordZotp_expiry_timerÚotprÚe©r.úK/Users/harjaapdhillon/Desktop/newidea/medvista_backend/Services/Password.pyÚforgot_password s`  % Ýü ûú ñ  û$ €û r0c Csötƒ}|stdddœƒdfS|jdd}tj}g}d|vr"| d¡d|vr+| d¡d |vr4| d ¡|rEtd d  |¡›ddœƒd fS| d¡}| d¡}| d ¡}zzu| d |f¡|  ¡}|svtdddœƒdfWW|  ¡|  ¡S| d||f¡|  ¡}|s—tdddœƒd fWW|  ¡|  ¡S|d|kr¸t   ¡|dkr¸tdddœƒdfWW|  ¡|  ¡Stdddœƒd fWW|  ¡|  ¡St yñ} ztd| ›ddœƒdfWYd} ~ W|  ¡|  ¡Sd} ~ ww|  ¡|  ¡w)Nr r rrTrrr,rúMissing required fields: ú, rrrrz® SELECT otp, otp_expiry, is_used FROM password_reset_tokens WHERE email = %s AND token = %s ORDER BY id DESC LIMIT 1 zInvalid or expired OTP or tokenrzOTP verified successfullyrrzInvalid OTP or OTP expiredr)r rrrr ÚappendÚjoinr!r"r#r$rr%r() r)rr*Úmissing_fieldsrr,rr+Úrecordr-r.r.r/Ú verify_otpFs^        êû ÷ ú û$ €û r7c Cs²tƒ}|stdddœƒdfS|jdd}tj}g}d|vr"| d¡d|vr+| d¡d |vr4| d ¡|rEtd d  |¡›ddœƒd fS| d¡}| d¡}| d ¡}z{zS| d ||f¡|  ¡}|swtdddœƒd fWW|  ¡|  ¡St   |¡  d¡}| d||f¡| ¡| d|f¡| ¡tdddœƒdfWW|  ¡|  ¡StyÏ} ztd| ›ddœƒdfWYd} ~ W|  ¡|  ¡Sd} ~ ww|  ¡|  ¡w)Nr r rrTrrÚ new_passwordrr1r2rzˆ SELECT otp, otp_expiry, is_used FROM password_reset_tokens WHERE email = %s AND token = %s zInvalid email or tokenúutf-8ú/UPDATE users SET password = %s WHERE email = %sz2DELETE FROM password_reset_tokens WHERE token = %súPassword updated successfullyrrr)r rrrr r3r4r!r"r#r$ÚbcryptÚgenerate_password_hashÚdecodeÚcommitr() r)rr*r5rr8rr6Úhashed_new_passwordr-r.r.r/Úreset_passwordsd       ü îÿÿÿÿ û$ €û rAcCsøt ¡}| d¡}| d¡}| d¡}|r|r|s"tdddœƒdfStƒ}|s0tdddœƒd fS| ¡}| d |f¡| ¡}|sJtd ddœƒd fSt  |d |¡s[tdddœƒdfSt  |¡  d¡}| d||f¡|  ¡|  ¡tdddœƒdfS)NrÚ old_passwordr8zMissing required fieldsr rrr rz+SELECT password FROM users WHERE email = %szUser not foundrrzOld password is incorrectr9r:r;rr)rÚget_jsonr!rr rr"r#r<Úcheck_password_hashr=r>r?r$)r*rrBr8r)rr+r@r.r.r/Úchange_passwordºs6    ÿÿÿrEN)ÚflaskrrZServices.SendEmailrrrrrÚ flask_bcryptr r Úconfr r<r0r7rArEr.r.r.r/Ús    ;9 ;