DPL-456 Duplex Seq - Migration to transfer well receptacle metadata into requests metadata and delete columns

[andrewsparkes]

User story As PSD we want to migrate the data held in 4 columns on the receptacle table into the relevant stored_metadata field in the requests. Then delete the unneeded columns from receptacle and the code.

Who are the primary contacts for this story Andrew S

Who is the nominated tester for UAT PSD

Acceptance criteria To be considered successful the solution must allow:

• [ ] Columns in receptacle to migrate / remove:
  • [ ] coverage
  • [ ] sub_pool
  • [ ] diluent_volume
  • [ ] submit_for_sequencing
• [ ] Fields in related request_metadata stored_metadata field:
  • [ ] coverage
  • [ ] sub_pool
  • [ ] diluent_volume
  • [ ] submit_for_sequencing

Dependencies This story is blocked by the following dependencies:

• #3660

Additional context Consider that the request type for the changed pipeline is a DilutionAndCleanup request, whereas historically there is just the library type request. We could migrate the field values into the request metadata for the library requests, but the attributes are not present on that type of request. So maybe needs some thought.