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
11 log = logging.getLogger(__name__)
\r
13 def map_index(request):
\r
15 Provides a list of all the current maps.
\r
17 if request.params.has_key('page'):
\r
18 current_page = request.params['page']
\r
23 map_q = DBSession.query(Map).\
\r
24 order_by(Map.map_id.desc())
\r
26 maps = Page(map_q, current_page, items_per_page=10, url=page_url)
\r
28 except Exception as e:
\r
31 return {'maps':maps, }
\r
34 def map_info(request):
\r
36 List the information stored about a given map.
\r
38 map_id = request.matchdict['id']
\r
41 leaderboard_lifetime = int(
\r
42 request.registry.settings['xonstat.leaderboard_lifetime'])
\r
44 leaderboard_lifetime = 30
\r
46 leaderboard_count = 10
\r
47 recent_games_count = 20
\r
50 gmap = DBSession.query(Map).filter_by(map_id=map_id).one()
\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
61 for i in range(recent_games_count-len(recent_games)):
\r
62 recent_games.append(('-', '-', '-', '-'))
\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
78 top_scorers = [(player_id, html_colors(nick), score) \
\r
79 for (player_id, nick, score) in top_scorers]
\r
81 for i in range(leaderboard_count-len(top_scorers)):
\r
82 top_scorers.append(('-', '-', '-'))
\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
97 top_players = [(player_id, html_colors(nick), score) \
\r
98 for (player_id, nick, score) in top_players]
\r
100 for i in range(leaderboard_count-len(top_players)):
\r
101 top_players.append(('-', '-', '-'))
\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
114 for i in range(leaderboard_count-len(top_servers)):
\r
115 top_servers.append(('-', '-', '-'))
\r
117 except Exception as e:
\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