annotate django querset code example
Example 1: django order by
class Meta:
ordering = ('date',)
Example 2: sum values in django models and insert value in model field
# models.py
def total_amount_spent(self):
temp_values = [int(user.amount_spent) for user in ExtendedProfile.objects.all()]
return sum(temp_values)
Example 3: django 3.0 queryset examples
>>> Entry.objects.filter(
... headline__startswith='What'
... ).exclude(
... pub_date__gte=datetime.date.today()
... ).filter(
... pub_date__gte=datetime.date(2005, 1, 30)
... )