SQLAlchemy Wiki¶

Cascades¶

class User(Base):
    # ...

    addresses = relationship("Address", cascade="all, delete-orphan")

When, a User object is marked for completion, addresses associated with the object will also be deleted. Same goes for addresses that have been de-associated from their parent.

Query on JSON field¶

query = Table.query.filter(Table.json_column.contains({"someField": True}))

Single table inheritance alongside mixins¶

A mixin that sets table name for a table can be used for a single table inheritance scenario by just setting __tablename__ to None in subclasses.

More here.