1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
| import functools
import json
import elasticsearch
import elasticsearch.helpers
import elasticsearch_dsl
from elasticsearch_dsl import Q
from pydantic import BaseModel
class UserModel(BaseModel):
name: str
age: int
sex: str
def print_returned_value(func):
@functools.wraps(func)
def wrapper(*args, **kwargs):
rtn = func(*args, **kwargs)
print(rtn)
return rtn
return wrapper
def print_elasticsearch_exception(func):
@functools.wraps(func)
def wrapper(*args, **kwargs):
try:
rtn = func(*args, **kwargs)
except elasticsearch.ElasticsearchException as e:
print(str(e))
else:
return rtn
return wrapper
class ElasticSearchTest:
def __init__(self):
self.client = elasticsearch.Elasticsearch('http://localhost:9200')
@print_returned_value
@print_elasticsearch_exception
def create_index(self):
""" 创建索引 """
resp = self.client.indices.create('user')
return resp
@print_returned_value
@print_elasticsearch_exception
def get_index(self):
""" 查询索引 """
resp = self.client.indices.get('user')
return resp
@print_returned_value
@print_elasticsearch_exception
def delete_index(self):
""" 删除索引 """
resp = self.client.indices.delete('user')
return resp
@print_returned_value
@print_elasticsearch_exception
def create_doc(self):
""" 插入数据 """
user = UserModel(
name='zhangsan',
age=30,
sex='男',
)
resp = self.client.create(index='user', id=1001, body=user.json())
return resp
@print_returned_value
@print_elasticsearch_exception
def update_doc(self):
""" 更新数据 """
body = {
'doc': {
'sex': '女'
}
}
resp = self.client.update(index='user', id=1001, body=json.dumps(body))
return resp
@print_returned_value
@print_elasticsearch_exception
def get_doc(self):
""" 查询数据 """
resp = self.client.get(index='user', id=1001)
return resp
@print_returned_value
@print_elasticsearch_exception
def delete_doc(self):
""" 删除数据 """
resp = self.client.delete(index='user', id=1001)
return resp
@print_returned_value
@print_elasticsearch_exception
def bulk_create_doc(self):
""" 批量创建数据 """
users = [
UserModel(name='zhangsan', age=30, sex='男').dict(),
UserModel(name='lisi', age=30, sex='女').dict(),
UserModel(name='wangwu', age=40, sex='男').dict(),
UserModel(name='wangwu1', age=40, sex='女').dict(),
UserModel(name='wangwu2', age=50, sex='男').dict(),
UserModel(name='wangwu3', age=50, sex='男').dict(),
]
actions = []
for i in range(len(users)):
actions.append(
{'_op_type': 'create',
'_index': 'user',
'_id': 1001 + i,
'_source': users[i]}
)
resp = elasticsearch.helpers.bulk(self.client, actions)
return resp
@print_returned_value
@print_elasticsearch_exception
def bulk_delete_doc(self):
""" 批量删除数据 """
actions = []
for i in range(6):
actions.append(
{'_op_type': 'delete',
'_index': 'user',
'_id': 1001 + i}
)
resp = elasticsearch.helpers.bulk(self.client, actions)
return resp
@print_returned_value
@print_elasticsearch_exception
def search_all_doc(self):
""" 查询所有 """
s = elasticsearch_dsl.Search(using=self.client, index='user')
resp = s.execute()
return resp.hits
@print_returned_value
@print_elasticsearch_exception
def search_filtered_doc(self):
""" 条件查询 """
s = elasticsearch_dsl.Search(using=self.client, index='user').filter('term', age=30)
resp = s.execute()
return resp.hits
@print_returned_value
@print_elasticsearch_exception
def search_paginated_doc(self):
""" 分页查询 elasticsearch_dsl 依赖 slicing 分页 """
s = elasticsearch_dsl.Search(using=self.client, index='user')[2:4]
resp = s.execute()
return resp.hits
@print_returned_value
@print_elasticsearch_exception
def search_ordered_doc(self):
""" 排序查询 `-` 代表 DESC """
s = elasticsearch_dsl.Search(using=self.client, index='user').sort('-age')
resp = s.execute()
return resp.hits
@print_returned_value
@print_elasticsearch_exception
def search_field_doc(self):
""" 指定或排除字段查询 """
includes = []
excludes = ['age']
s = elasticsearch_dsl.Search(using=self.client, index='user') \
.source(includes=includes, excludes=excludes)
resp = s.execute()
return resp.hits
@print_elasticsearch_exception
def search_multi_filter_doc(self):
""" 组合条件 Q 组合(| & ~)会自动生成 bool : should must must_not"""
s = elasticsearch_dsl.Search(using=self.client, index='user') \
.query(Q('match', age=30) & ~Q('match', sex='男')) # ~ 表示 not
resp = s.execute()
print(resp.hits)
s = elasticsearch_dsl.Search(using=self.client, index='user') \
.query(Q('match', age=30) | Q('match', age=40))
resp = s.execute()
print(resp.hits)
@print_elasticsearch_exception
def search_range_doc(self):
""" 范围查询 """
s = elasticsearch_dsl.Search(using=self.client, index='user') \
.filter('range', age={'gte': 30, 'lt': 50})
resp = s.execute()
print(resp.hits)
@print_elasticsearch_exception
def search_fuzzy_queried_doc(self):
""" 模糊查询 """
s = elasticsearch_dsl.Search(using=self.client, index='user') \
.query(Q({'fuzzy': {"name": {"value": "wangwu", "fuzziness": 1}}}))
resp = s.execute()
print(resp.hits)
@print_elasticsearch_exception
def search_highlight_doc(self):
""" 高亮查询 """
s = elasticsearch_dsl.Search(using=self.client, index='user') \
.query('match', name='zhangsan') \
.highlight('name', pre_tags='<font color="red">', post_tags='</font>')
resp = s.execute()
print(resp.hits)
print(resp.hits[0].meta.highlight)
@print_elasticsearch_exception
def search_agg_doc(self):
""" 聚合查询 """
s = elasticsearch_dsl.Search(using=self.client, index='user')
s.aggs.metric('max_age', 'max', field='age')
resp = s.execute()
print(resp.aggs)
# 分组
s = elasticsearch_dsl.Search(using=self.client, index='user')
s.aggs.bucket('age_group', 'terms', field='age')
resp = s.execute()
print(resp.aggs.age_group.buckets)
|
