server/web/tweetgserver/views.py
changeset 32 1e47b1f9f42d
parent 6 8ffe9b89a23e
child 33 98ffc58f0bd3
equal deleted inserted replaced
31:7b76d97e3051 32:1e47b1f9f42d
    41 
    41 
    42 @app.route('/podium/<int:since>/<tokens>', methods=['GET'])
    42 @app.route('/podium/<int:since>/<tokens>', methods=['GET'])
    43 def podium(since, tokens):
    43 def podium(since, tokens):
    44     sincetime = datetime.fromtimestamp(since)
    44     sincetime = datetime.fromtimestamp(since)
    45     token_list = tokens.split(",")
    45     token_list = tokens.split(",")
    46     query_base = db.session.query(func.count(Tweet.id)) #@UndefinedVariable
    46     query_base = db.session.query(func.count(Tweet.id)).filter(Tweet.created_at >= sincetime)  #@UndefinedVariable
    47     podium_res = {}
    47     podium_res = {}
    48     for token in token_list:
    48     for token in token_list:
    49         query = query_base.filter(Tweet.text.op('~*')(token)) #@UndefinedVariable
    49         query = query_base.filter(Tweet.text.op('~*')(token)) #@UndefinedVariable
    50         podium_res[token] = query.scalar()
    50         podium_res[token] = query.scalar()
    51     res = {
    51     res = {