Prepares PostgreSQL queries for execution in more useful Pythonic way. Not ORM.
Project description
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
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
pssq-0.0.2.tar.gz
(3.3 kB
view hashes)