Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

PUT insert_shodan_vulns() Convert to API Endpoint #17

Open
4 of 6 tasks
arng4108 opened this issue Mar 12, 2024 · 0 comments
Open
4 of 6 tasks

PUT insert_shodan_vulns() Convert to API Endpoint #17

arng4108 opened this issue Mar 12, 2024 · 0 comments
Assignees
Labels
improvement This issue or pull request will add or improve functionality, maintainability, or ease of use

Comments

@arng4108
Copy link

arng4108 commented Mar 12, 2024

💡 Summary

Replace the existing TSQL function with a new REST endpoint that does the same thing
Specifically: Convert "insert_shodan_data()" 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

  • home/models.py model created
  • dataAPI/schemas.py schema created
  • dataAPI/views.py functions created
  • dataAPI/tasks.py function created (if applicable)
  • Verified endpoint is working
  • pushed to api extended/staging branch
@arng4108 arng4108 added the improvement This issue or pull request will add or improve functionality, maintainability, or ease of use label Mar 12, 2024
@arng4108 arng4108 self-assigned this Mar 12, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
improvement This issue or pull request will add or improve functionality, maintainability, or ease of use
Projects
None yet
Development

No branches or pull requests

1 participant