HCAP-1334: Optimize query for joining hires to site phase allocations

bcgov / hcap

Application supporting access to the Health Career Access Program (HCAP) for employers and participants.

Apache License 2.0

2 stars 1 forks source link

HCAP-1334: Optimize query for joining hires to site phase allocations #877

Closed rhattie-ey closed 1 year ago

rhattie-ey commented 1 year ago

HCAP-1334 (blocks HCAP-1298) Also fixes HCAP-1391

This PR optimizes the code used to get the phase allocation and hires for a given site. DB impact is now limited to two queries, and only the data needed is sent over the wire.

In addition, this PR:

Expands the capacity for custom queries in the DB wrapper
Simplifies the return type of getSiteByID (was an array with only one element, now directly returns the element) and updates all dependent code
Adds typing in a few related places

sonarcloud[bot] commented 1 year ago

Kudos, SonarCloud Quality Gate passed!

0 Bugs
0 Vulnerabilities
0 Security Hotspots
0 Code Smells

No Coverage information
0.0% Duplication