xonstat/views/game.py

   1 import datetime\r
   2 import logging\r
   3 import re\r
   4 import time\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 \r
  14 def game_index(request):\r
  15     """\r
  16     Provides a list of current games, with the associated game stats.\r
  17     These games are ordered by game_id, with the most current ones first.\r
  18     Paginated.\r
  19     """\r
  20     if 'page' in request.matchdict:\r
  21         current_page = request.matchdict['page']\r
  22     else:\r
  23         current_page = 1\r
  24 \r
  25     games_q = DBSession.query(Game, Server, Map).\\r
  26             filter(Game.server_id == Server.server_id).\\r
  27             filter(Game.map_id == Map.map_id).\\r
  28             order_by(Game.game_id.desc())\r
  29 \r
  30     games = Page(games_q, current_page, url=page_url)\r
  31 \r
  32     pgstats = {}\r
  33     for (game, server, map) in games:\r
  34         pgstats[game.game_id] = DBSession.query(PlayerGameStat).\\r
  35                 filter(PlayerGameStat.game_id == game.game_id).\\r
  36                 order_by(PlayerGameStat.rank).\\r
  37                 order_by(PlayerGameStat.score).all()\r
  38 \r
  39     return {'games':games, \r
  40             'pgstats':pgstats}\r
  41 \r
  42 \r
  43 def game_info(request):\r
  44     """\r
  45     List the game stats (scoreboard) for a particular game. Paginated.\r
  46     """\r
  47     game_id = request.matchdict['id']\r
  48     try:\r
  49         notfound = False\r
  50 \r
  51         (start_dt, game_type_cd, server_id, server_name, map_id, map_name) = \\r
  52         DBSession.query("start_dt", "game_type_cd", "server_id", \r
  53                 "server_name", "map_id", "map_name").\\r
  54                 from_statement("select g.start_dt, g.game_type_cd, "\r
  55                         "g.server_id, s.name as server_name, g.map_id, "\r
  56                         "m.name as map_name "\r
  57                         "from games g, servers s, maps m "\r
  58                         "where g.game_id = :game_id "\r
  59                         "and g.server_id = s.server_id "\r
  60                         "and g.map_id = m.map_id").\\r
  61                         params(game_id=game_id).one()\r
  62 \r
  63         player_game_stats = DBSession.query(PlayerGameStat).\\r
  64                 from_statement("select * from player_game_stats "\r
  65                         "where game_id = :game_id "\r
  66                         "order by score desc").\\r
  67                             params(game_id=game_id).all()\r
  68     except Exception as inst:\r
  69         notfound = True\r
  70         start_dt = None\r
  71         game_type_cd = None\r
  72         server_id = None\r
  73         server_name = None\r
  74         map_id = None\r
  75         map_name = None\r
  76         player_game_stats = None\r
  77 \r
  78     return {'notfound':notfound,\r
  79             'start_dt':start_dt,\r
  80             'game_type_cd':game_type_cd,\r
  81             'server_id':server_id,\r
  82             'server_name':server_name,\r
  83             'map_id':map_id,\r
  84             'map_name':map_name,\r
  85             'player_game_stats':player_game_stats}\r