/** Validate section entries (section.csv) */
public void validateSection() {
String file = "section.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 rowHasInvalidSection = false;
boolean rowHasInvalidDay = false;
boolean rowHasInvalidStart = false;
boolean rowHasInvalidEnd = false;
boolean rowHasInvalidSize = 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);
if (!rowHasInvalidCourse) {
rowHasInvalidSection = tool.rowHasInvalidSection(row, rowMessageList);
}
rowHasInvalidDay = tool.rowHasInvalidDay(row, rowMessageList);
rowHasInvalidStart = tool.rowOfSectionHasInvalidStart("start", row, rowMessageList);
rowHasInvalidEnd = tool.rowOfSectionHasInvalidEnd("start", "end", row, rowMessageList);
rowHasInvalidSize = tool.rowHasInvalidSize(row, rowMessageList);
// if there are duplicates, the latest/bottomest row will be accepted.
// The earlier rows will be errored.
// String foreignKey = "course";
// String primaryKey = "section";
// 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
|| rowHasInvalidSection
|| rowHasInvalidDay
|| rowHasInvalidStart
|| rowHasInvalidEnd
|| rowHasInvalidSize) {
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
}
