Build sqlalchemy queries from jQuery-Query json
Project description
SQLAlchemy query builder for jQuery QueryBuilder
This package implements a sqlalchemy query builder for json data generated with (but not limited to) jQuery QueryBuilder.
Installation
#!python pip install sqlalchemy-querybuilder
Quickstart
Using sqlalchemy-querybuilder is very simple:
#!python from sqlalchemy_querybuilder import Filter from myapp import models, query rule = { "condition": "OR", "rules": [{ "field": "mytable.myfield", "operator": "equal", "value": "foo" }, ], } myfilter = Filter(models, query) print(myfilter)
The following attributes from the rules are ignored and therefore can be omitted:
id
type
input
WARNING
sqlalchemy-querybuilder does not do any kind of json validation.
Filter class
Filter accepts two arguments, models and query:
models - can either be a module defining classes which inherit from declarative_base or a dict of such classes with the name of the tables as keys.
query - a SQLAlchemy query object. Optionaly loaded with some entity.
Release History
0.1.2 (2017-11-19)
Bugfixes
Fixed issue when models parameter was a dict() of classes.
Added missing test for models parameter
0.1 (2017-07-10)
Improvements
First release
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
Built Distribution
Hashes for sqlalchemy-querybuilder-0.1.2a0.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 02c37f427a50d4b68d370b2b5de1198bad897638dd1b48d4b45e7510c72f5ea9 |
|
MD5 | c51e7dea2230fe4ee554b5890111fa53 |
|
BLAKE2b-256 | 2ae30a36cb9dba24af78934c358e2c344bf51000cd3ac46853a4ab77685dab1d |
Hashes for sqlalchemy_querybuilder-0.1.2a0-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a06067c7b81f7424e1de51ee77b4970c2e5537d6b1531b666a2e7f2580f8b37a |
|
MD5 | 26ff8c3ca4c4be685d09d870bc792799 |
|
BLAKE2b-256 | 8f8e7ed572b2a314943113e92fb88304da6aaaaf5169ef0c30c4a2d0e34878b0 |