CODEWITHSUNDEEP
pythonhtmlmysqldjango
Omega
Omega

Reputation: 267

django error using pagination

I m trying to use pagination, but it gives me this error:

Traceback (most recent call last):
  File "/home/omega/venv/local/lib/python2.7/site-packages/django/core/handlers/exception.py", line 41, in inner
    response = get_response(request)
  File "/home/omega/venv/local/lib/python2.7/site-packages/django/core/handlers/base.py", line 187, in _get_response
    response = self.process_exception_by_middleware(e, request)
  File "/home/omega/venv/local/lib/python2.7/site-packages/django/core/handlers/base.py", line 185, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "/srv/tester/tables/views.py", line 44, in addview
    details = paginator.page(1)
  File "/home/omega/venv/local/lib/python2.7/site-packages/django/core/paginator.py", line 57, in page
    number = self.validate_number(number)
  File "/home/omega/venv/local/lib/python2.7/site-packages/django/core/paginator.py", line 46, in validate_number
    if number > self.num_pages:
  File "/home/omega/venv/local/lib/python2.7/site-packages/django/utils/functional.py", line 35, in __get__
    res = instance.__dict__[self.name] = self.func(instance)
  File "/home/omega/venv/local/lib/python2.7/site-packages/django/core/paginator.py", line 91, in num_pages
    if self.count == 0 and not self.allow_empty_first_page:
  File "/home/omega/venv/local/lib/python2.7/site-packages/django/utils/functional.py", line 35, in __get__
    res = instance.__dict__[self.name] = self.func(instance)
  File "/home/omega/venv/local/lib/python2.7/site-packages/django/core/paginator.py", line 84, in count
    return len(self.object_list)
TypeError: object of type 'RawQuerySet' has no len()

This is the part i m using for the tables paginations. models.py

def addview(request, table_id):
    table_name = Crawledtables.objects.get(id=table_id)

    tbl_details = "SELECT * FROM " + table_name.name
    tbl_detail = AllTables.objects.raw(tbl_details)

    paginator = Paginator(tbl_detail, 25)
    page = request.GET.get('page')

    try:
        details = paginator.page(page)
    except PageNotAnInteger:
        details = paginator.page(1)
    except EmptyPage:
        details = paginator.page(paginator.num_pages)

    crawled_tables = AllTablesFilter(request.GET, queryset=tbl_detail)
    return render(request, 'tables/table_list.html', {'tbl_name': table_name,
                                                      'details': tbl_detail,
                                                      'filter': crawled_tables,
                                                      'detail_page': details})

End this is the part of html where i have my pagination code. tables_list.html

{% if detail_page.has_other_pages %}
  <ul class="pagination">
    {% if detail_page.has_previous %}
      <li><a href="?page={{ detail_page.previous_page_number }}">&laquo;</a></li>
    {% else %}
      <li class="disabled"><span>&laquo;</span></li>
    {% endif %}
    {% for i in detail_page.paginator.page_range %}
      {% if detail_page.number == i %}
        <li class="active"><span>{{ i }} <span class="sr-only">(current)</span></span></li>
      {% else %}
        <li><a href="?page={{ i }}">{{ i }}</a></li>
      {% endif %}
    {% endfor %}
    {% if detail_page.has_next %}
      <li><a href="?page={{ detail_page.next_page_number }}">&raquo;</a></li>
    {% else %}
      <li class="disabled"><span>&raquo;</span></li>
    {% endif %}
  </ul>
{% endif %}

is it because i m using objects.raw()?

Thank you in advance for help

Upvotes: 0

Views: 786

Answers (1)

Exprator
Exprator

Reputation: 27533

change this line 

paginator = Paginator(tbl_detail, 25)

to 

paginator = Paginator((list(tbl_detail)), 25)

Upvotes: 1

Related Questions