Defining view function for displaying postgres data in django

Question

I created the wines database in postgresql (containing ID, names etc), and inserted around 300 observations. I would like to display names of every wine in drop menu with django. The urls.py are properly setted up. What have I done so far:

models.py

from django.db import connection
from django.db import models

class ListWines(models.Model):
    name = models.CharField(max_length=200)

views.py

from django.shortcuts import render
from wineapp.models import ListWines

def showallwines(request):
    wines = ListWines.objects
    return render(request, 'main.html', { 'name':wines } )

main.html

<!DOCTYPE html>
<head>
    <body>
        <select>
            <option disabled = "True" selected>Select your favourite wine!</option>
            {% for wines in showallwines %}
            <option>{{wines.name}}</option>
            {% endfor %}
        </select>
    </body>
</head>

The postgres database (column containing data that I want to display is name) is connected with app by setings.py, however it doesn't show names.

How should I redefine my functions in order to see display in main.html drop menu?

Sumithran · Accepted Answer · 2021-12-17 18:15:30Z

1

To get the list of all objects, you must use Model.objects.all()

So make these changes in your view

def showallwines(request):
    wines = ListWines.objects.all() # changed
    # changed context name to wines since it is list of wines not names.
    return render(request, 'main.html', { 'wines': wines } )

main.html

You have to use the context name wines since we are passing the context wines from the view

{% for wine in wines %}
    <option>{{ wine.name }}</option>
{% endfor %}

answered Dec 17, 2021 at 18:15

Sumithran

6,6157 gold badges46 silver badges60 bronze badges

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

Comments

Shaid Hasan Shawon · Accepted Answer · 2021-12-17 18:18:24Z

1

views.py

Insted of ListWines.objects use ListWines.objects.all() and update context name with "showallwines" this.

def showallwines(request):
    wines = ListWines.objects.all()
    return render(request, 'main.html', { 'showallwines':wines } )

answered Dec 17, 2021 at 18:18

Shaid Hasan Shawon

1511 silver badge7 bronze badges

Collectives™ on Stack Overflow

Defining view function for displaying postgres data in django

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related