schema.py 5.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117
  1. import re
  2. from fastapi import Query
  3. from pydantic import BaseModel, ConfigDict, Field, field_validator
  4. from app.common.enums import QueueEnum
  5. from app.core.base_schema import BaseSchema, UserBySchema
  6. from app.core.validator import DateTimeStr
  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. description: str | None = Query(None, description="描述"),
  64. status: str | None = Query(None, description="是否启用"),
  65. created_time: list[DateTimeStr] | None = Query(
  66. None,
  67. description="创建时间范围",
  68. examples=["2025-01-01 00:00:00", "2025-12-31 23:59:59"],
  69. ),
  70. updated_time: list[DateTimeStr] | None = Query(
  71. None,
  72. description="更新时间范围",
  73. examples=["2025-01-01 00:00:00", "2025-12-31 23:59:59"],
  74. ),
  75. created_id: int | None = Query(None, description="创建人"),
  76. updated_id: int | None = Query(None, description="更新人"),
  77. ) -> None:
  78. # 模糊查询字段
  79. self.request_path = (QueueEnum.like.value, request_path)
  80. # 精确查询字段
  81. self.request_method = (QueueEnum.eq.value, request_method)
  82. self.request_ip = (QueueEnum.eq.value, request_ip)
  83. self.response_code = (QueueEnum.eq.value, response_code)
  84. self.type = (QueueEnum.eq.value, type)
  85. # 模糊查询字段
  86. if description:
  87. self.description = (QueueEnum.like.value, description)
  88. # 精确查询字段
  89. if status:
  90. self.status = (QueueEnum.eq.value, status)
  91. # 时间范围查询
  92. if created_time and len(created_time) == 2:
  93. self.created_time = (QueueEnum.between.value, (created_time[0], created_time[1]))
  94. if updated_time and len(updated_time) == 2:
  95. self.updated_time = (QueueEnum.between.value, (updated_time[0], updated_time[1]))
  96. # 关联查询字段
  97. if created_id:
  98. self.created_id = (QueueEnum.eq.value, created_id)
  99. if updated_id:
  100. self.updated_id = (QueueEnum.eq.value, updated_id)