def test_players_db(self): """ Testing player functions player.insert_player_into_db player.get_players_from_db player.get_player_from_db_by_name player.update_player_by_name """ clear_tables(self.db) # test empty players test_players = player.get_players_from_db(GAME_ID1, self.db) assert (test_players == []) test_names = player.get_player_names_from_db(GAME_ID1, self.db) assert (test_names == []) # insert player test_player = player.Player (*TEST_PLAYER_VALUES1) player.insert_player_into_db(test_player, self.db) db_player = player.get_players_from_db(test_player.game_id, self.db)[0] assert db_player == test_player # get player db_player2 = player.get_player_from_db_by_name(db_player.name, db_player.game_id, self.db) assert(db_player2 == db_player) # update player cur_id = db_player.id_num db_player.id_num = cur_id + 1 player.update_player_by_name(db_player, self.db) # get player new_db_player = player.get_player_from_db_by_name( db_player.name, db_player.game_id, self.db) assert(new_db_player.id_num == db_player.id_num)
def test_clear(self): test_dice = dice.initialize_dice(3,'0') dice.insert_dice_into_db(test_dice, self.db) test_player = player.Player (*TEST_PLAYER_VALUES1) player.insert_player_into_db(test_player, self.db) assert len(player.get_players_from_db(test_player.game_id, self.db)) > 0 assert len(dice.get_dice_from_db(test_dice.game_id, self.db).dice_dic) > 0 clear_tables(self.db) assert len(player.get_players_from_db(test_player.game_id, self.db)) == 0 assert dice.get_dice_from_db(test_dice.game_id, self.db) == None
def test_game_control(self): """ Testing game_control functions game_control.initialize_game """ clear_tables(self.db) p1 = player.Player(*TEST_PLAYER_VALUES1) p2 = player.Player(*TEST_PLAYER_VALUES2) p3 = player.Player(*TEST_PLAYER_VALUES3) # insert players into db player.insert_player_into_db(p1, self.db) player.insert_player_into_db(p2, self.db) player.insert_player_into_db(p3, self.db) # initialize game game_control.initialize_game(p1.game_id, self.db) # get the updated player information p1 = player.get_player_from_db_by_name(p1.name, p1.game_id, self.db) p2 = player.get_player_from_db_by_name(p2.name, p2.game_id, self.db) p3 = player.get_player_from_db_by_name(p3.name, p3.game_id, self.db) # In a 3 person game, everyone should be neighbors with eachother assert(p1.p_left_name in [p2.name, p3.name]) assert(p1.p_right_name in [p2.name, p3.name]) assert(not p1.p_left_name == p1.p_right_name) assert(p2.p_left_name in [p1.name, p3.name]) assert(p2.p_right_name in [p1.name, p3.name]) assert(not p2.p_left_name == p2.p_right_name) assert(p3.p_left_name in [p1.name, p2.name]) assert(p3.p_right_name in [p1.name, p2.name]) assert(not p3.p_left_name == p3.p_right_name) # try setting relationships # first prepare the dice, so that there's enough for all the tests dice.insert_dice_into_db(dice.Dice({0:100,1:100,2:100,3:100,4:100,5:100,6:100},p1.game_id), self.db) test_playset = playset.parse_playset(TEST_PLAYSET) # p1 and p2: mayor / health commissioner # p1 and p3: drug dealer / drug manufacturer # p2 and p3: plumber / client p1_p2_rel_opt = ('elected official', 'mayor') p2_p1_rel_opt = ('elected official', 'health commissioner') p1_p3_rel_opt = ('drug person', 'dealer') p3_p1_rel_opt = ('drug person', 'manufacturer') p2_p3_rel_opt = ('tradesman', 'plumber') p3_p2_rel_opt = ('client', '') retval = game_control.set_relationship(p1_p2_rel_opt[0], p1_p2_rel_opt[1], p1.name, p2_p1_rel_opt[0], p2_p1_rel_opt[1], p2.name, p1.name, test_playset, p1.game_id, self.db) assert (retval == game_control.NO_ERROR) retval = game_control.set_relationship(p1_p3_rel_opt[0], p1_p3_rel_opt[1], p1.name, p3_p1_rel_opt[0], p3_p1_rel_opt[1], p3.name, p3.name, test_playset, p1.game_id, self.db) assert (retval == game_control.NO_ERROR) retval = game_control.set_relationship(p2_p3_rel_opt[0], p2_p3_rel_opt[1], p2.name, p3_p2_rel_opt[0], p3_p2_rel_opt[1], p3.name, p3.name, test_playset, p1.game_id, self.db) assert (retval == game_control.NO_ERROR) # get the updated player information p1 = player.get_player_from_db_by_name(p1.name, p1.game_id, self.db) p2 = player.get_player_from_db_by_name(p2.name, p2.game_id, self.db) p3 = player.get_player_from_db_by_name(p3.name, p3.game_id, self.db) #print_player_info(p1) #print_player_info(p2) #print_player_info(p3) # In a 3 person game, everyone should be neighbors with eachother if p1.p_left_name == p2.name: # for player 1: left is p2, right is p3 assert p1_p2_rel_opt == (p1.rel_l_role, p1.rel_l_option) assert p1_p3_rel_opt == (p1.rel_r_role, p1.rel_r_option) # for player 3: left is p1, right is p2 assert p3_p1_rel_opt == (p3.rel_l_role, p3.rel_l_option) assert p3_p2_rel_opt == (p3.rel_r_role, p3.rel_r_option) # for palyer 2: left is p3, right is p1 assert p2_p3_rel_opt == (p2.rel_l_role, p2.rel_l_option) assert p2_p1_rel_opt == (p2.rel_r_role, p2.rel_r_option) elif p1.p_left_name == p3.name: # for player 1: left is p3, right is p2 assert p1_p3_rel_opt == (p1.rel_l_role, p1.rel_l_option) assert p1_p2_rel_opt == (p1.rel_r_role, p1.rel_r_option) # for player 3: left is p2, right is p1 assert p3_p2_rel_opt == (p3.rel_l_role, p3.rel_l_option) assert p3_p1_rel_opt == (p3.rel_r_role, p3.rel_r_option) # for palyer 2: left is p1, right is p3 assert p2_p1_rel_opt == (p2.rel_l_role, p2.rel_l_option) assert p2_p3_rel_opt == (p2.rel_r_role, p2.rel_r_option) else: # this should not happen assert False
def playerjoin(): name = request.form['data'] if not name in player.get_players_from_db(GAME_ID, get_db()): player.insert_player_into_db(player.Player(name=name, game_id=GAME_ID), db=get_db()) session['player'] = name return ''