Django for loop from one DB table

Question

I'm working on a livescore app and can't get matches within leagues in the table, nested for loop is empty.

I only get listed leagues and I would like to have inside the leagues all the matches that belong to those leagues

-Leaugue

match
match

-League

match
match

My DB

Models:

class basic_scores(models.Model):
   time_status = models.CharField(max_length=5)
   time_minute = models.CharField(max_length=5)
   localteam_data_name = models.CharField(max_length=255)
   visitorteam_data_name = models.CharField(max_length=255)
   scores_localteam_score = models.CharField(max_length=15)
   scores_visitorteam_score = models.CharField(max_length=15)
   country_name = models.CharField(null=True, max_length=255)
   league_name = models.CharField(null=True, max_length=255

View:

def league(request):
#live_list = football_nows.objects.all()
live_list = basic_scores.objects.all()
return render(request, 'league.html',
              {'live_list': live_list})

league.html:

    <h1>Live</h1>
{% for league in live_list %}
        <center>
        <td>{{ league.league_name }}</td> 
    {% for live in league %}
         <td>{{ live.time_minute }}</td>  
            <td>{{  live.localteam_data_name  }}</td>
            <td>{{  live.scores_localteam_score  }} : {{  live.scores_visitorteam_score  }}</td>
            <td>{{  live.visitorteam_data_name  }}</td>
        
    {% endfor %}
</center>
       {#  This is a comment. #}
{% endfor %}

Browser result:

Please edit and add the model you have for match to the question. — Abdul Aziz Barkat
– Abdul Aziz Barkat, Commented May 15, 2021 at 8:04

Ajay Rathore · Accepted Answer · 2021-05-15 09:27:29Z

1

@Ronnin you need to modify your view and create context correctly to achieve your result.

Lets take it step by step:

Problem in your code. `league` is not a list or iterator or any kind. It is a single record.

{% for league in live_list %}
    <center>
    <td>{{ league.league_name }}</td>
{% for live in league %} // this is wrong
     <td>{{ live.time_minute }}</td>  
        <td>{{  live.localteam_data_name  }}</td>
        <td>{{  live.scores_localteam_score  }} : {{  live.scores_visitorteam_score  }}</td>
        <td>{{  live.visitorteam_data_name  }}</td>
    
{% endfor %}

Make your view to have right context.

def league(request):
#live_list = football_nows.objects.all()
live_list_obj = basic_scores.objects.all()

live_list = {}
for live in live_list_obj:
  if not live.league_name in live_list:
    live_list[live.league_name] = [live]
  else:
    live_list[live.league_name].append(live)

return render(request, 'league.html',
              {'live_list': live_list})

Here is the html for the view

    {% for league_name, league_details in live_list.items %}
    <center>
        <td>{{ league_name }}</td>
     {% for live in league_details %}
     <td>{{ live.time_minute }}</td>  
        <td>{{  live.localteam_data_name  }}</td>
        <td>{{  live.scores_localteam_score  }} : {{  live.scores_visitorteam_score  }}</td>
        <td>{{  live.visitorteam_data_name  }}</td>

{% endfor %}

answered May 15, 2021 at 9:27

Ajay Rathore

1341 silver badge7 bronze badges

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

4 Comments

Ronnin Over a year ago

Thank you very much @ajay-rathore, it works !! One more question, is it possible to have something like this - Country-> Leugaue - match - match

Ajay Rathore Over a year ago

@Ronnin this might be a little tricky. In our view you can update live_list[live.league_name] -> live_list[(live.country_name, live.league_name,)] Then in your template you would update it like this {{ league_name|first }} -> {{ league_name|last }}

Ronnin Over a year ago

Ok everything works great! but not all league games are shown, only one game per league is shown and there are multiple matches per league in the base. Thank you again for your help @ajay-rathore

Ajay Rathore Over a year ago

I do recommend you to learn normalization on your db table. This would also make your views much easier to make too. guru99.com/database-normalization.html

Collectives™ on Stack Overflow

Django for loop from one DB table

1 Answer 1

Problem in your code. `league` is not a list or iterator or any kind. It is a single record.

Make your view to have right context.

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Problem in your code. league is not a list or iterator or any kind. It is a single record.

Make your view to have right context.

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related

Problem in your code. `league` is not a list or iterator or any kind. It is a single record.