Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Task]: Add Schema Management for the analytics database #1610

Closed
1 task
acouch opened this issue Apr 2, 2024 · 1 comment
Closed
1 task

[Task]: Add Schema Management for the analytics database #1610

acouch opened this issue Apr 2, 2024 · 1 comment
Labels
project: grants.gov Grants.gov Modernization tickets

Comments

@acouch
Copy link
Collaborator

acouch commented Apr 2, 2024

Summary

For the #65 we have the analytics container that needs to be able to push data from github to the postgres database. We want a way to make sure the correct tables are created and schema in place.

This needs to support schema changes.

This should be a single file that checks if the tables exist and create them if they don't
similar to: https://github.com/HHS/simpler-grants-gov/blob/main/api/src/db/migrations/setup_local_postgres_db.py

This should be part of the script initialization.

This will likely removed for another tool or strategy down the road.

Acceptance criteria

  • file added that can be run in the script initialization
@sumiat
Copy link
Contributor

sumiat commented May 7, 2024

Combined with #1599

@sumiat sumiat closed this as not planned Won't fix, can't repro, duplicate, stale May 7, 2024
@sumiat sumiat removed the refinement label May 7, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
project: grants.gov Grants.gov Modernization tickets
Projects
Development

No branches or pull requests

2 participants