user.py 4.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119
  1. from __future__ import annotations
  2. from datetime import datetime
  3. from typing import TYPE_CHECKING
  4. from sqlalchemy import DateTime, String, func
  5. from sqlalchemy.orm import Mapped, mapped_column, relationship
  6. from backend.app.core.database import Base
  7. if TYPE_CHECKING:
  8. from backend.app.models.group import Group
  9. from backend.app.models.user_email_pref import UserEmailPreference
  10. class User(Base):
  11. """User model for authentication and authorization.
  12. Users can belong to multiple groups, and their permissions are additive
  13. across all groups. The legacy 'role' field is kept for backward compatibility
  14. but is_admin property now also considers group membership.
  15. """
  16. __tablename__ = "users"
  17. id: Mapped[int] = mapped_column(primary_key=True)
  18. username: Mapped[str] = mapped_column(String(100), unique=True, index=True)
  19. email: Mapped[str | None] = mapped_column(String(255), unique=True, index=True, nullable=True)
  20. password_hash: Mapped[str | None] = mapped_column(String(255), nullable=True)
  21. role: Mapped[str] = mapped_column(
  22. String(20), default="user"
  23. ) # "admin" or "user" (legacy, kept for backward compat)
  24. auth_source: Mapped[str] = mapped_column(String(20), default="local") # "local", "ldap", or "oidc"
  25. is_active: Mapped[bool] = mapped_column(default=True)
  26. created_at: Mapped[datetime] = mapped_column(DateTime, server_default=func.now())
  27. updated_at: Mapped[datetime] = mapped_column(DateTime, server_default=func.now(), onupdate=func.now())
  28. # Set whenever the local password is changed/reset — used to invalidate JWTs
  29. # issued before the change (M-R7-B). NULL means no password change recorded yet.
  30. password_changed_at: Mapped[datetime | None] = mapped_column(DateTime(timezone=True), nullable=True)
  31. # Per-user Bambu Cloud credentials (when auth is enabled, each user has their own)
  32. cloud_token: Mapped[str | None] = mapped_column(String(500), nullable=True, default=None)
  33. cloud_email: Mapped[str | None] = mapped_column(String(255), nullable=True, default=None)
  34. # Relationship to groups through association table
  35. groups: Mapped[list[Group]] = relationship(
  36. "Group",
  37. secondary="user_groups",
  38. back_populates="users",
  39. lazy="selectin",
  40. )
  41. # Relationship to email notification preferences
  42. email_preferences: Mapped[UserEmailPreference | None] = relationship(
  43. "UserEmailPreference",
  44. back_populates="user",
  45. uselist=False,
  46. cascade="all, delete-orphan",
  47. lazy="select",
  48. )
  49. @property
  50. def is_admin(self) -> bool:
  51. """Check if user is an admin.
  52. Returns True if:
  53. - User has legacy role='admin', OR
  54. - User belongs to the Administrators group
  55. """
  56. if self.role == "admin":
  57. return True
  58. return any(g.name == "Administrators" for g in self.groups)
  59. def get_permissions(self) -> set[str]:
  60. """Get all permissions from all groups the user belongs to.
  61. Returns a set of permission strings. Permissions are additive across groups.
  62. """
  63. permissions: set[str] = set()
  64. for group in self.groups:
  65. if group.permissions:
  66. permissions.update(group.permissions)
  67. return permissions
  68. def has_permission(self, permission: str) -> bool:
  69. """Check if user has a specific permission.
  70. Admins have all permissions. For other users, checks if the permission
  71. exists in any of their groups.
  72. """
  73. if self.is_admin:
  74. return True
  75. return permission in self.get_permissions()
  76. def has_all_permissions(self, *permissions: str) -> bool:
  77. """Check if user has ALL specified permissions.
  78. Admins have all permissions. For other users, checks if all permissions
  79. exist in their combined group permissions.
  80. """
  81. if self.is_admin:
  82. return True
  83. user_permissions = self.get_permissions()
  84. return all(p in user_permissions for p in permissions)
  85. def has_any_permission(self, *permissions: str) -> bool:
  86. """Check if user has ANY of the specified permissions.
  87. Admins have all permissions. For other users, checks if at least one
  88. permission exists in their combined group permissions.
  89. """
  90. if self.is_admin:
  91. return True
  92. user_permissions = self.get_permissions()
  93. return any(p in user_permissions for p in permissions)
  94. def __repr__(self) -> str:
  95. return f"<User {self.username}>"