假设 page_index=1,page_size=10；所有分页查询不可以再跟first(),all()等
1.用offset()设置索引偏移量,limit()限制取出
1#filter语句后面可以跟order_by语句 2db.session.query(User.name).filter(User.email.like('%'+email+'%')). 3limit(page_size).offset((page_index-1)*page_size) 4 5
2.用slice(偏移量，取出量)函数
1#filter语句后面可以跟order_by语句 2db.session.query(User.name).filter(User.email.like('%'+email+'%')).slice((page_index - 1) * 3page_size, page_index * page_size)
注释：此方法和第一种相同的效果。
因为：由一下内部方法可知，slice()函数第一个属性就是offset()函数值，第二个属性就是limit()函数值
1@_generative(_no_statement_condition) 2 def slice(self, start, stop): 3 """apply LIMIT/OFFSET to the ``Query`` based on a " 4 "range and return the newly resulting ``Query``.""" 5 6 if start is not None and stop is not None: 7 self._offset = (self._offset or 0) + start 8 self._limit = stop - start 9 elif start is None and stop is not None: 10 self._limit = stop 11 elif start is not None and stop is None: 12 self._offset = (self._offset or 0) + start 13 14 if self._offset == 0: 15 self._offset = None 16 17 @_generative(_no_statement_condition) 18 def limit(self, limit): 19 """Apply a ``LIMIT`` to the query and return the newly resulting 20 21 ``Query``. 22 23 """ 24 self._limit = limit 25 26 @_generative(_no_statement_condition) 27 def offset(self, offset): 28 """Apply an ``OFFSET`` to the query and return the newly resulting 29 ``Query``. 30 31 """ 32 self._offset = offset
3.用paginate(偏移量，取出量)函数,用于BaseQuery
1user_obj=User.query.filter(User.email.like('%'+email+'%')).paginate(int(page_index), 2int(page_size),False) 3#遍历时要加上items 4object_list =user_obj.items
4.filter中使用limit
1#此处不能再跟order_by语句，否则报错 2db.session.query(User.name).filter(User.email.like('%'+email+'%') and limit (page_index - 1) * 3page_size, page_size)