5 import sqlalchemy.sql.functions as sfunc
6 from datetime import timedelta
7 from sqlalchemy.orm import mapper
8 from sqlalchemy.orm import scoped_session
9 from sqlalchemy.orm import sessionmaker
10 from sqlalchemy.ext.declarative import declarative_base
11 from xonstat.util import strip_colors, html_colors, pretty_date
13 log = logging.getLogger(__name__)
15 DBSession = scoped_session(sessionmaker())
16 Base = declarative_base()
18 # define objects for all tables
20 def nick_html_colors(self):
22 return "Anonymous Player"
24 return html_colors(self.nick)
26 def nick_strip_colors(self):
28 return "Anonymous Player"
30 return strip_colors(self.nick)
32 def joined_pretty_date(self):
33 return pretty_date(self.create_dt)
36 return "<Player(%s, %s)>" % (self.player_id, self.nick.encode('utf-8'))
39 return {'player_id':self.player_id, 'name':self.nick.encode('utf-8')}
42 class GameType(object):
44 return "<GameType(%s, %s, %s)>" % (self.game_type_cd, self.descr, self.active_ind)
47 return {'game_type_cd':self.game_type_cd, 'name':self.descr, 'active':self.active_ind}
52 return "<Weapon(%s, %s, %s)>" % (self.weapon_cd, self.descr, self.active_ind)
55 return {'weapon_cd':self.weapon_cd, 'name':self.descr, 'active':self.active_ind}
59 def __init__(self, name=None, hashkey=None, ip_addr=None):
61 self.hashkey = hashkey
62 self.ip_addr = ip_addr
65 return "<Server(%s, %s)>" % (self.server_id, self.name.encode('utf-8'))
68 return {'server_id':self.server_id, 'name':self.name.encode('utf-8')}
71 return pretty_date(self.create_dt)
75 def __init__(self, name=None):
79 return "<Map(%s, %s, %s)>" % (self.map_id, self.name, self.version)
82 return {'map_id':self.map_id, 'name':self.name, 'version':self.version}
85 return pretty_date(self.create_dt)
88 def __init__(self, game_id=None, start_dt=None, game_type_cd=None,
89 server_id=None, map_id=None, winner=None):
90 self.game_id = game_id
91 self.start_dt = start_dt
92 self.game_type_cd = game_type_cd
93 self.server_id = server_id
98 return "<Game(%s, %s, %s, %s)>" % (self.game_id, self.start_dt, self.game_type_cd, self.server_id)
101 return {'game_id':self.game_id, 'start':self.start_dt.strftime('%Y-%m-%dT%H:%M:%SZ'), 'game_type_cd':self.game_type_cd, 'server_id':self.server_id}
103 def fuzzy_date(self):
104 return pretty_date(self.start_dt)
107 class PlayerGameStat(object):
108 def __init__(self, player_game_stat_id=None, create_dt=None):
109 self.player_game_stat_id = player_game_stat_id
110 self.create_dt = create_dt
113 return "<PlayerGameStat(%s, %s, %s)>" % (self.player_id, self.game_id, self.create_dt)
116 return {'player_id':self.player_id, 'game_id':self.game_id, 'create_dt':self.create_dt.strftime('%Y-%m-%dT%H:%M:%SZ')}
118 def nick_stripped(self):
119 if self.nick is None:
120 return "Anonymous Player"
122 return strip_colors(self.nick)
124 def nick_html_colors(self):
125 if self.nick is None:
126 return "Anonymous Player"
128 return html_colors(self.nick)
130 def team_html_color(self):
143 class Achievement(object):
145 return "<Achievement(%s, %s, %s)>" % (self.achievement_cd, self.descr, self.limit)
148 return {'achievement_cd':self.achievement_cd, 'name':self.descr, 'limit':self.limit}
151 class PlayerAchievement(object):
153 return "<PlayerAchievement(%s, %s)>" % (self.player_id, self.achievement_cd)
156 return {'player_id':self.player_id, 'achievement_cd':self.achievement_cd}
159 class PlayerWeaponStat(object):
168 return "<PlayerWeaponStat(%s, %s, %s)>" % (self.player_weapon_stats_id, self.player_id, self.game_id)
171 return {'player_weapon_stats_id':self.player_weapon_stats_id, 'player_id':self.player_id, 'game_id':self.game_id}
174 class Hashkey(object):
175 def __init__(self, player_id=None, hashkey=None):
176 self.player_id = player_id
177 self.hashkey = hashkey
180 return "<Hashkey(%s, %s)>" % (self.player_id, self.hashkey)
183 return {'player_id':self.player_id, 'hashkey':self.hashkey}
186 class PlayerNick(object):
188 return "<PlayerNick(%s, %s)>" % (self.player_id, self.stripped_nick)
191 return {'player_id':self.player_id, 'name':self.stripped_nick}
194 class PlayerElo(object):
195 def __init__(self, player_id=None, game_type_cd=None, elo=None):
197 self.player_id = player_id
198 self.game_type_cd = game_type_cd
204 return "<PlayerElo(pid=%s, gametype=%s, elo=%s)>" % (self.player_id, self.game_type_cd, self.elo)
207 return {'player_id':self.player_id, 'game_type_cd':self.game_type_cd, 'elo':self.elo}
210 class PlayerRank(object):
212 def nick_html_colors(self):
213 if self.nick is None:
214 return "Anonymous Player"
216 return html_colors(self.nick)
219 return "<PlayerRank(pid=%s, gametype=%s, rank=%s)>" % (self.player_id, self.game_type_cd, self.rank)
222 return {'player_id':self.player_id, 'game_type_cd':self.game_type_cd, 'rank':self.rank}
225 def initialize_db(engine=None):
226 DBSession.configure(bind=engine)
227 Base.metadata.bind = engine
228 Base.metadata.create_all(engine)
229 MetaData = sqlalchemy.MetaData(bind=engine, reflect=True)
231 # assign all those tables to an object
232 achievements_table = MetaData.tables['achievements']
233 cd_achievement_table = MetaData.tables['cd_achievement']
234 cd_game_type_table = MetaData.tables['cd_game_type']
235 cd_weapon_table = MetaData.tables['cd_weapon']
236 db_version_table = MetaData.tables['db_version']
237 games_table = MetaData.tables['games']
238 hashkeys_table = MetaData.tables['hashkeys']
239 maps_table = MetaData.tables['maps']
240 player_game_stats_table = MetaData.tables['player_game_stats']
241 players_table = MetaData.tables['players']
242 player_weapon_stats_table = MetaData.tables['player_weapon_stats']
243 servers_table = MetaData.tables['servers']
244 player_nicks_table = MetaData.tables['player_nicks']
245 player_elos_table = MetaData.tables['player_elos']
246 player_ranks_table = MetaData.tables['player_ranks']
248 # now map the tables and the objects together
249 mapper(PlayerAchievement, achievements_table)
250 mapper(Achievement, cd_achievement_table)
251 mapper(GameType, cd_game_type_table)
252 mapper(Weapon, cd_weapon_table)
253 mapper(Game, games_table)
254 mapper(Hashkey, hashkeys_table)
255 mapper(Map, maps_table)
256 mapper(PlayerGameStat, player_game_stats_table)
257 mapper(Player, players_table)
258 mapper(PlayerWeaponStat, player_weapon_stats_table)
259 mapper(Server, servers_table)
260 mapper(PlayerNick, player_nicks_table)
261 mapper(PlayerElo, player_elos_table)
262 mapper(PlayerRank, player_ranks_table)