Skylark

A micro python orm for mysql and sqlite3. (Original named CURD.py).

Latest version: v0.9.1

Development status: 4 - Beta

Testing status:

Sample Code

>>> 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 examples: sample/, snippets

Requirements

• Python >= 2.6 or >= 3.3

• For mysql users: MySQLdb(MySQL-python) or PyMySQL

Install

$ pip install skylark

Documentation

Documentation: http://skylark.readthedocs.org/

Strongly recommend that you read Quick Start at first.

NOTE: skylark is not currently threading safe.

Sample App

• A simple message board built with skylark and Flask: examples/messageboard

Tests

• Status:

• How to Run Tests

Contributors

https://github.com/hit9/skylark/graphs/contributors

About

Many ideas are inspired by peewee, thanks a lot to @coleifer. (#34)

License

• LICENSE-BSD
• LICENSE-PEEWEE

Changes

CHANGES](CHANGES)