From d63e3f31e926a53cbfdfb8accda77472ea66e2cc Mon Sep 17 00:00:00 2001
From: Michael Hoennig <michael@hoennig.de>
Date: Fri, 16 Sep 2022 15:25:58 +0200
Subject: [PATCH] introduce 058-rbac-generators.sql with generateRelatedRbacObject+generateRbacRoleDescriptors
---
src/main/resources/db/changelog/113-test-customer-rbac.sql | 39 ++++-----------------------------------
1 files changed, 4 insertions(+), 35 deletions(-)
diff --git a/src/main/resources/db/changelog/113-test-customer-rbac.sql b/src/main/resources/db/changelog/113-test-customer-rbac.sql
index 21ebfda..380894d 100644
--- a/src/main/resources/db/changelog/113-test-customer-rbac.sql
+++ b/src/main/resources/db/changelog/113-test-customer-rbac.sql
@@ -1,47 +1,16 @@
--liquibase formatted sql
-- ============================================================================
---changeset test-customer-rbac-CREATE-OBJECT:1 endDelimiter:--//
+--changeset test-customer-rbac-OBJECT:1 endDelimiter:--//
-- ----------------------------------------------------------------------------
-
-/*
- Creates the related RbacObject through a BEFORE INSERT TRIGGER.
- */
-drop trigger if exists createRbacObjectForCustomer_Trigger on test_customer;
-create trigger createRbacObjectForCustomer_Trigger
- before insert
- on test_customer
- for each row
-execute procedure insertRelatedRbacObject();
+call generateRelatedRbacObject('test_customer');
--//
+
-- ============================================================================
--changeset test-customer-rbac-ROLE-DESCRIPTORS:1 endDelimiter:--//
-- ----------------------------------------------------------------------------
-
-create or replace function testCustomerOwner(customer test_customer)
- returns RbacRoleDescriptor
- language plpgsql
- strict as $$
-begin
- return roleDescriptor('test_customer', customer.uuid, 'owner');
-end; $$;
-
-create or replace function testCustomerAdmin(customer test_customer)
- returns RbacRoleDescriptor
- language plpgsql
- strict as $$
-begin
- return roleDescriptor('test_customer', customer.uuid, 'admin');
-end; $$;
-
-create or replace function testCustomerTenant(customer test_customer)
- returns RbacRoleDescriptor
- language plpgsql
- strict as $$
-begin
- return roleDescriptor('test_customer', customer.uuid, 'tenant');
-end; $$;
+call generateRbacRoleDescriptors('testCustomer', 'test_customer');
--//
--
Gitblit v1.9.3