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?
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 %}