Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Error Using django-tables2 - Expected table or queryset, not 'str'

I am trying to create some tables for my application using django-tables2 and running into some difficulties. I am using Python 2.7, and Django 1.7. I am following the tutorial, and I ran into problems.

I reach the point where I need to create a Table class for customization. However, whenever I do so, I get the following error:

Expected table or queryset, not 'str'.

After doing some research it looks like I am using an older version of django-tables2. However, I just installed it yesterday using pip install django-tables2 and updated it a half an hour ago. Any idea how I can get django-tables2 to work properly?

EDIT - Problem solved. I was using {% render_table people %} instead of {% render_table table %}

like image 614
Ravi Mehta Avatar asked Apr 16 '15 18:04

Ravi Mehta


2 Answers

Well I think your problem isn't with the version of django-tables2. Here I think when you are passing a variable from view to template, you are passing a string instead of a queryset/table class object. For working example:

Table class:

class SomeTable(tables.Table):

    class Meta:
        model= SomeModel
        attrs = {"class": "paleblue"}

View Class:

class SomeTableView(SingleTableView):
    model = SomeModel
    template_name = 'test.html'
    table_class = SomeTable

Template:

 {% load render_table from django_tables2 %}
 {% render_table table %}   <!-- Here I am passing table class -->

Or you can directly send a queryset to render the table like:

class SomeView(TemplateView):
     def get(self, request, *args, **kwargs):
         data = SomeModel.objects.all()
         context = self.get_context_data(**kwargs)
         context['table'] = data
         return self.render_to_response(context)

and render it like this:

{% load render_table from django_tables2 %}
{% render_table table %} <!-- Here I am passing queryset -->
like image 142
ruddra Avatar answered Sep 30 '22 10:09

ruddra


I encountered that problem, too. The first thing you should do is to check your updates:

sudo pip install django-tables2 --upgrade
sudo pip install django-tables2-reports --upgrade

Upgrades didn't fix my problem either.
If you have already upgraded version of these. You should check your implementation. If you are using Class Based View and you probably implemented the view,template,table. You probably forget the urls:

/* I give the example with respect to other post*/
urls.py  /*Same dic with table.py,models..etc*/

from .views import SomeTableView   
urlpatterns = patterns('',
                   url(r"^$", SomeTableView.as_view(), name="index"),

                   
                   )

If it is not index of your website you have to probably change the r"^$" and name="index"

like image 24
Berke Atmaca Avatar answered Sep 30 '22 10:09

Berke Atmaca