Run tests in CI

[andrefkl]

No one has any reason to make sure tests pass or even think about test coverage when making changes.

We could make tests more part of our workflow if they ran in CI

[linear]

MONO-875

[junlarsen]

You can use the pre installed postgres on github actions to avoid spinning up a container

jobs:
  test:
    runs-on: ubuntu-latest
    steps:
    - uses: actions/checkout@v4
    - name: Start PostgreSQL service
      run: |
        sudo systemctl start postgresql.service
        pg_isready
    - name: Create database user and run tests
      run: |
        # Example: create a user and database using the pre-installed psql
        sudo -u postgres createuser --superuser runner
        sudo -u postgres createdb --owner=runner mytestdb
        # Run your application's tests here, configuring the connection as needed