UnisKB/apps/users/models/user_manage_ext.py

58 lines
3.1 KiB
Python
Raw Permalink Blame History

This file contains ambiguous Unicode characters!

This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.

# coding=utf-8
"""
用户管理扩展模型:
1. UserActivationApplication:初次注册用户的待激活审核申请(独立数据对象)
2. UserRoleAssignment:用户-角色-工作空间授权关系(独立数据对象)
说明:这两个模型用于规格书 2.2.2「设置初次注册用户为激活用户」「更改用户角色」
两个功能过程的独立申报,避免与「启用/停用用户账号」「更改用户信息」共用同一数据对象。
"""
import uuid_utils.compat as uuid
from django.db import models
class ActivationStatus(models.TextChoices):
PENDING = "PENDING", "待审核"
APPROVED = "APPROVED", "已通过"
REJECTED = "REJECTED", "已拒绝"
class UserActivationApplication(models.Model):
"""初次注册用户的激活审核申请。"""
id = models.UUIDField(primary_key=True, max_length=128, default=uuid.uuid7, editable=False, verbose_name="主键id")
user = models.OneToOneField('users.User', on_delete=models.CASCADE, db_constraint=False,
related_name="activation_application", verbose_name="关联用户")
email = models.EmailField(verbose_name="注册邮箱", blank=True, default="")
email_verified = models.BooleanField(default=False, verbose_name="邮箱是否已验证")
status = models.CharField(max_length=20, choices=ActivationStatus.choices,
default=ActivationStatus.PENDING, db_index=True, verbose_name="审核状态")
applied_at = models.DateTimeField(auto_now_add=True, db_index=True, verbose_name="申请时间")
audit_by = models.ForeignKey('users.User', on_delete=models.SET_NULL, db_constraint=False,
null=True, blank=True, related_name="+", verbose_name="审核人")
audit_time = models.DateTimeField(null=True, blank=True, verbose_name="审核时间")
reject_reason = models.CharField(max_length=500, blank=True, default="", verbose_name="拒绝原因")
class Meta:
db_table = "user_activation_application"
ordering = ["-applied_at"]
class UserRoleAssignment(models.Model):
"""用户-角色-工作空间授权关系。"""
id = models.UUIDField(primary_key=True, max_length=128, default=uuid.uuid7, editable=False, verbose_name="主键id")
user = models.ForeignKey('users.User', on_delete=models.CASCADE, db_constraint=False,
related_name="role_assignments", verbose_name="用户")
role_id = models.CharField(max_length=64, default="USER", db_index=True, verbose_name="角色标识")
workspace_id = models.CharField(max_length=128, default="default", db_index=True, verbose_name="工作空间id")
granted_by = models.ForeignKey('users.User', on_delete=models.SET_NULL, db_constraint=False,
null=True, blank=True, related_name="+", verbose_name="授权人")
granted_at = models.DateTimeField(auto_now_add=True, verbose_name="授权时间")
class Meta:
db_table = "user_role_assignment"
unique_together = ("user", "role_id", "workspace_id")
ordering = ["granted_at"]