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

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

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

Field.contains介绍

[英]Convenience method for #like(String,char) including proper adding of wildcards and escaping.

SQL: this like ('%' || escape(value, '\') || '%') escape '\'

Note: This also works with numbers, for instance val(1133).contains(13)

If you're using SQLDialect#POSTGRES, then you can use this method also to express the "ARRAY contains" operator. For example: ``

// Use this expression 
val(new Integer[] { 1, 2, 3 }).contains(new Integer[] { 1, 2 }) 
// ... to render this SQL 
ARRAY[1, 2, 3] @> ARRAY[1, 2]

Note, this does not correspond to the Oracle Text CONTAINS() function. Refer to OracleDSL#contains(Field,String) instead.
[中]#like(String,char)的简便方法,包括正确添加通配符和转义。
SQL:this like ('%' || escape(value, '\') || '%') escape '\'
注意:这也适用于数字,例如val(1133).contains(13)
如果您使用的是SQL方言#POSTGRES,那么还可以使用此方法来表示“ARRAY contains”操作符。例如:``

// Use this expression 
val(new Integer[] { 1, 2, 3 }).contains(new Integer[] { 1, 2 }) 
// ... to render this SQL 
ARRAY[1, 2, 3] @> ARRAY[1, 2]

注意,这与Oracle文本CONTAINS()函数不对应。请参考OracleDSL#contains(字段、字符串)。

代码示例

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

private void filterByMetaFilters(SelectQuery<Record> query, Map<String, String> filters) {
  if (filters == null || filters.isEmpty()) {
    return;
  }
  for (Map.Entry<String, String> e : filters.entrySet()) {
    query.addConditions(jsonText(PROCESS_QUEUE.META, e.getKey()).contains(e.getValue()));
  }
}

代码示例来源: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.endsWith(iterator.next());
case CONTAINING:
  return field.contains(iterator.next());
case SIMPLE_PROPERTY:
  return field.eq(iterator.next());

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

switch (command) {
case "cs":
  condition = field.contains(parts[2]);
  break;
case "sw":

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

return toField(ctx, left).contains((Field) toField(ctx, parseConcat(ctx, null)));

相关文章