线for doc in collection.find({'is_timeline_valid': True}):给出消息长度错误。如何获取所有集合而不出现错误？我知道关于find().limit()但我不知道如何使用它。
Code:
from openpyxl import load_workbook
import pymongo
import os
wb = load_workbook('concilia.xlsx')
ws = wb.active
client = pymongo.MongoClient('...')
db = client['...']
collection = db['...']
r = 2
for doc in collection.find({'is_timeline_valid': True}):
for dic in doc['timeline']['datas']:
if 'concilia' in dic['tramite'].lower():
ws.cell(row = r, column = 1).value = doc['id_process_unformatted']
ws.cell(row = r, column = 2).value = dic['data']
ws.cell(row = r, column = 3).value = dic['tramite']
wb.save('concilia.xlsx')
print('*****************************')
print(dic['tramite'])
# print('check!')
r += 1
这是一个简单的分页器，它将查询执行拆分为分页查询。
from itertools import count
class PaginatedCursor(object):
def __init__(self, cur, limit=100):
self.cur = cur
self.limit = limit
self.count = cur.count()
def __iter__(self):
skipper = count(start=0, step=self.limit)
for skip in skipper:
if skip >= self.count:
break
for document in self.cur.skip(skip).limit(self.limit):
yield document
self.cur.rewind()
...
cur = collection.find({'is_timeline_valid': True})
...
for doc in PaginatedCursor(cur, limit=100):
...
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系:hwhale#tublm.com(使用前将#替换为@)
