public void testQueryBuilder() {
ArrayList<ColumnDef> colList = new ArrayList<ColumnDef>();
int i = 1;
colList.add(new ColumnDef("Fld1", i));
colList.add(new ColumnDef("Agg1 ASC", ++i, ","));
colList.add(new ColumnDef("Agg2", ++i, ","));
String query = ListAggProcedure.buildQueryString(colList, "MyTable", "");
// System.out.println(query);
assertTrue(
query,
query.equals("<local> SELECT Fld1,Agg1,Agg2 FROM MyTable ORDER BY Fld1 ASC,Agg1 ASC"));
}
public void testQueryDesc1BuilderWithWhereCaluse() {
ArrayList<ColumnDef> colList = new ArrayList<ColumnDef>();
int i = 1;
colList.add(new ColumnDef("Fld1", i));
colList.add(new ColumnDef("Field2 DESC", ++i));
colList.add(new ColumnDef("Agg1 ASC", ++i, ","));
colList.add(new ColumnDef("Field3 ASC", ++i));
colList.add(new ColumnDef("Agg2 DESC", ++i, ","));
String query = ListAggProcedure.buildQueryString(colList, "MyTable", "Fld1='abc'");
// System.out.println(query);
assertTrue(
query,
query.equals(
"<local> SELECT Fld1,Field2,Agg1,Field3,Agg2 FROM MyTable WHERE Fld1='abc' ORDER BY Fld1 ASC,Field2 DESC,Agg1 ASC,Field3 ASC,Agg2 DESC"));
}
