Test Postgres and MySQL schemas #218
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/** | |
| concurrency: | |
| group: db-${{ github.event.pull_request.number || github.ref }} | |
| cancel-in-progress: true | |
| jobs: | |
| build: | |
| name: Install & Build | |
| runs-on: ubuntu-latest | |
| steps: | |
| - uses: actions/[email protected] | |
| - run: corepack enable | |
| - uses: actions/[email protected] | |
| with: | |
| node-version: 18.x | |
| cache: 'pnpm' | |
| - run: pnpm install --frozen-lockfile | |
| - 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 | |
| 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: 18.x | |
| cache: 'pnpm' | |
| - run: pnpm install --frozen-lockfile | |
| - 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 | |
| postgres: | |
| name: Postgres | |
| runs-on: ubuntu-latest | |
| needs: build | |
| timeout-minutes: 20 | |
| env: | |
| DB_POSTGRESDB_PASSWORD: password | |
| steps: | |
| - uses: actions/[email protected] | |
| - run: corepack enable | |
| - uses: actions/[email protected] | |
| with: | |
| node-version: 18.x | |
| cache: 'pnpm' | |
| - run: pnpm install --frozen-lockfile | |
| - 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 }}) |