expand repositories to accommodate full range of CRUD operations

Currently there is only `base_repository.py` containing minimal load and read operations for database testing. As API development expands there will need to be a wider range of CRUD operations. Suggest following the design pattern here https://github.com/UW-THINKlab/resilience/tree/main/src/support_sphere_py/src/support_sphere/repositories.

