From 6eb4f8aed692c0db63f415743300d10b63d95720 Mon Sep 17 00:00:00 2001 From: Cédric Bonhomme Date: Fri, 13 Jun 2014 08:12:10 +0200 Subject: We should filter articles only for one user. --- pyaggr3g470r/views.py | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'pyaggr3g470r') diff --git a/pyaggr3g470r/views.py b/pyaggr3g470r/views.py index c8ed0b79..56dc19ad 100644 --- a/pyaggr3g470r/views.py +++ b/pyaggr3g470r/views.py @@ -214,7 +214,8 @@ def signup(): @login_required def home(): feeds = {feed.id: feed.title for feed in g.user.feeds if feed.enabled} - articles = Article.query.filter(Article.feed_id.in_(feeds.keys())) + articles = Article.query.filter(Article.feed_id.in_(feeds.keys()), + Article.user_id == g.user.id) filter_ = request.args.get('filter_', 'unread') feed_id = int(request.args.get('feed', 0)) limit = request.args.get('limit', 1000) @@ -228,7 +229,7 @@ def home(): limit = int(limit) articles = articles.limit(limit) unread = db.session.query(Article.feed_id, func.count(Article.id))\ - .filter(Article.readed == False)\ + .filter(Article.readed == False, Article.user_id == g.user.id)\ .group_by(Article.feed_id).all() def gen_url(filter_=filter_, limit=limit, feed=feed_id): return '/?filter_=%s&limit=%s&feed=%d' % (filter_, limit, feed) -- cgit