org.jooq.Field.between()方法的使用及代码示例

x33g5p2x  于2022-01-19 转载在 其他  
字(4.3k)|赞(0)|评价(0)|浏览(196)

本文整理了Java中org.jooq.Field.between()方法的一些代码示例,展示了Field.between()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Field.between()方法的具体详情如下:
包路径:org.jooq.Field
类名称:Field
方法名:between

Field.between介绍

[英]Create a condition to check this field against some bounds.

SQL: this between minValue and maxValue
[中]创建一个条件,根据某些边界检查此字段。
SQL:this between minValue and maxValue

代码示例

代码示例来源:origin: org.jooq/jooq

private final QueryPartInternal delegate(Configuration configuration) {
  if (symmetric && NO_SUPPORT_SYMMETRIC.contains(configuration.family()))
    return not
      ? (QueryPartInternal) field.notBetween(minValue, maxValue).and(field.notBetween(maxValue, minValue))
      : (QueryPartInternal) field.between(minValue, maxValue).or(field.between(maxValue, minValue));
  else
    return new Native();
}

代码示例来源:origin: org.jooq/jooq

: ((RowN) left).notBetween((RowN) r1, (RowN) r2)
: left instanceof Field
  ? ((Field) left).between((Field) r1, (Field) r2)
  : ((RowN) left).between((RowN) r1, (RowN) r2);

代码示例来源:origin: com.ning.billing/killbill-osgi-bundles-analytics

private final QueryPartInternal delegate(Configuration configuration) {
  if (symmetric && asList(CUBRID, DERBY, FIREBIRD, H2, MARIADB, MYSQL, SQLITE).contains(configuration.dialect().family())) {
    if (not) {
      return (QueryPartInternal) field.notBetween(minValue, maxValue).and(field.notBetween(maxValue, minValue));
    }
    else {
      return (QueryPartInternal) field.between(minValue, maxValue).or(field.between(maxValue, minValue));
    }
  }
  else {
    return new Native();
  }
}

代码示例来源:origin: unipop-graph/unipop

private Condition getCompareCondition(Object value, BiPredicate<?, ?> biPredicate, Field<Object> field) {
  String predicateString = biPredicate.toString();
  switch (predicateString) {
    case ("eq"):
      return field.eq(value);
    case ("neq"):
      return field.notEqual(value);
    case ("gt"):
      return field.greaterThan(value);
    case ("gte"):
      return field.greaterOrEqual(value);
    case ("lt"):
      return field.lessThan(value);
    case ("lte"):
      return field.lessOrEqual(value);
    case ("inside"):
      List items = (List) value;
      Object firstItem = items.get(0);
      Object secondItem = items.get(1);
      return field.between(firstItem, secondItem);
    default:
      throw new IllegalArgumentException("predicate not supported in has step: " + biPredicate.toString());
  }
}

代码示例来源:origin: unipop-graph/unipop

Object firstItem = convertToSqlDate(items.get(0).toString());
  Object secondItem = convertToSqlDate(items.get(1).toString());
  return field.between(firstItem, secondItem);
case ("within"):
  List v = (List) value;

代码示例来源:origin: orientechnologies/spring-data-orientdb

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!");
  }
}

代码示例来源:origin: com.orientechnologies/spring-data-orientdb-commons

return field.le(iterator.next());
case BETWEEN:
  return field.between(iterator.next(), iterator.next());
case IS_NULL:
  return field.isNull();

代码示例来源:origin: icclab/cyclops

select.addConditions(Usage.TIME_FIELD.between(inline(new Timestamp(time_from)), inline(new Timestamp(time_to))));
select.addConditions(onlySelectTheseMetrics(metrics));

代码示例来源:origin: icclab/cyclops

select.addConditions(Usage.TIME_FIELD.between(inline(new Timestamp(time_from)), inline(new Timestamp(time_to))));

代码示例来源:origin: mevdschee/java-crud-api

case "bt":
  parts2 = parts[2].split(",", 2);
  condition = field.between(parts2[0], parts2[1]);
  break;
case "in":

相关文章