1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
|
# -*- coding: utf-8 -*-
import sqlite3
#all the imports
from flask import Flask, request, session, g, redirect, url_for, render_template
from flask import flash
from functools import wraps
app = Flask(__name__)
app.config.from_envvar('CONF')
def query_db(query, args=(), one=False):
cur = get_db().execute(query, args)
rv = cur.fetchone() if one else cur.fetchall()
cur.close()
return rv
def connect_db():
conn = sqlite3.connect(app.config['DATABASE'],
detect_types=sqlite3.PARSE_DECLTYPES)
conn.row_factory = sqlite3.Row
return conn
def get_db():
db = getattr(g, 'sqlite_db', None)
if db is None:
db = g.sqlite_db = connect_db()
return db
@app.teardown_appcontext
def close_db(error):
"""Closes the database again at the end of the request."""
db = getattr(g, 'sqlite_db', None)
if db:
db.close()
def login_required(f):
@wraps(f)
def decorated_function(*args, **kwargs):
if 'user_name' not in session:
return redirect(url_for('login', next=request.url))
return f(*args, **kwargs)
return decorated_function
@app.route('/getting/')
def getting_there():
return render_template("{0}/getting.htm".format(session["lang"]),
lang = session["lang"])
@app.route('/gifts/')
def gifts():
return render_template("{0}/gifts.htm".format(session["lang"]),
lang= session["lang"])
@app.route('/lodging/')
def lodging():
return render_template("{0}/lodging.htm".format(session["lang"]),
lang = session["lang"])
@app.route('/rsvp/', methods=['GET', 'POST'])
def rsvp():
if request.method == 'GET':
r = query_db("SELECT * from guests where user_name=?",
(session["user_name"],), one=True)
return render_template("{0}/rsvp.htm".format(session["lang"]),
lang = session["lang"],
form=r)
if request.method == 'POST':
db = get_db()
f = defaultdict(str)
update_string = []
args = []
for k, v in request.form.items():
update_string.append("{0}=?".format(k))
if k in ["rsvp", "plusone", "kids"]:
## convert to integer
args.append(int(v))
else:
args.append(v)
update_string = ",".join(update_string)
query = "UPDATE guests set %s WHERE user_name=?" % update_string
with db:
db.execute(query, tuple(args+[session['user_name']]))
flash("We have updated your information!")
return redirect(url_for('rsvp'))
@app.route('/')
@app.route('/home/')
@login_required
def main_page():
return render_template("{0}/main.htm".format(session["lang"]),
lang=session["lang"])
@app.route('/login/', methods=['GET', 'POST'])
def login():
wp = {'en': 'Wrong password',
'fr': 'Mot de passe erroné',
'sr': 'Pogrešna šifra'}
wn = {'en': 'Wrong name',
'fr': 'Prénom incorrect',
'sr': 'Pogrešno ime'}
if 'user_name' in session:
return redirect(url_for('main_page'))
error = None
if request.method == 'POST':
db = get_db()
with db:
c = db.execute("SELECT * from guests where user_name=?",
(request.form['username'],))
if not c.fetchone():
flash(wn[request.form['language']])
return redirect(url_for('login'))
if request.form['password'] != app.config['PASSWORD']:
flash(wp[request.form['language']])
return redirect(url_for('login'))
session['user_name'] = request.form['username']
session['lang'] = request.form['language']
return redirect(url_for('main_page'))
return render_template('login.htm')
if __name__=="__main__":
app.run()
|
