2 import sqlalchemy.sql.functions as func
\r
3 import sqlalchemy.sql.expression as expr
\r
5 from datetime import datetime, timedelta
\r
6 from pyramid.response import Response
\r
7 from sqlalchemy import desc
\r
8 from webhelpers.paginate import Page, PageURL
\r
9 from xonstat.models import *
\r
10 from xonstat.util import page_url, html_colors
\r
12 log = logging.getLogger(__name__)
\r
14 def server_index(request):
\r
16 Provides a list of all the current servers.
\r
18 if 'page' in request.matchdict:
\r
19 current_page = request.matchdict['page']
\r
24 server_q = DBSession.query(Server).\
\r
25 order_by(Server.server_id.desc())
\r
27 servers = Page(server_q, current_page, url=page_url)
\r
30 except Exception as e:
\r
33 return {'servers':servers, }
\r
36 def server_info(request):
\r
38 List the stored information about a given server.
\r
40 server_id = request.matchdict['id']
\r
43 leaderboard_lifetime = int(
\r
44 request.registry.settings['xonstat.leaderboard_lifetime'])
\r
46 leaderboard_lifetime = 30
\r
48 leaderboard_count = 10
\r
49 recent_games_count = 20
\r
52 server = DBSession.query(Server).filter_by(server_id=server_id).one()
\r
54 # top maps by total times played
\r
55 top_maps = DBSession.query(Game.map_id, Map.name,
\r
57 filter(Map.map_id==Game.map_id).\
\r
58 filter(Game.server_id==server.server_id).\
\r
59 filter(Game.create_dt >
\r
60 (datetime.now() - timedelta(days=leaderboard_lifetime))).\
\r
61 order_by(expr.desc(func.count())).\
\r
62 group_by(Game.map_id).\
\r
63 group_by(Map.name).all()[0:10]
\r
65 for i in range(leaderboard_count-len(top_maps)):
\r
66 top_maps.append(('-', '-', '-'))
\r
68 # top players by score
\r
69 top_scorers = DBSession.query(Player.player_id, Player.nick,
\r
70 func.sum(PlayerGameStat.score)).\
\r
71 filter(Player.player_id == PlayerGameStat.player_id).\
\r
72 filter(Game.game_id == PlayerGameStat.game_id).\
\r
73 filter(Game.server_id == server.server_id).\
\r
74 filter(Player.player_id > 2).\
\r
75 filter(PlayerGameStat.create_dt >
\r
76 (datetime.now() - timedelta(days=leaderboard_lifetime))).\
\r
77 order_by(expr.desc(func.sum(PlayerGameStat.score))).\
\r
78 group_by(Player.nick).\
\r
79 group_by(Player.player_id).all()[0:10]
\r
81 top_scorers = [(player_id, html_colors(nick), score) \
\r
82 for (player_id, nick, score) in top_scorers]
\r
84 for i in range(leaderboard_count-len(top_scorers)):
\r
85 top_scorers.append(('-', '-', '-'))
\r
87 # top players by playing time
\r
88 top_players = DBSession.query(Player.player_id, Player.nick,
\r
89 func.sum(PlayerGameStat.alivetime)).\
\r
90 filter(Player.player_id == PlayerGameStat.player_id).\
\r
91 filter(Game.game_id == PlayerGameStat.game_id).\
\r
92 filter(Game.server_id == server.server_id).\
\r
93 filter(Player.player_id > 2).\
\r
94 filter(PlayerGameStat.create_dt >
\r
95 (datetime.now() - timedelta(days=leaderboard_lifetime))).\
\r
96 order_by(expr.desc(func.sum(PlayerGameStat.alivetime))).\
\r
97 group_by(Player.nick).\
\r
98 group_by(Player.player_id).all()[0:10]
\r
100 top_players = [(player_id, html_colors(nick), score) \
\r
101 for (player_id, nick, score) in top_players]
\r
103 for i in range(leaderboard_count-len(top_players)):
\r
104 top_players.append(('-', '-', '-'))
\r
106 # recent games played in descending order
\r
107 recent_games = DBSession.query(Game, Server, Map, PlayerGameStat).\
\r
108 filter(Game.server_id==Server.server_id).\
\r
109 filter(Game.map_id==Map.map_id).\
\r
110 filter(PlayerGameStat.game_id==Game.game_id).\
\r
111 filter(PlayerGameStat.rank==1).\
\r
112 filter(Server.server_id==server.server_id).\
\r
113 order_by(expr.desc(Game.start_dt)).all()[0:recent_games_count]
\r
115 for i in range(recent_games_count-len(recent_games)):
\r
116 recent_games.append(('-', '-', '-', '-'))
\r
118 except Exception as e:
\r
120 recent_games = None
\r
123 return {'server':server,
\r
124 'recent_games':recent_games,
\r
125 'top_players': top_players,
\r
126 'top_scorers': top_scorers,
\r
127 'top_maps': top_maps,
\r
131 def server_game_index(request):
\r
133 List the games played on a given server. Paginated.
\r
135 server_id = request.matchdict['server_id']
\r
136 current_page = request.matchdict['page']
\r
139 server = DBSession.query(Server).filter_by(server_id=server_id).one()
\r
141 games_q = DBSession.query(Game, Server, Map).\
\r
142 filter(Game.server_id == server_id).\
\r
143 filter(Game.server_id == Server.server_id).\
\r
144 filter(Game.map_id == Map.map_id).\
\r
145 order_by(Game.game_id.desc())
\r
147 games = Page(games_q, current_page, url=page_url)
\r
148 except Exception as e:
\r
153 return {'games':games,
\r