qSQLA is a query builder for SQLAlchemy Core Selectables
Project description
qsqla
===============================
[![Build Status](https://travis-ci.org/blue-yonder/qsqla.svg?branch=master)](https://travis-ci.org/blue-yonder/qsqla)
qSQLA is a query builder for SQLAlchemy Core Selectables
Installation / Usage
--------------------
To install use pip:
$ pip install qsqla
Or clone the repo:
$ git clone https://github.com/blue-yonder/qsqla.git
$ python setup.py install
Example
-------
```python
from sqlalchemy import create_engine, MetaData, Table, Column, Integer, String
db = create_engine("sqlite:////:memory:")
md = MetaData(bind=db)
table = Table('user',
md,
Column('id', Integer, primary_key=True),
Column('name', String(16), nullable=False),
Column('age', Integer)
)
sel = table.select()
from qsqla.query import query, build_filters
filter = build_filters({"id__eq":1})
stm = query(sel, filter)
```
===============================
[![Build Status](https://travis-ci.org/blue-yonder/qsqla.svg?branch=master)](https://travis-ci.org/blue-yonder/qsqla)
qSQLA is a query builder for SQLAlchemy Core Selectables
Installation / Usage
--------------------
To install use pip:
$ pip install qsqla
Or clone the repo:
$ git clone https://github.com/blue-yonder/qsqla.git
$ python setup.py install
Example
-------
```python
from sqlalchemy import create_engine, MetaData, Table, Column, Integer, String
db = create_engine("sqlite:////:memory:")
md = MetaData(bind=db)
table = Table('user',
md,
Column('id', Integer, primary_key=True),
Column('name', String(16), nullable=False),
Column('age', Integer)
)
sel = table.select()
from qsqla.query import query, build_filters
filter = build_filters({"id__eq":1})
stm = query(sel, filter)
```
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
qsqla-0.3.2.tar.gz
(17.9 kB
view details)
File details
Details for the file qsqla-0.3.2.tar.gz
.
File metadata
- Download URL: qsqla-0.3.2.tar.gz
- Upload date:
- Size: 17.9 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/1.13.0 pkginfo/1.5.0.1 requests/2.21.0 setuptools/41.0.1 requests-toolbelt/0.9.1 tqdm/4.31.1 CPython/2.7.14
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0ba661bc168ea540ca448bdc304fc2533b363c4c43b54f6e70c6787b44806f7a |
|
MD5 | 5c777d3df4a88b7fe341ed176ccb4be2 |
|
BLAKE2b-256 | 5fe0738fe98be05cbfdcbd9e23e56531bbb2a9b2e038fb8ca546366c3fd9decd |