search

fedspendingtransparency / usaspending-api

Server application to serve U.S. federal spending data via a RESTful API
https://www.usaspending.gov
Creative Commons Zero v1.0 Universal
310 stars 113 forks source link

[DEV-10910][DEV-10911] Add Covid FABA spending database and delta models #4125

Closed aguest-kc closed 4 months ago

aguest-kc commented 4 months ago

Description: Added new delta and Postgres models for a new table named covid_faba_spending and the ability to populate the new table with the load_query_to_delta and load_table_from_delta commands.

Technical details: Added a new Django model and a new delta mode for a new table named covid_faba_spending. Made updates so that the load_query_to_delta.py, load_table_from_delta.py, copy_table_metadata.py, and swap_in_new_table.py commands work with the new table.

Requirements for PR merge:

  1. [ ] Necessary PR reviewers:
    • [ ] Backend
  2. [x] Data validation completed
  3. [x] Jira Ticket DEV-10910 and DEV-10911:
    • [x] Link to this Pull-Request

Area for explaining above N/A when needed:

1. Unit & integration tests updated
There are already tests that import and test the `TABLE_SPEC` that was updated as part of this change.

2. API documentation updated
No API endpoints are updated by this change.

3. Matview impact assessment completed
No matviews are impacted by this change.

4. Frontend impact assessment completed
The frontend is not impacted by this change.

5. Appropriate Operations ticket(s) created
No operations tickets are needed for this change.