mekasu0124

Untitled

Sep 21st, 2024
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 1.04 KB | None | 0 0
  1. def get_user(self, username: str) -> models.User:
  2.     file_path = self.create_db_path()
  3.  
  4.     with sql.connect(file_path) as mdb:
  5.         cursor = mdb.cursor()
  6.  
  7.         srch = 'SELECT Password FROM Users WHERE Username=?'
  8.         srch2 = 'SELECT Password FROM Passwords WHERE Username=?'
  9.  
  10.         try:
  11.             user_results = cursor.execute(srch, (username, )).fetchone()
  12.  
  13.             if not user_results:
  14.                 return False
  15.            
  16.             password_results = cursor.execute(srch2, (username, )).fetchall()
  17.  
  18.             return_user = models.User(
  19.                 username = username,
  20.                 password = user_results[0],
  21.                 saved_passwords = password_results if password_results else []
  22.             )
  23.  
  24.             if password_results:
  25.                 for password in password_results:
  26.                     return_user.saved_passwords.append(password[0])
  27.  
  28.             return return_user
  29.         except Exception as e:
  30.             raise e
  31.         except sql.Error as err:
  32.             raise err
Advertisement
Add Comment
Please, Sign In to add comment