db/PostgreSQL/02-import-authorization.sql - master - softailor/gridient

db/PostgreSQL/02-import-authorization.sql
28 строк2 KB
Jenkins
Auto add
18 фев 2026, 10:19
18 фев 2026, 10:191e6c4f8
\c gridient_authorization

SET search_path TO public;

-- Вставка данных о доступах к спискам для групп
-- ВАЖНО: Этот скрипт должен выполняться после 02-import.sql, так как он использует данные из gridient_db
-- Используем прямые значения ID списков (1-6) вместо подзапросов к другой БД

INSERT INTO list_groups (list_id, group_id, created_by_id, created_utc, "rule") VALUES
  (1, (SELECT id FROM "groups" WHERE alias = 'administrator' LIMIT 1), 0, '2025-01-01 00:00:00.001', 1),
  (1, (SELECT id FROM "groups" WHERE alias = 'editor' LIMIT 1), 0, '2025-01-01 00:00:00.001', 1),
  (1, (SELECT id FROM "groups" WHERE alias = 'reader' LIMIT 1), 0, '2025-01-01 00:00:00.001', 0),
  (2, (SELECT id FROM "groups" WHERE alias = 'administrator' LIMIT 1), 0, '2025-01-01 00:00:00.001', 1),
  (2, (SELECT id FROM "groups" WHERE alias = 'editor' LIMIT 1), 0, '2025-01-01 00:00:00.001', 1),
  (2, (SELECT id FROM "groups" WHERE alias = 'reader' LIMIT 1), 0, '2025-01-01 00:00:00.001', 0),
  (3, (SELECT id FROM "groups" WHERE alias = 'administrator' LIMIT 1), 0, '2025-01-01 00:00:00.001', 1),
  (3, (SELECT id FROM "groups" WHERE alias = 'editor' LIMIT 1), 0, '2025-01-01 00:00:00.001', 1),
  (3, (SELECT id FROM "groups" WHERE alias = 'reader' LIMIT 1), 0, '2025-01-01 00:00:00.001', 0),
  (4, (SELECT id FROM "groups" WHERE alias = 'administrator' LIMIT 1), 0, '2025-01-01 00:00:00.001', 1),
  (4, (SELECT id FROM "groups" WHERE alias = 'editor' LIMIT 1), 0, '2025-01-01 00:00:00.001', 1),
  (4, (SELECT id FROM "groups" WHERE alias = 'reader' LIMIT 1), 0, '2025-01-01 00:00:00.001', 0),
  (5, (SELECT id FROM "groups" WHERE alias = 'administrator' LIMIT 1), 0, '2025-01-01 00:00:00.001', 1),
  (5, (SELECT id FROM "groups" WHERE alias = 'editor' LIMIT 1), 0, '2025-01-01 00:00:00.001', 1),
  (5, (SELECT id FROM "groups" WHERE alias = 'reader' LIMIT 1), 0, '2025-01-01 00:00:00.001', 0),
  (6, (SELECT id FROM "groups" WHERE alias = 'administrator' LIMIT 1), 0, '2025-01-01 00:00:00.001', 1),
  (6, (SELECT id FROM "groups" WHERE alias = 'editor' LIMIT 1), 0, '2025-01-01 00:00:00.001', 1),
  (6, (SELECT id FROM "groups" WHERE alias = 'reader' LIMIT 1), 0, '2025-01-01 00:00:00.001', 0)
ON CONFLICT (list_id, group_id) DO NOTHING;