fc / apps /automation /models /token.py
jun2024's picture
Upload 2241 files
b4f2238 verified
Raw History Blame Contribute Delete
6.69 kB
"""Token 管理相关模型"""
from __future__ import annotations
from typing import Any, ClassVar
from django.db import models
from django.utils.translation import gettext_lazy as _
class CourtToken(models.Model):
"""人民法院在线服务网(一张网)/保全系统 Token 存储"""
id: int
site_name: models.CharField = models.CharField(
max_length=128,
verbose_name=_("站点标识"),
help_text=_("如:court_zxfw(人民法院在线服务网/一张网), court_baoquan(保全系统)"),
)
account: models.CharField = models.CharField(max_length=128, verbose_name=_("登录账号"))
token: models.TextField = models.TextField(
verbose_name=_("认证Token"), help_text=_("一张网/保全系统返回的 JWT Token 或其他认证令牌")
)
token_type: models.CharField = models.CharField(
max_length=32, default="Bearer", verbose_name=_("Token类型"), help_text=_("如:Bearer, JWT")
)
expires_at: models.DateTimeField = models.DateTimeField(verbose_name=_("过期时间"))
created_at: models.DateTimeField = models.DateTimeField(auto_now_add=True, verbose_name=_("创建时间"))
updated_at: models.DateTimeField = models.DateTimeField(auto_now=True, verbose_name=_("更新时间"))
class Meta:
app_label = "automation"
verbose_name = _("一张网Token管理")
verbose_name_plural = _("一张网Token管理")
unique_together: ClassVar = [["site_name", "account"]]
indexes: ClassVar = [
models.Index(fields=["site_name", "account"]),
models.Index(fields=["expires_at"]),
]
def __str__(self) -> str:
return f"{self.site_name} - {self.account}"
def is_expired(self) -> bool:
"""判断是否过期"""
from django.utils import timezone
result: bool = self.expires_at <= timezone.now()
return result
class TokenAcquisitionStatus(models.TextChoices):
"""一张网/保全系统 Token 获取状态"""
SUCCESS = "success", _("成功")
FAILED = "failed", _("失败")
TIMEOUT = "timeout", _("超时")
NETWORK_ERROR = "network_error", _("网络错误")
CAPTCHA_ERROR = "captcha_error", _("验证码错误")
CREDENTIAL_ERROR = "credential_error", _("账号密码错误")
class TokenAcquisitionHistory(models.Model):
"""一张网/保全系统 Token 获取历史记录"""
id: int
site_name: models.CharField = models.CharField(
max_length=128,
verbose_name=_("站点标识"),
help_text=_("如:court_zxfw(人民法院在线服务网/一张网), court_baoquan(保全系统)"),
)
account: models.CharField = models.CharField(max_length=128, verbose_name=_("使用账号"))
credential_id: models.IntegerField = models.IntegerField(
null=True, blank=True, verbose_name=_("凭证ID"), help_text=_("关联的AccountCredential ID")
)
status: models.CharField = models.CharField(
max_length=32, choices=TokenAcquisitionStatus.choices, verbose_name=_("获取状态")
)
trigger_reason: models.CharField = models.CharField(
max_length=256, verbose_name=_("触发原因"), help_text=_("如:token_expired, no_token, manual_trigger")
)
attempt_count: models.IntegerField = models.IntegerField(default=1, verbose_name=_("尝试次数"))
total_duration: models.FloatField = models.FloatField(null=True, blank=True, verbose_name=_("总耗时(秒)"))
login_duration: models.FloatField = models.FloatField(null=True, blank=True, verbose_name=_("登录耗时(秒)"))
captcha_attempts: models.IntegerField = models.IntegerField(default=0, verbose_name=_("验证码尝试次数"))
network_retries: models.IntegerField = models.IntegerField(default=0, verbose_name=_("网络重试次数"))
token_preview: models.CharField = models.CharField(
max_length=50, null=True, blank=True, verbose_name=_("Token预览"), help_text=_("Token 前50个字符")
)
token_fingerprint: models.CharField = models.CharField(
max_length=64,
null=True,
blank=True,
verbose_name=_("Token指纹"),
help_text=_("Token的SHA256指纹(用于排查重复/归因,不可反推Token)"),
)
token_redacted: models.CharField = models.CharField(
max_length=32,
null=True,
blank=True,
verbose_name=_("Token脱敏摘要"),
help_text=_("脱敏后的Token摘要(仅用于人工排查)"),
)
error_message: models.TextField = models.TextField(null=True, blank=True, verbose_name=_("错误信息"))
error_details: models.JSONField = models.JSONField(
null=True, blank=True, verbose_name=_("详细错误信息"), help_text=_("包含完整的错误堆栈和上下文")
)
created_at: models.DateTimeField = models.DateTimeField(auto_now_add=True, verbose_name=_("创建时间"))
started_at: models.DateTimeField = models.DateTimeField(null=True, blank=True, verbose_name=_("开始时间"))
finished_at: models.DateTimeField = models.DateTimeField(null=True, blank=True, verbose_name=_("完成时间"))
class Meta:
app_label = "automation"
verbose_name = _("一张网/保全Token获取历史")
verbose_name_plural = _("一张网/保全Token获取历史")
ordering: ClassVar = ["-created_at"]
indexes: ClassVar = [
models.Index(fields=["site_name", "-created_at"]),
models.Index(fields=["account", "-created_at"]),
models.Index(fields=["status", "-created_at"]),
models.Index(fields=["credential_id"]),
models.Index(fields=["created_at"]),
]
def __str__(self) -> str:
return f"{self.site_name} - {self.account} - {self.get_status_display()}" # type: ignore[attr-defined]
def save(self, *args: Any, **kwargs: Any) -> None:
"""保存前对敏感字段进行脱敏处理"""
from apps.core.security.scrub import fingerprint_sha256, mask_secret, scrub_obj, scrub_text
if self.token_preview:
raw = self.token_preview
self.token_fingerprint = fingerprint_sha256(raw)
self.token_redacted = mask_secret(raw)
self.token_preview = None
if self.error_message:
self.error_message = scrub_text(self.error_message)
if self.error_details:
self.error_details = scrub_obj(self.error_details)
super().save(*args, **kwargs)
def get_success_rate_display(self) -> str:
"""获取成功率显示"""
if self.status == TokenAcquisitionStatus.SUCCESS:
return "100%"
return "0%"