Node.js and PostgreSQL CI pipeline on Runnable

name: Node.js and PostgreSQL CI

on:
  push:
    branches: [main]
  pull_request:

permissions:
  contents: read

jobs:
  test:
    runs-on: ubuntu-24.04
    strategy:
      fail-fast: false
      matrix:
        suite: [unit, db]
    services:
      postgres:
        image: postgres:17
        env:
          POSTGRES_USER: example
          POSTGRES_PASSWORD: example
          POSTGRES_DB: example
        ports:
          - 5432/tcp
        options: >-
          --health-cmd "pg_isready -U example -d example"
          --health-interval 5s
          --health-timeout 5s
          --health-retries 10
    steps:
      - uses: actions/checkout@v4
      - uses: actions/cache@v4
        with:
          path: ~/.npm
          key: ${{ runner.os }}-node24-${{ hashFiles('package-lock.json') }}
      - name: Install dependencies
        run: npm ci
      - name: Test ${{ matrix.suite }}
        env:
          DATABASE_URL: postgresql://example:example@127.0.0.1:${{ job.services.postgres.ports['5432'] }}/example
        run: |
          set -o pipefail
          npm run test:${{ matrix.suite }} 2>&1 | tee test-output.txt
      - uses: actions/upload-artifact@v4
        if: always()
        with:
          name: node24-${{ matrix.suite }}-test-output
          path: test-output.txt
          if-no-files-found: warn