A RQL-enabled filter backend for django-rest-framework
Project description
This app implements a RQL/RSQL/FIQL filter backend for django-rest-framework and enables passing arbitrary conditional expressions to filter entities.
Installation
pip install django-rql-filter
Usage
Add rql_filter to your project INSTALLED_APPS.
Add the RQLFilterBackend to your viewset filter_backends:
from rql_filter.backend import RQLFilterBackend
class ThingyViewSet(viewsets.ReadOnlyModelViewSet):
filter_backends = (
...
RQLFilterBackend,
...
)
You may now pass a RQL/RSQL/FIQL query to API URLs using the q querystring parameter:
curl http://my.app/api/thingies/?format=json&q=name==bob;age=gt=30
Query syntax
A query is made using a combination of field comparisons. Comparisons are composed by a field name, an operator and a value.
Operator |
Meaning |
Examples |
---|---|---|
== |
Equal to |
name==bob |
!= |
Not equal to |
name!=bob |
< =lt= |
Less than |
age<30 age=lt=30 |
<= =le= |
Less than or equal to |
age<=30 age=le=30 |
> =gt= |
Greater than |
age>30 age=gt=30 |
>= =ge= |
Greater than or equal to |
age>=30 age=ge=30 |
=in= |
Belongs to set |
name=in=(bob,kate) |
=out= |
Does not belong to set |
name=out=(bob,kate) |
Comparisons can traverse model relations by separating field names with a double underscore: father__name==bob.
Values must be quoted with single or double quotes when they include special characters or spaces: name=="bob katz".
Comparisons may be combined using logical operators: ; for a logical AND, and , for a logical OR: name=="bob";age>=30. AND has priority over OR; grouping is available using parentheses: name=="bob";(age>=30,age<3).
Note: RQL/RSQL/FIQL support is still incomplete, it will be enhanced over time.
Configuration
RQL_FILTER_QUERY_PARAM sets the querystring parameter name to use; it defaults to 'q'.
Using without rest-framework
You may use the backend manually outside a rest-framework viewset:
from rql_filter.backend import RQLFilterBackend
# May be reused any number of times
backend = RQLFilterBackend()
# Fake request object
class FakeRQLRequest:
def __init__(self, q):
self.GET = {'q': q}
qs = Thingy.objects.all()
filtered_qs = backend.filter_queryset(
FakeRQLRequest('name==bob;age=gt=30'),
qs,
None
)
Testing
Install testing dependencies:
pip install -e .[testing]
Run tests:
py.test
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
File details
Details for the file django-rql-filter-0.1.1.tar.gz
.
File metadata
- Download URL: django-rql-filter-0.1.1.tar.gz
- Upload date:
- Size: 3.4 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0910d3824871e250075350e39e65eda7c8e39e5e5ae300364527e36ff00af6c0 |
|
MD5 | 15616fbdba6c99d9ad5b2561b08d946b |
|
BLAKE2b-256 | 5ce987f9383b0d89bd70955716664bc54dd63ce783edb5754f7ccba5549cb1cb |