def get_leaderboard(n, user_id=None, window=0, info=None): """Return the top n users with their rank.""" try: return gl(top_users=n, user_id=user_id, window=window, info=info) except ProgrammingError: db.session.rollback() lb(info=info) return gl(top_users=n, user_id=user_id, window=window, info=info)
def get_leaderboard(n, user_id=None, window=0, info=None): """Return the top n users with their rank.""" try: return gl(top_users=n, user_id=user_id, window=window, info=info) except ProgrammingError: db.session.rollback() lb(info=info) return gl(top_users=n, user_id=user_id, window=window, info=info)
def rank_and_score(user_id): """Return rank and score for a user.""" if exists_materialized_view(db, 'users_rank') is False: lb() sql = text('''SELECT * from users_rank WHERE id=:user_id''') results = session.execute(sql, dict(user_id=user_id)) rank_and_score = dict(rank=None, score=None) for row in results: rank_and_score['rank'] = row.rank rank_and_score['score'] = row.score return rank_and_score
def rank_and_score(user_id): """Return rank and score for a user.""" if exists_materialized_view(db, 'users_rank') is False: lb() sql = text('''SELECT * from users_rank WHERE id=:user_id''') results = session.execute(sql, dict(user_id=user_id)) rank_and_score = dict(rank=None, score=None) for row in results: rank_and_score['rank'] = row.rank rank_and_score['score'] = row.score return rank_and_score