server/web/tweetgserver/views.py
changeset 32 1e47b1f9f42d
parent 6 8ffe9b89a23e
child 33 98ffc58f0bd3
--- a/server/web/tweetgserver/views.py	Tue Feb 21 22:47:19 2012 +0100
+++ b/server/web/tweetgserver/views.py	Wed Feb 22 11:06:11 2012 +0100
@@ -43,7 +43,7 @@
 def podium(since, tokens):
     sincetime = datetime.fromtimestamp(since)
     token_list = tokens.split(",")
-    query_base = db.session.query(func.count(Tweet.id)) #@UndefinedVariable
+    query_base = db.session.query(func.count(Tweet.id)).filter(Tweet.created_at >= sincetime)  #@UndefinedVariable
     podium_res = {}
     for token in token_list:
         query = query_base.filter(Tweet.text.op('~*')(token)) #@UndefinedVariable