/**
* Creates a new appointment.
*
* @param appointment which shall be inserted into the underlying persistance layer. must not be
* null, id must be null
* @return the given appointment for further usage
* @throws PersistenceException if there are complications with the persitance layer
*/
@Override
public Appointment create(Appointment appointment) throws PersistenceException {
LOGGER.info("Creating a new appointment in db.. " + appointment);
try {
if (appointment == null) {
LOGGER.error("Create parameter (appointment) was null.");
throw new PersistenceException("Appointment to be create must not be null");
}
Statement appointmentNextValStm = connection.createStatement();
ResultSet rs_appointmentNextVal =
appointmentNextValStm.executeQuery("SELECT NEXTVAL('appointment_seq')");
rs_appointmentNextVal.next();
appointment.setId(rs_appointmentNextVal.getInt(1));
createStm.setInt(1, appointment.getId());
createStm.setDate(2, new java.sql.Date(appointment.getDatum().getTime()));
createStm.setInt(3, appointment.getSession_id());
createStm.setInt(4, appointment.getUser_id());
createStm.setBoolean(5, appointment.getIsTrained());
createStm.setBoolean(6, appointment.getIsDeleted());
createStm.execute();
} catch (SQLException e) {
LOGGER.error("Failed to create record into appointment table. - " + e.getMessage());
throw new PersistenceException("Failed to create record into appointment table.", e);
}
LOGGER.info("Record successfully created in appointment table.");
return appointment;
}
/**
* Updating a given appointment with new values in the persistence.
*
* @param appointment which shall be updated must not be null, id must not be null and must not be
* changed
* @return given appointment with updated values
* @throws PersistenceException if there are complications with the persitance layer
*/
@Override
public Appointment update(Appointment appointment) throws PersistenceException {
LOGGER.info("Updating record in appointment table..");
try {
if (appointment == null) {
LOGGER.error("Update parameter (appointment) was null.");
throw new PersistenceException("Appointment to be updated must not be null");
}
updateStm.setDate(1, new java.sql.Date(appointment.getDatum().getTime()));
updateStm.setInt(2, appointment.getSession_id());
updateStm.setInt(3, appointment.getUser_id());
updateStm.setBoolean(4, appointment.getIsTrained());
updateStm.setBoolean(5, appointment.getIsDeleted());
updateStm.setInt(6, appointment.getId());
updateStm.executeUpdate();
} catch (SQLException e) {
LOGGER.error("Failed to update record in appointment table. - " + e.getMessage());
throw new PersistenceException("Failed to update record in appointment table.", e);
}
LOGGER.info("Record successfully updated in appointment table. " + appointment);
return appointment;
}
/**
* @param id appointment id to search for
* @return if the appointment exists it is returned, otherwise null is the result.
* @throws PersistenceException if there are complications with the persitance layer
*/
@Override
public Appointment searchByID(int id) throws PersistenceException {
LOGGER.info("Searching record in appointment table with id: " + id + "..");
try {
searchByIDStm.setInt(1, id);
ResultSet rs_searchByID = searchByIDStm.executeQuery();
rs_searchByID.next();
Appointment foundAppointment = null;
foundAppointment =
new Appointment(
rs_searchByID.getInt(1),
rs_searchByID.getDate(2),
rs_searchByID.getInt(3),
rs_searchByID.getInt(4),
rs_searchByID.getBoolean(5),
rs_searchByID.getBoolean(6));
if (foundAppointment != null) {
foundAppointment.setSessionName(
trainingsSessionDAO.searchByID(foundAppointment.getSession_id()).getName());
String setNames = "";
if (trainingsSessionDAO.searchByID(foundAppointment.getSession_id()).getExerciseSets()
!= null) {
for (ExerciseSet exerciseSet :
trainingsSessionDAO.searchByID(foundAppointment.getSession_id()).getExerciseSets()) {
setNames +=
(exerciseSet.getRepeat() + " " + exerciseSet.getExercise().getName() + '\n');
}
}
foundAppointment.setSetNames(setNames);
foundAppointment.setSession(
trainingsSessionDAO.searchByID(foundAppointment.getSession_id()));
}
LOGGER.info(
"Appointment with id: " + id + ", successfully read from database." + foundAppointment);
return foundAppointment;
} catch (SQLException e) {
LOGGER.error("Failed to search for an appointment with id: " + id + ". - " + e.getMessage());
throw new PersistenceException("Failed to search for an appointment with id: " + id + ".");
}
}
/**
* Finds all appointments in the persistence, deleted appointments are ignored.
*
* @return List of all appointments stored in the persistence
* @throws PersistenceException if there are complications with the persitance layer
*/
@Override
public List<Appointment> findAll() throws PersistenceException {
LOGGER.info("Finding all records in appointment table..");
try {
ResultSet rs_findAll = findAllStm.executeQuery();
List<Appointment> result = new ArrayList<>();
while (rs_findAll.next()) {
Appointment appointment =
new Appointment(
rs_findAll.getInt(1),
rs_findAll.getDate(2),
rs_findAll.getInt(3),
rs_findAll.getInt(4),
rs_findAll.getBoolean(5),
rs_findAll.getBoolean(6));
appointment.setSessionName(
trainingsSessionDAO.searchByID(appointment.getSession_id()).getName());
String setNames = "";
if (trainingsSessionDAO.searchByID(appointment.getSession_id()).getExerciseSets() != null) {
for (ExerciseSet exerciseSet :
trainingsSessionDAO.searchByID(appointment.getSession_id()).getExerciseSets()) {
setNames +=
(exerciseSet.getRepeat() + " " + exerciseSet.getExercise().getName() + '\n');
}
}
appointment.setSetNames(setNames);
appointment.setSession(trainingsSessionDAO.searchByID(appointment.getSession_id()));
result.add(appointment);
}
LOGGER.info("All record successfully read from appointment table.");
return result;
} catch (SQLException e) {
LOGGER.error("Failed to find all records in appointment table. - " + e.getMessage());
throw new PersistenceException("Failed to find all records in appointment table.", e);
}
}
/**
* Deleting a given appointment in the persistence.
*
* @param appointment which shall be deleted, must not be null, id must not be null and must not
* be changed
* @throws PersistenceException if there are complications with the persitance layer
*/
@Override
public void delete(Appointment appointment) throws PersistenceException {
LOGGER.info("Deleting appointment in appointment table..");
try {
if (appointment == null) {
LOGGER.error("Delete parameter (appointment) was null.");
throw new PersistenceException("Appointment to be deleted must not be null");
}
deleteStm.setInt(1, appointment.getId());
deleteStm.executeUpdate();
} catch (SQLException e) {
LOGGER.error("Failed to delete record in appointment table. - " + e.getMessage());
throw new PersistenceException("Failed to delete record in appointment table.", e);
}
LOGGER.info("Appointment successfully deleted in appointment table.");
}