shanxia/bx/bx-backend/app/models/role.py

from sqlalchemy import Integer, SmallInteger, String
from sqlalchemy.orm import Mapped, mapped_column, relationship

from app.models.base import BaseModel, SoftDeleteMixin


class Role(BaseModel, SoftDeleteMixin):
    __tablename__ = "bx_role"

    role_name: Mapped[str] = mapped_column(String(64), nullable=False)
    role_code: Mapped[str] = mapped_column(String(64), nullable=False, unique=True)
    sort_order: Mapped[int] = mapped_column(Integer, nullable=False, default=0, server_default="0")
    status: Mapped[int] = mapped_column(SmallInteger, nullable=False, default=1, server_default="1")
    remark: Mapped[str | None] = mapped_column(String(512))

    users: Mapped[list["User"]] = relationship(
        "User", secondary="bx_role_user", back_populates="roles"
    )
    menus: Mapped[list["Menu"]] = relationship(
        "Menu", secondary="bx_menu_role", back_populates="roles"
    )