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

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

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

Field.isNull介绍

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

SQL: this is null
[中]创建一个条件以对照null检查此字段。
SQL:this is null

代码示例

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

/**
 * Create a <code>null</code>-safe condition.
 */
static final <T> Condition condition(Field<T> field, T value) {
  return (value == null) ? field.isNull() : field.eq(value);
}

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

private Condition getContainsCondition(Object value, BiPredicate<?, ?> biPredicate, Field<Object> field) {
  if (biPredicate == Contains.without) {
    if (value == null) {
      return field.isNull();
    } else {
      return field.notIn(value);
    }
  } else if (biPredicate == Contains.within) {
    if (value == null) {
      return field.isNotNull();
    } else {
      return field.in(((Collection) value).toArray());
    }
  }
  return null;
}

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

private final QueryPartInternal delegate(Configuration configuration) {
  // CUBRID 9.0.0 and HSQLDB have buggy implementations of the NULL predicate.
  // Informix doesn't implement the RVE IS NULL predicate.
  if (EMULATE_NULL.contains(configuration.family())) {
    Field<?>[] fields = row.fields();
    List<Condition> conditions = new ArrayList<Condition>(fields.length);
    for (Field<?> field : fields)
      conditions.add(isNull ? field.isNull() : field.isNotNull());
    Condition result = DSL.and(conditions);
    return (QueryPartInternal) result;
  }
  else {
    return new Native();
  }
}

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

private final QueryPartInternal delegate(Configuration configuration) {
  // CUBRID 9.0.0 and HSQLDB have buggy implementations of the NULL predicate.
  // Let's wait for them to be fixed
  if (asList(CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, SQLITE).contains(configuration.dialect().family())) {
    List<Condition> conditions = new ArrayList<Condition>();
    for (Field<?> field : row.fields()) {
      conditions.add(isNull ? field.isNull() : field.isNotNull());
    }
    Condition result = new CombinedCondition(Operator.AND, conditions);
    return (QueryPartInternal) result;
  }
  else {
    return new Native();
  }
}

代码示例来源:origin: com.walmartlabs.concord.server/concord-server

private Condition buildConditionClause(Triggers t, String eventSource, Map<String, String> conditions) {
  Condition result = t.EVENT_SOURCE.eq(eventSource);
  if (conditions == null) {
    return result;
  }
  for (Map.Entry<String, String> e : conditions.entrySet()) {
    result = result.and(
        jsonText(t.CONDITIONS, e.getKey()).isNull()
            .or(
                value(e.getValue()).likeRegex(jsonText(t.CONDITIONS, e.getKey()).cast(String.class))));
  }
  return result;
}

代码示例来源: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: infiniteautomation/ma-core-public

case "eq":
  if (firstArg == null) {
    return field.isNull();

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

return field.between(iterator.next(), iterator.next());
case IS_NULL:
  return field.isNull();
case IS_NOT_NULL:
  return field.isNotNull();

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

if (comparator == Comparator.IS_DISTINCT_FROM) {
  caseExpression = (QueryPartInternal) decode()
    .when(lhs.isNull().and(rhs.isNull()), zero())
    .when(lhs.isNull().and(rhs.isNotNull()), one())
    .when(lhs.isNotNull().and(rhs.isNull()), one())
    .when(lhs.equal(rhs), zero())
    .otherwise(one())
    .when(lhs.isNull().and(rhs.isNull()), one())
    .when(lhs.isNull().and(rhs.isNotNull()), zero())
    .when(lhs.isNotNull().and(rhs.isNull()), zero())
    .when(lhs.equal(rhs), one())
    .otherwise(zero())

代码示例来源:origin: perfectsense/dari

comparisonConditions.add(join.valueField.isNull());
  join.valueField.isNull().or(
      join.valueField.ne(join.value(value))));

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

break;
case "is":
  condition = field.isNull();
  break;

代码示例来源:origin: com.torodb.torod.backends/common

@Override
public Condition visit(IsEqualQueryCriteria criteria, Boolean inArray) {
  String[] keys = translateArrayRef(criteria);
  Field field = DSL.field(databaseInterface.arraySerializer().getFieldName(keys));
  Param<?> value;
  Condition criteriaCondition;
  if (criteria.getValue().getType().equals(ScalarType.NULL)) {
    if (!isInArrayValue(criteria.getAttributeReference(), inArray)) {
      criteriaCondition = field.isNull();
    }
    else {
      criteriaCondition
          = field.equal(
              translateValueToArraySerialization(criteria.getValue())
          );
    }
  }
  else {
    if (!isInArrayValue(criteria.getAttributeReference(), inArray)) {
      value = translateValueToSQL(criteria.getValue());
    }
    else {
      value = translateValueToArraySerialization(criteria.getValue());
    }
    criteriaCondition = field.equal(value);
  }
  return addArrayCondition(criteria, criteriaCondition, keys, inArray);
}

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

: ((RowN) left).isNotNull()
: left instanceof Field
  ? ((Field) left).isNull()
  : ((RowN) left).isNotNull();

相关文章