cisagov / pe-reports

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

Creative Commons Zero v1.0 Universal

17 stars 5 forks source link

PUT insert sixgill alerts #653

Closed edujosemena closed 7 months ago

edujosemena commented 10 months ago

💡 Summary

Add new REST endpoints that mirror existing sql queries and replace existing sql query with REST Specifically: Convert "insert_sixgill_alerts" 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
[X] Verified endpoint is working

arng4108 commented 7 months ago

Endpoint has been created and integrated in the accessor. Required a slight adjustment so that the input data is broken up into chunks instead of being passed in all at once