reworked the templates

1 files changed, 8 insertions, 3 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/<int:user_id>/')
+@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: