Enhance data integrity of animal and sample entries

[lparsons]

FEATURE REQUEST

Inspiration

When loading new data we rely on the researchers to clearly and uniquely label animal and sample records. While animal records contain various metadata attributes that reduce the chance of duplicate/incorrect entries, samples are more difficult to identify. It is important to ensure a sample is associated with the correct animal. When loading data files, matching to the correct sample becomes more difficult since we can match only on name.

Description

If multiple animal or sample records differ by only the name, they are likely duplicates and this should be flagged during loading. In addition, when loading data files we should require an associated sample sheet to ensure that we associate the data to the correct sample records by checking that the metadata matches (in addition to simply the sample name).

• [x] #577
• [x] #684
• [ ] #687
• [ ] #688

Alternatives

None

Dependencies

This issue cannot be started until the completion of the following issue(s)/ pull request(s):

• issue_number_1

• pull_request_1

Comment

None

---

ISSUE OWNER SECTION

Assumptions

1. List of assumptions that the code will not explicitly address/check
2. E.g. We will assume input is correct (explaining why there is no validation)

Limitations

1. A list of things this work will specifically not do
2. E.g. This feature will only handle the most frequent use case X

Affected Components

• change: File path or DB table ...
• add: Environment variable or server setting
• delete: External executable or cron job

Requirements

• [ ] 1. List of numbered conditions to be met for the feature
• [ ] 2. E.g. Every column/row must display a value, i.e. cannot be empty
• [ ] 3. Numbers for reference & checkboxes for progress tracking

DESIGN

Interface Change description

None provided

Code Change Description

None provided

Tests

• [ ] 1. A description of at least one test for each requirement above.
• [ ] 2. E.g. Test for req 2 that there's an exception when display value is ''
• [ ] 3. Numbers for reference & checkboxes for progress tracking

[hepcat72]

I edited #577 to bring it up to date. Much of the issue was outdated, but the spirit of the feature change was not yet fully implemented.