Test Postgres and MySQL schemas #4481
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: Test Postgres and MySQL schemas | |
| on: | |
| schedule: | |
| - cron: '0 0 * * *' | |
| workflow_dispatch: | |
| pull_request: | |
| paths: | |
| - packages/cli/src/databases/** | |
| - .github/workflows/ci-postgres-mysql.yml | |
| pull_request_review: | |
| types: [submitted] | |
| concurrency: | |
| group: db-${{ github.event.pull_request.number || github.ref }} | |
| cancel-in-progress: true | |
| jobs: | |
| build: | |
| name: Install & Build | |
| runs-on: ubuntu-latest | |
| if: github.event_name != 'pull_request_review' || startsWith(github.event.pull_request.base.ref, 'release/') | |
| steps: | |
| - uses: actions/[email protected] | |
| - run: corepack enable | |
| - uses: actions/[email protected] | |
| with: | |
| node-version: 20.x | |
| cache: 'pnpm' | |
| - run: pnpm install --frozen-lockfile | |
| - name: Setup build cache | |
| uses: rharkor/[email protected] | |
| - name: Build Backend | |
| run: pnpm build:backend | |
| - name: Cache build artifacts | |
| uses: actions/cache/[email protected] | |
| with: | |
| path: ./packages/**/dist | |
| key: ${{ github.sha }}:db-tests | |
| sqlite-pooled: | |
| name: SQLite Pooled | |
| runs-on: ubuntu-latest | |
| needs: build | |
| timeout-minutes: 20 | |
| env: | |
| DB_TYPE: sqlite | |
| DB_SQLITE_POOL_SIZE: 4 | |
| steps: | |
| - uses: actions/[email protected] | |
| - run: corepack enable | |
| - uses: actions/[email protected] | |
| with: | |
| node-version: 20.x | |
| cache: 'pnpm' | |
| - run: pnpm install --frozen-lockfile | |
| - name: Setup build cache | |
| uses: rharkor/[email protected] | |
| - name: Restore cached build artifacts | |
| uses: actions/cache/[email protected] | |
| with: | |
| path: ./packages/**/dist | |
| key: ${{ github.sha }}:db-tests | |
| - name: Test SQLite Pooled | |
| working-directory: packages/cli | |
| run: pnpm jest | |
| mysql: | |
| name: MySQL | |
| runs-on: ubuntu-latest | |
| needs: build | |
| timeout-minutes: 20 | |
| env: | |
| DB_MYSQLDB_PASSWORD: password | |
| steps: | |
| - uses: actions/[email protected] | |
| - run: corepack enable | |
| - uses: actions/[email protected] | |
| with: | |
| node-version: 20.x | |
| cache: 'pnpm' | |
| - run: pnpm install --frozen-lockfile | |
| - name: Setup build cache | |
| uses: rharkor/[email protected] | |
| - name: Restore cached build artifacts | |
| uses: actions/cache/[email protected] | |
| with: | |
| path: ./packages/**/dist | |
| key: ${{ github.sha }}:db-tests | |
| - name: Start MySQL | |
| uses: isbang/[email protected] | |
| with: | |
| compose-file: ./.github/docker-compose.yml | |
| services: | | |
| mysql | |
| - name: Test MySQL | |
| working-directory: packages/cli | |
| run: pnpm test:mysql --testTimeout 20000 | |
| postgres: | |
| name: Postgres | |
| runs-on: ubuntu-latest | |
| needs: build | |
| timeout-minutes: 20 | |
| env: | |
| DB_POSTGRESDB_PASSWORD: password | |
| DB_POSTGRESDB_POOL_SIZE: 1 # Detect connection pooling deadlocks | |
| steps: | |
| - uses: actions/[email protected] | |
| - run: corepack enable | |
| - uses: actions/[email protected] | |
| with: | |
| node-version: 20.x | |
| cache: 'pnpm' | |
| - run: pnpm install --frozen-lockfile | |
| - name: Setup build cache | |
| uses: rharkor/[email protected] | |
| - name: Restore cached build artifacts | |
| uses: actions/cache/[email protected] | |
| with: | |
| path: ./packages/**/dist | |
| key: ${{ github.sha }}:db-tests | |
| - name: Start Postgres | |
| uses: isbang/[email protected] | |
| with: | |
| compose-file: ./.github/docker-compose.yml | |
| services: | | |
| postgres | |
| - name: Test Postgres | |
| working-directory: packages/cli | |
| run: pnpm test:postgres | |
| notify-on-failure: | |
| name: Notify Slack on failure | |
| runs-on: ubuntu-latest | |
| needs: [mysql, postgres] | |
| steps: | |
| - name: Notify Slack on failure | |
| uses: act10ns/[email protected] | |
| if: failure() && github.ref == 'refs/heads/master' | |
| with: | |
| status: ${{ job.status }} | |
| channel: '#alerts-build' | |
| webhook-url: ${{ secrets.SLACK_WEBHOOK_URL }} | |
| message: Postgres or MySQL tests failed (${{ github.server_url }}/${{ github.repository }}/actions/runs/${{ github.run_id }}) |