xonstat/views/main.py

   1 import logging
   2 import sqlalchemy.sql.functions as func
   3 from pyramid.response import Response
   4 from xonstat.models import *
   5
   6 log = logging.getLogger(__name__)
   7
   8 def main_index(request):
   9     top_players = DBSession.query(Player.player_id, Player.nick, func.sum(PlayerGameStat.score)).\
  10             filter(Player.player_id == PlayerGameStat.player_id).\
  11             filter(Player.player_id > 2).\
  12             order_by(func.sum(PlayerGameStat.score)).\
  13             group_by(Player.nick).\
  14             group_by(Player.player_id).all()[0:10]
  15
  16     return {'top_players':top_players}