tests shouldn't rely on supabase db access

[Jonathan-Zollinger]

Summary

our tests require a specific supabase connection, which is a

Why Test?

anyone needs to be able to test this, not just those with access to that supabase instance.

Proposed Solution

load the data via a psql container with seed data

Why Proposed Solution

this can be spun up with test containers and micronaut testing

Alternative

add instructions for each user to start their own psql db, or read in the data from a json file and parse it that way, but that would require restrategizing how the test data is fetched.

Test Requirements

• tests pull data w/o a supabase credentials.

Additional Context

db_cluster-19-08-2025@07-01-11.backup.gz

Code of Conduct

• I agree to follow this project's Code of Conduct