@Test public void testLoadByType() { String type = "QB"; String[] types = {"RB", "WR", "TE"}; PlayerDAO dao = new PlayerDAO(); // test single type List<Player> players = dao.getByType(type); Iterator<Player> i = players.iterator(); while (i.hasNext()) { Player p = i.next(); assertEquals(type, p.getPosition()); } // test multi-type players = dao.getByType(types); i = players.iterator(); while (i.hasNext()) { Player p = i.next(); String pos = p.getPosition(); assertTrue(pos.equals(types[0]) || pos.equals(types[1]) || pos.equals(types[2])); } }
@Test public void testLoadById() { String id = "ac568889-d10d-4ccc-89a1-8e4233848086"; PlayerDAO dao = new PlayerDAO(); Player p = dao.getById(id); assertEquals(id, p.getId()); }
@Test public void testUpdate() { String id = UUID.randomUUID().toString(); PlayerDAO dao = new PlayerDAO(); Player p = new Player(); p.setId(id); p.setFirstName("Test"); p.setLastName("Player"); p.setNflTeam("Testers"); p.setPosition("QB"); p.setJerseyNumber(33); p.setHeight(80); p.setWeight(215); p.setBirthdate(new Date()); p.setCollege("Penn State"); assertTrue(dao.store(p)); Player p2 = dao.getById(id); assertEquals(215, p2.getWeight()); assertEquals(id, p2.getId()); p2.setWeight(200); dao.store(p2); Player p3 = dao.getById(id); assertEquals(200, p3.getWeight()); assertEquals(id, p3.getId()); assertTrue(dao.remove(p3)); }
/* remet les points de chaque team à 0, et assigne players/team joueurs à chaque team */ public void assignTeams() { for (int i = 1; i <= Game.TEAMS; i++) { find(i).setPoints(0); } try { ResultSet result = this.connect .createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY) .executeQuery("SELECT te_id FROM teams"); int[] shuffledArray = Game.shuffleArray(); PlayerDAO playerDAO = (PlayerDAO) DAOFactory.getPlayerDAO(); for (int i = 0; result.next(); i = i + Game.PLAYERS / Game.TEAMS) { for (int j = 0; j < Game.PLAYERS / Game.TEAMS; j++) { playerDAO.find(shuffledArray[i + j]).setTeamID(result.getInt("te_id")); } } } catch (SQLException e) { e.printStackTrace(); } }
public ArrayList<Player> getPlayerList(Team team) { ArrayList<Player> players = new ArrayList<>(); try { Statement state = this.connect.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); ResultSet result = state.executeQuery("SELECT pl_id FROM players WHERE te_id =" + team.getID()); PlayerDAO playerDAO = (PlayerDAO) DAOFactory.getPlayerDAO(); while (result.next()) { players.add(playerDAO.find(result.getInt(1))); } } catch (SQLException e) { e.printStackTrace(); } return players; }