Add integration tests to GitHub Actions CI

[hozan23]

Expand the current CI pipeline to include integration tests. Currently, we only run unit tests via make test.

I suggest we either add a new job or expand the existing test job in .github/workflows/ci.yaml to handle this. We need to ensure that the workflow spawns PostgreSQL and MySQL containers, along with any other required service dependencies, before the tests run.