user.py 4.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114
  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] = mapped_column(String(255))
  21. role: Mapped[str] = mapped_column(
  22. String(20), default="user"
  23. ) # "admin" or "user" (legacy, kept for backward compat)
  24. is_active: Mapped[bool] = mapped_column(default=True)
  25. created_at: Mapped[datetime] = mapped_column(DateTime, server_default=func.now())
  26. updated_at: Mapped[datetime] = mapped_column(DateTime, server_default=func.now(), onupdate=func.now())
  27. # Per-user Bambu Cloud credentials (when auth is enabled, each user has their own)
  28. cloud_token: Mapped[str | None] = mapped_column(String(500), nullable=True, default=None)
  29. cloud_email: Mapped[str | None] = mapped_column(String(255), nullable=True, default=None)
  30. # Relationship to groups through association table
  31. groups: Mapped[list[Group]] = relationship(
  32. "Group",
  33. secondary="user_groups",
  34. back_populates="users",
  35. lazy="selectin",
  36. )
  37. # Relationship to email notification preferences
  38. email_preferences: Mapped[UserEmailPreference | None] = relationship(
  39. "UserEmailPreference",
  40. back_populates="user",
  41. uselist=False,
  42. cascade="all, delete-orphan",
  43. lazy="select",
  44. )
  45. @property
  46. def is_admin(self) -> bool:
  47. """Check if user is an admin.
  48. Returns True if:
  49. - User has legacy role='admin', OR
  50. - User belongs to the Administrators group
  51. """
  52. if self.role == "admin":
  53. return True
  54. return any(g.name == "Administrators" for g in self.groups)
  55. def get_permissions(self) -> set[str]:
  56. """Get all permissions from all groups the user belongs to.
  57. Returns a set of permission strings. Permissions are additive across groups.
  58. """
  59. permissions: set[str] = set()
  60. for group in self.groups:
  61. if group.permissions:
  62. permissions.update(group.permissions)
  63. return permissions
  64. def has_permission(self, permission: str) -> bool:
  65. """Check if user has a specific permission.
  66. Admins have all permissions. For other users, checks if the permission
  67. exists in any of their groups.
  68. """
  69. if self.is_admin:
  70. return True
  71. return permission in self.get_permissions()
  72. def has_all_permissions(self, *permissions: str) -> bool:
  73. """Check if user has ALL specified permissions.
  74. Admins have all permissions. For other users, checks if all permissions
  75. exist in their combined group permissions.
  76. """
  77. if self.is_admin:
  78. return True
  79. user_permissions = self.get_permissions()
  80. return all(p in user_permissions for p in permissions)
  81. def has_any_permission(self, *permissions: str) -> bool:
  82. """Check if user has ANY of the specified permissions.
  83. Admins have all permissions. For other users, checks if at least one
  84. permission exists in their combined group permissions.
  85. """
  86. if self.is_admin:
  87. return True
  88. user_permissions = self.get_permissions()
  89. return any(p in user_permissions for p in permissions)
  90. def __repr__(self) -> str:
  91. return f"<User {self.username}>"