Python django custom query result in html

Question

Just started to learn python django framework ,i am trying to display a custom query result in html page.

def index(request):
    with connection.cursor() as cursor:
        cursor.execute("SELECT * FROM polls_post")
context ={
        'all_posts':cursor.fetchall()
    }

In my html page

<ul>
        {%  for post in all_posts %}
            <li>{{ post }}</li>
        {% endfor %}
    </ul>

But it displays the value as tuples ,so how can i get query result with table column name such as i can print the values like this way

<ul>
            {%  for post in all_posts %}
                <li>{{ post.title }}</li>
                <li>{{ post.name }}</li>
            {% endfor %}
        </ul>

If you just started to learn Django, what made you think the best way was to run a raw SQL query rather than use the well-documented model layer? — Daniel Roseman
– Daniel Roseman, Commented Nov 15, 2016 at 9:33

m.antkowicz · Accepted Answer · 2016-11-15 09:32:00Z

3

You cannot - using cursor you need to repack data by yourself inside view and then pass the list of objects to the template.

Something like

posts = []

with connection.cursor() as cursor:
    cursor.execute("SELECT * FROM polls_post")

    for obj in cursor.fetchall():
        posts.append({"title": obj[0], "name": obj[1]})
context = {'all_posts':cursor.fetchall()}

However I suppose that you rather want to use Django's ORM framework. Take a look at the Model reference then.

answered Nov 15, 2016 at 9:32

m.antkowicz

13.7k22 silver badges43 bronze badges

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

2 Comments

Blessan Kurien Over a year ago

Is any shorthandway to do this?? without manually using the column name

maxwell Over a year ago

@BlessanKurien, check documentation reference – docs.djangoproject.com/el/1.10/topics/db/sql There is example with use of cursor.description

NIKHIL RANE · Accepted Answer · 2016-11-15 09:34:59Z

1

Why are you use sql query in your view. Try to use Django ORM and QuerySets.

May be this is helps you

Django View

def your_view(request):
    all_posts = your_model_class_name.objects.all()
    return render_to_response("your_html.html", {'all_posts': all_posts})

And in you html page

<ul>
    {%  for post in all_posts %}
        <li>{{ post.title }}</li>
        <li>{{ post.name }}</li>
    {% endfor %}
</ul>

edited Nov 15, 2016 at 9:34

answered Nov 15, 2016 at 9:31

NIKHIL RANE

4,1222 gold badges26 silver badges49 bronze badges

3 Comments

Blessan Kurien Over a year ago

I will get unresolved reference error in polls_post

NIKHIL RANE Over a year ago

Pole post is your class name please replace it.

Blessan Kurien Over a year ago

So i need to use ORM layer but i don't need it

Afsal Salim · Accepted Answer · 2016-11-15 09:57:12Z

1

You can also do like this

def your_view(request):
    all_posts = model_class_name.objects.raw("Select * from tablename");
    return render_to_response("your_html.html", {'all_posts': all_posts})

and in template

<ul>
    {%  for post in all_posts %}
        <li>{{ post.title }}</li>
        <li>{{ post.name }}</li>
    {% endfor %}
</ul>

raw query are helpful when we use complex queries

answered Nov 15, 2016 at 9:57

Afsal Salim

4863 silver badges14 bronze badges

Collectives™ on Stack Overflow

Python django custom query result in html

3 Answers 3

2 Comments

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related