Metadata-Version: 2.1
Name: pssq
Version: 0.0.2
Summary: Prepares PostgreSQL queries for execution in more useful Pythonic way. Not ORM.
Home-page: https://github.com/aptakhin/pssq
Author: Alexander Ptakhin
Author-email: me@aptakhin.name
License: MIT
Project-URL: Source Code, https://github.com/aptakhin/pssq
Keywords: pssq
Platform: UNKNOWN
Classifier: Development Status :: 3 - Alpha
Classifier: Intended Audience :: Developers
Classifier: License :: OSI Approved :: MIT License
Classifier: Programming Language :: Python
Classifier: Topic :: Software Development
Description-Content-Type: text/markdown

Builds PostgreSQL queries for execution in more useful Pythonic way. Not ORM.

    >>> from pssq import Q
    >>> Q.select().from_("foo").where(a=5).end()
    ('SELECT * from "foo" where "a"=$1', (5,))

    >>> Q.insert("foo").set(a=5, b=7).end()
    ('INSERT INTO "foo" ("a", "b") VALUES ($1, $2)', (5, 7))
    
    >>> Q.insert("foo").set(q=Q.unsafe("4"), w=Q.unsafe("now()"), a=5).end()
    ('INSERT INTO "foo" ("q", "w", "a") VALUES (4, now(), $1)', (5,))

## Install
    
    pip3 install pssq
    
    
## Motivation

Originally written for asyncpg service without ORM. Because writing bind variables for raw PostgreSQL is hard.
    
    
    
## Tests

    pip3 install pytest
    PYTHONPATH=src py.test -s tests
    
    


