Download agy2api/src/panel/usage_logs.py from a3216/ds2api: direct link, hf CLI and curl.
- Browser
- Download file 6.65 kB
-
https://huggingface.co/spaces/a3216/ds2api/resolve/main/agy2api/src/panel/usage_logs.py
- Command line
-
hf download hf://spaces/a3216/ds2api/agy2api/src/panel/usage_logs.py
-
curl -L -o usage_logs.py https://huggingface.co/spaces/a3216/ds2api/resolve/main/agy2api/src/panel/usage_logs.py
6.65 kB
| """ | |
| 请求日志路由模块 - 处理 /usage-logs/* 相关的HTTP请求 | |
| 查询 usage_log 表:分页列表、聚合统计、清理、请求体详细日志读取 | |
| """ | |
| import asyncio | |
| import time | |
| from typing import Optional | |
| from fastapi import APIRouter, Depends, HTTPException | |
| from fastapi.responses import JSONResponse | |
| from sqlalchemy import text | |
| from config import get_usage_log_enabled | |
| from log import log | |
| from src.request_body_log import clear_request_body_logs, read_request_body_log | |
| from src.storage.database import UsageLog, get_database | |
| from src.usage_log import clear_usage_logs, flush_usage_logs | |
| from src.utils import verify_panel_token | |
| # 创建路由器 | |
| router = APIRouter(prefix="/usage-logs", tags=["usage-logs"]) | |
| async def get_usage_logs( | |
| token: str = Depends(verify_panel_token), | |
| offset: int = 0, | |
| limit: int = 50, | |
| start_timestamp: Optional[float] = None, | |
| end_timestamp: Optional[float] = None, | |
| model_name: str = "", | |
| credential_email: str = "", | |
| api_format: str = "", | |
| status: str = "all", | |
| is_stream: Optional[bool] = None, | |
| status_code: Optional[int] = None, | |
| ): | |
| """分页查询请求日志(新 -> 旧)""" | |
| try: | |
| if limit < 1 or limit > 1000: | |
| raise HTTPException(status_code=400, detail="limit 必须在 1-1000 之间") | |
| if offset < 0: | |
| raise HTTPException(status_code=400, detail="offset 不能为负数") | |
| database = await get_database() | |
| # 批量写队列中的待落库日志先刷盘,保证面板看到最新数据 | |
| await flush_usage_logs() | |
| items, total = await database.query_usage_logs( | |
| offset=offset, | |
| limit=limit, | |
| start_timestamp=start_timestamp, | |
| end_timestamp=end_timestamp, | |
| model_name=model_name.strip(), | |
| credential_email=credential_email.strip(), | |
| api_format=api_format.strip(), | |
| status=status, | |
| is_stream=is_stream, | |
| status_code=status_code, | |
| ) | |
| return JSONResponse(content={"items": items, "total": total}) | |
| except HTTPException: | |
| raise | |
| except Exception as e: | |
| log.error(f"查询请求日志失败: {e}") | |
| raise HTTPException(status_code=500, detail=str(e)) | |
| async def get_usage_stats( | |
| token: str = Depends(verify_panel_token), | |
| start_timestamp: Optional[float] = None, | |
| end_timestamp: Optional[float] = None, | |
| model_name: str = "", | |
| credential_email: str = "", | |
| api_format: str = "", | |
| ): | |
| """聚合统计:请求数 / 成功失败 / token 汇总 / 平均耗时 / 每模型分布""" | |
| try: | |
| database = await get_database() | |
| # 批量写队列中的待落库日志先刷盘,保证统计完整 | |
| await flush_usage_logs() | |
| stats = await database.usage_log_stats( | |
| start_timestamp=start_timestamp, | |
| end_timestamp=end_timestamp, | |
| model_name=model_name.strip(), | |
| credential_email=credential_email.strip(), | |
| api_format=api_format.strip(), | |
| ) | |
| return JSONResponse(content=stats) | |
| except Exception as e: | |
| log.error(f"查询日志统计失败: {e}") | |
| raise HTTPException(status_code=500, detail=str(e)) | |
| async def clear_logs( | |
| token: str = Depends(verify_panel_token), | |
| days: int = 30, | |
| ): | |
| """清理 N 天前的日志,返回删除条数""" | |
| try: | |
| if days < 0: | |
| raise HTTPException(status_code=400, detail="天数不能为负数") | |
| if days == 0: | |
| # 0 = 删除所有(cutoff = now),同步清空请求体详细日志文件 | |
| deleted = await clear_usage_logs(0) | |
| files_deleted = await asyncio.to_thread(clear_request_body_logs) | |
| return JSONResponse(content={ | |
| "message": "已清理全部日志", | |
| "deleted": deleted, | |
| "files_deleted": files_deleted, | |
| }) | |
| deleted = await clear_usage_logs(days) | |
| # 同步删除 N 天前的请求体详细日志文件 | |
| files_deleted = await asyncio.to_thread( | |
| clear_request_body_logs, time.time() - days * 86400 | |
| ) | |
| return JSONResponse(content={ | |
| "message": f"已清理 {days} 天前的日志", | |
| "deleted": deleted, | |
| "files_deleted": files_deleted, | |
| }) | |
| except HTTPException: | |
| raise | |
| except Exception as e: | |
| log.error(f"清理日志失败: {e}") | |
| raise HTTPException(status_code=500, detail=str(e)) | |
| async def truncate_logs(token: str = Depends(verify_panel_token)): | |
| """清空日志:直接 DROP 整张 usage_log 表并重建,不留任何残留""" | |
| try: | |
| database = await get_database() | |
| # 先刷掉批量写队列中的待落库日志 | |
| await flush_usage_logs() | |
| # 先统计当前条数用于返回 | |
| _, total = await database.query_usage_logs(offset=0, limit=1) | |
| async with database.session() as s: | |
| await s.execute(text(f"DROP TABLE IF EXISTS {UsageLog.__tablename__}")) | |
| # 重新建表(走统一的建表逻辑,保证结构最新) | |
| async with database._engine.begin() as conn: | |
| await conn.run_sync(database._create_tables) | |
| # 同步清空全部请求体详细日志文件 | |
| files_deleted = await asyncio.to_thread(clear_request_body_logs) | |
| return JSONResponse(content={ | |
| "message": "已清空全部日志(表已重建)", | |
| "deleted": total, | |
| "files_deleted": files_deleted, | |
| }) | |
| except Exception as e: | |
| log.error(f"清空日志失败: {e}") | |
| raise HTTPException(status_code=500, detail=str(e)) | |
| async def get_request_body_log( | |
| path: str, | |
| token: str = Depends(verify_panel_token), | |
| ): | |
| """按文件索引从磁盘读取请求体详细日志(JSON)""" | |
| try: | |
| data = await asyncio.to_thread(read_request_body_log, path) | |
| if data is None: | |
| raise HTTPException(status_code=404, detail="详细日志文件不存在或已清理") | |
| return JSONResponse(content=data) | |
| except HTTPException: | |
| raise | |
| except Exception as e: | |
| log.error(f"读取请求体详细日志失败: {e}") | |
| raise HTTPException(status_code=500, detail=str(e)) | |
| async def get_usage_log_config(token: str = Depends(verify_panel_token)): | |
| """获取日志开关配置""" | |
| return JSONResponse(content={ | |
| "enabled": await get_usage_log_enabled(), | |
| }) | |