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

21 votes127 views3 answers
How to copy all requirements to requirements.txt
Python
47 votes178 views6 answers
Python get files in directory
Python
13 votes134 views2 answers
Python remove directory not empty
Python
0 vote168 views1 answer
How to import flask restful using pip
Python Flask
2 votes130 views1 answer
Pandas get value not equal to
Python
0 vote138 views1 answer
Invalid Python Environment: Python is unable to find Maya's Python modules
Python
0 vote143 views1 answer
Ia
Python
1 vote103 views1 answer
Python remove read only file
Python
3 votes128 views1 answer
Simple colours python
Python
0 vote137 views1 answer
How to implement nfa in python
Python