public static String selectQueryBuilder(String from, boolean count, QueryParams criteria) {
String ret;
if (count) ret = "select count(*) from ";
else ret = "select from ";
ret += from;
if (criteria.getWhere() != null && !criteria.getWhere().equals("")) {
ret += " where ( " + criteria.getWhere() + " )";
}
if (!count && criteria.getOrderBy() != null && !criteria.getOrderBy().equals("")) {
ret += " order by " + criteria.getOrderBy();
}
if (!count && (criteria.getPage() != null && criteria.getPage() != -1)) {
ret +=
" skip "
+ (criteria.getPage() * criteria.getRecordPerPage())
+ " limit "
+ criteria.getRecordPerPage();
}
Logger.debug("queryBuilder: " + ret);
return ret;
}
