Advertisement
dollarortwo

alvin i need your help

Nov 7th, 2018
159
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.53 KB | None | 0 0
  1. import sqlite3
  2.  
  3. def currentUser():
  4. conn = sqlite3.connect('OS_Employee.db')
  5. print(conn.fetchall())
  6. userEmail = input("Enter login name: ")
  7. password = input("Enter password: ")
  8. with conn:
  9. cur = conn.cursor()
  10. try:
  11. cur.execute("SELECT*FROM employee WHERE(email='" + userEmail + "'AND password= '" + password + "')")
  12. results = cur.fetchall()
  13. rowCounter = 0
  14. for row in results:
  15. rowCounter += 1
  16. if results:
  17. for i in results:
  18. print("Login successful")
  19. loginSuccess = True
  20. else:
  21. print("Login unsucessful")
  22.  
  23. except:
  24. print("Connection failed")
  25.  
  26.  
  27. def newUser():
  28. try:
  29. createID = int(input("Enter employee ID: "))
  30. except ValueError:
  31. print("\nenter a valid employee ID\n")
  32. with sqlite3.connect('OS_Employee.db') as db:
  33. user = db.cursor()
  34. if createID in user:
  35. print("ID already exists")
  36. else:
  37. createLogin = input("Enter your email: ")
  38. if createLogin in user:
  39. print("email already exist")
  40. else:
  41. createPass = input("Enter new password: ")
  42. user[createLogin] = createPass
  43. print("\nNew user created\n")
  44.  
  45. status = input("Are you a registered user? y/n? Press q to quit: ")
  46. if status.lower() == "y":
  47. currentUser()
  48. elif status.lower() == "n":
  49. newUser()
  50. elif status.lower() == "q":
  51. quit()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement