Nice micro python orm for mysql and sqlite3. (Original named CURD.py).
Release: v0.9.0 - Beta (Installation)
Build status:
Contents
>>> from models import User
>>> user = User(name='Tom', email='tom@gmail.com')
>>> user.save() # insert
1
>>> user.email = 'tom@github.com'
>>> user.save() # update
1
>>> [user.name for user in User.select()] # select
[u'Tom']
>>> query = User.where(name='Tom').delete()
>>> query.execute() # delete
1
>>> user = User.create(name='Kate', email='kate@gmail.com') # another insert
>>> user
{'email': 'kate@gmail.com', 'name': 'Kate', 'id': 2}
>>> user.destroy() # another delete
1
More sample codes here
$ pip install skylark