bcgov / bcgov/wps

SPIKE: Add test data to dev deployments TIMEBOX = 3 days

Open
#3,722 0 comments 0 reactions 0 assignees View on GitHub
Spike
Dominant language
Python
Stars
65
Forks
11
Avg merge
21h 25m
Merged PRs (30d)
70

Description

**Describe the task**
To avoid data bugs, we should include test data in dev deployments.

**Acceptance Criteria**
- [ ] Identify a useful subset of test data
- [ ] ~~A dev deployment should include test data when spun up~~ A postgres service container could run in a Github action pipeline that runs our migrations, and then a series of data related tests could run against it: https://docs.github.com/en/actions/use-cases-and-examples/using-containerized-services/creating-postgresql-service-containers

**Additional context**
- Some approaches
- Create a migration that only runs in dev env to add test data (preferred since this leverages existing infra and easier to keep in line with database schemas)
- Create a static sql dump that gets imported in dev deployment crunchydb cluster

Contributor guide

Open the contributing guide

Research direction

Start by reviewing the existing database migrations and the GitHub Actions PostgreSQL service-container documentation linked in the issue. Compare the dev-only migration and static SQL dump approaches, then define a useful test-data subset and confirm that migrations and data-related tests run successfully against the service container.

Written by the indexing model from the issue text.

Assessment

Tech stack
github-actions, postgresql
Domain
ci-cd, databases, testing
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.