oblique epoch
Imagine example table:
class Experiance:
job_title = charfield
start_date = date time field
end_date = date time field
Now i want to query sum between every experiance, without overlapping so if 1 date is starting from 2023 ending on 2025, second is starting on 2020 ending on 2024 query should return total experiance of 5 years 😛
nimble aurora
Imagine example table:
```py
class Experiance:
job_title = charfield
sta...
Hey! If you haven't solved that yet, here's a simple solution.
>>> from django.db.models import Max, Min, F
>>> Experience.objects.aggregate(start=Min("start_date"), end=Max("end_date"), length=F("end")-F("start"))
{'start': datetime.date(2001, 6, 9), 'end': datetime.date(2023, 6, 9), 'length': datetime.timedelta(days=8035)}
https://docs.djangoproject.com/en/4.2/topics/db/aggregation/ has a ton more info about aggregating queries
Simplest is to just choose the lowest start date and highest end date using the Min and Max db functions.
As you can see, this returns a dict with the keys I passed to the aggregate method.
agile topaz
Great answer @nimble aurora