void addSnapshotIdentifiersFilter(List<SnapshotDbIdentifier> snapshotDbIdentifiers) { selectBuilder.append("and ("); snapshotDbIdentifiers.forEach(si -> selectBuilder.append("("+SNAPSHOT_GLOBAL_ID_FK+" = ? AND "+SNAPSHOT_VERSION+" = ?) OR", longParam(si.getGlobalIdPk()), longParam(si.getVer())) ); selectBuilder.append(" false)"); }
void addSnapshotIdentifiersFilter(List<SnapshotDbIdentifier> snapshotDbIdentifiers) { selectBuilder.append("and ("); snapshotDbIdentifiers.forEach(si -> selectBuilder.append("("+SNAPSHOT_GLOBAL_ID_FK+" = ? AND "+SNAPSHOT_VERSION+" = ?) OR", longParam(si.getGlobalIdPk()), longParam(si.getVer())) ); selectBuilder.append(" false)"); }
void limit(SelectBuilder query, long limit, long offset) { query.append("LIMIT ? OFFSET ?", longParam(limit), longParam(offset)); } }
@Override void limit(SelectBuilder query, long limit, long offset) { if (limit == 0){ return; } // if (offset == 0) { // query.wrap("select TOP "+limit.getLimit()+" * from (",") a"); query.append("OFFSET ? ROWS FETCH NEXT ? ROWS ONLY", longParam(offset), longParam(limit)); } }
@Override void limit(SelectBuilder query, long limit, long offset) { if (limit == 0){ return; } // if (offset == 0) { // query.wrap("select TOP "+limit.getLimit()+" * from (",") a"); query.append("OFFSET ? ROWS FETCH NEXT ? ROWS ONLY", longParam(offset), longParam(limit)); } }
void limit(SelectBuilder query, long limit, long offset) { query.append("LIMIT ? OFFSET ?", longParam(limit), longParam(offset)); } }