Plastic ORM
An ORM that molds itself to the data
Currently in beta validation. SQLite is the initial test.
See the dev/ directory for example usage.
Quickstart
Here's a quick way to get some data out of a SQLite database file:
>>> from plastic.connectors.sqlite import PlasticSqlite
>>> PlasticSqlite._dbInfo = './dev/sqlite-test.db'
>>> class Task(PlasticSqlite): pass
>>> print(Task.find(Task.id[3:]))
[task(id=4,active=0,title='Uninteresting',description='Not much to say here.'),
task(id=5,active=1,title='Very important',description=None)]To change a record you can set it this way:
>>> task = Task(id=4)
>>> print(task)
task(id=4,active=0,title='Uninteresting',description='Not much to say here.')
>>> task.title = "A bit more interesting"
>>> task._commit()
>>> print(Task(id=4))
task(id=4,active=0,title='A bit more interesting',description='Not much to say here.')Note: To avoid the need to call
_commit(), set_autocommit=True. This can be done at the object or class level. Also note that for SQLite a commit means the database file is updated!
Any column of the table can be referenced as an attribute, and they can also be used as a filter. For example, to find the tasks that are still active:
>>> print({task.title: task.description
for task
in Task.find(Task.active[0])})
{'Skipped': None, 'A bit more interesting': 'Not much to say here.'}Add an entry by instantiating without a bound key:
>>> newTask = Task()
>>> newTask.title = "A new task to do"
>>> newTask.active = True
>>> newTask._commit()
>>> print(Task.find(Task.id[5:])) # get tasks after the last added
[task(id=6,active=1,title='A new task to do',description=None)]Deletion is not yet supported. It wouldn't be hard, but there needs to be some sort of interlocking.
