/** Validate Student entries */
public void validateStudent() {
String file = "student.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 duplicateUserid and invalidEDollar
for (int i = 0; i < entries.size(); i++) {
boolean rowHasDuplicateUserId = false;
boolean rowHasInvalidEDollar = 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)) {
// if there are duplicates, the latest/bottomest row will be accepted.
// The earlier rows will be errored.
rowHasDuplicateUserId = tool.rowHasDuplicatePrimaryKey("userid", row, line, rowMessageList);
rowHasInvalidEDollar = tool.rowHasInvalidEDollar(row, rowMessageList);
// Blacklist row if any of the validations blacklistedEntries are "true"
if (rowHasInvalidEDollar || rowHasDuplicateUserId) {
blacklistedEntries.add(row); // add row to blackList
String[] message = rowMessageList.toArray(new String[0]);
errorList.add(new BootstrapError(file, line, message));
}
}
}
// method ends
}
