break; case lt: result = leftField.lt(rightField); break; case ne:
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.ge(firstArg); case "lt": return field.lt(firstArg); case "le": return field.le(firstArg);
.select(idField) .from(table.table) .where(removeField.lt(cutoffTime) .and(idField.gt(DSL.param(ID_GREATER_THAN_PARAM, 0L)))) .orderBy(idField)
case BEFORE: case LESS_THAN: return field.lt(iterator.next()); case LESS_THAN_EQUAL: return field.le(iterator.next());
if (time_to > -1 && time_from <= time_to) select.addConditions(CDR.TIME_TO_FIELD.lt(inline(new Timestamp(time_to))));
if (time_to > -1 && time_from <= time_to) select.addConditions(UDR.TIME_TO_FIELD.lt(inline(new Timestamp(time_to))));
if (time_to > -1 && time_from <= time_to) select.addConditions(Bill.TIME_TO_FIELD.lt(inline(new Timestamp(time_to))));
break; case "lt": condition = field.lt(parts[2]); break; case "le":
@SuppressWarnings({ "unchecked" }) @Override public void accept(Context<?> ctx) { switch (ctx.family()) { case POSTGRES: ctx.visit(DSL.field("{width_bucket}({0}, {1}, {2}, {3})", getType(), field, low, high, buckets)); break; default: ctx.visit( DSL.when(field.lt(low), zero()) .when(field.ge(high), buckets.add(one())) .otherwise((Field<Integer>) DSL.floor(field.sub(low).mul(buckets).div(high.sub(low))).add(one())) ); break; } }
break; case lt: result = leftField.lt(rightField); break; case ne:
and.addConditions(((Field) s.getField()).gt(getSeek().get(i))); else and.addConditions(((Field) s.getField()).lt(getSeek().get(i)));
and.addConditions(((Field) s.getField()).lt(getSeek().get(i)));