Write some integration tests

[acenturyandabit]

Come up with an integration test framework which supports:

• new contributors can check their changes don't break anything
• automated CICD can check their changes don't break anything.

[ephraimjuma]

Set up a range of test environments that mimic the production environment as closely as possible. This may include different configurations, operating systems, and databases. Docker containers or virtual machines can be used to manage these environments.
Populate test environments with realistic and representative test data. This ensures that tests are relevant to real-world scenarios.
Select a testing framework suitable for your project
Organize integration tests into test suites. Define different suites for different components or features, making it easy for contributors to target specific areas.
Set up the framework to automatically discover and run integration tests when code changes are detected in the repository.
Configure pre-commit hooks to run integration tests on contributors' local development environments before they push changes to the repository. This helps contributors catch issues early.