Extra/Aggregation

output_field

  • Django Q Example

    • https://github.com/Koed00/django-q/pull/185

      In [1]: from django.db.models import Sum, F, FloatField
      
      In [2]: from django.utils import timezone
      
      In [3]: from django_q.models import Success
      
      In [4]: from datetime import timedelta
      
      In [5]: Success.objects.filter(stopped__gte=timezone.now() - timedelta(hours=24)).aggregate(time_taken=Sum(F('stopped') - F('started')))
      # AttributeError: 'Decimal' object has no attribute 'tzinfo'
      
      In [6]: Success.objects.filter(stopped__gte=timezone.now() - timedelta(hours=24)).aggregate(time_taken=Sum(F('stopped') - F('started'), output_field=FloatField()))
      Out[6]: {'time_taken': 0.004298}
      

References

[1] [email protected], Aggregation

[2] [email protected], Query Expressions

[3] [email protected], django/django/db/models/expressions.py/_resolve_output_field

[4] [email protected], django/django/db/models/sql/compiler.py/get_converters

[5] [email protected], django/django/db/backends/mysql/operations.py/convert_datetimefield_value

[6] [email protected], Support for annotate(end=F('start') + F('duration'), output_field=DateTimeField)

results matching ""

    No results matching ""