Skip to main content

An ORM interface that molds itself to your data.

Project description

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.


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
# [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)
# task(id=4,active=0,title='Uninteresting',description='Not much to say here.')
task.title = "A bit more interesting"
# 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([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" = True
print(Task.find([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.

Project details

Download files

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

Source Distribution

plastic-0.2.0.tar.gz (16.4 kB view hashes)

Uploaded source

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page