/Python/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

12 votes56 views3 answers
How to delete last N columns of dataframe
Python
0 vote57 views1 answer
Im save to a bytes io python
Python
-1 vote58 views1 answer
Templates python
Python
0 vote66 views1 answer
Generate random list and find max in list python
Python
18 votes57 views3 answers
How to python
Python
2 votes80 views1 answer
Import validation error in django
Python Django
0 vote66 views1 answer
Why wont my python input accept string inputs
Python
0 vote60 views1 answer
Python - join two columns and transform it as index
Python
0 vote57 views1 answer
How to search a file in windows 10 using python
Python
2 votes56 views2 answers
Pyqt5 qtwebenginewidgets not found
Python