pysqle 0.0.2

No project description provided

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)


# Inspect REPL-style:
#
# >>> user.user_id
# 666
# >>> user.username
# thebeast
# >>> user == (666, 'thebeast')
# True

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