- mmap = DBSession.query(Map).filter_by(map_id=map_id).one()
-
- mct_q = DBSession.query(PlayerCaptime.fastest_cap, PlayerCaptime.create_dt,
- PlayerCaptime.player_id, PlayerCaptime.game_id,
- Game.server_id, Server.name.label('server_name'),
- PlayerGameStat.nick.label('player_nick')).\
- filter(PlayerCaptime.map_id==map_id).\
- filter(PlayerCaptime.game_id==Game.game_id).\
- filter(PlayerCaptime.map_id==Map.map_id).\
- filter(Game.server_id==Server.server_id).\
- filter(PlayerCaptime.player_id==PlayerGameStat.player_id).\
- filter(PlayerCaptime.game_id==PlayerGameStat.game_id).\
- order_by(expr.asc(PlayerCaptime.fastest_cap))
+ try:
+ mmap = DBSession.query(Map).filter_by(map_id=map_id).one()
+
+ mct_q = DBSession.query(PlayerCaptime.fastest_cap, PlayerCaptime.create_dt,
+ PlayerCaptime.player_id, PlayerCaptime.game_id,
+ Game.server_id, Server.name.label('server_name'),
+ PlayerGameStat.nick.label('player_nick')).\
+ filter(PlayerCaptime.map_id==map_id).\
+ filter(PlayerCaptime.game_id==Game.game_id).\
+ filter(PlayerCaptime.map_id==Map.map_id).\
+ filter(Game.server_id==Server.server_id).\
+ filter(PlayerCaptime.player_id==PlayerGameStat.player_id).\
+ filter(PlayerCaptime.game_id==PlayerGameStat.game_id).\
+ order_by(expr.asc(PlayerCaptime.fastest_cap))
+
+ except Exception as e:
+ raise pyramid.httpexceptions.HTTPNotFound