/** 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 }