2 import sqlalchemy.sql.functions as func
3 from pyramid.response import Response
4 from xonstat.models import *
6 log = logging.getLogger(__name__)
8 def main_index(request):
10 top_players = DBSession.query(Player.player_id, Player.nick,
11 func.sum(PlayerGameStat.score)).\
12 filter(Player.player_id == PlayerGameStat.player_id).\
13 filter(Player.player_id > 2).\
14 order_by(func.sum(PlayerGameStat.score)).\
15 group_by(Player.nick).\
16 group_by(Player.player_id).all()[0:10]
18 # top servers by number of total players played
19 top_servers = DBSession.query(Server.server_id, Server.name,
20 func.count(Game.game_id)).\
21 filter(Game.server_id==Server.server_id).\
22 order_by(func.count(Game.game_id)).\
23 group_by(Server.server_id).\
24 group_by(Server.name).all()[0:10]
26 return {'top_players':top_players,
27 'top_servers':top_servers,