groups.py 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332
  1. """Group management API routes."""
  2. from fastapi import APIRouter, Depends, HTTPException, status
  3. from sqlalchemy import select
  4. from sqlalchemy.ext.asyncio import AsyncSession
  5. from sqlalchemy.orm import selectinload
  6. from backend.app.core.auth import RequireAdminIfAuthEnabled, RequirePermissionIfAuthEnabled
  7. from backend.app.core.database import get_db
  8. from backend.app.core.permissions import (
  9. ALL_PERMISSIONS,
  10. PERMISSION_CATEGORIES,
  11. Permission,
  12. )
  13. from backend.app.models.group import Group
  14. from backend.app.models.user import User
  15. from backend.app.schemas.group import (
  16. GroupCreate,
  17. GroupDetailResponse,
  18. GroupResponse,
  19. GroupUpdate,
  20. PermissionCategory,
  21. PermissionInfo,
  22. PermissionsListResponse,
  23. UserBrief,
  24. )
  25. router = APIRouter(prefix="/groups", tags=["groups"])
  26. def _permission_label(perm: Permission) -> str:
  27. """Convert permission enum to human-readable label."""
  28. # e.g., "printers:read" -> "Read Printers"
  29. parts = perm.value.split(":")
  30. if len(parts) == 2:
  31. resource, action = parts
  32. resource = resource.replace("_", " ").title()
  33. action = action.replace("_", " ").title()
  34. return f"{action} {resource}"
  35. return perm.value
  36. @router.get("/permissions", response_model=PermissionsListResponse)
  37. async def list_permissions(
  38. _: User | None = RequirePermissionIfAuthEnabled(Permission.GROUPS_READ),
  39. ):
  40. """List all available permissions organized by category."""
  41. categories = []
  42. for name, perms in PERMISSION_CATEGORIES.items():
  43. categories.append(
  44. PermissionCategory(
  45. name=name,
  46. permissions=[PermissionInfo(value=p.value, label=_permission_label(p)) for p in perms],
  47. )
  48. )
  49. return PermissionsListResponse(
  50. categories=categories,
  51. all_permissions=ALL_PERMISSIONS,
  52. )
  53. @router.get("", response_model=list[GroupResponse])
  54. @router.get("/", response_model=list[GroupResponse])
  55. async def list_groups(
  56. _: User | None = RequirePermissionIfAuthEnabled(Permission.GROUPS_READ),
  57. db: AsyncSession = Depends(get_db),
  58. ):
  59. """List all groups."""
  60. result = await db.execute(select(Group).options(selectinload(Group.users)).order_by(Group.name))
  61. groups = result.scalars().all()
  62. return [
  63. GroupResponse(
  64. id=group.id,
  65. name=group.name,
  66. description=group.description,
  67. permissions=group.permissions or [],
  68. is_system=group.is_system,
  69. user_count=len(group.users),
  70. created_at=group.created_at,
  71. updated_at=group.updated_at,
  72. )
  73. for group in groups
  74. ]
  75. @router.post("", response_model=GroupResponse, status_code=status.HTTP_201_CREATED)
  76. @router.post("/", response_model=GroupResponse, status_code=status.HTTP_201_CREATED)
  77. async def create_group(
  78. group_data: GroupCreate,
  79. _admin: User | None = RequireAdminIfAuthEnabled(),
  80. _: User | None = RequirePermissionIfAuthEnabled(Permission.GROUPS_CREATE),
  81. db: AsyncSession = Depends(get_db),
  82. ):
  83. """Create a new group."""
  84. # Check if group name already exists
  85. existing = await db.execute(select(Group).where(Group.name == group_data.name))
  86. if existing.scalar_one_or_none():
  87. raise HTTPException(
  88. status_code=status.HTTP_400_BAD_REQUEST,
  89. detail="Group name already exists",
  90. )
  91. # Validate permissions
  92. invalid_perms = [p for p in group_data.permissions if p not in ALL_PERMISSIONS]
  93. if invalid_perms:
  94. raise HTTPException(
  95. status_code=status.HTTP_400_BAD_REQUEST,
  96. detail=f"Invalid permissions: {', '.join(invalid_perms)}",
  97. )
  98. group = Group(
  99. name=group_data.name,
  100. description=group_data.description,
  101. permissions=group_data.permissions,
  102. is_system=False, # User-created groups are not system groups
  103. )
  104. db.add(group)
  105. await db.commit()
  106. await db.refresh(group)
  107. return GroupResponse(
  108. id=group.id,
  109. name=group.name,
  110. description=group.description,
  111. permissions=group.permissions or [],
  112. is_system=group.is_system,
  113. user_count=0,
  114. created_at=group.created_at,
  115. updated_at=group.updated_at,
  116. )
  117. @router.get("/{group_id}", response_model=GroupDetailResponse)
  118. async def get_group(
  119. group_id: int,
  120. _: User | None = RequirePermissionIfAuthEnabled(Permission.GROUPS_READ),
  121. db: AsyncSession = Depends(get_db),
  122. ):
  123. """Get a group by ID with user list. Read-only — gated on
  124. ``GROUPS_READ`` only."""
  125. result = await db.execute(select(Group).where(Group.id == group_id).options(selectinload(Group.users)))
  126. group = result.scalar_one_or_none()
  127. if not group:
  128. raise HTTPException(
  129. status_code=status.HTTP_404_NOT_FOUND,
  130. detail="Group not found",
  131. )
  132. return GroupDetailResponse(
  133. id=group.id,
  134. name=group.name,
  135. description=group.description,
  136. permissions=group.permissions or [],
  137. is_system=group.is_system,
  138. user_count=len(group.users),
  139. created_at=group.created_at,
  140. updated_at=group.updated_at,
  141. users=[UserBrief(id=u.id, username=u.username, is_active=u.is_active) for u in group.users],
  142. )
  143. @router.patch("/{group_id}", response_model=GroupResponse)
  144. async def update_group(
  145. group_id: int,
  146. group_data: GroupUpdate,
  147. _admin: User | None = RequireAdminIfAuthEnabled(),
  148. _: User | None = RequirePermissionIfAuthEnabled(Permission.GROUPS_UPDATE),
  149. db: AsyncSession = Depends(get_db),
  150. ):
  151. """Update a group."""
  152. result = await db.execute(select(Group).where(Group.id == group_id).options(selectinload(Group.users)))
  153. group = result.scalar_one_or_none()
  154. if not group:
  155. raise HTTPException(
  156. status_code=status.HTTP_404_NOT_FOUND,
  157. detail="Group not found",
  158. )
  159. # Check if updating name to one that already exists
  160. if group_data.name is not None and group_data.name != group.name:
  161. existing = await db.execute(select(Group).where(Group.name == group_data.name, Group.id != group_id))
  162. if existing.scalar_one_or_none():
  163. raise HTTPException(
  164. status_code=status.HTTP_400_BAD_REQUEST,
  165. detail="Group name already exists",
  166. )
  167. # System groups cannot have their name changed
  168. if group.is_system:
  169. raise HTTPException(
  170. status_code=status.HTTP_400_BAD_REQUEST,
  171. detail="Cannot rename system groups",
  172. )
  173. group.name = group_data.name
  174. if group_data.description is not None:
  175. group.description = group_data.description
  176. if group_data.permissions is not None:
  177. # System groups (Administrators in particular) have fixed permission
  178. # sets that the app depends on — stripping them is a denial-of-
  179. # service vector that even admin callers shouldn't trigger by
  180. # accident through the generic edit form. Mirrors the rename block
  181. # immediately above.
  182. if group.is_system:
  183. raise HTTPException(
  184. status_code=status.HTTP_400_BAD_REQUEST,
  185. detail="Cannot modify permissions of system groups",
  186. )
  187. # Validate permissions
  188. invalid_perms = [p for p in group_data.permissions if p not in ALL_PERMISSIONS]
  189. if invalid_perms:
  190. raise HTTPException(
  191. status_code=status.HTTP_400_BAD_REQUEST,
  192. detail=f"Invalid permissions: {', '.join(invalid_perms)}",
  193. )
  194. group.permissions = group_data.permissions
  195. await db.commit()
  196. await db.refresh(group)
  197. return GroupResponse(
  198. id=group.id,
  199. name=group.name,
  200. description=group.description,
  201. permissions=group.permissions or [],
  202. is_system=group.is_system,
  203. user_count=len(group.users),
  204. created_at=group.created_at,
  205. updated_at=group.updated_at,
  206. )
  207. @router.delete("/{group_id}", status_code=status.HTTP_204_NO_CONTENT)
  208. async def delete_group(
  209. group_id: int,
  210. _admin: User | None = RequireAdminIfAuthEnabled(),
  211. _: User | None = RequirePermissionIfAuthEnabled(Permission.GROUPS_DELETE),
  212. db: AsyncSession = Depends(get_db),
  213. ):
  214. """Delete a group (non-system groups only)."""
  215. result = await db.execute(select(Group).where(Group.id == group_id))
  216. group = result.scalar_one_or_none()
  217. if not group:
  218. raise HTTPException(
  219. status_code=status.HTTP_404_NOT_FOUND,
  220. detail="Group not found",
  221. )
  222. if group.is_system:
  223. raise HTTPException(
  224. status_code=status.HTTP_400_BAD_REQUEST,
  225. detail="Cannot delete system groups",
  226. )
  227. await db.delete(group)
  228. await db.commit()
  229. @router.post("/{group_id}/users/{user_id}", status_code=status.HTTP_204_NO_CONTENT)
  230. async def add_user_to_group(
  231. group_id: int,
  232. user_id: int,
  233. _admin: User | None = RequireAdminIfAuthEnabled(),
  234. _: User | None = RequirePermissionIfAuthEnabled(Permission.GROUPS_UPDATE),
  235. db: AsyncSession = Depends(get_db),
  236. ):
  237. """Add a user to a group."""
  238. # Get group with users
  239. result = await db.execute(select(Group).where(Group.id == group_id).options(selectinload(Group.users)))
  240. group = result.scalar_one_or_none()
  241. if not group:
  242. raise HTTPException(
  243. status_code=status.HTTP_404_NOT_FOUND,
  244. detail="Group not found",
  245. )
  246. # Get user
  247. user_result = await db.execute(select(User).where(User.id == user_id))
  248. user = user_result.scalar_one_or_none()
  249. if not user:
  250. raise HTTPException(
  251. status_code=status.HTTP_404_NOT_FOUND,
  252. detail="User not found",
  253. )
  254. # Check if user is already in group
  255. if user in group.users:
  256. raise HTTPException(
  257. status_code=status.HTTP_400_BAD_REQUEST,
  258. detail="User is already in this group",
  259. )
  260. group.users.append(user)
  261. await db.commit()
  262. @router.delete("/{group_id}/users/{user_id}", status_code=status.HTTP_204_NO_CONTENT)
  263. async def remove_user_from_group(
  264. group_id: int,
  265. user_id: int,
  266. _admin: User | None = RequireAdminIfAuthEnabled(),
  267. _: User | None = RequirePermissionIfAuthEnabled(Permission.GROUPS_UPDATE),
  268. db: AsyncSession = Depends(get_db),
  269. ):
  270. """Remove a user from a group."""
  271. # Get group with users
  272. result = await db.execute(select(Group).where(Group.id == group_id).options(selectinload(Group.users)))
  273. group = result.scalar_one_or_none()
  274. if not group:
  275. raise HTTPException(
  276. status_code=status.HTTP_404_NOT_FOUND,
  277. detail="Group not found",
  278. )
  279. # Get user
  280. user_result = await db.execute(select(User).where(User.id == user_id))
  281. user = user_result.scalar_one_or_none()
  282. if not user:
  283. raise HTTPException(
  284. status_code=status.HTTP_404_NOT_FOUND,
  285. detail="User not found",
  286. )
  287. # Check if user is in group
  288. if user not in group.users:
  289. raise HTTPException(
  290. status_code=status.HTTP_400_BAD_REQUEST,
  291. detail="User is not in this group",
  292. )
  293. group.users.remove(user)
  294. await db.commit()