next-exp / next-exp/IC

Improve checks on DB update

Open
#916 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

database testing
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

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.