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
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
            
            
        
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
