# app/services/agent/tools/builtin/proxy_pool_tools.py from typing import Optional, Dict, Any, List from sqlalchemy.ext.asyncio import AsyncSession from sqlalchemy import select, func, desc from app.models.user import VasUser from app.models.proxy_pool import ProxyPool from app.services.agent.tools.registry import agent_tool ADMIN_CHECK_MSG = "权限不足:该运维操作仅系统管理员(admin)可执行" @agent_tool( name="get_proxy_pool_stats", description="按所属代理池统计代理总数、可用状态(active/disable)及可用就绪比例(管理员专有)", ) async def get_proxy_pool_stats( pool_name: Optional[str] = None, *, db: AsyncSession, current_user: VasUser, ) -> Dict[str, Any]: """统计代理池健康指标""" if current_user.role != "admin": return {"error": ADMIN_CHECK_MSG} try: stmt = select( ProxyPool.pool_name, ProxyPool.status, func.count(ProxyPool.id).label("count"), ).group_by(ProxyPool.pool_name, ProxyPool.status) if pool_name and pool_name.strip(): stmt = stmt.where(ProxyPool.pool_name == pool_name.strip()) res = await db.execute(stmt) rows = res.all() pools_summary: Dict[str, Dict[str, int]] = {} total_proxies = 0 for r_pool, r_status, r_count in rows: if r_pool not in pools_summary: pools_summary[r_pool] = {"total": 0, "active": 0, "disable": 0} pools_summary[r_pool]["total"] += r_count if r_status == "active": pools_summary[r_pool]["active"] += r_count elif r_status == "disable": pools_summary[r_pool]["disable"] += r_count total_proxies += r_count return { "total_proxies": total_proxies, "pools_count": len(pools_summary), "pools": pools_summary, } except Exception as e: return {"error": f"统计代理池失败: {str(e)}"} @agent_tool( name="list_proxies", description="查询代理池中的代理列表,支持按代理池名与状态筛选(管理员专有)", ) async def list_proxies( pool_name: Optional[str] = None, status: Optional[str] = None, page: int = 1, page_size: int = 20, *, db: AsyncSession, current_user: VasUser, ) -> Dict[str, Any]: """查询代理列表""" if current_user.role != "admin": return {"error": ADMIN_CHECK_MSG} try: stmt = select(ProxyPool) if pool_name and pool_name.strip(): stmt = stmt.where(ProxyPool.pool_name == pool_name.strip()) if status and status.strip(): stmt = stmt.where(ProxyPool.status == status.strip().lower()) page = max(1, page) page_size = min(page_size, 50) stmt = stmt.order_by(desc(ProxyPool.id)).offset((page - 1) * page_size).limit(page_size) res = await db.execute(stmt) proxies = res.scalars().all() items = [] for p in proxies: # 遮蔽 IP 末段保护安全 ip_parts = p.ip.split(".") masked_ip = ".".join(ip_parts[:2] + ["*", "*"]) if len(ip_parts) == 4 else p.ip[:8] + "***" items.append({ "id": p.id, "pool_name": p.pool_name, "proto": p.proto, "masked_ip": masked_ip, "port": p.port, "status": p.status, "next_use_time": p.next_use_time.strftime("%Y-%m-%d %H:%M:%S") if p.next_use_time else None, "time_zone": p.time_zone, }) return { "count": len(items), "page": page, "proxies": items, } except Exception as e: return {"error": f"获取代理列表失败: {str(e)}"} @agent_tool( name="toggle_proxy_status", description="将指定代理设置为 active(启用)或 disable(禁用)(管理员专有)", is_dangerous=True, ) async def toggle_proxy_status( proxy_id: int, status: str, *, db: AsyncSession, current_user: VasUser, ) -> Dict[str, Any]: """启停单个代理""" if current_user.role != "admin": return {"error": ADMIN_CHECK_MSG} clean_status = status.strip().lower() if clean_status not in ("active", "disable"): return {"error": f"无效状态: '{status}',仅支持 'active' 或 'disable'"} try: stmt = select(ProxyPool).where(ProxyPool.id == proxy_id) proxy = (await db.execute(stmt)).scalar_one_or_none() if not proxy: return {"error": f"代理 ID #{proxy_id} 不存在"} proxy.status = clean_status await db.commit() await db.refresh(proxy) return { "success": True, "proxy_id": proxy.id, "pool_name": proxy.pool_name, "new_status": proxy.status, "message": f"代理 #{proxy_id} 状态已更新为 {clean_status}", } except Exception as e: return {"error": f"更新代理状态失败: {str(e)}"}