iskylims
iskylims copied to clipboard
Run states table cleaning
Description of feature
This errors are defined in the run_states table: testing_run Processing Demultiplexing Processing Metrics Error Cancelled Completed Processed Bcl2fastq Processing Bcl2fastq Processed Run Processing Run Sample Sent Recorded Pre-Recorded
Only these are used in the code: Error Completed Processed Bcl2fastq Processing Bcl2fastq Processed Run Processing Run Sample Sent Recorded
However there are runs that are incorrectly set in some on the unused errors. We need to clean those updating the state to error and delete the unused states.
Moreover we need to change the table to have the same fields that the service state table in drylab, with an id and a label name, being the ids p.e "sample_sent", "recorded", in snake_case.