/** Validate prerequisites entries (prerequisite.csv) */
public void validatePrerequisites() {
String file = "prerequisite.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 rowHasInvalidCourse = false;
boolean rowHasInvalidPrerequisite = false;
boolean rowHasDuplicatePrimaryKey = 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)) {
rowHasInvalidCourse = tool.rowHasInvalidCourse(row, rowMessageList);
rowHasInvalidPrerequisite = tool.rowHasInvalidPrerequisite(row, rowMessageList);
// if there are duplicates, the latest/bottomest row will be accepted.
// The earlier rows will be errored.
String foreignKey = "course";
String primaryKey = "prerequisite";
// rowHasDuplicatePrimaryKey =
// tool.rowHasDuplicatePrimaryKey(foreignKey,primaryKey,row,rowMessageList);
/*
* NO NEED TO TEST FOR DUPLICATES
*/
// Blacklist row if any of the validations blacklistedEntries are "true"
if (rowHasInvalidCourse || rowHasInvalidPrerequisite || rowHasDuplicatePrimaryKey) {
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
}
