Provide total number of results via database access

[scleary1cs]

Story

As the CDC, in order to understand how much the ETOR service is being used, I need to view the total number of ETOR results received via a database query.

Pre-conditions

• Assumptions of prior or future work that's out of scope for this story

Acceptance Criteria

• A database exists where the total number of ETOR test results can be determined.
• The database is accessible by CDC staff

Tasks

Research

• Determine level of auth that is needed

Engineering

• Engineering work needed to complete the story
• Foundational: Technical runway work to support this and future efforts

Definition of Done

• Documentation tasks completed
  • Documentation and diagrams created or updated
    • ADRs (/adr folder)
    • Main README.md
    • Other READMEs in the repo
    • If applicable, update the ReportStream Setup section in README.md
  • Threat model updated
  • API documentation updated
• Code quality tasks completed
  • Code refactored for clarity and no design/technical debt
  • Adhere to separation of concerns; code is not tightly coupled, especially to 3rd party dependencies
• Testing tasks completed
  • Load tests passed
  • Additional e2e tests created
  • Additional RS e2e assertions created in the rs-e2e project for any new transformations. Includes improvements to the assertion code required to make the new assertions
• Build & Deploy tasks completed
  • Build process updated
  • API(s) are versioned
  • Feature toggles created and/or deleted. Document the feature toggle
  • Source code is merged to the main branch

Note: Please remove any DoD items that are not applicable

Research Questions

• Optional: Any initial questions for research

Decisions

• Optional: Any decisions we've made while working on this story

Notes

• Optional: Any reference material or thoughts we may need for later reference