sillyORM 1.1.0

an ORM library

sillyORM

simple ORM library written in Python

Should work with most DBMS that SQLAlchemy supports as it uses SQLAlchemy core, but it's only tested with

• SQLite
• PostgreSQL

[!CAUTION] :warning: sillyORM is not ready for use in production environments. It is still beta software and under development. The API is unstable, and each release may introduce breaking changes. There may even be security vulnerabilities present. If you use it anyway, make sure to pin the version!

Projects using sillyORM

• theverygaming/silly
• iLollek/Figuyo-Public - An app for keeping track of Anime Figures

Installation

pip install sillyorm

Usage

import sillyorm


# define a model, a model abstracts a table in the database
class Example(sillyorm.model.Model):
    _name = "example"  # database table name (sanitized) & name in environment

    # fields
    name = sillyorm.fields.String(length=255)


# connect to the DB and create a model registry
registry = sillyorm.Registry("sqlite:///test.db")

# register the model in the environment
registry.register_model(Example)

# create the database tables
registry.resolve_tables()
registry.init_db_tables()
env = registry.get_environment(autocommit=True)

# start using the model
record = env["example"].create({"name": "Hello world!"})
print(record.name)

Documentation

Read the docs here

[!NOTE] The docs are always for the latest release. If you need docs for another version you must build them yourself