From fc0203fd66be5b9003e8a6a362a0811dea7d743a Mon Sep 17 00:00:00 2001 From: Guillaume Horel Date: Sat, 21 Mar 2015 20:23:46 -0400 Subject: properly save the rsvp form --- wedding.py | 19 ++++++++++++++++++- 1 file changed, 18 insertions(+), 1 deletion(-) (limited to 'wedding.py') diff --git a/wedding.py b/wedding.py index c8b5b54..249c940 100644 --- a/wedding.py +++ b/wedding.py @@ -66,7 +66,24 @@ def rsvp(): form=r) if request.method == 'POST': db = get_db() - cur = db.execute("UPDATE guests set ", args) + args = (request.form["fullname"], + int(request.form["answer"]), + request.form["email"], + request.form["mailing"], + int(request.form["plusone"]), + request.form["plusonename"], + int(request.form["kids"]), + request.form["kidsnames"], + request.form["comments"], + session["user_name"]) + cur = db.execute("""UPDATE guests set full_name=?, + rsvp=?, email=?, mailing=?, plusone=?, plusonename=?, kids=?, + kidsnames=?, comments=? WHERE user_name=?""", args) + db.commit() + cur.close() + flash("We have updated your information!") + return redirect(url_for('rsvp')) + @app.route('/') @app.route('/home/') -- cgit v1.2.3-70-g09d2