view_user() done

1 files changed, 4 insertions, 2 deletions

diff --git a/famille.py b/famille.py
index 75205d0..6445c7e 100644
--- a/famille.py
+++ b/famille.py
@@ -208,8 +208,10 @@ def edit_news(news_id):
 @app.route('/user/<int:user_id>/')
 @login_required
 def view_user(user_id):
-
-    user = query_db(db, 'SELECT * FROM users WHERE id= ?', (user_id,), True)
+    metadata = get_metadata()
+    users = Table('users', metadata, autoload = True)
+    stmt = select([users]).where(users.c.id = user_id)
+    user = query_db(stmt, True)
     return render_template("user/show.html", user=user)
 
 @app.route('/user/edit/', methods=['GET', 'POST'])