Recover database data on Django

Question

My project is a simple table showing countries, number of covid cases, deaths and recoveries. By Django admin I have already registered two countries and now I want to recover this data and show on the route, but is not showing.

Link to the complete project: https://github.com/PUC-DISCIPLINAS/monitorcoviddjango-monitor-django-guilherme-pedro This is my html file: https://github.com/CunhaGuilhermeBR/html/blob/main/index.html

My model, I’m calling data:

# Create your models here.
class Dados(models.Model):
 casos_confirmados =  models.IntegerField()
 mortes = models.IntegerField()
 recuperados = models.IntegerField()
 pais = models.CharField(max_length=100)

 def __int__(self):
     return(self.id)


 class Meta:
     db_table = 'dados'

And this is my view

@login_required(login_url='/login/')
def list_data(request):
    dados = Dados.objects.all()
    print(dados.query)
    for d in dados:
      print(d)
    return render(request, 'index.html',{dados: dados})

What it prints is: Data Object (1) Data Object (2) Remembering that I have two registered countries. I wanted to find out what I am doing wrong.

Answer 1

To retrieve database values for an html or directly in the console in views

from .models import Dados
#Do model dados
dados = Dados.objects.all()# retorna todos os valores, mesmo são do tipo queryset
for i in list(dados): # para a forma de list e não queryset
   print(i) # valores

The function str(self), within the scope of the model class returns readable values, which can be specified

def __str__(self):
        return f'{self.pais} {self.casos_confirmados} {self.mortes} {self.recuperados}' 

The presentation in an html needs a context, a dictionary;

def list_data(request):
     conteuto = {"casos": Dados.objects.all()}
    return render(request, 'index.html',conteuto)

html:

 {% for caso in casos %}
  informações: {{caso}}
{% endfor %}

That code solves the question

Answer 2

Use:

dados = Dados.objects.all().values_list
for d in dados:
   print(d)

Another option is to use the values():

dados = Dados.objects.all().values()

See the possibility to use __str__()
Example of documentation:

from django.db import models

class Person(models.Model):
    first_name = models.CharField(max_length=50)
    last_name = models.CharField(max_length=50)

    def __str__(self):
        return '%s %s' % (self.first_name, self.last_name)