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
309 stars 112 forks source link

[DEV-11207] updated summary state view model #4160

Closed ayubshahab closed 2 months ago

ayubshahab commented 3 months ago

Description: In order to support the new changes to the State Profile Pages, the summary_state_view matview in Postgres is updated to include an additional field total_outlays. The total_outlays is added to summary_state_view delta model as well as the postgres django model.

Technical details: The technical details for the knowledge of other developers. Any detailed caveats or specific deployment steps should be outlined here.

Requirements for PR merge:

  1. [x] Unit & integration tests updated
  2. [x] API documentation updated
  3. [x] Necessary PR reviewers:
    • [x] Backend
  4. [x] Appropriate Operations ticket(s) created
  5. [x] Jira Ticket DEV-11207:
    • [x] Link to this Pull-Request

Area for explaining above N/A when needed:

aguest-kc commented 3 months ago

@ayubshahab if PR #4163 gets merged in before this PR you'll need to rename your migration to be 0042, because Ron's PR also has a migration named 0041 within the search app.