🔱 SPIKE Implement a form in AP UI to manage database access projects

[michaeljcollinsuk]

User Story

As a data engineer
I want to manage database access projects via the AP UI
So that we do not need to maintain the access via GitHub

Value / Purpose

We are investigating alternative ways of allowing data engineers to manage database access projects

Useful Contacts

No response

User Types

No response

Hypothesis

No response

Proposal

Replicate the functionality that is currently managed via GitHub within the AP UI.

This will mean storing details of projects in the UI database. We can then use these stored projects to grant/manage permissions to the required resources (databases/tables).

This initial POC will focus on creating projects in the UI, rather than implementing the API calls to grant access

Additional Information

No response

Definition of Done

• Map out required models in a diagram
• Implement models in the AP UI
• Add forms to allow user to create and manage projects via the UI

[michaeljcollinsuk]

DB diagram implemented https://app.diagrams.net/?libs=general;er#G1pKmReLN8FCS8qaI-J0fDNtZIUysJ2BeQ#%7B%22pageId%22%3A%22R2lEEEUBdFMjLlhIrx00%22%7D

Draft PR open with initial work on the models ministryofjustice/analytical-platform-ui#194

[github-actions]

This issue is being marked as stale because it has been open for 60 days with no activity. Remove stale label or comment to keep the issue open.

[github-actions]

This issue is being closed because it has been open for a further 7 days with no activity. If this is still a valid issue, please reopen it, Thank you!

[github-actions]

This issue is being marked as stale because it has been open for 60 days with no activity. Remove stale label or comment to keep the issue open.

[github-actions]

This issue is being closed because it has been open for a further 7 days with no activity. If this is still a valid issue, please reopen it, Thank you!