From efa223ff9b66884ec1490123d729fe08f6726a90 Mon Sep 17 00:00:00 2001
From: Guillaume Horel <guillaume.horel@gmail.com>
Date: Thu, 26 Sep 2013 01:24:42 -0400
Subject: rss() last one!

---
 famille.py | 10 ++++++----
 1 file 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()
-- 
cgit v1.2.3-70-g09d2