在Websauna管理面板中管理ManyToMany关系

from sqlalchemy import Column, Integer, String, ForeignKey
from sqlalchemy.orm import relationship
from websauna.system.model.columns import UTCDateTime
from websauna.system.model.meta import Base

class User(Base):
    __tablename__ = "users"

    id = Column(Integer, primary_key=True)
    name = Column(String(255), nullable=False)

    groups = relationship("Group", secondary="user_group", back_populates="users")

class Group(Base):
    __tablename__ = "groups"

    id = Column(Integer, primary_key=True)
    name = Column(String(255), nullable=False)

    users = relationship("User", secondary="user_group", back_populates="groups")

class UserGroup(Base):
    __tablename__ = "user_group"

    user_id = Column(Integer, ForeignKey("users.id"), primary_key=True)
    group_id = Column(Integer, ForeignKey("groups.id"), primary_key=True)
    created_at = Column(UTCDateTime, nullable=False, default=datetime.utcnow)

from websauna.system.admin.modeladmin import ModelAdmin
from websauna.system.admin.modeladmin import model_admin

@model_admin.register
class UserAdmin(ModelAdmin):
    model = User

@model_admin.register
class GroupAdmin(ModelAdmin):
    model = Group