Join tables in django orm

Django model query join

Blog.objects.filter(entry__headline__contains='Lennon').filter(entry__pub_date__year=2008)

Source: docs.djangoproject.com

Join tables in django orm

{% for x in data %}
   {{ x.location_id.name }}
{% endfor %}

Source: stackoverflow.com

Join tables in django orm

class EventsMeetinglocation(models.Model):
    id = models.IntegerField(primary_key=True)
    name = models.CharField(max_length=100)
    address = models.CharField(max_length=200)

    class Meta:
        managed = True
        db_table = 'events_meetinglocation'

class EventsBoardmeeting(models.Model):
    id = models.IntegerField(primary_key=True)
    date = models.DateTimeField()
    agenda_id = models.IntegerField(blank=True, null=True)
    location_id = models.ForeignKey(EventsMeetinglocation)
    minutes_id = models.IntegerField(blank=True, null=True)

    class Meta:
       managed = True
       db_table = 'events_boardmeeting'

Source: stackoverflow.com

Join tables in django orm

def meetings(request):
    meetingData = EventsBoardmeeting.objects.all()
    return render(request, 'board/meetings.html', {'data': meetingData })

Source: stackoverflow.com

Similar codes

5 votes247 views1 answer
Tkinter maximum window size
Python
18 votes255 views1 answer
Convert column in pandas to datetime
Python
24 votes237 views1 answer
How to randomly choose from a list python
Python
1 vote240 views1 answer
Django group by date from datetime field
Python
8 votes232 views2 answers
Django create empty migration
Python
16 votes220 views1 answer
Save model keras
Python
0 vote236 views1 answer
Error: The file/path provided (flaskr) does not appear to exist. Please verify the path is correct. If app is not on PYTHONPATH, ensure the extension is .py
Python
19 votes217 views2 answers
Renaming headers pandasd
Python
8 votes222 views3 answers
Python multiply list
Python
0 vote223 views1 answer
Install python packages behind proxy
Python