skylark

skylark

A micro python orm for mysql and sqlite.

Sample Usage

.. code:: python

    >>> from models import User
    >>> user = User(name='Tom', email='[e-mail]')
    >>> user.save()  # insert
    1
    >>> user.email = '[e-mail]'
    >>> 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='[e-mail]')  # another insert
    >>> user
    {'email': '[e-mail]', 'name': 'Kate', 'id': 2}
    >>> user.destroy()  # another delete
    1

Installation

.. code:: bash

$ pip install skylark

Links

* `Documentation <http://skylark.readthedocs.org/>`_
* `Code on Github <https://github.com/hit9/skylark>`_

**NOTICE**: skylark may not be stable before version 1.0