Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

GPL-745 Add sample and plate uuids to lighthouse cherrypicking - Crawler #156

Closed
4 tasks done
andrewsparkes opened this issue Nov 18, 2020 · 0 comments · Fixed by #158
Closed
4 tasks done

GPL-745 Add sample and plate uuids to lighthouse cherrypicking - Crawler #156

andrewsparkes opened this issue Nov 18, 2020 · 0 comments · Fixed by #158
Assignees
Labels
Beckman integration Beckman integration

Comments

@andrewsparkes
Copy link
Member

andrewsparkes commented Nov 18, 2020

User story
As developers we would like to add sample and plate UUID fields to the Mongo, MLWH and DART databases. This will improve uniqueness and make event handling easier.
This story is for the Crawler changes.
See also story sanger/unified_warehouse#145 for the unified warehouse changes.

Who are the primary contacts for this story
Andrew, Chris, Eduardo, Alex

Acceptance criteria
To be considered successful the solution must allow:

  • Each sample entry into the Mongo and MLWH, and DART databases will be given a unique UUID for sample
  • Each sample entry into the Mongo and MLWH database will be given a unique UUID for plate
  • A new table 'source_plates' to store the plate UUIDs will be created and checked for each sample row insert in case the plate has been seen before (see confluence below for columns and indexes)
  • Update https://ssg-confluence.internal.sanger.ac.uk/display/PSDPUB/i.+Low+Occupancy+Cherry+Picking with any new error TYPEs

Dependencies
#145

Additional context
See https://ssg-confluence.internal.sanger.ac.uk/display/PSDPUB/Cherrypicking+Events

@andrewsparkes andrewsparkes added the Beckman integration Beckman integration label Nov 18, 2020
@rl15 rl15 changed the title GPL-nnn Add sample and plate uuids to lighthouse cherrypicking - MongoDB GPL-745 Add sample and plate uuids to lighthouse cherrypicking - MongoDB Nov 18, 2020
@andrewsparkes andrewsparkes changed the title GPL-745 Add sample and plate uuids to lighthouse cherrypicking - MongoDB GPL-745 Add sample and plate uuids to lighthouse cherrypicking - Crawler Nov 18, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Beckman integration Beckman integration
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants