63 lines
2.8 KiB
Python
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'
|