解决python 中的警告提示: site.py:12: UnorderedObjectListWarning: Pagination may yield inconsistent results with an unordered object_list:

分类:Python |

site.py:12: UnorderedObjectListWarning: Pagination may yield inconsistent results with an unordered object_list: <class 'blog.models.BlogItems'> QuerySet.


解决方法: 

1. model 里添加: 

使用 BlogItems.objects.all() 得到数据集合时: 

class Meta:

       managed = False

       ordering = ['-item_id']

       db_table = 'blog_items'



2. 修改all() 方法为 get_queryset().order_by('item_id')

item_list = BlogItems.objects.all()

改为: 

item_list = BlogItems.objects.get_queryset().order_by('item_id')

paginator = Paginator(item_list,2);