Advertisement
lessientelrunya

Update Info DB

Apr 19th, 2017
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.64 KB | None | 0 0
  1. @app.route('/profile', methods=["GET", "POST"])
  2. @login_required
  3. def profile():
  4.     if request.method == "POST":
  5.         query = """
  6.            UPDATE user
  7.            SET first_name=:first_name, last_name=:last_name, birth_date=:birth_date
  8.            WHERE username=:username;
  9.        """
  10.         params = {
  11.             'first_name': request.form['first_name'],
  12.             'last_name': request.form['last_name'],
  13.             'birth_date': request.form['birth_date'],
  14.             'username': request.form['username']
  15.         }
  16.         g.db.execute(query, params)
  17.         g.db.commit()
  18.         flash("Your profile was correctly updated")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement