sqlalchemy-nest 1.0.0

easy create nested models for sqlalchemy

sqlalchemy-nest

sqlalchemy-nest is easy create nested models for sqlalchemy

Getting started

use declarative_nested_model_constructor for declarative_base constructor

from sqlalchemy import Column, ForeignKey, Integer, String

from sqlalchemy.orm import declarative_base, relationship

from sqlalchemy_nest import declarative_nested_model_constructor



Base = declarative_base(constructor=declarative_nested_model_constructor)



class Root(Base):

    __tablename__ = "root"

    

    id = Column(Integer, primary_key=True, autoincrement=True)

    name = Column(String(100))

    

    branches = relationship("Branch", back_populates="root", uselist=True, lazy="joined")

    

class Branch(Base):

    __tablename__ = "branch"

    

    id = Column(Integer, primary_key=True, autoincrement=True)

    name = Column(String(100))

    root_id = Column(Integer, ForeignKey("root.id"))

    

    root = relationship("Root")

initialization from kwargs.

sets attributes on the constructed instance using the names and values in kwargs.

root = {

    'name': 'root',

    'branches': [

        {

            'name': 'branch',

        },

    ] 

}

>>> session.add(Root(**root))

>>> session.commit()

>>> added_root: Root = session.query(Root).filter(Root.id == 1).first()

Root(id=1, name='root', branches=[Branch(id=1, name='branch', root_id=1)])