/Python/Django/Fetching data from multiple tables using related name in django

Fetching data from multiple tables using related name in django

from App.models import Student, Subject
def myFunc():
    students = Student.objects.all()
    for student in students:
        subj = student.subject.sub

def myFunc2():
    subjects = Subject.objects.all()
    for subject in subjects:
        student_name = subject.student.nm

Source: stackoverflow.com

Fetching data from multiple tables using related name in django

Order.objects.select_related('account_customer').all() \
    .values('customer_id', 'other_field_1', ...) \
    .annotate(total_sales=Sum('total_price')) \
    .filter(created_at__year=today.year, created_at__month=today.month)

Source: stackoverflow.com

Similar codes

0 vote246 views1 answer
No default language could be detected for django app
Python Django
0 vote264 views1 answer
Django save object in view
Python Django
0 vote281 views1 answer
Backend not found Request Method: GET Request URL: http://127.0.0.1:8000/oauth/login/google-oauth2/ Raised by: social_django.views.au
Python Django
0 vote263 views1 answer
Django snippet 800
Python Django
0 vote245 views1 answer
Python django model range validation
Python Django
7 votes257 views3 answers
How to delete migrations in django
Python Django
0 vote253 views1 answer
Django update field after save
Python Django
0 vote235 views1 answer
Add header info in django response
Python Django
0 vote281 views1 answer
How to pass primary key to url django
Python Django
6 votes242 views1 answer
Django desc order
Python Django