DPL-078 Biosero - Update cherrytrack when destination created in LIMS

[andrewsparkes]

User story
As Biosero we would like to be able to warn the user at the start of a run when a destination plate has already been created in the LIMS (e.g. partial created as result of error recovery or created via lighthouse-ui).

Who are the primary contacts for this story
Rob H
Andrew
Eduardo
Harry

Acceptance criteria
To be considered successful the solution must allow:

• add a new table 'destination_plates_in_lims' with a barcode (unique) column
• add a new endpoint for lighthouse to call with a barcode
• endpoint adds the barcode to the table
• add a new stored procedure 'isDestinationPlateInLIMS' that takes a barcode as input, checks the new table, and returns a boolean (see existing stored procedure 'doesSourcePlateExist' for example

Dependencies
This story is blocked by the following dependencies:
None

References
This story has a non-blocking relationship with:
Lighthouse story sanger/lighthouse#397

Additional context
Discussed error recovery at technical mtg 16th July. Outcome of that was that this would be good to have in place.

[andrewsparkes]

No longer required, alternate solution found see sanger/lighthouse#399