python - Django find_each(如 RoR)

Question

有没有办法在django中使用find_each？

根据 rails 文档:

This method is only intended to use for batch processing of large amounts of records that wouldn’t fit in memory all at once. If you just need to loop over less than 1000 records, it’s probably better just to use the regular find methods.

http://apidock.com/rails/ActiveRecord/Batches/ClassMethods/find_each

谢谢。

Answer 1

一个可能的解决方案是使用内置的 Paginator 类(可以省去很多麻烦)。

https://docs.djangoproject.com/en/dev/topics/pagination/

尝试这样的事情:

from django.core.paginator import Paginator
from yourapp.models import YourModel

result_query = YourModel.objects.filter(<your find conditions>)

paginator = Paginator(result_query, 1000) # the desired batch size

for page in range(1, paginator.num_pages + 1):
   for row in paginator.page(page).object_list:
       # here you can add your required code

或者，您可以使用 limiting options根据需要迭代结果。