From dbd8753c2bdd78d669d9ee9bc353c3f3f4b0b228 Mon Sep 17 00:00:00 2001 From: Guillaume Horel Date: Thu, 26 Mar 2015 22:47:26 -0400 Subject: also store the last time form was updated --- wedding.py | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'wedding.py') diff --git a/wedding.py b/wedding.py index e592f97..bb3df7a 100644 --- a/wedding.py +++ b/wedding.py @@ -82,7 +82,8 @@ def rsvp(): else: args.append(v) update_string = ",".join(update_string) - query = "UPDATE guests set %s WHERE user_name=?" % update_string + query = "UPDATE guests set {0} , lastupdate=current_timestamp " \ + "WHERE user_name=?".format(update_string) with db: db.execute(query, tuple(args+[session['user_name']])) flash(gettext("We have updated your information!")) -- cgit v1.2.3-70-g09d2