程序包 com.sh.wf.module.util

类 DslQueryUtils

java.lang.Object

com.sh.wf.module.util.DslQueryUtils

public class DslQueryUtils
extends Object

Description: Title:首亨软件 - 聚天平台

从以下版本开始:

2018年9月30日

字段概要

字段

修饰符和类型	字段	说明
static final String	_SOURCE
static final String	_SOURCEAGGS
static final String	_SOURCEAGGS_COLLAPSEC
static final String	ASC
static final String	DESC

构造器概要

构造器

构造器	说明
DslQueryUtils()

方法概要

修饰符和类型	方法	说明
static String	aggsBucket()	https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket.html
static String	aggsLine()
static String	aggsMetrics(String... values)
static String	aggsMetrics(String nickName, String aggsType, String field)	度量聚合 https://blog.csdn.net/donghaixiaolongwang/article/details/58597058 _search?
static String	asc(String field)
static String	bool(String must)
static String	bool(String must, String mustNot, String should)
static String	bool(String must, String mustNot, String should, int minimum_should_match)
static String	bool(String must, String mustNot, String should, Integer minimum_should_match, String filter)
static String	bool(String must, String mustNot, String should, String filter)
static String	boolFilter(String filter)
static String	desc(String field)
static String	exists(String type)
static String	filter(String operator, String dsl)	and or not
static String	hasChild(String type, String dsl, boolean showChild)
static String	hasChild(String type, String dsl, String dsl2, boolean showChild)
static String	hasParent(String type, String dsl)
static String	highlight(String field, String value)
static String	inner_hits(String name, String sort, int from, int size)
static String	match(String field, Object... list)
static String	match(String field, String value)
static String	match(String field, String query, String operator, int minnum)	match
static String	match(HashMap<String,Object> map)
static String	matchAll()
static String	mergeDsl(String... dsls)
static String	missing(String type)
static String	muilMatch(String ctx, String... fields)
static String	muilMatchAll(String ctx)
static String	muilMatchFuzzy(String ctx, String... fields)
static String	must(String dsl)
StringBuilder	mustNot(HashMap<String,Object> map)
static String	nestedFilter(String path, String dsl)
static String	nestedQuery(String path, String dsl)
static String	nestedQuery(String path, String dsl, boolean showNested)
static String	nestedQuery(String type, String dsl, String dsl2, boolean showChild)
static String	packageScript(String script)
static String	queryString(String query, String... fields)
static String	queryStringOpr(String query, String operator, String... fields)	https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-simple-query-string-query.html
static String	queryStringOr(String query, String... fields)
static String	range(String type, Object minValue, Object maxValue, String gte, String lte)
static String	rangeGtAndLt(String type, Object minValue, Object maxValue)
static String	rangeGte(String type, Object minValue)
static String	rangeGteAndLte(String type, Object minValue, Object maxValue)
static String	rangeLte(String type, Object maxValue)
static String	rangeMarkValue(HashMap<String,HashMap<String,Object>> markMap)
static String	reduceChar(String sub)
static String	regexp(String field, String regexp)
static String	replaceChar(String sub)
static String	scriptFields(String... values)
static String	scriptMetrics(String nickName, String init, String map, String combine, String reduce)	自定义聚合 https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics-scripted-metric-aggregation.html
static String	scriptQuery(String source)
static String	scriptQuery(String source, String paramJson)
static String	scriptQueryByScriptId(String id, String paramJson)
static String	scriptQueryByTime(String startTime, String endTime)
static String	scriptQueryByTime2(String startTime, String endTime)
static String	search(String dsl)
static String	search(String dsl, int from, int size)
static String	search(String dsl, int from, int size, String source)
static String	search(String dsl, String source, int from, int size)
static String	search(String dsl, String scriptfield, String source, String sort, int from, int size)
static String	search(String dsl, String scriptfield, String aggs, String source, String sort, String hightlight, Integer from, Integer size, boolean profile)
static String	search(String dsl, String scriptfield, String aggs, String collapse, String source, String sort, String hightlight, Integer from, Integer size, boolean profile)
static String	searchAddScriptField(String dsl, String scriptField, int from, int size)
static String	searchAddScriptField(String dsl, String sort, String scriptField, int from, int size)
static String	searchAggs(String dsl, String aggs, int from, int size)
static String	searchCollapse(String dsl, String collapse, int from, int size)
static String	searchPostFilter(String dsl, String postFilter, String aggs, int from, int size, String source)	https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-post-filter.html
static String	searchSort(String dsl, String sort, int from, int size)
static String	should(HashMap<String,Object> map)
static String	sort(String field, String sortType)
static String	source(String... fields)	Elasticsearch Fields _source 返回值字段设置
static String	term(String type, Object value)
static String	term(String field, String... values)
static String	term(HashMap<String,Object> map)
static String	termCoverPlate(String type, String value)
static String	wildCardQuery(String field, String value)
static String	wipeBracket(String json)	去除中括号,或者括号

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

字段详细资料

ASC

public static final String ASC

另请参阅:

• 常量字段值

DESC

public static final String DESC

另请参阅:

• 常量字段值

_SOURCE

public static final String _SOURCE

另请参阅:

• 常量字段值

_SOURCEAGGS

public static final String _SOURCEAGGS

另请参阅:

• 常量字段值

_SOURCEAGGS_COLLAPSEC

public static final String _SOURCEAGGS_COLLAPSEC

另请参阅:

• 常量字段值

构造器详细资料

DslQueryUtils

public DslQueryUtils()

方法详细资料

search

public static String search(String dsl,
 String scriptfield,
 String aggs,
 String source,
 String sort,
 String hightlight,
 Integer from,
 Integer size,
 boolean profile)

search

public static String search(String dsl,
 String scriptfield,
 String aggs,
 String collapse,
 String source,
 String sort,
 String hightlight,
 Integer from,
 Integer size,
 boolean profile)

search

public static String search(String dsl)

search

public static String search(String dsl,
 int from,
 int size)

searchSort

public static String searchSort(String dsl,
 String sort,
 int from,
 int size)

search

public static String search(String dsl,
 int from,
 int size,
 String source)

searchAddScriptField

public static String searchAddScriptField(String dsl,
 String scriptField,
 int from,
 int size)

searchAddScriptField

public static String searchAddScriptField(String dsl,
 String sort,
 String scriptField,
 int from,
 int size)

searchAggs

public static String searchAggs(String dsl,
 String aggs,
 int from,
 int size)

searchCollapse

public static String searchCollapse(String dsl,
 String collapse,
 int from,
 int size)

searchPostFilter

public static String searchPostFilter(String dsl,
 String postFilter,
 String aggs,
 int from,
 int size,
 String source)

https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-post-filter.html

参数:

dsl - String

postFilter - String

aggs - String

from - int

size - int

source - String

返回:

String

search

public static String search(String dsl,
 String source,
 int from,
 int size)

search

public static String search(String dsl,
 String scriptfield,
 String source,
 String sort,
 int from,
 int size)

queryStringOpr

public static String queryStringOpr(String query,
 String operator,
 String... fields)

https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-simple-query-string-query.html

参数:

query - 正则通配符 widldcards

operator - String

fields - String[]

返回:

String

queryString

public static String queryString(String query,
 String... fields)

queryStringOr

public static String queryStringOr(String query,
 String... fields)

scriptFields

public static String scriptFields(String... values)

bool

public static String bool(String must)

bool

public static String bool(String must,
 String mustNot,
 String should)

bool

public static String bool(String must,
 String mustNot,
 String should,
 int minimum_should_match)

bool

public static String bool(String must,
 String mustNot,
 String should,
 String filter)

bool

public static String bool(String must,
 String mustNot,
 String should,
 Integer minimum_should_match,
 String filter)

boolFilter

public static String boolFilter(String filter)

filter

public static String filter(String operator,
 String dsl)

and or not

参数:

operator - String

dsl - String

返回:

String

mergeDsl

public static String mergeDsl(String... dsls)

match

public static String match(String field,
 String value)

match

public static String match(String field,
 String query,
 String operator,
 int minnum)

match

参数:

field - String

query - String

operator - String

minnum - int

返回:

String

match

public static String match(HashMap<String,Object> map)

match

public static String match(String field,
 Object... list)

term

public static String term(String type,
 Object value)

termCoverPlate

public static String termCoverPlate(String type,
 String value)

term

public static String term(HashMap<String,Object> map)

term

public static String term(String field,
 String... values)

muilMatch

public static String muilMatch(String ctx,
 String... fields)

muilMatchFuzzy

public static String muilMatchFuzzy(String ctx,
 String... fields)

wildCardQuery

public static String wildCardQuery(String field,
 String value)

regexp

public static String regexp(String field,
 String regexp)

highlight

public static String highlight(String field,
 String value)

muilMatchAll

public static String muilMatchAll(String ctx)

matchAll

public static String matchAll()

must

public static String must(String dsl)

mustNot

public StringBuilder mustNot(HashMap<String,Object> map)

should

public static String should(HashMap<String,Object> map)

rangeMarkValue

public static String rangeMarkValue(HashMap<String,HashMap<String,Object>> markMap)

range

public static String range(String type,
 Object minValue,
 Object maxValue,
 String gte,
 String lte)

rangeGtAndLt

public static String rangeGtAndLt(String type,
 Object minValue,
 Object maxValue)

rangeGteAndLte

public static String rangeGteAndLte(String type,
 Object minValue,
 Object maxValue)

rangeGte

public static String rangeGte(String type,
 Object minValue)

rangeLte

public static String rangeLte(String type,
 Object maxValue)

scriptQuery

public static String scriptQuery(String source)

scriptQueryByTime

public static String scriptQueryByTime(String startTime,
 String endTime)

scriptQueryByTime2

public static String scriptQueryByTime2(String startTime,
 String endTime)

scriptQuery

public static String scriptQuery(String source,
 String paramJson)

scriptQueryByScriptId

public static String scriptQueryByScriptId(String id,
 String paramJson)

missing

public static String missing(String type)

exists

public static String exists(String type)

packageScript

public static String packageScript(String script)

sort

public static String sort(String field,
 String sortType)

asc

public static String asc(String field)

desc

public static String desc(String field)

hasParent

public static String hasParent(String type,
 String dsl)

hasChild

public static String hasChild(String type,
 String dsl,
 String dsl2,
 boolean showChild)

hasChild

public static String hasChild(String type,
 String dsl,
 boolean showChild)

nestedQuery

public static String nestedQuery(String path,
 String dsl,
 boolean showNested)

nestedQuery

public static String nestedQuery(String path,
 String dsl)

nestedFilter

public static String nestedFilter(String path,
 String dsl)

nestedQuery

public static String nestedQuery(String type,
 String dsl,
 String dsl2,
 boolean showChild)

source

public static String source(String... fields)

Elasticsearch Fields _source 返回值字段设置

参数:

fields - String[]

返回:

String

aggsMetrics

public static String aggsMetrics(String nickName,
 String aggsType,
 String field)

度量聚合 https://blog.csdn.net/donghaixiaolongwang/article/details/58597058 _search?search_type=count 参数：search_type=count 表示只返回aggregation部分的结果。 avg max min sum cardinality(distinct) stats 最大、最小、和、平均值。一起求出来 extended_stats 其他属性，包括最大最小，方差等等。 geo_bounds （attr "wrap_longitude" : true ） 计算出所有的地理坐标将会落在一个矩形区域 geo_centroid 计算出所有文档的大概的中心点 percentiles 百分比统计。可 percentile_ranks top_hits 当于sql 中 group by 后取出前n条。 value_count 数量统计，看看这个字段一共有多少个不一样的数值。

参数:

nickName - String

aggsType - String

field - String

返回:

String

inner_hits

public static String inner_hits(String name,
 String sort,
 int from,
 int size)

scriptMetrics

public static String scriptMetrics(String nickName,
 String init,
 String map,
 String combine,
 String reduce)

自定义聚合 https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics-scripted-metric-aggregation.html

参数:

nickName - String

init - String

map - String

combine - String

reduce - String

返回:

String

aggsMetrics

public static String aggsMetrics(String... values)

aggsBucket

public static String aggsBucket()

https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket.html

返回:

adjacency_matrix 邻接矩阵,同事满足两个条件的数量 Children Aggregation 父子关系 聚合 Composite Aggregation sub Aggregation Nested Aggregation

aggsLine

public static String aggsLine()

wipeBracket

public static String wipeBracket(String json)

去除中括号,或者括号

参数:

json - String

返回:

String

reduceChar

public static String reduceChar(String sub)

replaceChar

public static String replaceChar(String sub)