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:
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.3 (2020-05-10)
Improvements
- Use poetry for development.
Bugfixes
- First release on sourcehut (bye bye bitbucket!).
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
Close
Hashes for sqlalchemy-querybuilder-0.1.3.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | eb190ddcaa4ef8fe0bbbd9f49c3b6afbf3afff07268fa71d3554978643551f0a |
|
MD5 | eb13aeffe600ba93e312488c05e5f26b |
|
BLAKE2b-256 | f49d4c276a7a23632fc4a14c039a7c2ddc04024241489e46124e1f7152e7386f |
Close
Hashes for sqlalchemy_querybuilder-0.1.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ee07c5659ffbe38e4169b1beaed007d8ae2c61e49f8188d5654b73b58827d781 |
|
MD5 | 4977388f944276919270be4b411b7f06 |
|
BLAKE2b-256 | 770cd554d0f9e13fe53a8be040cd4c22a377d0c0a4b48a3475f45dbc7d1df02e |