From d7e915f77c42f6d0c5a85e03d87106c27082ec99 Mon Sep 17 00:00:00 2001 From: Guillaume Horel Date: Wed, 7 Nov 2012 22:22:58 -0500 Subject: reworked the templates --- famille.py | 11 ++++++++--- schema.sql | 2 +- templates/layout.html | 4 ++-- templates/news/add.html | 33 ++++++++++++++++++++++++++------- templates/news/list.html | 16 +++++++++++----- templates/news/show.html | 2 +- 6 files changed, 49 insertions(+), 19 deletions(-) diff --git a/famille.py b/famille.py index 4e6a716..bda0440 100644 --- a/famille.py +++ b/famille.py @@ -34,7 +34,7 @@ def query_db(query, args=(), one=False): @app.before_request def before_request(): conn = sqlite3.connect(app.config['DATABASE']) - conn.row_factory = sqlite3.Row + conn.row_factory = sqlite3.Row g.db = conn @app.teardown_appcontext @@ -111,6 +111,11 @@ def edit_news(news_id): g.db.commit() return redirect(url_for('show_news', news_id=news_id)) +@app.route('/user//') +@login_required +def view_user(user_id): + pass + @app.route('/login/', methods=['GET', 'POST']) def login(): if 'user_name' in session: @@ -120,10 +125,10 @@ def login(): if request.method == 'POST': username = request.form['username'] password = hashlib.md5(request.form['password']).hexdigest(); - user = query_db('select * from users where name = ?', (username,), True) + user = query_db('select * from users where user_name = ?', (username,), True) if user: if user['password'] == password: - session['user_name'] = user['name'] + session['user_name'] = user['user_name'] session['user_id'] = user['id'] return redirect(url_for('list_news')) else: diff --git a/schema.sql b/schema.sql index bae55ab..cda7bc3 100644 --- a/schema.sql +++ b/schema.sql @@ -1,7 +1,7 @@ drop table if exists users; create table users ( id integer primary key autoincrement, - name string not null, + user_name string not null, password string not null ); diff --git a/templates/layout.html b/templates/layout.html index 39e00a8..dc9be11 100644 --- a/templates/layout.html +++ b/templates/layout.html @@ -11,8 +11,8 @@
- {{session['user_name']}} - (Mon compte | Se déconnecter)

+

{{session['user_name']}} + (Mon compte | Se déconnecter)