break; case gt: result = leftField.gt(rightField); break; case le:
private SelectLimitStep<? extends Record> orderByIfRequired(SelectConditionStep<? extends Record> conditionStep, Pageable pageable, Sort sort) { if (isCountQuery()) { return conditionStep; } if (sort == null) { return pageable == null ? conditionStep : conditionStep.and(field("@rid").gt(pageable.getOffset())); } // if (sort == null) { // return conditionStep; // } return conditionStep.orderBy(toOrders(sort)); }
private SelectLimitStep<? extends Record> orderByIfRequired(SelectConditionStep<? extends Record> conditionStep, Pageable pageable, Sort sort) { if (isCountQuery()) { return conditionStep; } if (sort == null) { return pageable == null ? conditionStep : conditionStep.and(field("@rid").gt(pageable.getOffset())); } else { return conditionStep.orderBy(toOrders(sort)); } }
protected Condition toCondition(Part part, Iterator<Object> iterator) { String property = part.getProperty().toDotPath(); Field<Object> field = field(property); switch (part.getType()) { case AFTER: case GREATER_THAN: return field.gt(iterator.next()); case GREATER_THAN_EQUAL: return field.ge(iterator.next()); case BEFORE: case LESS_THAN: return field.lt(iterator.next()); case LESS_THAN_EQUAL: return field.le(iterator.next()); case BETWEEN: return field.between(iterator.next(), iterator.next()); case IS_NULL: return field.isNull(); case IS_NOT_NULL: return field.isNotNull(); case IN: return field.in(toList(iterator)); case NOT_IN: return field.notIn(toList(iterator)); case LIKE: return lowerIfIgnoreCase(part, field, iterator); case NOT_LIKE: return lowerIfIgnoreCase(part, field, iterator).not(); case STARTING_WITH: return field.startsWith(iterator.next()); case ENDING_WITH: return field.endsWith(iterator.next()); case CONTAINING: return field.contains(iterator.next()); case SIMPLE_PROPERTY: return field.eq(iterator.next()); case NEGATING_SIMPLE_PROPERTY: return field.ne(iterator.next()); case TRUE: return field.eq(true); case FALSE: return field.eq(false); default: throw new IllegalArgumentException("Unsupported keyword!"); } }
return field.gt(firstArg); case "ge": return field.ge(firstArg);
.from(table.table) .where(removeField.lt(cutoffTime) .and(idField.gt(DSL.param(ID_GREATER_THAN_PARAM, 0L)))) .orderBy(idField) .limit(QUERY_LIMIT_ROWS.getValue());
case AFTER: case GREATER_THAN: return field.gt(iterator.next()); case GREATER_THAN_EQUAL: return field.ge(iterator.next());
break; case "gt": condition = field.gt(parts[2]); break; case "bt":
break; case gt: result = leftField.gt(rightField); break; case le:
and.addConditions(((Field) s.getField()).gt(getSeek().get(i))); else and.addConditions(((Field) s.getField()).lt(getSeek().get(i)));
and.addConditions(((Field) s.getField()).gt(getSeek().get(i)));