sanger / sequencescape

Web based LIMS
MIT License
83 stars 32 forks source link

Y24-245 - As lab users we would like to be able to make a submission from a Stock Plate for the 10x - CITEseq and Emseq pipelines so that we no longer need to do a fake cherrypick to reduce workload and remove creation of fake data #4270

Open stevieing opened 1 month ago

stevieing commented 1 month ago

User story As lab users we would like to be able to make a submission from a Stock Plate for the 10x - CITEseq and Emseq pipelines so that we no longer need to do a fake cherrypick to reduce workload and remove creation of fake data

Who are the primary contacts for this story Steve / Liz

Who is the nominated tester for UAT SSRs / ??

Acceptance criteria To be considered successful the solution must allow:

Dependencies This story is blocked by the following dependencies:

References This story has a non-blocking relationship with:

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

wendyyang commented 6 days ago

For existing DB (e.g. UAT and PROD), use the following steps to manually update the Stock Plate purpose:

login to the server, e.g. ssh sss0-uat.psd.sanger.ac.uk

Go to the current release directory: cd /var/www/sequencescape/current/

Run the console bundle exec rails c

find the stock plate

p = PlatePurpose.find_by(name:"Stock Plate")

update the type

p.type = 'PlatePurpose::Input'

save it

p.save

Check the uat database, i.e. psdd. in Mysql Workbench, run query: select * from sequencescape_staging.plate_purposes where name = 'Stock Plate'; check if the stock plate type is 'PlatePurpose::Input'. If so, that should mean the update is successful.