schema.py 3.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293
  1. # -*- coding: utf-8 -*-
  2. from pydantic import BaseModel, ConfigDict, Field, PlainSerializer
  3. from fastapi import Query
  4. from decimal import Decimal
  5. from app.core.validator import DateTimeStr
  6. from app.core.base_schema import BaseSchema, UserBySchema
  7. from typing import Annotated
  8. # 定义通用的Decimal序列化类型:转为字符串(全局复用)
  9. # 若需转浮点数,把 lambda v: str(v) 改为 lambda v: float(v)
  10. DecimalStr = Annotated[
  11. Decimal,
  12. PlainSerializer(
  13. func=lambda v: str(v), # Decimal -> 字符串(如 Decimal("100.50") → "100.50")
  14. return_type=str,
  15. when_used="always" # 始终应用该序列化规则
  16. )
  17. ]
  18. class BizCraneCreateSchema(BaseModel):
  19. """
  20. 行车信息新增模型
  21. """
  22. crane_name: str = Field(default=..., description='行车名称')
  23. crane_no: str = Field(default=..., description='行车编号')
  24. crane_model: str = Field(default=..., description='行车型号')
  25. work_span: DecimalStr = Field(default=..., description='工作跨度')
  26. work_height: DecimalStr = Field(default=..., description='工作高度')
  27. ip_address: str = Field(default=..., description='ip地址')
  28. order: int = Field(default=..., description='排序')
  29. status: str = Field(default="1", description='是否启用(0:禁用 1:启用)')
  30. description: str | None = Field(default=None, max_length=255, description='备注/描述')
  31. class BizCraneUpdateSchema(BizCraneCreateSchema):
  32. """
  33. 行车信息更新模型
  34. """
  35. ...
  36. class BizCraneOutSchema(BizCraneCreateSchema, BaseSchema, UserBySchema):
  37. """
  38. 行车信息响应模型
  39. """
  40. model_config = ConfigDict(from_attributes=True)
  41. class BizCraneQueryParam:
  42. """行车信息查询参数"""
  43. def __init__(
  44. self,
  45. crane_name: str | None = Query(None, description="行车名称"),
  46. crane_no: str | None = Query(None, description="行车编号"),
  47. crane_model: str | None = Query(None, description="行车型号"),
  48. ip_address: str | None = Query(None, description="ip地址"),
  49. status: str | None = Query(None, description="是否启用(0:启用 1:禁用)"),
  50. work_span: Decimal | None = Query(None, description="工作跨度"),
  51. work_height: Decimal | None = Query(None, description="工作高度"),
  52. order: int | None = Query(None, description="排序"),
  53. created_id: int | None = Query(None, description="创建人ID"),
  54. updated_id: int | None = Query(None, description="更新人ID"),
  55. created_time: list[DateTimeStr] | None = Query(None, description="创建时间范围", examples=["2025-01-01 00:00:00", "2025-12-31 23:59:59"]),
  56. updated_time: list[DateTimeStr] | None = Query(None, description="更新时间范围", examples=["2025-01-01 00:00:00", "2025-12-31 23:59:59"]),
  57. ) -> None:
  58. # 模糊查询字段
  59. self.crane_name = ("like", crane_name)
  60. # 模糊查询字段
  61. self.crane_no = ("like", crane_no)
  62. # 模糊查询字段
  63. self.crane_model = ("like", crane_model)
  64. # 精确查询字段
  65. self.work_span = work_span
  66. # 精确查询字段
  67. self.work_height = work_height
  68. # 模糊查询字段
  69. self.ip_address = ("like", ip_address)
  70. # 精确查询字段
  71. self.order = order
  72. # 模糊查询字段
  73. self.status = ("like", status)
  74. # 精确查询字段
  75. self.created_id = created_id
  76. # 精确查询字段
  77. self.updated_id = updated_id
  78. # 时间范围查询
  79. if created_time and len(created_time) == 2:
  80. self.created_time = ("between", (created_time[0], created_time[1]))
  81. if updated_time and len(updated_time) == 2:
  82. self.updated_time = ("between", (updated_time[0], updated_time[1]))