forked from Boris-code/feapder
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathmongodb.py
More file actions
422 lines (365 loc) · 13.3 KB
/
mongodb.py
File metadata and controls
422 lines (365 loc) · 13.3 KB
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
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
# -*- coding: utf-8 -*-
"""
Created on 2021-04-18 14:12:21
---------
@summary: 操作mongo数据库
---------
@author: Mkdir700
@email: mkdir700@gmail.com
"""
import re
from typing import List, Dict, Optional
from urllib import parse
import pymongo
from pymongo import MongoClient
from pymongo.collection import Collection
from pymongo.database import Database
from pymongo.errors import DuplicateKeyError, BulkWriteError
import feapder.setting as setting
from feapder.utils.log import log
class MongoDB:
def __init__(
self,
ip=None,
port=None,
db=None,
user_name=None,
user_pass=None,
url=None,
**kwargs,
):
if url:
self.client = MongoClient(url, **kwargs)
else:
if not ip:
ip = setting.MONGO_IP
if not port:
port = setting.MONGO_PORT
if not db:
db = setting.MONGO_DB
if not user_name:
user_name = setting.MONGO_USER_NAME
if not user_pass:
user_pass = setting.MONGO_USER_PASS
self.client = MongoClient(
host=ip, port=port, username=user_name, password=user_pass
)
self.db = self.get_database(db)
# 缓存索引信息
self.__index__cached = {}
@classmethod
def from_url(cls, url, **kwargs):
"""
Args:
url: mongodb://[username:password@]host1[:port1][,host2[:port2],...[,hostN[:portN]]][/[database][?options]]
参考：http://mongodb.github.io/mongo-java-driver/3.4/javadoc/com/mongodb/MongoClientURI.html
**kwargs:
Returns:
"""
url_parsed = parse.urlparse(url)
db_type = url_parsed.scheme.strip()
if db_type != "mongodb":
raise Exception(
"url error, expect mongodb://[username:password@]host1[:port1][,host2[:port2],...[,hostN[:portN]]][/[database][?options]], but get {}".format(
url
)
)
return cls(url=url, **kwargs)
def get_database(self, database, **kwargs) -> Database:
"""
获取数据库对象
@param database: 数据库名
@return:
"""
return self.client.get_database(database, **kwargs)
def get_collection(self, coll_name, **kwargs) -> Collection:
"""
根据集合名获取集合对象
@param coll_name: 集合名
@return:
"""
return self.db.get_collection(coll_name, **kwargs)
def find(
self, coll_name: str, condition: Optional[Dict] = None, limit: int = 0, **kwargs
) -> List[Dict]:
"""
@summary:
无数据： 返回[]
有数据： [{'_id': 'xx', ...}, ...]
---------
@param coll_name: 集合名(表名)
@param condition: 查询条件
@param limit: 结果数量
@param kwargs:
更多参数 https://docs.mongodb.com/manual/reference/command/find/#command-fields
---------
@result:
"""
condition = {} if condition is None else condition
command = {"find": coll_name, "filter": condition, "limit": limit}
command.update(kwargs)
result = self.run_command(command)
cursor = result["cursor"]
cursor_id = cursor["id"]
dataset = cursor["firstBatch"]
while True:
if cursor_id == 0:
break
result = self.run_command(
{
"getMore": cursor_id,
"collection": coll_name,
"batchSize": kwargs.get("batchSize", 100),
}
)
cursor = result["cursor"]
cursor_id = cursor["id"]
dataset.extend(cursor["nextBatch"])
return dataset
def add(
self,
coll_name,
data: Dict,
replace=False,
update_columns=(),
update_columns_value=(),
insert_ignore=False,
):
"""
添加单条数据
Args:
coll_name: 集合名
data: 单条数据
replace: 唯一索引冲突时直接覆盖旧数据，默认为False
update_columns: 更新指定的列（如果数据唯一索引冲突，则更新指定字段，如 update_columns = ["name", "title"]
update_columns_value: 指定更新的字段对应的值, 不指定则用数据本身的值更新
insert_ignore: 索引冲突是否忽略 默认False
Returns: 插入成功的行数
"""
affect_count = 1
collection = self.get_collection(coll_name)
try:
collection.insert_one(data)
except DuplicateKeyError as e:
# 存在则更新
if update_columns:
if not isinstance(update_columns, (tuple, list)):
update_columns = [update_columns]
condition = self.__get_update_condition(
coll_name, data, e.details.get("errmsg")
)
# 更新指定的列
if update_columns_value:
# 使用指定的值更新
doc = {
key: value
for key, value in zip(update_columns, update_columns_value)
}
else:
# 使用数据本身的值更新
doc = {key: data[key] for key in update_columns}
collection.update_one(condition, {"$set": doc})
# 覆盖更新
elif replace:
condition = self.__get_update_condition(
coll_name, data, e.details.get("errmsg")
)
# 替换已存在的数据
collection.replace_one(condition, data)
elif not insert_ignore:
raise e
return affect_count
def add_batch(
self,
coll_name: str,
datas: List[Dict],
replace=False,
update_columns=(),
update_columns_value=(),
condition_fields: dict = None,
):
"""
批量添加数据
Args:
coll_name: 集合名
datas: 数据 [{'_id': 'xx'}, ... ]
replace: 唯一索引冲突时直接覆盖旧数据，默认为False
update_columns: 更新指定的列（如果数据的唯一索引存在，则更新指定字段，如 update_columns = ["name", "title"]
update_columns_value: 指定更新的字段对应的值, 不指定则用数据本身的值更新
condition_fields: 用于条件查找的字段，不指定则用索引冲突中的字段查找
Returns: 添加行数，不包含更新
"""
add_count = 0
if not datas:
return add_count
collection = self.get_collection(coll_name)
if not isinstance(update_columns, (tuple, list)):
update_columns = [update_columns]
try:
add_count = len(datas)
collection.insert_many(datas, ordered=False)
except BulkWriteError as e:
write_errors = e.details.get("writeErrors")
for error in write_errors:
if error.get("code") == 11000:
# 数据重复
# 获取重复的数据
data = error.get("op")
def get_condition():
# 获取更新条件
if condition_fields:
condition = {
condition_field: data[condition_field]
for condition_field in condition_fields
}
else:
# 根据重复的值获取更新条件
condition = self.__get_update_condition(
coll_name, data, error.get("errmsg")
)
return condition
if update_columns:
# 更新指定的列
if update_columns_value:
# 使用指定的值更新
doc = {
key: value
for key, value in zip(
update_columns, update_columns_value
)
}
else:
# 使用数据本身的值更新
doc = {key: data.get(key) for key in update_columns}
collection.update_one(get_condition(), {"$set": doc})
add_count -= 1
elif replace:
# 覆盖更新
collection.replace_one(get_condition(), data)
add_count -= 1
else:
# log.error(error)
add_count -= 1
return add_count
def count(self, coll_name, condition: Optional[Dict], limit=0, **kwargs):
"""
计数
@param coll_name: 集合名
@param condition: 查询条件
@param limit: 限制数量
@param kwargs:
----
command = {
count: <collection or view>,
query: <document>,
limit: <integer>,
skip: <integer>,
hint: <hint>,
readConcern: <document>,
collation: <document>,
comment: <any>
}
https://docs.mongodb.com/manual/reference/command/count/#mongodb-dbcommand-dbcmd.count
@return: 数据数量
"""
command = {"count": coll_name, "query": condition, "limit": limit, **kwargs}
result = self.run_command(command)
return result["n"]
def update(self, coll_name, data: Dict, condition: Dict, upsert: bool = False):
"""
更新
Args:
coll_name: 集合名
data: 单条数据 {"xxx":"xxx"}
condition: 更新条件 {"_id": "xxxx"}
upsert: 数据不存在则插入,默认为 False
Returns: True / False
"""
try:
collection = self.get_collection(coll_name)
collection.update_one(condition, {"$set": data}, upsert=upsert)
except Exception as e:
log.error(
"""
error:{}
condition: {}
""".format(
e, condition
)
)
return False
else:
return True
def delete(self, coll_name, condition: Dict) -> bool:
"""
删除
Args:
coll_name: 集合名
condition: 查找条件
Returns: True / False
"""
try:
collection = self.get_collection(coll_name)
collection.delete_one(condition)
except Exception as e:
log.error(
"""
error:{}
condition: {}
""".format(
e, condition
)
)
return False
else:
return True
def run_command(self, command: Dict):
"""
运行指令
参考文档 https://www.geek-book.com/src/docs/mongodb/mongodb/docs.mongodb.com/manual/reference/command/index.html
@param command:
@return:
"""
return self.db.command(command)
def create_index(self, coll_name, keys, unique=True):
collection = self.get_collection(coll_name)
_keys = [(key, pymongo.ASCENDING) for key in keys]
collection.create_index(_keys, unique=unique)
def get_index(self, coll_name):
return self.get_collection(coll_name).index_information()
def drop_collection(self, coll_name):
return self.db.drop_collection(coll_name)
def get_index_key(self, coll_name, index_name):
"""
获取参与索引的key
Args:
index_name: 索引名
Returns:
"""
cache_key = f"{coll_name}:{index_name}"
if cache_key in self.__index__cached:
return self.__index__cached.get(cache_key)
index = self.get_index(coll_name)
index_detail = index.get(index_name)
if not index_detail:
errmsg = f"not found index {index_name} in collection {coll_name}"
raise Exception(errmsg)
index_keys = [val[0] for val in index_detail.get("key")]
self.__index__cached[cache_key] = index_keys
return index_keys
def __get_update_condition(
self, coll_name: str, data: dict, duplicate_errmsg: str
) -> dict:
"""
根据索引冲突的报错信息 获取更新条件
Args:
duplicate_errmsg: E11000 duplicate key error collection: feapder.test index: a_1_b_1 dup key: { : 1, : "你好" }
data: {"a": 1, "b": "你好", "c": "嘻嘻"}
Returns: {"a": 1, "b": "你好"}
"""
index_name = re.search(r"index: (\w+)", duplicate_errmsg).group(1)
index_keys = self.get_index_key(coll_name, index_name)
condition = {key: data.get(key) for key in index_keys}
return condition
def __getattr__(self, name):
return getattr(self.db, name)