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

POST getDataSource() Convert to API Endpoint #7

Open
4 of 6 tasks
arng4108 opened this issue Feb 15, 2024 · 0 comments
Open
4 of 6 tasks

POST getDataSource() Convert to API Endpoint #7

arng4108 opened this issue Feb 15, 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

💡 Summary

Replace the existing TSQL function with a new REST endpoint that does the same thing
Specifically: Convert "getDataSource()" 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 Feb 15, 2024
@arng4108 arng4108 self-assigned this Feb 15, 2024
@arng4108 arng4108 mentioned this issue Feb 16, 2024
13 tasks
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