django mysql aggregate query examples

Sangeetha S

1y486Blazor

Given me aggregate query examples for Django python

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

sasikala s1y ago
Accepted answer
f aggregate queries in Django using Python:

1. Calculating the average price of all books:

Python
```
from django.db.models import Avg
from .models import Book

average_price = Book.objects.all().aggregate(Avg("price"))
print(average_price)
```
This query calculates the average price of all books in the Book model. The result will be a dictionary with the key price__avg.

2. Calculating the total sum of expenses for a user:

Python
```
from django.db.models import Sum
from .models import Post

total_expenses = Post.objects.filter(author=request.user).aggregate(sum=Sum("expense"))
print(total_expenses)
```
This query calculates the sum of all expenses for the current logged-in user.

3. Counting the number of restaurants:

Python
```
from .models import Restaurant

restaurant_count = Restaurant.objects.count()
print(restaurant_count)
```
0
mohd kaif1y ago
thanks for the information
0
Eliana Blake1y ago
Absolutely! In Django, aggregate queries allow you to perform operations across a set of values. These queries can help you retrieve statistical information like counting, summing, averaging, and finding minimum or maximum values from your database. Let's delve into some aggregate query examples in Django Python:

1. Count: Counting the total number of records that meet certain criteria.
```
   from myapp.models import MyModel
   
   total_count = MyModel.objects.count()
```
2. Sum: Calculating the sum of a specific field across all records.
```
   from myapp.models import Sales
   
   total_revenue = Sales.objects.aggregate(total_revenue=Sum('amount'))['total_revenue']
```
3. Average: Finding the average value of a particular field in your dataset.
```
    from myapp.models import Product
    
    avg_price = Product.objects.aggregate(avg_price=Avg('price'))['avg_price']
```
4. Minimum and Maximum: Identifying the minimum and maximum values in a specific field.
```
   from myapp.models import Temperature
   
   min_temp = Temperature.objects.aggregate(min_temp=Min('degrees'))['min_temp']
   max_temp = Temperature.objects.aggregate(max_temp=Max('degrees'))['max_temp']
```
5. Group By: Grouping results based on a specific field and then performing aggregate functions.
```
   from myapp.models import Order
   
   order_total_by_customer = Order.objects.values('customer__name').annotate(total=Sum('amount'))
```
These examples showcase how you can utilize Django's queryset aggregation capabilities to extract valuable insights from your database. Whether you're working with simple counts or complex calculations, Django's aggregate queries offer a powerful way to analyze and manipulate data effectively. Let me know if you need further clarification or have any specific scenarios in mind!
0