@Test
public void mixedCriteria() throws Exception {
FindReachRequest req = new FindReachRequest();
req.modelID = TEST_MODEL_ID.toString();
req.edaName = " , ,, Albemarle Sound, Altamaha River, ";
req.meanQLo = "50";
req.totContributingAreaLo = "100";
req.totContributingAreaHi = "150";
req.reachName = "cr";
req.huc = "030102";
FindReaches action = new FindReaches();
action.setReachRequest(req);
action.setPageSize(10);
DataTable result = action.run();
assertTrue(result.getRowCount() == 4);
assertEquals(0, action.getValidationErrors().length);
assertEquals("4915", result.getString(0, result.getColumnByName("FULL_IDENTIFIER")));
assertEquals("4851", result.getString(1, result.getColumnByName("FULL_IDENTIFIER")));
assertEquals("4840", result.getString(2, result.getColumnByName("FULL_IDENTIFIER")));
assertEquals("4850", result.getString(3, result.getColumnByName("FULL_IDENTIFIER")));
}
/**
* The contributing area for this reach is different than the total area for this reach, so this
* test ensures that we are search on the correct column.
*
* <p>**Note that the areas in the DEV db (the one being queries for these tests) is different
* than the values in the TEST db.
*
* @throws Exception
*/
@Test
public void searchByHiLowContribAreaWithSingleResultAndEnsureContribAreaNotTotalArea()
throws Exception {
FindReachRequest req = new FindReachRequest();
req.modelID = TEST_MODEL_ID.toString();
req.totContributingAreaHi = "113285";
req.totContributingAreaLo = "113284";
FindReaches action = new FindReaches();
action.setReachRequest(req);
action.setPageSize(50);
DataTable result = action.run();
assertTrue(result.getRowCount() == 1);
assertEquals(0, action.getValidationErrors().length);
assertEquals("9682", result.getString(0, result.getColumnByName("FULL_IDENTIFIER")));
assertEquals("MOBILE R", result.getString(0, result.getColumnByName("REACH_NAME")));
assertEquals("64063.55", result.getString(0, result.getColumnByName("MEANQ")));
assertEquals("113284.268214", result.getString(0, result.getColumnByName("TOT_CONTRIB_AREA")));
assertEquals("03", result.getString(0, result.getColumnByName("HUC2")));
assertEquals("0316", result.getString(0, result.getColumnByName("HUC4")));
assertEquals("031602", result.getString(0, result.getColumnByName("HUC6")));
assertEquals("03160204", result.getString(0, result.getColumnByName("HUC8")));
}
@Test
public void searchByHiLowContribAreaWithMultipleResults() throws Exception {
FindReachRequest req = new FindReachRequest();
req.modelID = TEST_MODEL_ID.toString();
req.totContributingAreaHi = "100";
req.totContributingAreaLo = "99.5";
FindReaches action = new FindReaches();
action.setReachRequest(req);
action.setPageSize(50);
DataTable result = action.run();
assertTrue(result.getRowCount() == 15);
assertEquals(0, action.getValidationErrors().length);
assertEquals("7126", result.getString(0, result.getColumnByName("FULL_IDENTIFIER")));
assertEquals("BIG SANDY CR", result.getString(0, result.getColumnByName("REACH_NAME")));
assertEquals("81.02", result.getString(0, result.getColumnByName("MEANQ")));
assertEquals("99.82", result.getString(0, result.getColumnByName("TOT_CONTRIB_AREA")));
assertEquals("03", result.getString(0, result.getColumnByName("HUC2")));
assertEquals("0307", result.getString(0, result.getColumnByName("HUC4")));
assertEquals("030701", result.getString(0, result.getColumnByName("HUC6")));
assertEquals("03070103", result.getString(0, result.getColumnByName("HUC8")));
}
@Test
public void searchByHiLowContribAreaValidationCheck() throws Exception {
FindReachRequest req = new FindReachRequest();
req.modelID = TEST_MODEL_ID.toString();
req.totContributingAreaHi = "10";
req.totContributingAreaLo = "11";
FindReaches action = new FindReaches();
action.setReachRequest(req);
action.setPageSize(50);
DataTable result = action.run();
assertNull(result);
assertEquals(1, action.getValidationErrors().length);
}