Guest User

Untitled

a guest
Aug 27th, 2018
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. sqlalchemy query issue
  2. user = User.query.get(1)
  3. user.email = 'some@email.com'
  4.  
  5. if user.validate(): # The validate function performs a query to see if 'some@email.com' is already taken
  6. user.save()
  7.  
  8. check = User.query.filter_by(User.email='some@email.com').first()
  9. if check:
  10. # email already exists
  11.  
  12. def user_email_exists(email):
  13. return (not User.query.filter(User.email=email) == None)
  14.  
  15. ...
  16.  
  17. # User object to alter
  18. user = ...
  19.  
  20. # the new email address, which needs to be checked
  21. new_email_addr = 'new@shiny.com'
  22.  
  23. if user_email_exists(new_email_addr):
  24. raise SomeMeaningfulException() # or some `flash` message + a redirect
  25. else:
  26. user.email = new_email_addr
  27. db.session.add(user)
  28. db.commit()
  29.  
  30. ...
Add Comment
Please, Sign In to add comment