schema.py 4.4 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697
  1. # -*- coding: utf-8 -*-
  2. import re
  3. from pydantic import BaseModel, ConfigDict, Field, field_validator
  4. from fastapi import Query
  5. from app.core.validator import DateTimeStr
  6. from app.core.base_schema import BaseSchema, UserBySchema
  7. class OperationLogCreateSchema(BaseModel):
  8. """日志创建模型"""
  9. type: int | None = Field(default=None, description="日志类型(1登录日志 2操作日志)")
  10. request_path: str | None = Field(default=None, description="请求路径")
  11. request_method: str | None = Field(default=None, description="请求方法")
  12. request_payload: str | None = Field(default=None, description="请求负载")
  13. request_ip: str | None = Field(default=None, description="请求 IP 地址")
  14. login_location: str | None = Field(default=None, description="登录位置")
  15. request_os: str | None = Field(default=None, description="请求操作系统")
  16. request_browser: str | None = Field(default=None, description="请求浏览器")
  17. response_code: int | None = Field(default=None, description="响应状态码")
  18. response_json: str | None = Field(default=None, description="响应 JSON 数据")
  19. process_time: str | None = Field(default=None, description="处理时间")
  20. status: str = Field(default="0", description="是否成功")
  21. description: str | None = Field(default=None, max_length=255, description="描述")
  22. created_id: int | None = Field(default=None, description="创建人ID")
  23. updated_id: int | None = Field(default=None, description="更新人ID")
  24. @field_validator("type")
  25. @classmethod
  26. def _validate_type(cls, value: int):
  27. if value is None:
  28. return value
  29. if value not in {1, 2}:
  30. raise ValueError("日志类型仅支持 1(登录) 或 2(操作)")
  31. return value
  32. @field_validator("request_method")
  33. @classmethod
  34. def _validate_method(cls, value: str):
  35. if value is None:
  36. return value
  37. allowed = {"GET", "POST", "PUT", "DELETE", "PATCH", "OPTIONS", "HEAD"}
  38. if value.upper() not in allowed:
  39. raise ValueError(f"请求方法必须为 {', '.join(sorted(allowed))}")
  40. return value.upper()
  41. @field_validator("request_ip")
  42. @classmethod
  43. def _validate_ip(cls, value: str | None):
  44. if value is None or value == "":
  45. return value
  46. ipv4 = r"^(25[0-5]|2[0-4]\d|1\d{2}|[1-9]?\d)(\.(25[0-5]|2[0-4]\d|1\d{2}|[1-9]?\d)){3}$"
  47. ipv6 = r"^([0-9a-fA-F]{1,4}:){7}[0-9a-fA-F]{1,4}$"
  48. if not re.match(ipv4, value) and not re.match(ipv6, value):
  49. raise ValueError("请求IP必须为有效的IPv4或IPv6地址")
  50. return value
  51. class OperationLogOutSchema(OperationLogCreateSchema, BaseSchema, UserBySchema):
  52. """日志响应模型"""
  53. model_config = ConfigDict(from_attributes=True)
  54. class OperationLogQueryParam:
  55. """操作日志查询参数"""
  56. def __init__(
  57. self,
  58. type: int | None = Query(None, description="日志类型(1:登录日志, 2:操作日志)"),
  59. request_path: str | None = Query(None, description="请求路径"),
  60. request_method: str | None = Query(None, description="请求方法"),
  61. request_ip: str | None = Query(None, description="请求IP"),
  62. response_code: int | None = Query(None, description="响应状态码"),
  63. created_time: list[DateTimeStr] | None = Query(None, description="创建时间范围", examples=["2025-01-01 00:00:00", "2025-12-31 23:59:59"]),
  64. updated_time: list[DateTimeStr] | None = Query(None, description="更新时间范围", examples=["2025-01-01 00:00:00", "2025-12-31 23:59:59"]),
  65. created_id: int | None = Query(None, description="创建人"),
  66. updated_id: int | None = Query(None, description="更新人"),
  67. ) -> None:
  68. # 模糊查询字段
  69. self.request_path = ("like", f"%{request_path}%") if request_path else None
  70. # 精确查询字段
  71. self.created_id = created_id
  72. self.updated_id = updated_id
  73. self.request_method = request_method
  74. self.request_ip = request_ip
  75. self.response_code = response_code
  76. self.type = type
  77. # 时间范围查询 - 增加对单个时间参数的处理
  78. if created_time and len(created_time) == 2:
  79. self.created_time = ("between", (created_time[0], created_time[1]))
  80. if updated_time and len(updated_time) == 2:
  81. self.updated_time = ("between", (updated_time[0], updated_time[1]))