DPL-890-2 Add a new UI and the endpoint to allow the creation of new prefixes

[Sangeetha-Bheeman]

User story As PSD developer I want to be able to add prefixes in UI to be stored in Postgresql database instead of a config file so I don't have to redeploy baracoda every time a new prefix is needed.

Who are the primary contacts for this story Sangeetha, Steve

Who is the nominated tester for UAT Sangeetha

Acceptance criteria To be considered successful the solution must allow:

• [ ] users to create a new prefix from UI.
• [ ] the prefixes must be stored in and retrieved from a postgresql database.
• [ ] remove the need to redeploy baracoda for adding prefixes.
• [ ] the application should continue to work as expected without any loss of service to the users.

Dependencies

• https://github.com/sanger/baracoda/issues/417
• https://github.com/sanger/baracoda/issues/470
• https://github.com/sanger/baracoda/issues/472

Additional context Add any other context or screenshots about the feature request here.

[Sangeetha-Bheeman]

Tasks:

• [ ] Create a new UI to add a new prefix

• [ ] Create a HTML template that includes:
  • [ ] Text box to add a new prefix,
  • [ ] Dropdown to select the barcode format(three existing barcode formats to choose from):
    • Heron COG UK Id format - <Prefix>-<Hexadecimal><Checksum>
    • Generic Barcode Format -<Prefix>-<Number>
    • Sequencescape 22 Format - <Prefix>-<Number>-<Checksum>
  • [ ] Dropdown to choose from the existing sequence names to use(heron,pam,csm etc) or
    • create a new sequence by providing a sequence name and a starting number for the sequence.
  • [ ] Dropdown to enable children creation(True/False)
  • [ ] Create button
• [ ] Add the required styles.
• [ ] Add the javascript functionality to post the prefix details to the new endpoint.
• [ ] Add a button Create new prefix in the index.html to navigate to the new page.
• [ ] Add an endpoint to handle the POST request to create a new prefix
  • [ ] Add the required validations like avoiding creation of duplicate prefixes, etc.
  • [ ] Add error handling.
• [ ] Add the flexibility to create new postgresql sequence for a prefix or to use the existing sequence number based on the post request data.
• [ ] Modify the existing code to fetch prefixes from the database instead of config/defaults.py during barcode creation.
• [ ] Add the required tests
• [ ] Run and pass all the tests and CI
• [ ] Make sure the application works as expected by testing all the existing endpoints and the new endpoint for creating prefixes.