public void testExtraSpaces(SheetValidation sheetValidation) {
String colC = "Column C";
ColumnValidation validateColC = sheetValidation.createColumnValidation(colC);
boolean check = validateColC.leadingTrailingSpaces();
if (!check) {
StringBuffer errorToPrint =
sheetValidation
.getErrorManager()
.createMessage(ErrorManager.EXTRA_SPACES_ERROR, validateColC.getErrorsFound());
System.out.println(errorToPrint);
sheetValidation.getErrorManager().printMessage(errorToPrint.toString());
}
}
public void testUniqueValue(SheetValidation sheetValidation) {
String colC = "Column C";
ColumnValidation validateColC = sheetValidation.createColumnValidation(colC);
boolean check = validateColC.uniqueValue();
if (!check) {
StringBuffer errorToPrint =
sheetValidation
.getErrorManager()
.createDupFoundMessage(
ErrorManager.UNIQUENESS_ERROR, validateColC.getMultipleErrorsFound(), ",");
System.out.println(errorToPrint);
sheetValidation.getErrorManager().printMessage(errorToPrint.toString());
}
}
public void testPatternAbsent(SheetValidation sheetValidation) {
String colA = "Column A";
ColumnValidation validateColA = sheetValidation.createColumnValidation(colA);
String[] pattern = new String[] {".", "/"};
boolean check = validateColA.isPatternAbsent(pattern);
if (!check) {
ErrorManager errorManager = sheetValidation.getErrorManager();
String message =
ErrorManager.PATTERN_DETECTED_ERROR + errorManager.getListOfTerms(pattern, " or ");
StringBuffer errorToPrint =
errorManager.createMessage(message, validateColA.getErrorsFound());
System.out.println(errorToPrint);
errorManager.printMessage(errorToPrint.toString());
}
}
public void testPatternPresent(SheetValidation sheetValidation) {
String colB = "Column B";
ColumnValidation validateColB = sheetValidation.createColumnValidation(colB);
String[] pattern = new String[] {".jpg", ".tiff"};
boolean check = validateColB.isPatternPresent(pattern);
if (!check) {
ErrorManager errorManager = sheetValidation.getErrorManager();
String message =
ErrorManager.PATTERN_NOT_FOUND_ERROR + errorManager.getListOfTerms(pattern, " or ");
StringBuffer errorToPrint =
errorManager.createMessage(message, validateColB.getErrorsFound());
System.out.println(errorToPrint);
errorManager.printMessage(errorToPrint.toString());
}
}
public void testDropDown(SheetValidation sheetValidation) {
String colB = "Column B";
String colDD = "Drop Down";
ColumnValidation validation = sheetValidation.createColumnValidation(colB, colDD);
boolean check = validation.dropDown();
if (!check) {
// StringBuffer errorToPrint = sheetValidation.getErrorManager()
// .createDropDownMessage(ErrorManager.DROP_DOWN_ERROR,
// validation.getMultipleErrorsFound());
StringBuffer errorToPrint2 =
sheetValidation
.getErrorManager()
.createMessageFromErrorMessage(
ErrorManager.DROP_DOWN_ERROR, new Object[] {validation.getMultipleErrorsFound()});
System.out.println(errorToPrint2);
// sheetValidation.getErrorManager().printMessage(errorToPrint.toString());
}
}
