{"repo":"OmenApps/django-generate-series","free":true,"listed":false,"github":"https://github.com/OmenApps/django-generate-series","clone":"git clone https://github.com/OmenApps/django-generate-series.git","description":"Use Postgres' generate_series to create sequences with Django's ORM","language":"Python","stars":33,"topics":["database-functions","django","orm","postgresql","sequence","sequences","sets","series","generate-series"],"license":"MIT","category":"databases-storage","readme_excerpt":"django-generate-series Use Postgres' generate series to create sequences with Django's ORM https://django-generate-series.readthedocs.io/ Goals When using Postgres, the set-returning functions allow us to easily create sequences of numbers, dates, datetimes, etc. Unfortunately, this functionality is not currently available within the Django ORM. This project makes it possible to create such sequences, which are returned as a Django QuerySet. For instance, assuming you have an Order model, you can create a set of sequential dates and then annotate each with the number of orders placed on that date. This will ensure you have no date gaps in the resulting QuerySet. To get the same effect without this package, additional post-processing of the QuerySet with Python would be required. New in version 1.0.0 : you can now generate cartesian products with a QuerySet or an iterable. For instance, you can create a sequence of dates that are repeated for each item in a QuerySet or iterable. Terminology Although this packages is named django-generate-series based on Postgres' generate series set-returning function, mathematically we are creating a sequence rather than a series). - sequence : Formally, \"a list of objects (or events) which have been ordered in a sequential fashion; such that each member either comes before, or after, every other member.\" In django-generate-series, we can generate sequences of integers, decimals, dates, datetimes, as well as the equivalent ranges of each of t","default_branch":null,"files":null,"tree":[],"storefront":"/r/OmenApps","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/OmenApps/django-generate-series/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}