| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108 |
- from typing import List, Optional
- from sqlalchemy.ext.asyncio import AsyncSession
- from sqlalchemy import select
- from sqlalchemy.orm.attributes import flag_modified
- from app.core.biz_exception import BizException
- from app.models.provider import Provider
- from app.schemas.provider import ProviderCreate, ProviderUpdate
- class ProviderService:
- @classmethod
- async def list_providers(
- cls,
- db: AsyncSession,
- enabled_only: bool = False,
- ) -> List[Provider]:
- stmt = select(Provider)
- if enabled_only:
- stmt = stmt.where(Provider.enabled == 1)
- stmt = stmt.order_by(Provider.name)
- result = await db.execute(stmt)
- return list(result.scalars().all())
- @classmethod
- async def get_provider_by_name(
- cls,
- db: AsyncSession,
- name: str,
- ) -> Provider:
- name = name.strip()
- stmt = select(Provider).where(Provider.name == name)
- provider = (await db.execute(stmt)).scalar_one_or_none()
- if not provider:
- raise BizException(
- code=40400,
- message=f"Provider '{name}' not found",
- http_status=404,
- )
- return provider
- @classmethod
- async def create_provider(
- cls,
- db: AsyncSession,
- payload: ProviderCreate,
- operator: str = "system",
- ) -> Provider:
- name = payload.name.strip()
- # Check duplicate name
- stmt = select(Provider).where(Provider.name == name)
- existing = (await db.execute(stmt)).scalar_one_or_none()
- if existing:
- raise BizException(
- code=40900,
- message=f"Provider name '{name}' already exists",
- http_status=409,
- )
- provider = Provider(
- name=name,
- enabled=1 if payload.enabled else 0,
- plugin_config=payload.plugin_config or {},
- role_templates=payload.role_templates or {},
- version=1,
- updated_by=operator,
- )
- db.add(provider)
- await db.commit()
- await db.refresh(provider)
- return provider
- @classmethod
- async def update_provider(
- cls,
- db: AsyncSession,
- name: str,
- payload: ProviderUpdate,
- operator: str = "system",
- ) -> Provider:
- provider = await cls.get_provider_by_name(db, name)
- if payload.enabled is not None:
- provider.enabled = 1 if payload.enabled else 0
- if payload.plugin_config is not None:
- provider.plugin_config = payload.plugin_config
- flag_modified(provider, "plugin_config")
- if payload.role_templates is not None:
- provider.role_templates = payload.role_templates
- flag_modified(provider, "role_templates")
- provider.version = (provider.version or 0) + 1
- provider.updated_by = operator
- await db.commit()
- await db.refresh(provider)
- return provider
- @classmethod
- async def delete_provider(
- cls,
- db: AsyncSession,
- name: str,
- ) -> bool:
- provider = await cls.get_provider_by_name(db, name)
- await db.delete(provider)
- await db.commit()
- return True
|