一些ES查询-DSL语法
wildcard模糊查询
# 真实车道进行模糊查询
crossroadName = "*" + roadName + "*"
# --1.通过道路名称查询cameraIdList
query1 = {"query": {"wildcard": {"crossroadName": crossroadName}}}
bool 布尔 + must 实现多字段联合查询
query2 = {
"query": {
"bool": {
"must": [
{"match": {"cameraId": i}},
{"match": {"cameraDirection": cameraDirection}}
]
}
}
}
range 实现范围查询
gte : 大于等于
lte : 小于等于
gt : 大于
lt : 小于
query2 = {
"query": {
"bool": {
"must": [
{"match": {"deviceIp": deviceIp}},
{"match": {"lane": lane}},
{"match": {"tailOrHead": 1}},
{"range": {
"passTime": {
"gte": startTime,
"lte": endTime,
}
}
}
]
}
}
}