class PlayerWeaponStat(object):
- def __init__(self):
+ def __init__(self, player_id=None, game_id=None, weapon_cd=None):
+ self.player_id = player_id
+ self.game_id = game_id
+ self.weapon_cd = weapon_cd
self.fired = 0
self.max = 0
self.hit = 0
return "<PlayerWeaponStat(%s, %s, %s)>" % (self.player_weapon_stats_id, self.player_id, self.game_id)
def to_dict(self):
- return {'player_weapon_stats_id':self.player_weapon_stats_id, 'player_id':self.player_id, 'game_id':self.game_id}
+ return {
+ 'weapon_cd':self.weapon_cd,
+ 'player_weapon_stats_id':self.player_weapon_stats_id,
+ 'player_id':self.player_id,
+ 'game_id':self.game_id,
+ 'fired':self.fired,
+ 'max':self.max,
+ 'hit':self.hit,
+ 'actual':self.actual,
+ 'frags':self.frags,
+ }
class Hashkey(object):
def __repr__(self):
return "<PlayerCaptime(pid=%s, map_id=%s)>" % (self.player_id, self.map_id)
+ def fuzzy_date(self):
+ return pretty_date(self.create_dt)
+
+ def epoch(self):
+ return timegm(self.create_dt.timetuple())
+
class SummaryStat(object):
def __repr__(self):
return "<SummaryStat(total_players=%s, total_games=%s, total_servers=%s)>" % (self.total_players, self.total_games, self.total_servers)
+class TeamGameStat(object):
+ def __init__(self, team_game_stat_id=None, create_dt=None):
+ self.team_game_stat_id = team_game_stat_id
+ self.create_dt = create_dt
+
+ def __repr__(self):
+ return "<TeamGameStat(%s, %s, %s)>" % (self.team_game_stat_id, self.game_id, self.team)
+
+ def to_dict(self):
+ return {
+ 'team_game_stat_id':self.team_game_stat_id,
+ 'game_id':self.game_id,
+ 'team':self.team,
+ 'score':self.score,
+ 'rounds':self.rounds,
+ 'caps':self.caps,
+ 'create_dt':self.create_dt.strftime('%Y-%m-%dT%H:%M:%SZ'),
+ }
+
+ def team_html_color(self):
+ if self.team == 5:
+ return "red"
+ if self.team == 14:
+ return "blue"
+ if self.team == 13:
+ return "yellow"
+ if self.team == 10:
+ return "pink"
+
+
+class PlayerGameAnticheat(object):
+ def __init__(self, player_id=None, game_id=None, key=None,
+ value=None, create_dt=None):
+ self.player_id = player_id
+ self.game_id = game_id
+ self.key = key
+ self.value = value
+ self.create_dt = create_dt
+
+ def __repr__(self):
+ return "<PlayerGameAnticheat(%s, %d)>" % (self.key, self.value)
+
+
def initialize_db(engine=None):
DBSession.configure(bind=engine)
Base.metadata.bind = engine
Base.metadata.create_all(engine)
- MetaData = sqlalchemy.MetaData(bind=engine, reflect=True)
+ MetaData = sqlalchemy.MetaData(bind=engine)
+ MetaData.reflect()
# assign all those tables to an object
achievements_table = MetaData.tables['achievements']
player_ranks_table = MetaData.tables['player_ranks']
player_captimes_table = MetaData.tables['player_map_captimes']
summary_stats_table = MetaData.tables['summary_stats']
+ team_game_stats_table = MetaData.tables['team_game_stats']
+ player_game_anticheats_table = MetaData.tables['player_game_anticheats']
# now map the tables and the objects together
mapper(PlayerAchievement, achievements_table)
mapper(PlayerRank, player_ranks_table)
mapper(PlayerCaptime, player_captimes_table)
mapper(SummaryStat, summary_stats_table)
+ mapper(TeamGameStat, team_game_stats_table)
+ mapper(PlayerGameAnticheat, player_game_anticheats_table)