當前位置:成語大全網 - 新華字典 - 如何有效的遍歷django的QuerySet

如何有效的遍歷django的QuerySet

參考代碼:

def get_employees(position, start, end):

return employee.objects.filter(alert_time__lt=end,alert_time__gt=start).filter(position__in=position)

@login_required

def show(request):

if not validate(request):

return render_to_response('none.html',

context_instance=RequestContext(request, 'msg':'params error')

)

position = request.REQUEST.get('position')

time_range = request.REQUEST.get('time')

start, end = time_range[0], time_range[1]

num_per_page, page_num = get_num(request)

all_employees = get_employees(position, start, end)

# 根據當前頁與每頁展示的記錄數,取到正確的記錄

employees = employees_events[(page_num-1)*num_per_page:page_num*num_per_page]

return render_to_response('show_employees.html',

context_instance=RequestContext(

request,

'employees': employees,

'num_per_page': num_per_page,

'page_num':page_num,

'page_options' : [50, 100, 200]

)

)