UnisKB/apps/system_manage/models/platform_access.py

63 lines
2.8 KiB
Python

"""Platform-wide roles and additive grants in the default workspace."""
import uuid
from django.db import models
from django.contrib.postgres.fields import ArrayField
class PlatformRole(models.Model):
id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
name = models.CharField(max_length=64, unique=True)
description = models.CharField(max_length=256, blank=True, default='')
enabled = models.BooleanField(default=True)
is_default = models.BooleanField(default=False)
modules = models.JSONField(default=list)
created_at = models.DateTimeField(auto_now_add=True)
updated_at = models.DateTimeField(auto_now=True)
class Meta:
db_table = 'platform_role'
class PlatformRoleMember(models.Model):
role = models.ForeignKey(PlatformRole, on_delete=models.CASCADE, related_name='members')
user = models.ForeignKey('users.User', on_delete=models.CASCADE, related_name='platform_roles')
class Meta:
db_table = 'platform_role_member'
constraints = [models.UniqueConstraint(fields=['role', 'user'], name='unique_platform_role_member')]
class PlatformGrant(models.Model):
id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
subject_type = models.CharField(max_length=8, choices=[('ALL', '所有用户'), ('ROLE', '角色'), ('USER', '用户')])
subject_id = models.CharField(max_length=64, blank=True, default='')
workspace_id = models.CharField(max_length=128, default='default', db_index=True)
resource_type = models.CharField(max_length=32)
target = models.CharField(max_length=128)
actions = models.JSONField(default=list)
expires_at = models.DateTimeField(null=True, blank=True)
granted_by = models.ForeignKey('users.User', null=True, on_delete=models.SET_NULL, related_name='+')
updated_at = models.DateTimeField(auto_now=True)
class Meta:
db_table = 'platform_grant'
constraints = [models.UniqueConstraint(fields=['workspace_id', 'subject_type', 'subject_id', 'resource_type', 'target'], name='unique_platform_grant')]
indexes = [models.Index(fields=['subject_type', 'subject_id'], name='platform_grant_subject_idx')]
class EffectiveResourcePermission(models.Model):
"""Read-only SQL view merging legacy, role, user and public resource grants."""
id = models.UUIDField(primary_key=True)
workspace_id = models.CharField(max_length=128)
user_id = models.UUIDField()
auth_target_type = models.CharField(max_length=128)
target = models.CharField(max_length=128)
auth_type = models.CharField(max_length=64)
permission_list = ArrayField(models.CharField(max_length=256))
create_time = models.DateTimeField()
update_time = models.DateTimeField()
class Meta:
managed = False
db_table = 'effective_resource_permission'