icipe-official / icipe-official/vectoratlas-software-code

Make a script to load test data on start-up in dev environment

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

Nobody has claimed this yet.

Dominant language
TypeScript
Stars
2
Forks
8
Avg merge
5d 4h
Merged PRs (30d)
11

Description

A good set of realistic test data needs to be collected and loaded into the database when the dev environment is started. This should contain both bionomics and occurrence data, with their associated entities, and user_role data for the dev team.
The process for this story might involve getting realistic data from Marianne, importing it into a local db using the ingest endpoints, and then using pgAdmin to export this data as a sql file, which is then applied to the database after it has been initialised

Acceptance Criteria:

  • Realistic test data is imported into the database when the docker db container is started. This includes bionomics and occurrence data, with corresponding entities and links between, and a few entries in the user_roles table

Contributor guide

No contributing guide indexed for this repository

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

Start by reading the Docker database startup configuration and the ingest endpoints described in the issue, then review how pgAdmin exports the local data. Run the development environment to observe database initialization. Done means startup loads realistic bionomics and occurrence data with their entities and links, plus several user_roles entries.

Written by the indexing model from the issue text.

Assessment

Tech stack
docker, sql
Domain
database, devops
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 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.