Declarative query builder for SQLAlchemy
Project description
filteralchemy is a declarative query builder for SQLAlchemy. filteralchemy uses marshmallow-sqlalchemy to auto-generate filter fields and webargs to parse field parameters from the request. Use it to filter data with minimal boilerplate.
For Django users: the design of filteralchemy is strongly inspired by django-filter.
Install
pip install filteralchemy
Quickstart
import flask
from models import Album, session
from webargs.flaskparser import parser
from filteralchemy import FilterSet
from filteralchemy.operators import Equal, Less, Greater
class AlbumFilterSet(FilterSet):
class Meta:
model = Album
query = session.query(Album)
operators = (Equal, Less, Greater)
parser = parser
app = flask.Flask(__name__)
@app.route('/albums')
def get_albums():
query = AlbumFilterSet().filter()
return flask.jsonify(query.all())
http :5000/albums artist==Queen genre==rock sales__gt==1000000
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
filteralchemy-0.1.0.tar.gz
(5.6 kB
view details)
Built Distribution
File details
Details for the file filteralchemy-0.1.0.tar.gz
.
File metadata
- Download URL: filteralchemy-0.1.0.tar.gz
- Upload date:
- Size: 5.6 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 38b9784aa85d31a393282eb2b313e5955b5c7632d9bbfc5c653c040e937a7d96 |
|
MD5 | 32a298e46e8d95daf9dceeaf153e0ab6 |
|
BLAKE2b-256 | ad3c20280257ee8411e905fdd09e4bf7f2bbc37d7e47986413c57b30acb473a0 |
File details
Details for the file filteralchemy-0.1.0-py2.py3-none-any.whl
.
File metadata
- Download URL: filteralchemy-0.1.0-py2.py3-none-any.whl
- Upload date:
- Size: 8.5 kB
- Tags: Python 2, Python 3
- Uploaded using Trusted Publishing? No
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 72a8f636a88094c5ac65accefcdf1b935af7baa13697399c5f049dc267539af5 |
|
MD5 | fcc18a71c5ff9c9fa586069823fa4d24 |
|
BLAKE2b-256 | 6df71a6205908834ac7249796dea17ecfa310595d4184b7be89db3ac047ee588 |