BU-ISCIII / iskylims

is an open-source LIMS (laboratory Information Management System) for Next Generation Sequencing sample management, statistics and reports, and bioinformatics analysis service management.
https://github.com/BU-ISCIII/iSkyLIMS/wiki
GNU General Public License v3.0
71 stars 34 forks source link

Run states table cleaning #260

Closed saramonzon closed 1 week ago

saramonzon commented 6 months ago

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.