/** Validate course entries (course.csv) */
public void validateCourse() {
String file = "course.csv";
// CHECK ALL ENTRIES FOR BLANK FIELDS
for (int i = 0; i < entries.size(); i++) {
boolean rowHasMissingFields = false;
// Line Number. First row (index 0) is data row. So +2 to get line number.
int line = i + 2;
ArrayList<String> rowMessageList = new ArrayList<>();
String[] row = entries.get(i);
rowHasMissingFields = tool.rowHasMissingFields(row, rowMessageList);
if (rowHasMissingFields) {
blacklistedEntries.add(row);
String[] message = rowMessageList.toArray(new String[0]);
errorList.add(new BootstrapError(file, line, message));
}
}
// STEP 2: CHECK ALL FOR invalidExamDate invalidStart, invalidEnd
for (int i = 0; i < entries.size(); i++) {
boolean rowHasInvalidExamDate = false;
boolean rowHasInvalidExamStart = false;
boolean rowHasInvalidExamEnd = false;
boolean rowHasDuplicateCourse = false;
int line = i + 2;
ArrayList<String> rowMessageList = new ArrayList<>();
String[] row = entries.get(i);
// if not already blacklisted due to error
if (!blacklistedEntries.contains(row)) {
rowHasInvalidExamDate = tool.rowHasInvalidExamDate(row, rowMessageList);
rowHasInvalidExamStart = tool.rowHasInvalidStart("exam start", row, rowMessageList);
rowHasInvalidExamEnd = tool.rowHasInvalidEnd("exam start", "exam end", row, rowMessageList);
// if there are duplicates, the latest/bottomest row will be accepted.
// The earlier rows will be errored.
// rowHasDuplicateCourse = tool.rowHasDuplicatePrimaryKey("course",row,rowMessageList);
/*
* NO NEED TO TEST FOR DUPLICATES
*/
// Blacklist row if any of the validations blacklistedEntries are "true"
if (rowHasInvalidExamDate
|| rowHasInvalidExamStart
|| rowHasInvalidExamEnd
|| rowHasDuplicateCourse) {
blacklistedEntries.add(row); // add row to blackList
String[] message = rowMessageList.toArray(new String[0]);
errorList.add(new BootstrapError(file, line, message));
}
}
} // end of 2nd for-loop
// method ends
}
