Test Postgres and MySQL schemas #7015
Workflow file for this run
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 | |
| - .github/docker-compose.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] | |
| - uses: actions/[email protected] | |
| with: | |
| node-version: 20.x | |
| - name: Setup corepack and pnpm | |
| run: | | |
| npm i -g [email protected] | |
| corepack enable | |
| - 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] | |
| - uses: actions/[email protected] | |
| with: | |
| node-version: 20.x | |
| - name: Setup corepack and pnpm | |
| run: | | |
| npm i -g [email protected] | |
| corepack enable | |
| - 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 | |
| mariadb: | |
| name: MariaDB | |
| runs-on: ubuntu-latest | |
| needs: build | |
| timeout-minutes: 20 | |
| env: | |
| DB_MYSQLDB_PASSWORD: password | |
| steps: | |
| - uses: actions/[email protected] | |
| - uses: actions/[email protected] | |
| with: | |
| node-version: 20.x | |
| - name: Setup corepack and pnpm | |
| run: | | |
| npm i -g [email protected] | |
| corepack enable | |
| - 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 MariaDB | |
| uses: isbang/[email protected] | |
| with: | |
| compose-file: ./.github/docker-compose.yml | |
| services: | | |
| mariadb | |
| - name: Test MariaDB | |
| working-directory: packages/cli | |
| run: pnpm test:mariadb --testTimeout 30000 | |
| 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] | |
| - uses: actions/[email protected] | |
| with: | |
| node-version: 20.x | |
| - name: Setup corepack and pnpm | |
| run: | | |
| npm i -g [email protected] | |
| corepack enable | |
| - 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: [mariadb, 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 MariaDB tests failed (${{ github.server_url }}/${{ github.repository }}/actions/runs/${{ github.run_id }}) |