Introduce Automated Testing to Prevent Code Regressions

Currently, changes to the codebase may introduce unintended regressions due to lack of automated verification.
Adding structured testing will increase confidence when refactoring and prevent breaking database logic

## Scope

- Add unit tests for core logic
- Add integration tests for database layer
- Prepare CI to run tests automatically