pysqle 0.1.0

With PySQLe you can easily write parameterized SQL queries in Python, and run it against any SQLAlchemy-supported database.

With PySQLe you can easily write parameterized SQL queries in Python, and run it against any SQLAlchemy-supported database.

from pysqle import PysqleModule, one

class MyQueries(PysqleModule):
    @one
    def find_user(self, user_id:):
        return "select * from users where user_id = :user_id"

# Create the module and directly connect to the database
queries = MyQueries("sqlite:///foo.db")

# Invoke queries
user = queries.find_user(user_id=666)

print(repr(user))            #  (666, 'thebeast')
print(repr(user._asdict()))  #  {'user_id': 666, 'username': 'thebeast'}

This is the way of running SQL with Python. Install PySQLe today!