Skip to main content
Help us improve PyPI by participating in user testing. All experience levels needed!

Simple python ORM micro-framework for sqlite3

Project description

litesimple
==========

Litesimple is a simple ORM micro-library for sqlite3. It offers mapping
between attributes (or fields as it's named here) to table columns with
conversion support from different formats, querying, saving and other simple
task.

Installation and dependencies
-----------------------------

To install litesimple, either run ``pip install litesimple`` or download [litesimple.py](https://github.com/TheThing/litesimple) directly in your browser or with wget.

Litesimple has no dependancy requirements other than is included in the Python Standard Library.

Example
-------

First create your models:

``` python
from litesimple import Model, FieldInteger, FieldText, FieldDateTime

class car(Model):
id = FieldInteger(is_key=True)
text = FieldText()
time_created = FieldDateTime(auto_now_add=True)
time_updated = FieldDateTime(auto_now=True)

def __str__(self):
return "car (%s)" % self.make
```

Then play with it:

``` python
>>> from models import car
>>> car(make="Opel").save()
>>> car(make="Hyundai").save()
>>> car(make="BMW").save()
>>> print car.get(1)
car (Opel)
>>> for x in car.filter(): print x
queue (Opel)
queue (Hyundai)
queue (BMW)
>>> c = car.get(2)
>>> print c
car (Hyundai)
>>> c = car.get(id=2)
>>> print c
car (Hyundai)
>>> c.delete()
>>> for x in car.filter(): print x
car (Opel)
car (BMW)
>>> car.delete(make="Opel")
>>> for x in car.filter(): print x
car (BMW)
```

Project details


Release history Release notifications

This version
History Node

0.1.0

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
litesimple-0.1.0.tar.gz (9.5 kB) Copy SHA256 hash SHA256 Source None Jul 11, 2013

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging CloudAMQP CloudAMQP RabbitMQ AWS AWS Cloud computing Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page