search

sanger / baracoda

Generate barcodes on demand
MIT License
0 stars 1 forks source link

DPL-880-1 Add a new postgresql table for storing the prefixes instead of a config file to avoid deployment of baracoda for adding a prefix #470

Open Sangeetha-Bheeman opened 9 months ago

Sangeetha-Bheeman commented 9 months ago

User story As PSD developer I want to create a new postgresql table for storing the prefixes instead of a config file to avoid deployment of baracoda for adding a prefix.

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:

Dependencies

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

Sangeetha-Bheeman commented 9 months ago

Tasks:

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">

Column name | Type | Description -- | -- | -- Id | SERIAL |   prefix | VARCHAR(32) NOT NULL | The prefix to be created barcode_format | VARCHAR(255) NOT NULL | Format for the barcode like -. Example: ASDF-A34ADA sequence_name | VARCHAR(32) NOT NULL | The sequence name to use like heron, pam, csm etc to maintain the sequence number enable_children_creation | BOOLEAN NOT NULL | True/False to allow child barcode creation is_active | BOOLEAN NOT NULL | True/False to maintain list of active/inactive prefixes created_at | TIMESTAMP NOT NULL | Creation timestamp modified_at | TIMESTAMP | Modified timestamp
  • [ ] Add a migration to create the table.
  • [ ] Write script to seed the existing prefixes from the config/defaults to the new table.