Skip to content

sirithink/CURD.py

 
 

Repository files navigation

CURD.py

Tiny Python ORM for MySQL.

Latest version: v0.4.1

Development status: 3 - Alpha

Only support C, U, R, D, responsing to its name:

  • Create

  • Update

  • Read

  • Delete

NOTE: CURD.py may not be stable before version v1.0

Sample Code

>>> from models import User
>>> user = User(name='Tom', email='tom@gmail.com')
>>> user.save()  # insert
1L
>>> user.email = 'tom@github.com'
>>> user.save()  # update
1L
>>> [user.name for user in User.select()]  # select
[u'Tom']
>>> query = User.where(name='Tom').delete()
>>> query.execute()  # delete
1L
>>> user = User.create(name='Kate', email='kate@gmail.com')  # another insert
>>> user.data
{'email': 'kate@gmail.com', 'name': 'Kate', 'id': 2L}
>>> user.destroy()  # another delete
1L

More examples: docs/sample/.

Install

$ pip install CURD.py

Documentation

Sample App

A simple message board built with CURD.py and Flask: examples/messageboard

FAQ

Tests

License

LICENSE-BSD

Changes

CHANGES