Improve checks on DB update
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 11
- Forks
- 77
- PR merge metrics
- No merged PRs in 30d
Description
Currently, any update to the database is checked by a specific workflow in GHA. In this check, we confirm that what we store in the local db matches what's stored on the server. I would like these checks to be more exhaustive, for instance:
- Ensure that runs before the new changes are unaffected
- Ensure no invalid values (nans, <0, etc.)
- Ensure the number of entries makes sense
- Ensure no overlap between min/max run
- etc.
Some of these are not trivial, but it would improve our confidence in the database.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Locate the GitHub Actions workflow that checks whether local database updates match the server, then read how its current checks are implemented. Define the expected validation for unaffected prior runs, invalid values, entry counts, and overlapping min/max runs; done means the workflow catches these inconsistencies without rejecting valid updates.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- github-actions, python
- Domain
- ci-cd, databases, testing-qa
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100