bug: uniqueness constraints are not enforced when creating CoreObjectPermission and CoreGlobalPermission nodes

[wvandeun]

Component

API Server / GraphQL

Infrahub version

stable

Current Behavior

You can create duplicate CoreObjectPermission and CoreGlobalPermission nodes that violate the uniqueness constraints that they have defined on them. However the schema integrity check in the CI does seem to pick up the issue.

CoreObjectPermission has an uniqueness constraint on namespace__value, name__value, action__value, decision__value
CoreGlobalPermission has an uniqueness constraint on action__value, decision__value

Expected Behavior

You cannot create duplicate object permission or global permission objects, or the uniqueness constraints have to be removed.

Steps to Reproduce

• load an instance of infrahub
• navigate to admin > users & permissions
• navigate to the global permissions tab
• create the global permission global:manage_schema:allow_all 2 times
• navigate to the object permissions tab
• create the object permission object:*:Tag:create:allow_all 2 times
• create a branch
• create a new tag object in the branch
• open a proposed change for the branch
• wait for CI to complete, schema integrity check will have failed

Additional Information

No response