@Before
public void setUp() throws SQLException {
ds = prepareDataSource();
DBUtils.executeSqlScript(ds, RoomManager.class.getResource("createTables.sql"));
manager = new HotelManagerImpl();
manager.setDataSource(ds);
personManager = new PersonManagerImpl();
personManager.setDataSource(ds);
roomManager = new RoomManagerImpl();
roomManager.setDataSource(ds);
prepareTestData();
}
private void prepareTestData() {
r1 = newRoom(RoomType.apartment, 1);
r2 = newRoom(RoomType.apartment, 2);
r3 = newRoom(RoomType.bungalow, 3);
p1 = newPerson("Jozko1", "Mrkvička1", "obc3211", "tel6541", "[email protected]");
p2 = newPerson("Jozko2", "Mrkvička2", "obc3212", "tel6542", "[email protected]");
p3 = newPerson("Jozko3", "Mrkvička3", "obc3213", "tel6543", "[email protected]");
p4 = newPerson("Jozko4", "Mrkvička4", "obc3214", "tel6544", "[email protected]");
p5 = newPerson("Jozko5", "Mrkvička5", "obc3215", "tel6545", "[email protected]");
personManager.createPerson(p1);
personManager.createPerson(p2);
personManager.createPerson(p3);
personManager.createPerson(p4);
personManager.createPerson(p5);
roomManager.createRoom(r1);
roomManager.createRoom(r2);
roomManager.createRoom(r3);
roomWithNullId = newRoom(RoomType.apartment, 1);
roomNotInDB = newRoom(RoomType.apartment, 1);
roomNotInDB.setId(r3.getId() + 100);
personWithNullId =
newPerson(
"Jozko null", "Mrkvička null", "obc321 null", "tel654 null", "[email protected] null");
personNotInDB =
newPerson(
"Jozko not in db",
"Mrkvička not in db",
"obc321 not in db",
"tel654 not in db",
"[email protected] not in db");
personNotInDB.setId(p5.getId() + 100);
}
