UnisKB/apps/system_manage/migrations/0008_platform_access.py

117 lines
5.8 KiB
Python

# Generated by Django 5.2.8 on 2026-10-23 06:05
import django.contrib.postgres.fields
import django.db.models.deletion
import uuid
from django.db import migrations, models
EFFECTIVE_VIEW = """
CREATE VIEW effective_resource_permission AS
SELECT id, workspace_id, user_id, auth_target_type, target, auth_type,
permission_list, create_time, update_time
FROM workspace_user_resource_permission
UNION ALL
SELECT g.id, g.workspace_id, u.id, g.resource_type::varchar(128), g.target,
'RESOURCE_PERMISSION_GROUP'::varchar,
(ARRAY['VIEW']::varchar[] || CASE WHEN g.actions ? 'EDIT'
THEN ARRAY['MANAGE']::varchar[] ELSE ARRAY[]::varchar[] END),
g.updated_at, g.updated_at
FROM platform_grant g JOIN "user" u ON u.is_active = true
WHERE g.resource_type IN ('KNOWLEDGE','APPLICATION','MODEL','TOOL')
AND g.actions <> '[]'::jsonb
AND (g.expires_at IS NULL OR g.expires_at > statement_timestamp())
AND NOT EXISTS (SELECT 1 FROM user_activation_application a WHERE a.user_id=u.id AND a.status <> 'APPROVED')
AND (g.subject_type='ALL'
OR (g.subject_type='USER' AND g.subject_id=u.id::text)
OR (g.subject_type='ROLE' AND EXISTS (
SELECT 1 FROM platform_role r WHERE r.id::text=g.subject_id AND r.enabled
AND (r.is_default OR EXISTS (SELECT 1 FROM platform_role_member m WHERE m.role_id=r.id AND m.user_id=u.id)))))
"""
def seed_default(apps, schema_editor):
apps.get_model('system_manage', 'PlatformRole').objects.get_or_create(
id='00000000-0000-0000-0000-000000000001',
defaults={'name': '普通用户', 'description': '所有已激活用户自动关联',
'is_default': True, 'modules': ['knowledge', 'mindmap']})
class Migration(migrations.Migration):
dependencies = [
('system_manage', '0007_ai_hub'),
('users', '0002_user_activation_and_role_assignment'),
]
operations = [
migrations.CreateModel(
name='EffectiveResourcePermission',
fields=[
('id', models.UUIDField(primary_key=True, serialize=False)),
('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', django.contrib.postgres.fields.ArrayField(base_field=models.CharField(max_length=256), size=None)),
('create_time', models.DateTimeField()),
('update_time', models.DateTimeField()),
],
options={
'db_table': 'effective_resource_permission',
'managed': False,
},
),
migrations.CreateModel(
name='PlatformRole',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('name', models.CharField(max_length=64, unique=True)),
('description', models.CharField(blank=True, default='', max_length=256)),
('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)),
],
options={
'db_table': 'platform_role',
},
),
migrations.CreateModel(
name='PlatformGrant',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('subject_type', models.CharField(choices=[('ALL', '所有用户'), ('ROLE', '角色'), ('USER', '用户')], max_length=8)),
('subject_id', models.CharField(blank=True, default='', max_length=64)),
('workspace_id', models.CharField(db_index=True, default='default', max_length=128)),
('resource_type', models.CharField(max_length=32)),
('target', models.CharField(max_length=128)),
('actions', models.JSONField(default=list)),
('expires_at', models.DateTimeField(blank=True, null=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('granted_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='users.user')),
],
options={
'db_table': 'platform_grant',
'indexes': [models.Index(fields=['subject_type', 'subject_id'], name='platform_grant_subject_idx')],
'constraints': [models.UniqueConstraint(fields=('workspace_id', 'subject_type', 'subject_id', 'resource_type', 'target'), name='unique_platform_grant')],
},
),
migrations.CreateModel(
name='PlatformRoleMember',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('role', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='members', to='system_manage.platformrole')),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='platform_roles', to='users.user')),
],
options={
'db_table': 'platform_role_member',
'constraints': [models.UniqueConstraint(fields=('role', 'user'), name='unique_platform_role_member')],
},
),
migrations.RunSQL(EFFECTIVE_VIEW, 'DROP VIEW IF EXISTS effective_resource_permission'),
migrations.RunPython(seed_default, migrations.RunPython.noop),
]