rss() last one!sqlalchemy

1 files changed, 6 insertions, 4 deletions

diff --git a/famille.py b/famille.py
index a0ae07e..768e323 100644
--- a/famille.py
+++ b/famille.py
@@ -288,10 +288,12 @@ def logout():
 
 @app.route('/rss.xml')
 def rss():
-    db = get_db()
-    news = query_db(db, "SELECT * FROM news LEFT JOIN users ON "
-                    "news.user_id=users.id ORDER BY news.date desc")
-    return render_template('rss.xml', news=news)
+    metadata = get_metadata()
+    news = Table('news', metadata, autoload=True)
+
+    stmt = select([news]).order_by(news.c.date.desc())
+    news_list = query_db(stmt)
+    return render_template('rss.xml', news=news_list)
 
 if __name__=="__main__":
     app.run()