groups.py 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316
  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 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. _: User | None = RequirePermissionIfAuthEnabled(Permission.GROUPS_CREATE),
  80. db: AsyncSession = Depends(get_db),
  81. ):
  82. """Create a new group."""
  83. # Check if group name already exists
  84. existing = await db.execute(select(Group).where(Group.name == group_data.name))
  85. if existing.scalar_one_or_none():
  86. raise HTTPException(
  87. status_code=status.HTTP_400_BAD_REQUEST,
  88. detail="Group name already exists",
  89. )
  90. # Validate permissions
  91. invalid_perms = [p for p in group_data.permissions if p not in ALL_PERMISSIONS]
  92. if invalid_perms:
  93. raise HTTPException(
  94. status_code=status.HTTP_400_BAD_REQUEST,
  95. detail=f"Invalid permissions: {', '.join(invalid_perms)}",
  96. )
  97. group = Group(
  98. name=group_data.name,
  99. description=group_data.description,
  100. permissions=group_data.permissions,
  101. is_system=False, # User-created groups are not system groups
  102. )
  103. db.add(group)
  104. await db.commit()
  105. await db.refresh(group)
  106. return GroupResponse(
  107. id=group.id,
  108. name=group.name,
  109. description=group.description,
  110. permissions=group.permissions or [],
  111. is_system=group.is_system,
  112. user_count=0,
  113. created_at=group.created_at,
  114. updated_at=group.updated_at,
  115. )
  116. @router.get("/{group_id}", response_model=GroupDetailResponse)
  117. async def get_group(
  118. group_id: int,
  119. _: User | None = RequirePermissionIfAuthEnabled(Permission.GROUPS_READ),
  120. db: AsyncSession = Depends(get_db),
  121. ):
  122. """Get a group by ID with user list."""
  123. result = await db.execute(select(Group).where(Group.id == group_id).options(selectinload(Group.users)))
  124. group = result.scalar_one_or_none()
  125. if not group:
  126. raise HTTPException(
  127. status_code=status.HTTP_404_NOT_FOUND,
  128. detail="Group not found",
  129. )
  130. return GroupDetailResponse(
  131. id=group.id,
  132. name=group.name,
  133. description=group.description,
  134. permissions=group.permissions or [],
  135. is_system=group.is_system,
  136. user_count=len(group.users),
  137. created_at=group.created_at,
  138. updated_at=group.updated_at,
  139. users=[UserBrief(id=u.id, username=u.username, is_active=u.is_active) for u in group.users],
  140. )
  141. @router.patch("/{group_id}", response_model=GroupResponse)
  142. async def update_group(
  143. group_id: int,
  144. group_data: GroupUpdate,
  145. _: User | None = RequirePermissionIfAuthEnabled(Permission.GROUPS_UPDATE),
  146. db: AsyncSession = Depends(get_db),
  147. ):
  148. """Update a group."""
  149. result = await db.execute(select(Group).where(Group.id == group_id).options(selectinload(Group.users)))
  150. group = result.scalar_one_or_none()
  151. if not group:
  152. raise HTTPException(
  153. status_code=status.HTTP_404_NOT_FOUND,
  154. detail="Group not found",
  155. )
  156. # Check if updating name to one that already exists
  157. if group_data.name is not None and group_data.name != group.name:
  158. existing = await db.execute(select(Group).where(Group.name == group_data.name, Group.id != group_id))
  159. if existing.scalar_one_or_none():
  160. raise HTTPException(
  161. status_code=status.HTTP_400_BAD_REQUEST,
  162. detail="Group name already exists",
  163. )
  164. # System groups cannot have their name changed
  165. if group.is_system:
  166. raise HTTPException(
  167. status_code=status.HTTP_400_BAD_REQUEST,
  168. detail="Cannot rename system groups",
  169. )
  170. group.name = group_data.name
  171. if group_data.description is not None:
  172. group.description = group_data.description
  173. if group_data.permissions is not None:
  174. # Validate permissions
  175. invalid_perms = [p for p in group_data.permissions if p not in ALL_PERMISSIONS]
  176. if invalid_perms:
  177. raise HTTPException(
  178. status_code=status.HTTP_400_BAD_REQUEST,
  179. detail=f"Invalid permissions: {', '.join(invalid_perms)}",
  180. )
  181. group.permissions = group_data.permissions
  182. await db.commit()
  183. await db.refresh(group)
  184. return GroupResponse(
  185. id=group.id,
  186. name=group.name,
  187. description=group.description,
  188. permissions=group.permissions or [],
  189. is_system=group.is_system,
  190. user_count=len(group.users),
  191. created_at=group.created_at,
  192. updated_at=group.updated_at,
  193. )
  194. @router.delete("/{group_id}", status_code=status.HTTP_204_NO_CONTENT)
  195. async def delete_group(
  196. group_id: int,
  197. _: User | None = RequirePermissionIfAuthEnabled(Permission.GROUPS_DELETE),
  198. db: AsyncSession = Depends(get_db),
  199. ):
  200. """Delete a group (non-system groups only)."""
  201. result = await db.execute(select(Group).where(Group.id == group_id))
  202. group = result.scalar_one_or_none()
  203. if not group:
  204. raise HTTPException(
  205. status_code=status.HTTP_404_NOT_FOUND,
  206. detail="Group not found",
  207. )
  208. if group.is_system:
  209. raise HTTPException(
  210. status_code=status.HTTP_400_BAD_REQUEST,
  211. detail="Cannot delete system groups",
  212. )
  213. await db.delete(group)
  214. await db.commit()
  215. @router.post("/{group_id}/users/{user_id}", status_code=status.HTTP_204_NO_CONTENT)
  216. async def add_user_to_group(
  217. group_id: int,
  218. user_id: int,
  219. _: User | None = RequirePermissionIfAuthEnabled(Permission.GROUPS_UPDATE),
  220. db: AsyncSession = Depends(get_db),
  221. ):
  222. """Add a user to a group."""
  223. # Get group with users
  224. result = await db.execute(select(Group).where(Group.id == group_id).options(selectinload(Group.users)))
  225. group = result.scalar_one_or_none()
  226. if not group:
  227. raise HTTPException(
  228. status_code=status.HTTP_404_NOT_FOUND,
  229. detail="Group not found",
  230. )
  231. # Get user
  232. user_result = await db.execute(select(User).where(User.id == user_id))
  233. user = user_result.scalar_one_or_none()
  234. if not user:
  235. raise HTTPException(
  236. status_code=status.HTTP_404_NOT_FOUND,
  237. detail="User not found",
  238. )
  239. # Check if user is already in group
  240. if user in group.users:
  241. raise HTTPException(
  242. status_code=status.HTTP_400_BAD_REQUEST,
  243. detail="User is already in this group",
  244. )
  245. group.users.append(user)
  246. await db.commit()
  247. @router.delete("/{group_id}/users/{user_id}", status_code=status.HTTP_204_NO_CONTENT)
  248. async def remove_user_from_group(
  249. group_id: int,
  250. user_id: int,
  251. _: User | None = RequirePermissionIfAuthEnabled(Permission.GROUPS_UPDATE),
  252. db: AsyncSession = Depends(get_db),
  253. ):
  254. """Remove a user from a group."""
  255. # Get group with users
  256. result = await db.execute(select(Group).where(Group.id == group_id).options(selectinload(Group.users)))
  257. group = result.scalar_one_or_none()
  258. if not group:
  259. raise HTTPException(
  260. status_code=status.HTTP_404_NOT_FOUND,
  261. detail="Group not found",
  262. )
  263. # Get user
  264. user_result = await db.execute(select(User).where(User.id == user_id))
  265. user = user_result.scalar_one_or_none()
  266. if not user:
  267. raise HTTPException(
  268. status_code=status.HTTP_404_NOT_FOUND,
  269. detail="User not found",
  270. )
  271. # Check if user is in group
  272. if user not in group.users:
  273. raise HTTPException(
  274. status_code=status.HTTP_400_BAD_REQUEST,
  275. detail="User is not in this group",
  276. )
  277. group.users.remove(user)
  278. await db.commit()