Skip to main content

Write Django model properties that can be used in database queries.

Project description

https://travis-ci.com/W1ldPo1nter/django-queryable-properties.svg?branch=master https://codecov.io/gh/W1ldPo1nter/django-queryable-properties/branch/master/graph/badge.svg https://readthedocs.org/projects/django-queryable-properties/badge/?version=latest https://img.shields.io/pypi/v/django-queryable-properties.svg

django-queryable-properties is a Django extension that allows to implement model properties which can be used in database queries performed via Django’s ORM.

Further information, including supported Python and Django versions as well as installation instructions, can be found in the documentation hosted by readthedocs.

Contributing and getting help

The GitHub repository is the central place to report bugs and get help using the GitHub issues as well as to contribute to the project via pull requests while following the guide on contributing.

Changelog

master (unreleased)

1.2.0 (2019-10-21)

  • Added a mixin that allows custom filters for queryable properties (both class- and decorator-based) to be implemented using multiple functions/methods for different lookups

  • Added some ready-to-use queryable property implementations (ValueCheckProperty, RangeCheckProperty) to simplify common code patterns

  • Added a standalone version of six to the package requirements

1.1.0 (2019-06-23)

  • Queryable property filters (both annotation-based and custom) can now be used across relations when filtering querysets (i.e. a queryset can now be filtered by a queryable property on a related model)

  • Queryset annotations can now refer to annotatable queryable properties defined on a related model

  • Querysets can now be ordered by annotatable queryable properties defined on a related model

  • Filters and annotations that reference annotatable queryable properties will not select the queryable property annotation anymore in Django versions below 1.8 (ordering by such a property will still lead to a selection in these versions)

  • Fixed unnecessary selections of queryable property annotations in querysets that don’t return model instances (i.e. queries with .values() or .values_list())

  • Fixed unnecessary fields in GROUP BY clauses in querysets that don’t return model instances (i.e. queries with .values() or .values_list()) in Django versions below 1.8

  • Fixed an infinite recursion when constructing the HAVING clause for annotation-based filters that are not an aggregate in Django 1.8

1.0.2 (2019-06-02)

  • The lookup parameter of custom filter implementations of queryable properties will now receive the combined lookup string if multiple lookups/transforms are used at once instead of just the first lookup/transform

  • Fixed the construction of GROUP BY clauses when annotating queryable properties based on aggregates

  • Fixed the construction of HAVING clauses when annotating queryable properties based on aggregates in Django versions below 1.9

  • Fixed the ability to pickle queries and querysets with queryable properties functionality in Django versions below 1.6

1.0.1 (2019-05-11)

  • Added support for Django 2.2

1.0.0 (2018-12-31)

  • Initial release

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

django-queryable-properties-1.2.0.tar.gz (39.1 kB view hashes)

Uploaded Source

Built Distribution

django_queryable_properties-1.2.0-py2.py3-none-any.whl (51.5 kB view hashes)

Uploaded Python 2 Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page