RBAC Diagram+PostgreSQL Generator #21

hsh-michaelhoennig · 2024-03-07T08:35:35+01:00

hsh-michaelhoennig commented

2024-03-07 08:35:35 +01:00

No description provided.

hsh-michaelhoennig added 34 commits 2024-03-07 08:35:35 +01:00

experimental RbacView: API for a potential Mermaid + pl/pgSQL generator 491516e516

improve readability for defineEntityAlias a0473976d5

generate flowchart for RbacView, with import of simple objects f11edc082d

generate postgres trigger function + trigger for RbacView for simple objects 74071c15db

check for unused grants 54cff5ece9

rekursive Entity-Imports and render complex Mermad-Flowcharts (example: Debitor with parterRel+personRel and holderPerspn+anchorPerson each) 3e2fa5a6f6

Merge remote-tracking branch 'origin/master' into experimental-rbacview-generator 8d3fb4e951

introduce RbacObject and initial test for RbacViewMermaidFlowchart fc1cc5815f

add customer and outgoing grants to RelationshipEntity f45f88ba77

introduce StringWriter and generate properly indented Flowchart b4d6930fbe

improve RBAC definition DSL 5ac616e425

fix duplicate grangs error 2171424118

align naming to rootEntityAlias c1c67b3c7b

fix relationship holderPerson-role d7f0727efe

use StringWriter in Postgres generator 86cf4f6c97

generates Postgres for Relationship faf6710ef1

fix TestCustomerEntity + Flowchart generator 4ba78a70c2

rbacDef for HsOfficePartnerEntity and related amendments of generators 12010b4dae

fix some warnings 4bef9391e1

added PartnerDetails as SubEntity and amend genertors accordingly e521c3c9c3

stable and better readable order of generated grants 59ea077a4e

add RBAC for HsOfficeSepaMandateEntity, improved DSL and Postgres-generator dff9803dc3

split trigger function from the procedure which actually generates the groles and grants fef6e1c01c

frame for update trigger 5276471adb

only render the update trigger if there are any updatable entity aliases bc33f1fd9d

first working version for UPDATE-trigger-function 17282c857f

finally working version for UPDATE-trigger-function with separated INSERT+UPDATE trigger functions b187c705b1

generate identityview, restrictedview and roledescriptors fa15378fd2

insert (into) table permission b2cea1e882

use identity view projection for restricted view orderBy if none is explicitely specified 4df5c2606a

initially working version of generated INSERT-Trigger 3cc5185551

WIP

WIP

add RbacGrantsDiagramService 0a9fd9f83b

WIP 18ce4fd8e9

integrate RbacGrantsDiagramService in ContextBasedTest and TestCustomerRepositoryIntegrationTest 4e2b17a216

hsh-michaelhoennig added 2 commits 2024-03-07 12:26:13 +01:00

fixes and improvements after self-review 20de9ba7a4

implement insert trigger if no explicit grant rule is specified b37e8044b2

hsh-michaelhoennig added 1 commit 2024-03-07 14:42:31 +01:00

fix currentContext resp. define Context and fix related fixme 9ecfdc722a

hsh-michaelhoennig added 2 commits 2024-03-07 16:03:49 +01:00

better error message for failing insert of rbacpermission, but leaving RbacOp domain check commented for now 20fc37da22

.createRole().with.owningUser(CREATOR) is not working 1fb1dcce50

hsh-michaelhoennig added 1 commit 2024-03-07 18:27:09 +01:00

fix TestCustomerControllerAcceptanceTest eb7dea54b5

hsh-michaelhoennig added 1 commit 2024-03-08 08:53:36 +01:00

some minor amendments after self-code-review 86c0bb3e76

hsh-michaelhoennig added 1 commit 2024-03-08 13:21:07 +01:00

implement assumed in Generator d40cf019cc

hsh-michaelhoennig added 2 commits 2024-03-08 14:51:10 +01:00

fix tests in Hostsharing-Office Entity-Tests bbcef53b87

WIP trying to fix Debitor RBAC system 7fab1186ed

hsh-michaelhoennig added 1 commit 2024-03-08 16:05:03 +01:00

fix Debitor RBAC system c2ad5a7e28

hsh-michaelhoennig added 1 commit 2024-03-08 18:01:22 +01:00

fix RbacOp check d71d0215ec

hsh-michaelhoennig changed title from ~~WIP: RBAC Diagram+PostgreSQL Generator~~ to RBAC Diagram+PostgreSQL Generator

2024-03-08 18:04:19 +01:00

hsh-michaelhoennig added 1 commit 2024-03-08 19:46:44 +01:00

fix Rbac most Rbac Integration-Tests (view->SELECT etc.) eb6b56e476

hsh-michaelhoennig added 1 commit 2024-03-09 09:12:38 +01:00

add RBAC def for Domain and fix related assertions e81da57ffd

hsh-michaelhoennig added 2 commits 2024-03-10 07:16:46 +01:00

reduce the changeset c7931a67a9

introduce singleton() 8d697e1ea7

hsh-michaelhoennig added 1 commit 2024-03-10 11:46:04 +01:00

support SQL_QUERY for identity view 8b78265e51

hsh-michaelhoennig added 2 commits 2024-03-11 09:20:31 +01:00

add check for @Version field 1c2cdf207c

use XX for not-assumed c67af5948b

hsh-timotheuspokorra approved these changes 2024-03-11 11:03:03 +01:00

hsh-timotheuspokorra left a comment

sieht gut aus

hsh-michaelhoennig added 1 commit 2024-03-11 12:29:52 +01:00

amendments according to code review 7aa158e406

hsh-michaelhoennig merged commit 187c0db8e2 into master

2024-03-11 12:30:44 +01:00

hsh-michaelhoennig referenced this issue from a commit

2024-03-11 12:30:45 +01:00

RBAC Diagram+PostgreSQL Generator and view->SELECT etc. refactoring (#21)

Sign in to join this conversation.

No reviewers

No Label

No Milestone

No Assignees

2 Participants

Notifications

Due Date

The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: hostsharing/hs.hsadmin.ng#21