pynoorm 0.1.1

Easier raw SQL, with or without an ORM.

The Binder class

A Binder abstracts differences in the underlying database’s bind variable syntax and also grabs bind variables from a list of arguments, using dict, then attribute lookup.

Simple sqlite3 example:

from pynoorm.binder import Binder
binder = Binder.factory("qmark")

#just for test... assign a custid to binder for attribute lookup
binder.custid = "AMAZON"

query, parameters = binder("select * from orders where custid = %(custid)s", dict(custid="ACME"), binder)

query and parameters are now in the sqlite3/qmark format:

>>> print(query)
select * from orders where custid = ?
>>> print(parameters)
('ACME',)

History

0.1.0 (2016-01-17)

• First release on github.

0.1.1 (2016-01-22)

• Registered on PyPI