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