xonstat/views/map.py

   1 import logging\r
   2 import sqlalchemy.sql.functions as func\r
   3 import sqlalchemy.sql.expression as expr\r
   4 from datetime import datetime, timedelta\r
   5 from pyramid.response import Response\r
   6 from sqlalchemy import desc\r
   7 from webhelpers.paginate import Page, PageURL\r
   8 from xonstat.models import *\r
   9 from xonstat.util import page_url\r
  10 \r
  11 log = logging.getLogger(__name__)\r
  12 \r
  13 def map_index(request):\r
  14     """\r
  15     Provides a list of all the current maps. \r
  16     """\r
  17     if request.params.has_key('page'):\r
  18         current_page = request.params['page']\r
  19     else:\r
  20         current_page = 1\r
  21 \r
  22     try:\r
  23         map_q = DBSession.query(Map).\\r
  24                 order_by(Map.map_id.desc())\r
  25 \r
  26         maps = Page(map_q, current_page, items_per_page=10, url=page_url)\r
  27 \r
  28     except Exception as e:\r
  29         maps = None\r
  30 \r
  31     return {'maps':maps, }\r
  32 \r
  33 \r
  34 def map_info(request):\r
  35     """\r
  36     List the information stored about a given map. \r
  37     """\r
  38     map_id = request.matchdict['id']\r
  39 \r
  40     try: \r
  41         leaderboard_lifetime = int(\r
  42                 request.registry.settings['xonstat.leaderboard_lifetime'])\r
  43     except:\r
  44         leaderboard_lifetime = 30\r
  45 \r
  46     leaderboard_count = 10\r
  47     recent_games_count = 20\r
  48 \r
  49     try:\r
  50         gmap = DBSession.query(Map).filter_by(map_id=map_id).one()\r
  51 \r
  52         # recent games on this map\r
  53         recent_games = DBSession.query(Game, Server, Map, PlayerGameStat).\\r
  54             filter(Game.server_id==Server.server_id).\\r
  55             filter(Game.map_id==Map.map_id).\\r
  56             filter(Game.map_id==map_id).\\r
  57             filter(PlayerGameStat.game_id==Game.game_id).\\r
  58             filter(PlayerGameStat.rank==1).\\r
  59             order_by(expr.desc(Game.start_dt)).all()[0:recent_games_count]\r
  60 \r
  61         for i in range(recent_games_count-len(recent_games)):\r
  62             recent_games.append(('-', '-', '-', '-'))\r
  63 \r
  64 \r
  65         # top players by score\r
  66         top_scorers = DBSession.query(Player.player_id, Player.nick,\r
  67                 func.sum(PlayerGameStat.score)).\\r
  68                 filter(Player.player_id == PlayerGameStat.player_id).\\r
  69                 filter(Game.game_id == PlayerGameStat.game_id).\\r
  70                 filter(Game.map_id == map_id).\\r
  71                 filter(Player.player_id > 2).\\r
  72                 filter(PlayerGameStat.create_dt > \r
  73                         (datetime.utcnow() - timedelta(days=leaderboard_lifetime))).\\r
  74                 order_by(expr.desc(func.sum(PlayerGameStat.score))).\\r
  75                 group_by(Player.nick).\\r
  76                 group_by(Player.player_id).all()[0:10]\r
  77 \r
  78         top_scorers = [(player_id, html_colors(nick), score) \\r
  79                 for (player_id, nick, score) in top_scorers]\r
  80 \r
  81         for i in range(leaderboard_count-len(top_scorers)):\r
  82             top_scorers.append(('-', '-', '-'))\r
  83 \r
  84         # top players by playing time\r
  85         top_players = DBSession.query(Player.player_id, Player.nick, \r
  86                 func.sum(PlayerGameStat.alivetime)).\\r
  87                 filter(Player.player_id == PlayerGameStat.player_id).\\r
  88                 filter(Game.game_id == PlayerGameStat.game_id).\\r
  89                 filter(Game.map_id == map_id).\\r
  90                 filter(Player.player_id > 2).\\r
  91                 filter(PlayerGameStat.create_dt > \r
  92                         (datetime.utcnow() - timedelta(days=leaderboard_lifetime))).\\r
  93                 order_by(expr.desc(func.sum(PlayerGameStat.alivetime))).\\r
  94                 group_by(Player.nick).\\r
  95                 group_by(Player.player_id).all()[0:10]\r
  96 \r
  97         top_players = [(player_id, html_colors(nick), score) \\r
  98                 for (player_id, nick, score) in top_players]\r
  99 \r
 100         for i in range(leaderboard_count-len(top_players)):\r
 101             top_players.append(('-', '-', '-'))\r
 102 \r
 103         # top servers using/playing this map\r
 104         top_servers = DBSession.query(Server.server_id, Server.name, \r
 105                 func.count(Game.game_id)).\\r
 106                 filter(Game.server_id == Server.server_id).\\r
 107                 filter(Game.map_id == map_id).\\r
 108                 filter(Game.create_dt > \r
 109                         (datetime.utcnow() - timedelta(days=leaderboard_lifetime))).\\r
 110                 order_by(expr.desc(func.count(Game.game_id))).\\r
 111                 group_by(Server.name).\\r
 112                 group_by(Server.server_id).all()[0:10]\r
 113 \r
 114         for i in range(leaderboard_count-len(top_servers)):\r
 115             top_servers.append(('-', '-', '-'))\r
 116 \r
 117     except Exception as e:\r
 118         gmap = None\r
 119     return {'gmap':gmap,\r
 120             'recent_games':recent_games,\r
 121             'top_scorers':top_scorers,\r
 122             'top_players':top_players,\r
 123             'top_servers':top_servers,\r
 124             }\r