Skip to content
This repository has been archived by the owner on Sep 18, 2024. It is now read-only.

[Task]: Add make sprint-data-import and issue-data-import to import github sprint and issue data to database #46

Closed
acouch opened this issue May 20, 2024 · 4 comments · Fixed by #84

Comments

@acouch
Copy link
Member

acouch commented May 20, 2024

Summary

From: HHS#1600

One strategy would be to keep the make sprint-data-export and issue-data-export and create make sprint-db-data-import and issue-data-db-import so that the data is exported to JSON and then imported into the database.

A single make command could then be created to run the the export and then import files.

Bonus points if there is a way to pipe the Github data directly to the database.

Acceptance criteria

No response

@aplybeah aplybeah self-assigned this May 20, 2024
@aplybeah
Copy link

aplybeah commented Jun 7, 2024

Update: added make command while polishing up work for #45

@acouch acouch changed the title [Task]: Update make sprint-data-export and issue-data-export to export to database [Task]: Add make sprint-data-import and issue-data-import to import github sprint and issue data to database Jun 12, 2024
@aplybeah
Copy link

Update: work can be tracked on this branch
There is a bit of loc al testing happening

@acouch
Copy link
Member Author

acouch commented Sep 17, 2024

Issue migrated to HHS#2076

@acouch
Copy link
Member Author

acouch commented Sep 17, 2024

Issue migrated to HHS#2078

@acouch acouch added Migrated and removed Migrated labels Sep 17, 2024
acouch pushed a commit that referenced this issue Sep 18, 2024
…rint and issue data to database (#84)

Fixes #46

* added `sprint-db-data-import` to Makefile
* added `export_json_to_database`

> One strategy would be to keep the make sprint-data-export and
issue-data-export and create make sprint-db-data-import and
issue-data-db-import so that the data is exported to JSON and then
imported into the database.
>
> A single make command could then be created to run the the export and
then import files.

Sample data in database

<img width="1133" alt="Screen Shot 2024-06-26 at 3 38 47 PM"
src="https://github.com/navapbc/simpler-grants-gov/assets/37313082/34c962d6-a78e-4963-be15-ef0f7de3bccf">
acouch pushed a commit that referenced this issue Sep 18, 2024
…rint and issue data to database (#84)

Fixes #46

* added `sprint-db-data-import` to Makefile
* added `export_json_to_database`

> One strategy would be to keep the make sprint-data-export and
issue-data-export and create make sprint-db-data-import and
issue-data-db-import so that the data is exported to JSON and then
imported into the database.
>
> A single make command could then be created to run the the export and
then import files.

Sample data in database

<img width="1133" alt="Screen Shot 2024-06-26 at 3 38 47 PM"
src="https://github.com/navapbc/simpler-grants-gov/assets/37313082/34c962d6-a78e-4963-be15-ef0f7de3bccf">
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
2 participants