add rss flux

1 files changed, 6 insertions, 0 deletions

diff --git a/famille.py b/famille.py
index 0d2c498..0d2e7b9 100644
--- a/famille.py
+++ b/famille.py
@@ -204,5 +204,11 @@ def logout():
     session.pop('user_id', None)
     return redirect(url_for('login'))
 
+@app.route('/rss.xml')
+def rss():
+    news = query_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)
+
 if __name__=="__main__":
     app.run()