sqlalchemy-orm 1.2.3

Data Relation Mapping framework for Python.

SQLAlchemy-ORM

ORM framework for Python. Designed for simplicity, based on SQLAlchemy.

Check out the tests directory for more examples.

Basic Example

from sqlalachemy_orm import Model, Database

Base = Model()

class Animal(Base):
    name: str
    age: int

db = Database("sqlite:///:memory:") # use an in-memory SQLite database
db.create(Animal)  # Create the `Animal` table in the database

bea = Animal(name="bea", age=5)

session = db.session()
session.create(bea) # Create a row in the `Animal` table

print(session.query(Animal).filter(Animal.name == "bea").one())

session.commit() # commit the session to the database

$ python example.py
>>> Animal(name='bea', age=5)