users.py 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306
  1. from fastapi import APIRouter, Form, Depends, HTTPException, Body
  2. from fastapi.security import OAuth2PasswordRequestForm, OAuth2PasswordBearer
  3. from app.models.models import User
  4. from app.api import deps
  5. from sqlalchemy.orm import Session
  6. from typing import Any, Dict, Optional
  7. import secrets
  8. from fastapi_login.exceptions import InvalidCredentialsException
  9. from fastapi_login import LoginManager
  10. from datetime import timedelta,datetime
  11. from app.config import settings
  12. from pathlib import Path
  13. from jose import jwt
  14. import emails
  15. from emails.template import JinjaTemplate
  16. import logging
  17. import bcrypt
  18. import smtplib
  19. from email.mime.text import MIMEText
  20. from google.oauth2 import id_token
  21. from google.auth.transport import requests
  22. from fastapi.openapi.models import OAuthFlows as OAuthFlowsModel
  23. from fastapi.security.utils import get_authorization_scheme_param
  24. users = APIRouter()
  25. SECRET: str = secrets.token_urlsafe(32)
  26. manager = LoginManager(SECRET, '/login',default_expiry=timedelta(hours=72))
  27. @manager.user_loader()
  28. async def query_user(user_id: str):
  29. """
  30. Get a user from the db
  31. :param user_id: E-Mail of the user
  32. :return: None or the user object
  33. """
  34. result = await User.filter(email=user_id,is_gmail=0).first()
  35. if not result:
  36. print('無此筆資料')
  37. return None
  38. return result
  39. @manager.user_loader()
  40. async def query_user_username(user_id: str):
  41. """
  42. Get a user from the db
  43. :param user_id: E-Mail of the user
  44. :return: None or the user object
  45. """
  46. result = await User.filter(username=user_id).first()
  47. if not result:
  48. print('無此筆資料')
  49. return None
  50. return result
  51. @users.post("/login")
  52. async def login(data: OAuth2PasswordRequestForm = Depends()):
  53. email = data.username
  54. password = data.password
  55. user = await query_user(email)
  56. print(user)
  57. access_token = manager.create_access_token(
  58. data={'sub': email}
  59. )
  60. if not user:
  61. # you can return any response or error of your choice
  62. return {"message":"查無此人"}
  63. # elif password != user.password:
  64. # raise InvalidCredentialsException
  65. else:
  66. stored_hashed_password = user.password.encode('utf-8')
  67. if bcrypt.checkpw(password.encode('utf-8'),stored_hashed_password):
  68. return {'msg':'登入成功','code':'200','access_token': access_token,'username':user.username,'email':user.email,'points':user.points}
  69. else:
  70. return {"message": "Invalid username or password"}
  71. oauth2_scheme = OAuth2PasswordBearer(tokenUrl="https://oauth2.googleapis.com/token")
  72. CLIENT_ID = settings.CLIENT_ID
  73. @users.post("/login/google/access-token")
  74. async def login(username: str = Form(default=''), password: str = Form(default=''), email: str = Form(default='')
  75. ) -> Any:
  76. """
  77. OAuth2 compatible token login, get an access token for future requests
  78. """
  79. user = await User.filter(email=email,is_gmail=1).first() # 確認信箱是否已存在
  80. if not user:
  81. u = await User.create(username=username, password=password, email=email, is_gmail=1)
  82. # if user:
  83. # print('已用相同信箱註冊過,再開一個GMAIL帳號')
  84. # u = await User.create(username=username, password=password,email=email,is_gmail=1)
  85. access_token = manager.create_access_token(
  86. data={'sub': username}
  87. )
  88. return_msg = {
  89. "access_token": access_token,
  90. "token_type": "bearer",
  91. }
  92. return return_msg
  93. # if add_time_code:
  94. # available_ser_no = crud.serial_number.available(db, ser_no=add_time_code)
  95. # print(available_ser_no)
  96. # if available_ser_no:
  97. # user_in = schemas.UserUpdate(available_time=user.available_time + available_ser_no.time)
  98. # crud.user.update(db, db_obj=user, obj_in=user_in)
  99. #
  100. # ser_no_in = schemas.SerialNumberUpdate(code=available_ser_no.code, is_used=True,
  101. # used_datetime=str(datetime.now()), owner_id=user.id)
  102. # crud.serial_number.update(db, db_obj=available_ser_no, obj_in=ser_no_in)
  103. # print(available_ser_no.time, type(available_ser_no.time))
  104. # return_msg['time_added'] = available_ser_no.time
  105. # else:
  106. # return_msg['time_added'] = -1
  107. # return return_msg
  108. @users.post("/logout")
  109. async def logout():
  110. return {"msg":"logout success","code":200}
  111. @users.post("/add")
  112. async def add(username: str = Form(default=''), password: str = Form(default=''), email: str = Form(default=''), re_password: str = Form(default='')):
  113. if username and password and email:
  114. user_email = await query_user(email)
  115. user_username = await query_user_username(username)
  116. if user_email and user_username:
  117. return {"msg":"該信箱或使用者名稱已存在","code":403}
  118. # elif user_username:
  119. # return {"msg":"該使用者名稱已存在","code":403}
  120. else:
  121. if password == re_password:
  122. hashed_password = bcrypt.hashpw(password.encode('utf-8'), bcrypt.gensalt()).decode('utf-8')
  123. u = await User.create(username=username, password=hashed_password, email=email,is_superuser=0,is_gmail=0)
  124. if u:
  125. message = '註冊成功'
  126. subject = '註冊信'
  127. print(message)
  128. send_email(email,message,subject)
  129. return {"msg": "已寄送註冊信", "code": 200}
  130. else:
  131. return {"msg":"確認密碼錯誤","code":403}
  132. return {"msg": "create user failed", "code": 403}
  133. def generate_password_reset_token(email: str) -> str:
  134. delta = timedelta(hours=settings.EMAIL_RESET_TOKEN_EXPIRE_HOURS)
  135. now = datetime.utcnow()
  136. expires = now + delta
  137. exp = expires.timestamp()
  138. encoded_jwt = jwt.encode(
  139. {"exp": exp, "nbf": now, "sub": email}, settings.SECRET_KEY, algorithm="HS256",)
  140. print(encoded_jwt)
  141. return encoded_jwt
  142. def verify_password_reset_token(token: str):
  143. try:
  144. decoded_token = jwt.decode(token, settings.SECRET_KEY, algorithms=["HS256"])
  145. print(decoded_token)
  146. return decoded_token["sub"]
  147. except jwt.JWTError:
  148. return None
  149. def send_email(
  150. email_to: str,
  151. subject_template: str = "",
  152. html_template: str = "",
  153. environment: Dict[str, Any] = {},
  154. ):
  155. message = emails.Message(
  156. subject=JinjaTemplate(subject_template),
  157. html=JinjaTemplate(html_template),
  158. mail_from=(settings.EMAILS_FROM_NAME, settings.EMAILS_FROM_EMAIL),
  159. )
  160. smtp_options = {"host": settings.SMTP_HOST, "port": settings.SMTP_PORT}
  161. if settings.SMTP_TLS:
  162. smtp_options["tls"] = True
  163. if settings.SMTP_USER:
  164. smtp_options["user"] = settings.SMTP_USER
  165. if settings.SMTP_PASSWORD:
  166. smtp_options["password"] = settings.SMTP_PASSWORD
  167. response = message.send(to=email_to, render=environment, smtp=smtp_options)
  168. return {"message":f"send email result: {response}"}
  169. # logging.info(f"send email result: {response}")
  170. # email_content = MIMEText(message)
  171. # email_content["Subject"] = subject
  172. # email_content["From"] = 'zooey@choozmo.com'
  173. # email_content["To"] = email_to
  174. # try:
  175. # print('測試成功')
  176. # # Connect to the SMTP server
  177. # smtp_server = smtplib.SMTP(settings.SMTP_HOST, settings.SMTP_PORT)
  178. # smtp_server.starttls()
  179. #
  180. # # Login to the email account
  181. # smtp_server.login(settings.SMTP_HOST, settings.SMTP_PASSWORD)
  182. #
  183. # # Send the email
  184. # smtp_server.sendmail(settings.SMTP_HOST, email_to, email_content.as_string())
  185. #
  186. # # Close the connection
  187. # smtp_server.quit()
  188. #
  189. # return {"message": "Email sent successfully."}
  190. # except Exception as e:
  191. # print('測試失敗')
  192. def send_reset_password_email(email_to: str, email: str, token: str) -> None:
  193. subject = f"Password recovery for user {email}"
  194. with open(Path(settings.EMAIL_TEMPLATES_DIR) / "reset_password.html") as f:
  195. template_str = f.read()
  196. server_host = settings.SERVER_HOST
  197. link = f"{server_host}/reset-password?token={token}"
  198. message = '重新設定密碼'
  199. send_email(
  200. email_to=email_to,
  201. subject_template=subject,
  202. html_template=template_str,
  203. environment={
  204. "project_name": settings.PROJECT_NAME,
  205. "username": email,
  206. "email": email_to,
  207. "valid_hours": settings.EMAIL_RESET_TOKEN_EXPIRE_HOURS,
  208. "link": link,
  209. },
  210. )
  211. @users.post("/password-recovery/{email}")
  212. async def recover_password(email:str):
  213. user = await User.filter(email=email).first()
  214. if not user:
  215. raise HTTPException(
  216. status_code=404,
  217. detail="The user with this username does not exist in the system.",
  218. )
  219. password_reset_token = generate_password_reset_token(email=email)
  220. send_reset_password_email(
  221. email_to=user.email, email=email, token=password_reset_token
  222. )
  223. return {"msg": "Password recovery email sent"}
  224. from pydantic import BaseModel
  225. class Msg(BaseModel):
  226. msg: str
  227. @users.post("/reset-password/", response_model=Msg)
  228. async def reset_password(
  229. token: str = Body(...),
  230. new_password: str = Body(...),
  231. db: Session = Depends(deps.get_db),
  232. ) -> Any:
  233. """
  234. Reset password
  235. """
  236. email = verify_password_reset_token(token)
  237. print(email)
  238. if not email:
  239. raise HTTPException(status_code=400, detail="Invalid token")
  240. # user = await query_user(email)
  241. user = await User.filter(email=email).first()
  242. if not user:
  243. raise HTTPException(
  244. status_code=404,
  245. detail="The user with this username does not exist in the system.",
  246. )
  247. # elif not crud.user.is_active(user):
  248. # raise HTTPException(status_code=400, detail="Inactive user")
  249. hashed_password = bcrypt.hashpw(new_password.encode('utf-8'), bcrypt.gensalt()).decode('utf-8')
  250. user.password = hashed_password
  251. # db.add(user)
  252. db.commit()
  253. print(user.password)
  254. db.close()
  255. return {"msg": "Password updated successfully"}
  256. @users.get("/delete_user/{id}")
  257. async def delete(id: int):
  258. if id:
  259. await User.filter(id=id).delete()
  260. return {"msg": "success", "code": 200}
  261. return {"msg": "failed", "code": 400}
  262. @users.get("/information")
  263. async def get_information(email:str,is_gmail:int):
  264. result = await User.filter(email=email, is_gmail=is_gmail).first()
  265. return {"msg":result, "code":200}