proxy_pool_tools.py 5.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157
  1. # app/services/agent/tools/builtin/proxy_pool_tools.py
  2. from typing import Optional, Dict, Any, List
  3. from sqlalchemy.ext.asyncio import AsyncSession
  4. from sqlalchemy import select, func, desc
  5. from app.models.user import VasUser
  6. from app.models.proxy_pool import ProxyPool
  7. from app.services.agent.tools.registry import agent_tool
  8. ADMIN_CHECK_MSG = "权限不足:该运维操作仅系统管理员(admin)可执行"
  9. @agent_tool(
  10. name="get_proxy_pool_stats",
  11. description="按所属代理池统计代理总数、可用状态(active/disable)及可用就绪比例(管理员专有)",
  12. )
  13. async def get_proxy_pool_stats(
  14. pool_name: Optional[str] = None,
  15. *,
  16. db: AsyncSession,
  17. current_user: VasUser,
  18. ) -> Dict[str, Any]:
  19. """统计代理池健康指标"""
  20. if current_user.role != "admin":
  21. return {"error": ADMIN_CHECK_MSG}
  22. try:
  23. stmt = select(
  24. ProxyPool.pool_name,
  25. ProxyPool.status,
  26. func.count(ProxyPool.id).label("count"),
  27. ).group_by(ProxyPool.pool_name, ProxyPool.status)
  28. if pool_name and pool_name.strip():
  29. stmt = stmt.where(ProxyPool.pool_name == pool_name.strip())
  30. res = await db.execute(stmt)
  31. rows = res.all()
  32. pools_summary: Dict[str, Dict[str, int]] = {}
  33. total_proxies = 0
  34. for r_pool, r_status, r_count in rows:
  35. if r_pool not in pools_summary:
  36. pools_summary[r_pool] = {"total": 0, "active": 0, "disable": 0}
  37. pools_summary[r_pool]["total"] += r_count
  38. if r_status == "active":
  39. pools_summary[r_pool]["active"] += r_count
  40. elif r_status == "disable":
  41. pools_summary[r_pool]["disable"] += r_count
  42. total_proxies += r_count
  43. return {
  44. "total_proxies": total_proxies,
  45. "pools_count": len(pools_summary),
  46. "pools": pools_summary,
  47. }
  48. except Exception as e:
  49. return {"error": f"统计代理池失败: {str(e)}"}
  50. @agent_tool(
  51. name="list_proxies",
  52. description="查询代理池中的代理列表,支持按代理池名与状态筛选(管理员专有)",
  53. )
  54. async def list_proxies(
  55. pool_name: Optional[str] = None,
  56. status: Optional[str] = None,
  57. page: int = 1,
  58. page_size: int = 20,
  59. *,
  60. db: AsyncSession,
  61. current_user: VasUser,
  62. ) -> Dict[str, Any]:
  63. """查询代理列表"""
  64. if current_user.role != "admin":
  65. return {"error": ADMIN_CHECK_MSG}
  66. try:
  67. stmt = select(ProxyPool)
  68. if pool_name and pool_name.strip():
  69. stmt = stmt.where(ProxyPool.pool_name == pool_name.strip())
  70. if status and status.strip():
  71. stmt = stmt.where(ProxyPool.status == status.strip().lower())
  72. page = max(1, page)
  73. page_size = min(page_size, 50)
  74. stmt = stmt.order_by(desc(ProxyPool.id)).offset((page - 1) * page_size).limit(page_size)
  75. res = await db.execute(stmt)
  76. proxies = res.scalars().all()
  77. items = []
  78. for p in proxies:
  79. # 遮蔽 IP 末段保护安全
  80. ip_parts = p.ip.split(".")
  81. masked_ip = ".".join(ip_parts[:2] + ["*", "*"]) if len(ip_parts) == 4 else p.ip[:8] + "***"
  82. items.append({
  83. "id": p.id,
  84. "pool_name": p.pool_name,
  85. "proto": p.proto,
  86. "masked_ip": masked_ip,
  87. "port": p.port,
  88. "status": p.status,
  89. "next_use_time": p.next_use_time.strftime("%Y-%m-%d %H:%M:%S") if p.next_use_time else None,
  90. "time_zone": p.time_zone,
  91. })
  92. return {
  93. "count": len(items),
  94. "page": page,
  95. "proxies": items,
  96. }
  97. except Exception as e:
  98. return {"error": f"获取代理列表失败: {str(e)}"}
  99. @agent_tool(
  100. name="toggle_proxy_status",
  101. description="将指定代理设置为 active(启用)或 disable(禁用)(管理员专有)",
  102. is_dangerous=True,
  103. )
  104. async def toggle_proxy_status(
  105. proxy_id: int,
  106. status: str,
  107. *,
  108. db: AsyncSession,
  109. current_user: VasUser,
  110. ) -> Dict[str, Any]:
  111. """启停单个代理"""
  112. if current_user.role != "admin":
  113. return {"error": ADMIN_CHECK_MSG}
  114. clean_status = status.strip().lower()
  115. if clean_status not in ("active", "disable"):
  116. return {"error": f"无效状态: '{status}',仅支持 'active' 或 'disable'"}
  117. try:
  118. stmt = select(ProxyPool).where(ProxyPool.id == proxy_id)
  119. proxy = (await db.execute(stmt)).scalar_one_or_none()
  120. if not proxy:
  121. return {"error": f"代理 ID #{proxy_id} 不存在"}
  122. proxy.status = clean_status
  123. await db.commit()
  124. await db.refresh(proxy)
  125. return {
  126. "success": True,
  127. "proxy_id": proxy.id,
  128. "pool_name": proxy.pool_name,
  129. "new_status": proxy.status,
  130. "message": f"代理 #{proxy_id} 状态已更新为 {clean_status}",
  131. }
  132. except Exception as e:
  133. return {"error": f"更新代理状态失败: {str(e)}"}