Cheng Zhou
6cefa620e4
重新设计权限系统所有 UI 组件的视觉风格，统一配色、圆角、阴影和交互动效： - 实时概览：统计卡片加图标和渐变色条，健康评分改为环形进度，告警改为卡片式 - 趋势分析：图表卡片加彩色图标标识，ECharts 配色升级为渐变面积填充 - 访问日志：指标卡片带图标，日志审计改为卡片式入口，IP排行前三高亮 - IP属地：工具栏重设计，排行列表前三渐变高亮，指标卡片统一新风格 - 系统级权限：从 el-table 改为自定义卡片列表，模块块独立圆角卡片 - 项目权限配置：空状态引导优化，成员表格加头像，工具栏加背景容器 - 角色概览卡片：加进度条可视化，hover 微动效 - 接口权限矩阵：工具栏分离布局，表格圆角包裹 - 角色管理抽屉：侧边栏选中态渐变，操作行 hover 高亮 Co-Authored-By: Claude Opus 4.7 <noreply@anthropic.com>
39 lines
1.5 KiB
Python
39 lines
1.5 KiB
Python
"""权限指标快照模型 - 每小时聚合"""
|
|
|
|
from __future__ import annotations
|
|
|
|
import uuid
|
|
from datetime import datetime
|
|
|
|
from sqlalchemy import DateTime, Float, Index, Integer
|
|
from sqlalchemy.dialects.postgresql import UUID
|
|
from sqlalchemy.orm import Mapped, mapped_column
|
|
from sqlalchemy.sql import func
|
|
|
|
from app.db.base_class import Base
|
|
|
|
|
|
class PermissionMetricSnapshot(Base):
|
|
__tablename__ = "permission_metric_snapshots"
|
|
__table_args__ = (
|
|
Index("ix_perm_snapshot_bucket", "bucket_time"),
|
|
)
|
|
|
|
id: Mapped[uuid.UUID] = mapped_column(
|
|
UUID(as_uuid=True), primary_key=True, default=uuid.uuid4
|
|
)
|
|
bucket_time: Mapped[datetime] = mapped_column(
|
|
DateTime(timezone=True), nullable=False
|
|
)
|
|
total_checks: Mapped[int] = mapped_column(Integer, nullable=False, default=0)
|
|
allowed_checks: Mapped[int] = mapped_column(Integer, nullable=False, default=0)
|
|
denied_checks: Mapped[int] = mapped_column(Integer, nullable=False, default=0)
|
|
avg_elapsed_ms: Mapped[float] = mapped_column(Float, nullable=False, default=0.0)
|
|
max_elapsed_ms: Mapped[float] = mapped_column(Float, nullable=False, default=0.0)
|
|
cache_hits: Mapped[int] = mapped_column(Integer, nullable=False, default=0)
|
|
cache_misses: Mapped[int] = mapped_column(Integer, nullable=False, default=0)
|
|
error_count: Mapped[int] = mapped_column(Integer, nullable=False, default=0)
|
|
created_at: Mapped[datetime] = mapped_column(
|
|
DateTime(timezone=True), nullable=False, server_default=func.now()
|
|
)
|