/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 vote302 views1 answer
Load data(review path) python
Python
0 vote332 views1 answer
Python - join two columns and transform it as index
Python
0 vote323 views1 answer
View scrapy response in chrome from inside the spider
Python
15 votes311 views1 answer
Function to a button in tkinter
Python
0 vote350 views1 answer
Append to l'st python
Python
0 vote311 views1 answer
Echo $pythonpath ubuntu set default
Python
0 vote325 views1 answer
String times python
Python
0 vote326 views3 answers
Matlab to python
Python
0 vote309 views1 answer
How to download feature engine in spyder console
Python
0 vote319 views1 answer
Apa itu duck typing python
Python