public class QueryBuilderTest extends TestCase {
private String[] variablesChosen = new String[0];
public void buildingPhenoTypeQuery() {
String[] displayItemsChosen = getDisplayItems();
QueryBuilder builder = new QueryBuilder();
String query = builder.buildPhenotypeQuery(displayItemsChosen);
String result = "from edu.iu.ms.ped.matrixweb.domain.Category cat where cat.displayOrder > 0 AND cat.phenoCat='Y' AND (cat.id in(66,68,70) OR cat.id in (select distinct(c.parent) from edu.iu.ms.ped.matrixweb.domain.Category c where c.id in(66,68,70))) order by cat.displayOrder";
assertNotNull(query);
assertEquals(query, result);
}
private String[] getDisplayItems() {
String[] displayItemsChosen = new String[3];
displayItemsChosen[0] = "66";
displayItemsChosen[1] = "68";
displayItemsChosen[2] = "70";
return displayItemsChosen;
}
}