VberAdminPy/VapAdmin/BACKEND/domain/models/admin/sys_log.py

from datetime import datetime

from sqlalchemy import BigInteger, Column, DateTime, Index, Integer, String

from domain.models.base_model import BaseModel


class SysLoginLogModel(BaseModel):
    """
    系统访问记录
    """

    __tablename__ = "sys_login_log"

    username = Column(String(50), nullable=True, default="", comment="用户账号")
    ipaddr = Column(String(128), nullable=True, default="", comment="登录IP地址")
    login_location = Column(String(255), nullable=True, default="", comment="登录地点")
    browser = Column(String(50), nullable=True, default="", comment="浏览器类型")
    os = Column(String(50), nullable=True, default="", comment="操作系统")
    status = Column(
        Integer, nullable=False, default=0, comment="登录状态（0成功 1失败）"
    )
    msg = Column(String(255), nullable=True, default="", comment="提示消息")
    login_time = Column(
        DateTime, nullable=True, default=datetime.now(), comment="访问时间"
    )

    idx_sys_login_log_s = Index("idx_sys_login_log_s", "status")
    idx_sys_login_log_lt = Index("idx_sys_login_log_lt", "login_time")


class SysOperLogModel(BaseModel):
    """
    操作日志记录
    """

    __tablename__ = "sys_oper_log"

    title = Column(String(50), nullable=True, default="", comment="模块标题")
    business_type = Column(
        Integer, default=0, comment="业务类型（0其它 1新增 2修改 3删除）"
    )
    method = Column(String(100), nullable=True, default="", comment="方法名称")
    request_method = Column(String(10), nullable=True, default="", comment="请求方式")
    operator_type = Column(
        Integer, default=0, comment="操作类别（0其它 1后台用户 2手机端用户）"
    )
    oper_name = Column(String(50), nullable=True, default="", comment="操作人员")
    dept_id = Column(String(50), nullable=True, default="", comment="部门ID")
    dept_name = Column(String(50), nullable=True, default="", comment="部门名称")
    oper_url = Column(String(255), nullable=True, default="", comment="请求URL")
    oper_ip = Column(String(128), nullable=True, default="", comment="主机地址")
    oper_location = Column(String(255), nullable=True, default="", comment="操作地点")
    oper_param = Column(String(2000), nullable=True, default="", comment="请求参数")
    json_result = Column(String(2000), nullable=True, default="", comment="返回参数")
    status = Column(Integer, default=0, comment="操作状态（0正常 1异常）")
    error_msg = Column(String(2000), nullable=True, default="", comment="错误消息")
    oper_time = Column(
        DateTime, nullable=True, default=datetime.now(), comment="操作时间"
    )
    cost_time = Column(BigInteger, default=0, comment="消耗时间")

    idx_sys_oper_log_bt = Index("idx_sys_oper_log_bt", "business_type")
    idx_sys_oper_log_s = Index("idx_sys_oper_log_s", "status")
    idx_sys_oper_log_ot = Index("idx_sys_oper_log_ot", "oper_time")