@Override void limit(SelectBuilder query, long limit, long offset) { if (limit == 0) { return; } if (offset == 0){ query.wrap("SELECT a.*, rownum FROM (", ") a WHERE rownum <= ?", longParam(limit)); } else { long lowRownum = offset + 1; long highRownum = offset + limit; query.wrap( "select b.* from (SELECT a.*, rownum r__ FROM (", ") a WHERE rownum <= ? ) b where b.r__ >= ?", longParam(highRownum), longParam(lowRownum)); } } }
@Override void limit(SelectBuilder query, long limit, long offset) { if (limit == 0) { return; } if (offset == 0){ query.wrap("SELECT a.*, rownum FROM (", ") a WHERE rownum <= ?", longParam(limit)); } else { long lowRownum = offset + 1; long highRownum = offset + limit; query.wrap( "select b.* from (SELECT a.*, rownum r__ FROM (", ") a WHERE rownum <= ? ) b where b.r__ >= ?", longParam(highRownum), longParam(lowRownum)); } } }
public SelectBuilder and(String columnName, Long value) { return and(columnName, "=", longParam(value)); }
public SelectBuilder and(String columnName, Long value) { return and(columnName, "=", longParam(value)); }
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)"); }