cisagov / pe-reports

Automated process to build and distribute Posture & Exposure Reports' bi-weekly to customers.

Creative Commons Zero v1.0 Universal

17 stars 6 forks source link

POST get_data_source_uid() Convert to API Endpoint #700

Closed arng4108 closed 7 months ago

arng4108 commented 8 months ago

💡 Summary

Replace the existing TSQL function with a new REST endpoint that does the same thing Specifically: Convert "get_data_source_uid()" TSQL query to an API endpoint

Motivation and context

There are two major reasons to use endpoints in place of sql queries.

Replace the need to know t-sql
Off load data aggregation to fastapi parallel workers

Implementation notes

Gather existing queries from code.
Create new endpoints at fastapi.
Secure new endpoints in same fashion as existing endpoint.

Acceptance criteria

[X] home/models.py model created
[X] dataAPI/schemas.py schema created
[X] dataAPI/views.py functions created
[X] dataAPI/tasks.py function created (if applicable)
[ ] Verified endpoint is working
[ ] pushed to api extended/staging branch

schmelz21 commented 7 months ago

Closing s all endpoint testing has moved to this https://github.com/cisagov/pe-reports/issues/705.