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

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

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

Field.like介绍

[英]Create a condition to pattern-check this field against a value.

SQL: this like value
[中]创建一个条件,根据值对该字段进行模式检查。
SQL:this like value

代码示例

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

@SuppressWarnings("incomplete-switch")
private Condition lowerIfIgnoreCase(Part part, Field<Object> field, Iterator<Object> iterator) {
  switch (part.shouldIgnoreCase()) {
    case ALWAYS:
    case WHEN_POSSIBLE: return field.likeIgnoreCase(iterator.next().toString());
    default: break;
  }
  
  return field.like(iterator.next().toString());
}

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

private Condition getTextCondition(Object value, BiPredicate<?, ?> biPredicate, Field<Object> field) {
    String predicateString = biPredicate.toString();
    switch (predicateString) {
      case ("LIKE"):
        return field.like(value.toString().replace("*", "%"));
      case ("UNLIKE"):
        return field.notLike(value.toString().replace("*", "%"));
      case ("REGEXP"):
        return field.likeRegex(value.toString());
      case ("UNREGEXP"):
        return field.notLikeRegex(value.toString());
      case ("PREFIX"):
        return field.like(value.toString() + "%");
      case ("UNPREFIX"):
        return field.notLike(value.toString() + "%");
      default:
        throw new IllegalArgumentException("predicate not supported in has step: " + biPredicate.toString());
    }
  }
}

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

return (value) -> join.valueField.like((Param) join.value("%" + value + "%"));
return (value) -> join.valueField.like((Param) join.value(value + "%"));

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

private final Condition condition(Configuration configuration) {
  // [#1107] Some dialects support "contains" operations for ARRAYs
  // [#5929] Check both sides of the operation for array types
  if (lhs.getDataType().isArray()
    || (rhs != null && rhs.getDataType().isArray())
    || (rhs == null && value != null && value.getClass().isArray()))
    return new PostgresArrayContains();
  // "contains" operations on Strings
  else
    return lhs.like((rhs == null)
      ? DSL.concat(inline("%"), Tools.escapeForLike(value, configuration), inline("%"))
      : DSL.concat(inline("%"), Tools.escapeForLike(rhs, configuration), inline("%")), Tools.ESCAPE);
}

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

@SuppressWarnings("incomplete-switch")
private Condition lowerIfIgnoreCase(Part part, Field<Object> field, Iterator<Object> iterator) {
  switch (part.shouldIgnoreCase()) {
    case ALWAYS:
    case WHEN_POSSIBLE:
      return field.likeIgnoreCase(iterator.next().toString());
  }
  return field.like(iterator.next().toString());
}

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

return context.select(FT_WORDS_NAME_FIELD)
    .from(FT_WORDS_TABLE)
    .where(FT_WORDS_NAME_FIELD.like(value
        .replace("%", "\\%")
        .replace("_", "\\_")

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

private final Condition condition(Configuration configuration) {
  // [#1107] Some dialects support "contains" operations for ARRAYs
  if (lhs.getDataType().isArray()) {
    return new PostgresArrayContains();
  }
  // "contains" operations on Strings
  else {
    Field<String> concat;
    if (rhs == null) {
      concat = DSL.concat(inline("%"), Utils.escapeForLike(value, configuration), inline("%"));
    }
    else {
      concat = DSL.concat(inline("%"), Utils.escapeForLike(rhs, configuration), inline("%"));
    }
    return lhs.like(concat, Utils.ESCAPE);
  }
}

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

? not
  ? ((Field) left).notLike(right, character)
  : ((Field) left).like(right, character)
: not
  ? ((Field) left).notLike(right)
  : ((Field) left).like(right);

相关文章