How to render table from custom sql with django-tables2?

Question

I'm working with Django and django-tables2 to make a nice representation of sql queries in a web-interface. I have a legacy sql code which is very-very complicated to define it throught standard models.py.

The question is: how can i render a table from custom sql query using django-tables2?

Alasdair · Accepted Answer · 2012-12-17 14:02:52Z

3

The docs on populating a table with data show how you can create a table with a list of dictionaries as the input data.

import django_tables2 as tables

data = [
    {"name": "Bradley"},
    {"name": "Stevie"},
]

class NameTable(tables.Table):
    name = tables.Column()

table = NameTable(data)

Assuming your custom sql query returns data in a similar format, you should be able to use the same approach.

answered Dec 17, 2012 at 14:02

Alasdair

310k59 gold badges605 silver badges534 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

alexeyhaidamaka · Accepted Answer · 2012-12-25 23:07:17Z

0

Well, i didn't get the conception of djt2 right. So i should've rendered it using the conditional operator. And now it works perfectly with django's Manager.raw() and returns nice tables.

{% load render_table from django_tables2%}
 <link rel="stylesheet" href="{{ STATIC_URL }}django_tables2/themes/paleblue/css/screen.css" />

            {% if result%}
        {%render_table result%}
            {%endif%}

`

answered Dec 25, 2012 at 23:07

alexeyhaidamaka

1781 silver badge9 bronze badges

Collectives™ on Stack Overflow

How to render table from custom sql with django-tables2?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related