provider_service.py 3.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108
  1. from typing import List, Optional
  2. from sqlalchemy.ext.asyncio import AsyncSession
  3. from sqlalchemy import select
  4. from sqlalchemy.orm.attributes import flag_modified
  5. from app.core.biz_exception import BizException
  6. from app.models.provider import Provider
  7. from app.schemas.provider import ProviderCreate, ProviderUpdate
  8. class ProviderService:
  9. @classmethod
  10. async def list_providers(
  11. cls,
  12. db: AsyncSession,
  13. enabled_only: bool = False,
  14. ) -> List[Provider]:
  15. stmt = select(Provider)
  16. if enabled_only:
  17. stmt = stmt.where(Provider.enabled == 1)
  18. stmt = stmt.order_by(Provider.name)
  19. result = await db.execute(stmt)
  20. return list(result.scalars().all())
  21. @classmethod
  22. async def get_provider_by_name(
  23. cls,
  24. db: AsyncSession,
  25. name: str,
  26. ) -> Provider:
  27. name = name.strip()
  28. stmt = select(Provider).where(Provider.name == name)
  29. provider = (await db.execute(stmt)).scalar_one_or_none()
  30. if not provider:
  31. raise BizException(
  32. code=40400,
  33. message=f"Provider '{name}' not found",
  34. http_status=404,
  35. )
  36. return provider
  37. @classmethod
  38. async def create_provider(
  39. cls,
  40. db: AsyncSession,
  41. payload: ProviderCreate,
  42. operator: str = "system",
  43. ) -> Provider:
  44. name = payload.name.strip()
  45. # Check duplicate name
  46. stmt = select(Provider).where(Provider.name == name)
  47. existing = (await db.execute(stmt)).scalar_one_or_none()
  48. if existing:
  49. raise BizException(
  50. code=40900,
  51. message=f"Provider name '{name}' already exists",
  52. http_status=409,
  53. )
  54. provider = Provider(
  55. name=name,
  56. enabled=1 if payload.enabled else 0,
  57. plugin_config=payload.plugin_config or {},
  58. role_templates=payload.role_templates or {},
  59. version=1,
  60. updated_by=operator,
  61. )
  62. db.add(provider)
  63. await db.commit()
  64. await db.refresh(provider)
  65. return provider
  66. @classmethod
  67. async def update_provider(
  68. cls,
  69. db: AsyncSession,
  70. name: str,
  71. payload: ProviderUpdate,
  72. operator: str = "system",
  73. ) -> Provider:
  74. provider = await cls.get_provider_by_name(db, name)
  75. if payload.enabled is not None:
  76. provider.enabled = 1 if payload.enabled else 0
  77. if payload.plugin_config is not None:
  78. provider.plugin_config = payload.plugin_config
  79. flag_modified(provider, "plugin_config")
  80. if payload.role_templates is not None:
  81. provider.role_templates = payload.role_templates
  82. flag_modified(provider, "role_templates")
  83. provider.version = (provider.version or 0) + 1
  84. provider.updated_by = operator
  85. await db.commit()
  86. await db.refresh(provider)
  87. return provider
  88. @classmethod
  89. async def delete_provider(
  90. cls,
  91. db: AsyncSession,
  92. name: str,
  93. ) -> bool:
  94. provider = await cls.get_provider_by_name(db, name)
  95. await db.delete(provider)
  96. await db.commit()
  97. return True