def add_game_from_db_row(self, row):
game = Game()
for field, value in row.iteritems():
game.__setattr__(field, value)
if game.master_id:
game.master = user_manager.get_user_by_id(game.master_id)
for contact_row in db.query("SELECT * FROM " + CONTACT_TABLE_NAME + " WHERE game_id = %s AND is_active=1", game.id):
contact = self.add_contact_from_db_row(contact_row)
game.add_active_contact(contact)
contact.game = game
if contact.is_accepted and (not game.last_accepted_contact or game.last_accepted_contact.connected_at <= contact.connected_at):
game.last_accepted_contact = contact
if contact.is_accepted:
self.create_contact_check_task(contact)
for word_row in db.query("SELECT word FROM " + CONTACT_TABLE_NAME + " WHERE game_id = %s AND is_active=0", game.id):
game.add_used_word(word_row.word)
self.current_game_in_room[game.room_id] = game
return game
def get_game_in_room(self, room_id):
if not room_id in self.current_game_in_room:
for row in db.query("SELECT * FROM " + GAME_TABLE_NAME + " where room_id = %s", room_id):
self.add_game_from_db_row(row)
return self.current_game_in_room[room_id]
