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,
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 # top maps by total times played
27 top_maps = DBSession.query(Map.map_id, Map.name,
28 func.count(Game.game_id)).\
29 filter(Map.map_id==Game.game_id).\
30 order_by(func.count(Game.game_id)).\
31 group_by(Map.map_id).\
32 group_by(Map.name).all()[0:10]
34 return {'top_players':top_players,
35 'top_servers':top_servers,