sqlwitch 0.2

sqlwitch offers idiomatic SQL generation on top of MySQLdb.

sqlwitch is a Python 2.5+ library that offers idiomatic SQL generation on top of MySQLdb. BSD-licensed.

Usage

with db.insert(into='foobars') as obj:
    obj.foo = 1
with db.select('foo, bar', from_='foobars'):
    db.where('foo = 1')
with db.update('foobars') as changeset:
    changeset.foo = 2
    db.where('foo = 1')
with db.delete(from_='foobars'):
    db.where('foo = 2')

Setup

$ pip install sqlwitch # or
$ easy_install sqlwitch # or
$ cd sqlwitch-0.2; python setup.py install

Links

• Full documentation

• Development repository

• Author’s website