/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

0 vote35 views1 answer
Wexpect in python
Python
1 vote34 views1 answer
Install python packages from inside within python program
Python
0 vote26 views1 answer
How to python program
Python
5 votes28 views2 answers
Random boolean python
Python
1 vote25 views1 answer
Python datetime round to nearest hour
Python
0 vote27 views1 answer
Alternatives for appending to numpy array
Python
50 votes31 views6 answers
Python uppercase
Python
2 votes34 views1 answer
Python compare if 2 files are equal
Python
1 vote31 views1 answer
Import tknter
Python
0 vote28 views1 answer
Numpy array with 2 times each value
Python