mvc树形菜单数据库

from sqlalchemy import create_engine, Column, Integer, String, ForeignKey
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship, sessionmaker

Base = declarative_base()

class Menu(Base):
    __tablename__ = 'menu'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    parent_id = Column(Integer, ForeignKey('menu.id'))
    children = relationship("Menu", backref="parent", remote_side=[id])

engine = create_engine('sqlite:///menu.db')
Base.metadata.create_all(engine)

Session = sessionmaker(bind=engine)
session = Session()

# 插入数据
root = Menu(name='Root')
child1 = Menu(name='Child1', parent=root)
child2 = Menu(name='Child2', parent=root)
grandchild = Menu(name='Grandchild', parent=child1)

session.add(root)
session.commit()

# 查询数据
def get_children(menu_id):
    return session.query(Menu).filter_by(parent_id=menu_id).all()

print(get_children(1))  # 输出所有根节点的子节点