crud.py 3.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293
  1. # -*- coding: utf-8 -*-
  2. from typing import Sequence, Any
  3. from app.core.base_crud import CRUDBase
  4. from app.api.v1.module_system.auth.schema import AuthSchema
  5. from .model import ApplicationModel
  6. from .schema import ApplicationCreateSchema, ApplicationUpdateSchema
  7. class ApplicationCRUD(CRUDBase[ApplicationModel, ApplicationCreateSchema, ApplicationUpdateSchema]):
  8. """应用系统数据层"""
  9. def __init__(self, auth: AuthSchema) -> None:
  10. """
  11. 初始化应用CRUD
  12. 参数:
  13. - auth (AuthSchema): 认证信息模型
  14. """
  15. self.auth = auth
  16. super().__init__(model=ApplicationModel, auth=auth)
  17. async def get_by_id_crud(self, id: int, preload: list[str | Any] | None = None) -> ApplicationModel | None:
  18. """
  19. 根据id获取应用详情
  20. 参数:
  21. - id (int): 应用ID
  22. - preload (list[str | Any] | None): 预加载关系,未提供时使用模型默认项
  23. 返回:
  24. - ApplicationModel | None: 应用详情,如果不存在则为None
  25. """
  26. return await self.get(id=id, preload=preload)
  27. async def list_crud(self, search: dict[str, Any] | None = None, order_by: list[dict[str, str]] | None = None, preload: list[str | Any] | None = None) -> Sequence[ApplicationModel]:
  28. """
  29. 列表查询应用
  30. 参数:
  31. - search (dict[str, Any] | None): 查询参数,默认None
  32. - order_by (list[dict[str, str]] | None): 排序参数,默认None
  33. - preload (list[str | Any] | None): 预加载关系,未提供时使用模型默认项
  34. 返回:
  35. - Sequence[ApplicationModel]: 应用列表
  36. """
  37. return await self.list(search=search, order_by=order_by, preload=preload)
  38. async def create_crud(self, data: ApplicationCreateSchema) -> ApplicationModel | None:
  39. """
  40. 创建应用
  41. 参数:
  42. - data (ApplicationCreateSchema): 应用创建模型
  43. 返回:
  44. - ApplicationModel | None: 创建的应用详情,如果创建失败则为None
  45. """
  46. return await self.create(data=data)
  47. async def update_crud(self, id: int, data: ApplicationUpdateSchema) -> ApplicationModel | None:
  48. """
  49. 更新应用
  50. 参数:
  51. - id (int): 应用ID
  52. - data (ApplicationUpdateSchema): 应用更新模型
  53. 返回:
  54. - ApplicationModel | None: 更新后的应用详情,如果更新失败则为None
  55. """
  56. return await self.update(id=id, data=data)
  57. async def delete_crud(self, ids: list[int]) -> None:
  58. """
  59. 批量删除应用
  60. 参数:
  61. - ids (list[int]): 应用ID列表
  62. """
  63. return await self.delete(ids=ids)
  64. async def set_available_crud(self, ids: list[int], status: str) -> None:
  65. """
  66. 批量设置可用状态
  67. 参数:
  68. - ids (list[int]): 应用ID列表
  69. - status (str): 可用状态,True为可用,False为不可用
  70. """
  71. return await self.set(ids=ids, status=status)