biocore / biocore/microsetta-private-api

ag.source_barcodes_surveys is missing a UNIQUE constraint

Open
#294 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
6
Forks
18
PR merge metrics
No merged PRs in 30d

Description

...as a result, a `(barcode, survey_id)` can be replicated. There are some examples of this, the reason why is not known.

Contributor guide

No contributing guide indexed for this repository

Research direction

Locate the schema or migration defining ag.source_barcodes_surveys and inspect how (barcode, survey_id) is represented. Check the reported duplicate examples and determine the project’s expected handling of existing duplicates before enforcing uniqueness. Done means the pair cannot be replicated in the table and the relevant database checks pass.

Written by the indexing model from the issue text.

Assessment

Domain
database
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.