semvec/pypi-packages huggingface dataset:
pssq 0.0.2
Prepares PostgreSQL queries for execution in more useful Pythonic way. Not ORM.
License: MIT
Keywords: pssq

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