Guest User

Untitled

a guest
Feb 12th, 2019
411
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.57 KB | None | 0 0
  1. @login_blueprint.route('/login', methods=['GET', 'POST'])
  2. def login():
  3. if request.method == 'POST' and 'email' in request.form:
  4. try:
  5. email = request.form['email']
  6. password = request.form['password']
  7. database = mysql.connector.connect(
  8. host=DBHost,
  9. user=DBUser,
  10. passwd=DBPass,
  11. database=DB
  12. )
  13. cursor = database.cursor()
  14. query = "SELECT * FROM users WHERE (email, password) = %s, %s"
  15. values = (email, password)
  16. cursor.execute(query, values)
  17. cursor.fetchall()
  18. return render_template('dashboard.html', email=email)
  19. except Exception as error:
  20. print(error)
  21. return jsonify(result='that account does not exist')
  22. return render_template('login.html')
  23.  
  24. @register_blueprint.route('/register', methods=['GET', 'POST'])
  25. def register():
  26. if request.method == 'POST' and 'email' in request.form:
  27. email = request.form['email']
  28. password = request.form['password']
  29. database = mysql.connector.connect(
  30. host=DBHost,
  31. user=DBUser,
  32. passwd=DBPass,
  33. database=DB
  34. )
  35. cursor = database.cursor()
  36. query = "INSERT INTO users (email, password) VALUES (%s, %s)"
  37. values = (email, password)
  38. cursor.execute(query, values)
  39. database.commit()
  40. return jsonify(result='account created, proceed to login')
  41. return render_template('register.html')
Add Comment
Please, Sign In to add comment